Mastering Excel 365 – Advanced

Mastering Excel 365 - Advanced

# of Lessons

50

Duration

4:14:41

Skill Level

Advanced

MSRP

$30

Instructor(s)

Kathy Jones

Available Captions

Not Captioned

Also Included

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

There are two kinds of people: Those who are masters at Excel 365, and those who wish they were

 

 

When you master Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. Once you have completed this course, there are few things you won’t be able to do with Excel!

 

 

Topics covered include:

  • Collaborating and Sharing
  • Efficiency functions
  • Auditing Functions
  • Forecasting data and trends

 

 

Over 5 hours of high-quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher-Learner style!

Course Contents:

Section # Section Title Lesson # Lesson Name Duration
1 Linking and Consolidating 1 Introduction 1:55
2 Creating Internal Links 4:08
3 Creating External Links 9:00
4 Using Paste Special 5:50
5 Using Group Mode 3:18
6 Using 3D References 2:32
7 Consolidating Data 6:56
2 Sharing and Protecting 8 Adding Comments 7:23
9 Tracking Changes 6:04
10 Co-Authoring, Part 1 6:12
11 Co-Authoring, Part 2 4:44
12 Using Sheet Views 4:29
13 Using Compare and Merge 3:04
14 Preparing to Share 7:19
15 Adding Digital Signatures 5:55
16 Protecting Worksheets 10:33
17 Protecting Workbook Structure 3:01
18 Protecting a Workbook File 7:08
3 Automating 19 Applying Data Validation 7:18
20 Adding a Dropdown List 4:56
21 Customizing Data Validation 5:18
22 Recording a Macro 8:08
23 Running a Macro 5:32
24 Editing a Macro 8:27
4 Using Lookup Functions 25 Using VLOOKUP, Part 1 5:40
26 Using VLOOKUP, Part 2 5:14
27 Using XLOOKUP 10:51
28 More Lookup Functions 9:44
29 Using Array Formulas 6:00
5 Auditing Formulas 30 Tracing Formulas 6:22
31 Addressing Formula Errors 7:16
32 Watching and Evaluating Formulas 4:46
33 Adding Error Handling 4:34
34 Working with Information Functions 5:11
6 Forecasting Data 35 Using Goal Seek 3:30
36 Forecasting with Data Tables 5:04
37 Using Solver 6:46
38 Forecasting with Scenarios 8:16
39 Forecasting Data Trends 3:23
7 More Features 40 Inserting Symbols and Special Characters 2:31
41 Creating Sparklines 3:58
42 Creating a Map Chart 3:47
43 Creating a 3D Map Tour 8:27
44 Creating Custom Lists 5:34
45 Importing and Exporting Data 3:19
46 Creating a Web Query 3:52
47 Using Data Types 0:00
48 Working with Forms 9:54
49 Using ActiveX Controls 4:01
50 Ideas in Office 365 2:06

Related Course Recommendations:

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

Catalog Request

Login Logo
Login Logo

Stay up to date on new courses, tools, and services!