Excel 2019 Expert E-Learning

Excel 2019: Working with Excel Tables

Course: 19 Minutes

Creating a table
Manipulating data in a table
Using table styles
Configuring a table
Using slicers in tables
Formatting slicers

Excel 2019: Inserting PivotTables

Course: 32 Minutes

Creating a PivotTable
Editing your PivotTable
Formatting your PivotTable
Copying & reusing your PivotTable
Sorting data in your PivotTable
Filtering your table data
Using label & value filters
Grouping data in your PivotTable
Inserting a slicer in your PivotTable
Customizing your slicer
Using the Timeline

Excel 2019: Working with Data in PivotTables

Course: 29 Minutes

Analyzing data in a PivotTable
Working with multiple data tables in a PivotTable
Analyzing your database tables in a PivotTable
Using calculations in your PivotTable
Comparing values in a PivotTable
Inserting a PivotChart
Modifying your PivotChart
Configuring your PivotTable

Excel 2019: Using Conditional Formulas

Course: 39 Minutes

Inserting a conditional sum formula
Inserting a conditional message formula
Performing complex conditional formulas
Creating multiple conditions
Using IF & OR in conditional formulas
Using conditional formulas to count up value occurrences
Using reference positions in conditional formulas
Keeping your table up to date with conditional formulas

Excel 2019: Finding & Analyzing Information with Formulas

Course: 35 Minutes

Retrieving information with dates
Finding a date automatically
Finding the largest & smallest values in a list
Separating data into multiple cells
Combining data values in a single cell
Creating automatic reports
Cross-referencing data with formulas
Performing a search across two tables
Inserting data automatically with formulas

Excel 2019: Configuring Options & Settings

Course: 32 Minutes

Retrieving information with dates  
Finding a date automatically  
Finding the largest & smallest values in a list  
Separating data into multiple cells  
Combining data values in a single cell  
Creating automatic reports   Cross-referencing data with formulas  
Performing a search across two tables  
Inserting data automatically with formulas

Excel 2019: Managing Data

Course: 43 Minutes

Managing your account & connected services
Installing & managing add-ins
Creating & managing custom templates
Configuring user & input behavior
Configuring your default formula options
Customizing your document default settings
Customizing your save options
Customizing your interface
Customizing the Quick Access Toolbar
Customizing the ribbon

Excel 2019: Getting to Know Macros in Excel

Course: 34 Minutes Recording a macro

Saving a workbook with macros
Discovering Excel macro tools
Navigating the VBA Editor
Running macros
Managing macros
Editing a macro
Enabling macros in a workbook
Managing macros security options
Using macros in different workbooks