Mastering Excel 2013

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

Instructor : Barbara Evers

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 is your path to first learning, and then mastering Excel 2013.

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. Of course, you may have a rudimentary knowledge of how Excel works, but if you want to learn to get the most of it, then take this course. Let our Microsoft Certified Trainers Barbara Evers and Christina Tankersley walk you through everything you’ve ever wanted to know about Microsoft Excel 2013, including:

  • How to customize Microsoft Excel 2013 to work better for you
  • Easily creating & modifying Pivot Tables
  • The best way to create easy-to-view Charts & Graphs
  • Using Conditional Formatting and Sparklines to Highlight Data Trends
  • Tips & Tweaks for over 120 Excel 2013 functions and features!

Objectives – You will be able to:

  • Demonstrate navigating around the Excel Interface
  • Explain the relationship between Workbooks, Worksheets, rows, columns, cells, and named ranges
  • Describe how to create and use Pivot Tables and Pivot Charts

Course Length

Mastering Excel 2013 – Basics
Modules : 21
Seat Time : 3 Hours
Mastering Excel 2013 – Intermediate
Modules : 30
Seat Time : 4.25 Hours
Mastering Excel 2013 – Advanced
Modules : 23
Seat Time : 2.75 Hours
Mastering Excel 2013 – Full Course
Modules : 74
Seat Time : 10 Hours

Lessons Include:

Mastering Excel 2013 – Basics
01: Looking at Excel 2013 (8:59)
02: Worksheet Navigation, Part 1 (6:50)
03: Worksheet Navigation, Part 2 (8:15)
04: Sheet Tab Options (6:41)
05: The Excel Interface (9:36)
06: The Status Bar (9:54)
07: Keyboard Shortcuts (10:10)
08: File Types (9:49)
09: Open, Save, & AutoSave (14:45)
10: Templates (7:51)
11: AutoCorrect (5:48)
12: Undo and Redo (4:44)
13: Text Formatting, Part 1 (9:02)
14: Text Formatting, Part 2 (9:27)
15: The Windows Clipboard (12:17)
16: Microsoft Office Clipboard (6:32)
17: Highlighting and Navigating in a Workbook (11:52)
18: Entering Data in Series (8:54)
19: Flash Fill (6:43)
20: Formulas (13:04)
21: Intro to Functions (8:59)
Mastering Excel 2013 – Intermediate
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 & SmartArt (10:11)
10: Text Boxes (6:02)
11: Financial Functions (9:55)
12: Data and Time Functions (9:09)
13: Text Functions (7:48)
14: Logical, Math, and Statistical Functions (8:31)
15: vLookup & Misc Functions (8:36)
16: New Functions in 2013 (6:35)
17: Formatting Cells & Ranges, Part 1 (8:10)
18: Formatting Cells & Ranges, Part 2 (10:43)
19: Tables (12:36)
20: Sorting and Filtering (11:51)
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)
Mastering Excel 2013 – Advanced

1: Quick Analysis & Slicers (9:19)
2: Subtotals (6:36)
3: Creating Pivot Tables (7:48)
4: Recommended Pivot Tables (3:55)
5: Customizing Pivot Tables (14:38)
6: Pivot Charts (5:18)
7: Customizing Your View, Part 1 (12:47)
8: Customizing Your View, Part 2 (3:51)
9: Advanced Formatting (7:46)
10: Advanced Data Copy Techniques (8:35)
11: Transforming Data with the Clipboard (2:52)
12: Using Data Validation (10:33)
13: Analyzing Data: Scenario Manager (7:26)
14: Analyzing Data: Data Tables (7:48)
15: Analyzing Data: Goal Seek (2:59)
16: Text to Columns (4:36)
17: Consolidating Data (3:38)
18: Creating Macros (8:18)
19: Advanced Macros (5:53)
20: Creating Random Numbers and Custom Series (6:48)
21: External References (3:55)
22: Customizing the Ribbon and Toolbar (9:31)
23: Power View (7:52)