Search
Search
Close this search box.
All   >   Learning Excel 2019 – Advanced (TOSA)

Learning Excel 2019 – Advanced (TOSA)

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

$30 USD

Suggested price per user, ask about bundle discounts

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

$30 USD

Suggested price per user, ask about bundle discounts

Related Course Recommendations

Learning Excel 2019 – Expert (TOSA)

Learning Excel 2019 – Productive (TOSA)

Microsoft Teams Fundamentals and Best Practices (2022)

Bigger Brains Course Catalog and Pricing

Fill out the information below to receive a download link for our latest course catalog.

I am getting training for…