Take this
course

Office Productivity / Microsoft

Mastering Excel 2013 - Intermediate

The World Is Filled With Two Kinds Of People: A Handful Of People Who Are Masters Of Excel, And The Millions Of Others Who Wish They Were

Description

The World Is Filled With Two Kinds Of People: A Handful Of People Who Are Masters Of Excel, And The Millions Of Others Who Wish They Were 


If you’ve mastered Microsoft Excel 2013 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business critical questions like ROI, budget allocations, tracking expenditures, and more. This course moves you beyond the basics and into being a real pro with Excel.  


This is our most requested training course!  If you learn to use Excel 2013, you will start to see how useful it is in your life – from formatting your grocery list to calculating complex ROI values. If you already have some familiarity with Excel, let our Microsoft Certified Trainers Barbara Evers and Christina Tankersley improve your skills with the more productive features of Microsoft Excel 2013, including: 

  • Using Find, Replace, and Spellcheck
  • Adding Shapes, Pictures, ClipArt, and Text Boxes
  • Implementing Financial, Date, Logical, and other Functions
  • Formatting Cells and Ranges
  • Choosing and creating Charts
  • Printing and working with Print Area 


Quickly Search For And Find The Skills You Want To Master– Then Just Point, Click, And Learn Over 5 hours of high quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher/Learner style!

Full details

Curriculum

  • Excel - Intermediate
    Adding Hyperlinks
    4:32
    Scientific Equations
    6:46
    Find and Replace
    12:17
    Spellcheck and Reference
    9:13
  • Shapes and Art
    Shapes, Part 1
    11:20
    Shapes, Part 2
    8:43
    Pictures
    11:14
    Pictures + Shapes = Awesome
    4:05
    ClipArt and SmartArt
    10:11
    Text Boxes
    6:03
  • Working with Functions
    Financial Functions
    9:55
    Date and Time Functions
    9:09
    Text Functions
    7:48
    Logical, Math, and Statistical Functions
    8:32
    vLookup and Misc Functions
    8:36
    New Functions in 2013
    6:36
  • Formatting and Tables
    Formatting Cells and Ranges, Part 1
    8:10
    Formatting Cells and Ranges, Part 2
    10:43
    Tables
    12:37
    Sorting and Filtering
    11:55
    Importing Data
    8:54
  • Charts and Sparklines
    Intro to Charts
    4:27
    Choosing the Right Chart
    5:37
    Chart Data
    3:50
    Optimizing Charts
    10:58
    New Chart Formatting Options
    12:17
    Sparklines
    5:27
    Manipulating Text with Functions
    8:37
  • Printing
    Printing Worksheets
    11:38
    Working with Print Area
    5:30

Skills

  • Microsoft Excel
  • Microsoft Office
  • Office 365

Similar Courses

More Courses by this Instructor