Mastering Excel 2013

Mastering Excel 2013

# of Lessons

74

Duration

10:02:19

Skill Level

Everyone

MSRP

$45

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 is your path to first learning, then mastering 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. Of course, you may have a rudimentary knowledge of how Excel works, but if you want 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. 

 

 

Topics covered include: 

  • Customizing Microsoft Excel features to work best for you 
  • Creating & modifying Pivot Tables 
  • Creating easy-to-view Charts & Graphs 
  • Using Conditional Formatting and Sparklines to highlight data trends 
  • Learning tips & tweaks for over 120 Excel 2013 functions and features! 

 

 

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

Course Contents:

#  Lesson  Length 
1  Looking at Excel 2013   8:58 
2  Navigating the Worksheet   6:49 
3  Worksheet Navigation, Part 2   8:15 
4  Sheet Tab Options   6:40 
5  The Excel Interface   9:35 
6  The Status Bar   9:53 
7  Keyboard Shortcuts   10:10 
8  File Types   9:48 
9  Open, Save, & Autosave   14:44 
10  Templates   7:50 
11  AutoCorrect   5:48 
12  Undo & Redo   4:43 
13  Text Formatting, Part 1   9:02 
14  Text Formatting, Part 2   9:26 
15  Adding Hyperlinks   4:31 
16  Scientific Equations   6:45 
17  The Windows Clipboard   12:16 
18  Microsoft Office Clipboard   6:32 
19  Find & Replace   8:09 
20  Spellcheck & References   9:12 
21  Shapes, Part 1   11:19 
22  Shapes, Part 2   8:42 
23  Pictures   11:13 
24  Pictures + Shapes = Awesome   4:04 
25  ClipArt & SmartArt   10:10 
26  Text Boxes   6:02 
27  Highlighting & Navigating in a Workbook   11:52 
28  Entering Data in Series   8:54 
29  Flash Fill   6:43 
30  Formulas   13:04 
31  Intro to Functions   8:58 
32  Financial Functions   9:54 
33  Data & Time Functions   9:08 
34  Text Functions   7:48 
35  Logical, Math, & Statistical Functions   8:33 
36  vLookup & Misc Functions   8:35 
37  New Functions in 2013   6:33 
38  Formatting Cells & Ranges, Part 1   8:08 
39  Formatting Cells & Ranges, Part 2   10:36 
40  Tables   12:34 
41  Sorting & Filtering   11:51 
42  Quick Analysis & Slicers   9:17 
43  Subtotals   6:33 
44  Creating Pivot Tables   7:46 
45  Recommended Pivot Tables   3:53 
46  Customizing Pivot Tables   14:33 
47  Importing Data   8:50 
48  Intro to Charts   4:24 
49  Choosing the Right Chart   5:33 
50  Chart Data   3:46 
51  Optimizing Charts   10:56 
52  New Chart Formatting Options   12:14 
53  Pivot Charts   5:14 
54  Sparklines   5:22 
55  Customizing Your View, Part 1   12:44 
56  Customizing Your View, Part 2   3:47 
57  Advanced Formatting   7:43 
58  Advanced Data Copy Techniques   8:31 
59  Transforming Data with the Clipboard   2:50 
60  Manipulating Text with Functions   8:35 
61  Printing Worksheets   11:34 
62  Working with Print Area   5:27 
63  Using Data Validation   10:31 
64  Analyzing Data: Scenario Manager   7:27 
65  Analyzing Data: Data Tables   7:47 
66  Analyzing Data: Goal Seek   2:59 
67  Text to Columns   4:35 
68  Consolidating Data   3:37 
69  Creating Macros   8:16 
70  Advanced Macros   5:49 
71  Creating Random Numbers & Custom Series   6:46 
72  External References   3:55 
73  Customizing the Ribbon & Toolbar   9:28 
74  Power View   7:50 

Related Course Recommendations:

Whats New in Excel 2019?
Microsoft 365 Office Essentials (2020)

Catalog Request

Login Logo