Mastering Excel 2013 – Intermediate

Mastering Excel 2013 - Intermediate

# of Lessons

30

Duration

4:11:14

Skill Level

Intermediate

MSRP

$30

Instructor(s)

Barbara Evers

Available Captions

Not Captioned

Also Included

Handout, High-quality HD content in the “Uniquely Engaging™” Bigger Brains Teacher-Learner style! 

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 businesses’ 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. 

 

 

Topics covered include: 

  • 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 4 hours of high-quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher-Learner style! 

Course Contents:

#  Lesson  Length 
1  Adding Hyperlinks   4:31 
2  Scientific Equations   6:46 
3  Find and Replace   8:10 
4  Spellcheck and References    9:12 
5  Shapes, Part 1   11:19 
6  Shapes, Part 2   8:42 
7  Pictures   11:13 
8  Pictures + Shapes = Awesome   4:04 
9  ClipArt and SmartArt   10:11 
10  Text Boxes   6:02 
11  Financial Functions   9:55 
12  Date and Time Functions    9:09 
13  Text Functions   7:48 
14  Logical, Math, and Statistical Functions   8:31 
15  vLookup and Misc Functions   8:36 
16  New Functions in 2013   6:35 
17  Formatting Cells and Ranges, Part 1   8:10 
18  Formatting Cells and Ranges, Part 2   10:43 
19  Tables   12:36 
20  Sorting and Filtering   11:54 
21  Importing Data   8:53 
22  Intro to Charts   4:27 
23  Choosing the Right Chart   5:36 
24  Chart Data   3:49 
25  Optimizing Charts   10:57 
26  New Chart Formatting Options   12:17 
27  Sparklines   5:26 
28  Manipulating Text with Functions   8:36 
29  Printing Worksheets   11:37 
30  Working with Print Area   5:29 

Related Course Recommendations:

Mastering Excel 2013 - Advanced
Whats New in Excel 2019?
Microsoft 365 Office Essentials (2020)

Catalog Request

Login Logo