Learning Excel 2019 – Advanced (TOSA)

Learning Excel 2019 – Advanced (TOSA)

# of Lessons

55

Duration

5:34:58

Skill Level

Advanced

Instructor(s)

Kathy Jones

Available Captions

Not Captioned

Also Included

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

There are two kinds of people in the world: A handful of people who are masters of Excel, and the millions of others who wish they were.  

 

When you master Excel, you have one of the most practical and valuable skillsets in modern business. A spreadsheet expert can work wonders—from organizing lists to creating multi-layered interactive reports; from answering critical business questions to managing budget allocations and tracking expenses.  

Take this course and you’ll be one step closer to becoming an expert at using Excel 2019. Material in these modules is aligned with the Level 4 – Advanced User TOSA Certification. You’ll work with more complex features and functions of Excel and acquire a skillset to handle large tables and databases. Learn to use customized sorting and filters to extract data, so you can review and manage your data with ease. 

 

Topics covered include: 

  • Using Autofill and Named Ranges 
  • Working with advanced functions (Date, Time, Conditional, Database, Lookup) 
  • Applying advanced filtering 
  • Using advanced chart features 
  • Inserting and modifying graphics 
  • Creating PivotTables with advanced PivotTable features 
  • Creating internal and external links 
  • Consolidating data 
  • Co-authoring and using Compare and Merge 
  • Adding Digital Signatures 
  • Protecting workbooks and worksheets 
  • Customizing Data Validation 
  • Running and editing Macros 
  • Inserting symbols and characters 
  • Working with Forms 

 

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

Course Contents:

# Section # Lesson Length
1 Working with Functions 1 Using AutoFill 7:36
2 Copying Formulas and Functions 7:09
3 Using Named Ranges, Part 1 5:00
4 Using Named Ranges, Part 2 5:25
5 Using Named Ranges, Part 3 5:08
6 Working with Date Functions, Part 1 8:55
7 Working with Date Functions, Part 2 4:17
8 Working with Date Functions, Part 3 3:37
9 Working with Time Functions 5:29
10 Working with Conditional Functions 7:33
11 Multiple Criteria Functions 5:03
2 Working with Lists 12 Filtering Data, Part 1 7:11
13 Filtering Data, Part 2 7:55
14 Querying with Database Functions 6:55
15 Using the Subtotal Function 4:28
16 Using the Subtotal Feature 6:12
3 Visualizing Data with Charts 17 Using Advanced Chart Features 4:29
18 Applying Trendlines 4:35
19 Creating a Chart Template 3:27
4 Inserting Graphics 20 Inserting Graphics 8:41
21 Modifying Graphics, Part 1 5:40
22 Modifying Graphics, Part 2 6:12
5 Using PivotTables and Slicers 23 Creating a PivotTable 11:31
24 Summarizing Data in a PivotTable 8:00
25 Grouping Data in a PivotTable 6:15
26 Formatting a PivotTable 6:56
27 Selecting and Moving PivotTables 3:15
28 Changing PivotTable Options 8:07
29 Adding Calculated Fields 2:03
30 Using Slicers 7:26
31 Using Timeline Slicers 1:44
6 Linking and Consolidating 32 Creating Internal Links 4:08
33 Creating External Links 9:00
34 Using Paste Special 5:50
35 Consolidating Data 6:56
7 Sharing and Protecting 36 Co-Authoring, Part 1 6:12
37 Co-Authoring, Part 2 4:44
38 Using Compare and Merge 3:04
39 Adding Digital Signatures 5:55
40 Protecting Worksheets 10:33
41 Protecting Workbook Structure 3:01
42 Protecting a Workbook File 7:08
8 Automating 43 Applying Data Validation 7:18
44 Adding a Dropdown List 4:56
45 Customizing Data Validation 5:18
46 Recording a Macro 8:08
47 Running a Macro 5:32
48 Editing a Macro 8:27
9 Using Lookup Functions 49 Using VLOOKUP, Part 1 5:40
50 Using VLOOKUP, Part 2 5:14
51 More Lookup Functions 9:44
52 Using Array Formulas 6:00
10 Other 53 Using Goal Seek 3:30
54 Inserting Symbols and Characters 2:32
55 Working with Forms 9:54

Related Course Recommendations:

Microsoft Teams Essentials 2021

Catalog Request

Login Logo

Get course updates, Learning and Development ideas, and Information on how to use Bigger Brains!