Mastering Excel 2013 – Advanced

Mastering Excel 2013 - Advanced

# of Lessons

23

Duration

2:42:49

Skill Level

Advanced

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 is for users who wish to gain skills in the more advanced features of 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 are comfortable working in Excel but want to learn more, 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 Quick Analysis, Slicers, and Subtotals 
  • Working with Pivot Tables and Pivot Charts 
  • Manipulating text 
  • Analyzing data with Scenario Manager, Goal Seek, and Data Tables 
  • Working with Macros 
  • Using Power View 

  Quickly search for and find the skills you want to master– then just point, click, and learn.  Over 2 hours of high-quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher-Learner style! 

Course Contents:

#  Lesson  Length 
1  Quick Analysis and 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   3:06 
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 

Related Course Recommendations:

Whats New in Excel 2019?
Mastering Office 365 - 2019
Microsoft Teams Essentials 2021

Catalog Request

Login Logo