TOSA
Learning Excel 2019 – Expert (TOSA)
Lessons Include
Customizing General Options 4:45
Customizing the Ribbon 7:02- Customizing the Quick Access Toolbar 6:46
Working with Functions
Working with Logical Functions 8:36
Working with Conditional Functions 7:33
Multiple Criteria Functions 5:03
Using Nested Functions 5:13
Using IFS and SWITCH Functions 5:56
Working with Text Functions, Part 1 4:13
Working with Text Functions, Part 2 4:27
Working with Text Functions, Part 3 3:42
Working with Text Functions, Part 4 8:14
Working with Math Functions 6:59
More Lookup Functions 9:44
Using PivotTables and PivotCharts
Creating a PivotTable 11:31
16 Summarizing Data in a PivotTable 8:00
17 Grouping Data in a PivotTable 6:15
18 Formatting a PivotTable 6:56
19 Selecting and Moving PivotTables 3:15
20 Changing PivotTable Options 8:07
21 Adding Calculated Fields 2:03
22 Presenting Data with PivotCharts 4:21
Sharing and Protecting
Co-Authoring, Part 1 6:12
Co-Authoring, Part 2 4:44
Protecting a Workbook File 7:08
Applying Data Validation 7:18
Auditing Formulas
Addressing Formula Errors 7:16
Watching and Evaluating Formulas 4:46
Adding Error Handling 4:34
Working with Information Functions 5:12
Forecasting Data
Forecasting with Data Tables 5:04
Using Solver 6:46
Forecasting with Scenarios 8:16
Forecasting Data Trends 3:23
Creating Sparklines 3:58
More Features
Using Paste Special 5:50
Summarizing Data in Tables 4:32
Creating Custom Lists 5:34
Working with Forms 9:54
Using ActiveX Controls 4:02
4h 3m
0
0
Learning Excel 2019 – Advanced (TOSA)
- Working with Functions
Using AutoFill 7:36
Copying Formulas and Functions 7:09
Using Named Ranges, Part 1 5:00
Using Named Ranges, Part 2 5:25
Using Named Ranges, Part 3 5:08
Working with Date Functions, Part 1 8:55
Working with Date Functions, Part 2 4:17
Working with Date Functions, Part 3 3:37
Working with Time Functions 5:29
Working with Conditional Functions 7:33
Multiple Criteria Functions 5:03
Working with Lists
Filtering Data, Part 1 7:11
Filtering Data, Part 2 7:55
Querying with Database Functions 6:55
Using the Subtotal Function 4:28
Using the Subtotal Feature 6:12
Visualizing Data with Charts
Using Advanced Chart Features 4:29
Applying Trendlines 4:35
Creating a Chart Template 3:27
Inserting Graphics
Inserting Graphics 8:41
Modifying Graphics, Part 1 5:40
Modifying Graphics, Part 2 6:12
Using PivotTables and Slicers
Creating a PivotTable 11:31
Summarizing Data in a PivotTable 8:00
Grouping Data in a PivotTable 6:15
Formatting a PivotTable 6:56
Selecting and Moving PivotTables 3:15
Changing PivotTable Options 8:07
Adding Calculated Fields 2:03
Using Slicers 7:26
Using Timeline Slicers 1:44
Linking and Consolidating
Creating Internal Links 4:08
Creating External Links 9:00
Using Paste Special 5:50
Consolidating Data 6:56
Sharing and Protecting
Co-Authoring, Part 1 6:12
Co-Authoring, Part 2 4:44
Using Compare and Merge 3:04
Adding Digital Signatures 5:55
Protecting Worksheets 10:33
Protecting Workbook Structure 3:01
Protecting a Workbook File 7:08
Automating
Applying Data Validation 7:18
Adding a Dropdown List 4:56
Customizing Data Validation 5:18
Recording a Macro 8:08
Running a Macro 5:32
Editing a Macro 8:27
Using Lookup Functions
Using VLOOKUP, Part 1 5:40
Using VLOOKUP, Part 2 5:14
More Lookup Functions 9:44
Using Array Formulas 6:00
Other
Using Goal Seek 3:30
Inserting Symbols and Characters 2:32
Working with Forms 9:54
5h 35m
0
0
Learning Excel 2019 – Basics (TOSA)
Performing Calculations
Inserting Functions 8:10
Using Absolute References 9:51
Formatting Worksheets
Inserting and Deleting Cells 8:50
Applying Text Formats 8:35
Applying Number Formats 7:24
Aligning Cell Contents 7:17
Applying Themes 3:48
Using Templates 6:01
Printing Workbooks
Setting the Page Layout 6:34
Inserting Page Breaks 8:38
Configuring Headers and Footers, Part 1 5:09
Configuring Headers and Footers, Part 2 4:04
Managing Workbooks
Managing Worksheets, Part 1 5:02
Managing Worksheets, Part 2 7:39
Creating a Custom View 3:47
Working with Functions
Using Named Ranges 5:25
Working with Logical Functions 8:36
Working with Conditional Functions 7:33
Other
Sorting Data 5:18
Creating Charts 5:37
Using Chart Types 2:27
Tracing Formulas 6:22
Addressing Formula Errors 7:16
2h 29m
0
0
Learning Excel 2019 – Beginner (TOSA)
- Getting Started
Navigating the Interface 8:42
Selecting Data 9:15
Using Commands 7:14
Creating a New Workbook 8:04
Entering Cell Data 5:59
Using Excel Help 2:05
Formulas and Functions
Creating Formulas 7:57
Inserting Functions 8:14
Using Absolute References 9:51
Formatting
Applying Text Formats 8:35
Applying Number Formats 7:24
Customizing Number Formats 7:46
Applying Cell Styles 5:20
Applying Conditional Formatting to Numbers 6:45
Applying Conditional Formatting to Text and Dates 7:56
Printing
Printing Workbooks 4:12
Setting the Page Layout 6:34
Sorting and Filtering
Sorting Data 5:18
Filtering Data 5:20
Other
Using Chart Types 2:27
Ideas in Office 365 2:06
2h 17m
0
0