About This Course
Course Curriculum
-
Introduction to Microsoft Excel 2019 New Features00:07:00
-
CONCAT00:02:00
-
IFS00:01:00
-
MAXIFS00:01:00
-
MINIFS00:01:00
-
SWITCH00:02:00
-
TEXTJOIN00:01:00
-
Map Chart00:02:00
-
Funnel Chart00:01:00
-
Better Visuals00:06:00
-
Pivot Table Enhancements00:02:00
-
Power Pivot Updates00:01:00
-
Navigate the Excel User Interface00:28:00
-
Use Excel Commands00:10:00
-
Create and Save a Basic Workbook00:19:00
-
Enter Cell Data00:12:00
-
Use Excel Help00:05:00
-
Create Worksheet Formulas00:15:00
-
Insert Functions00:17:00
-
Reuse Formulas and Functions00:17:00
-
Insert, Delete, and Adjust Cells, Columns, and Rows00:10:00
-
Search for and Replace Data00:09:00
-
Use Proofing and Research Tools00:07:00
-
Apply Text Formats00:16:00
-
Apply Number Format00:08:00
-
Align Cell Contents00:09:00
-
Apply Styles and Themes00:12:00
-
Apply Basic Conditional Formatting00:11:00
-
Create and Use Templates00:08:00
-
Preview and Print a Workbook00:10:00
-
Set Up the Page Layout00:09:00
-
Configure Headers and Footers00:07:00
-
Manage Worksheets00:05:00
-
Manage Workbook and Worksheet Views00:07:00
-
Manage Workbook Properties00:06:00
-
Work with Ranges00:18:00
-
Use Specialized Functions00:11:00
-
Work with Logical Functions00:23:00
-
Work with Date & Time Functions00:08:00
-
Work with Text Functions00:11:00
-
Sort Data00:10:00
-
Filter Data00:10:00
-
Query Data with Database Functions00:09:00
-
Outline and Subtotal Data00:09:00
-
Apply Intermediate Conditional Formatting00:07:00
-
Apply Advanced Conditional Formatting00:05:00
-
Create Charts00:13:00
-
Modify and Format Charts00:12:00
-
Use Advanced Chart Features00:12:00
-
Create a PivotTable00:13:00
-
Analyze PivotTable Data00:12:00
-
Present Data with PivotCharts00:07:00
-
Filter Data by Using Timelines and Slicers00:11:00
-
Use Links and External References00:12:00
-
Use 3-D References00:06:00
-
Consolidate Data00:05:00
-
Use Lookup Functions00:12:00
-
Trace Cells00:09:00
-
Watch and Evaluate Formulas00:08:00
-
Collaborate on a Workbook00:19:00
-
Protect Worksheets and Workbooks00:08:00
-
Apply Data Validation00:13:00
-
Search for Invalid Data and Formulas with Errors00:04:00
-
Work with Macros00:18:00
-
Create Sparklines00:07:00
-
MapData00:07:00
-
Determine Potential Outcomes Using Data Tables00:08:00
-
Determine Potential Outcomes Using Scenarios00:09:00
-
Use the Goal Seek Feature00:04:00
-
Forecasting Data Trends00:05:00
-
Create a Macro Using the Macro Recorder01:00:00
-
Edit a Macro01:00:00
-
Debug a Macro00:30:00
-
Customize the Quick Access Toolbar and Hotkeys00:30:00
-
Set Macro Security01:00:00
-
Insert Text00:30:00
-
Format Text00:30:00
-
Sort Data00:30:00
-
Duplicate Data01:00:00
-
Generate a Report01:00:00
-
Determine the Dialog Box Type00:15:00
-
Capture User Input01:00:00
-
Insert, Copy, and Delete Worksheets00:30:00
-
Rename Worksheets00:30:00
-
Modify the Order of Worksheets00:15:00
-
Print Worksheets00:30:00
-
Create User-Defined Functions00:30:00
-
Automate SUM Functions00:30:00
-
Activities and Exercise Files – Microsoft Excel 2016 and VBA
-
Excel Templates
-
Mock Exam – Microsoft Excel Complete Course 201900:20:00
-
Final Exam – Microsoft Excel Complete Course 201900:20:00