| Excel Beginner |
| Module 01: Introduction to Excel |
|
Identify the Elements of the Excel Interface |
|
00:30:00 |
|
Activity – Identify the Elements of the Excel Interface |
|
00:10:00 |
|
Create a Basic Worksheet |
|
01:00:00 |
|
Activity – Create a Basic Worksheet |
|
00:10:00 |
|
Use the Help System |
|
00:05:00 |
|
Activity – Use the Help System |
|
00:10:00 |
| Module 02: Formulas and Functions |
|
Create Formulas in a Worksheet |
|
00:05:00 |
|
Activity – Create Formulas in a Worksheet |
|
00:05:00 |
|
Insert Functions in a Worksheet |
|
00:05:00 |
|
Activity – Insert Functions in a Worksheet |
|
00:10:00 |
|
Reuse Formulas |
|
00:10:00 |
|
Activity – Reuse Formulas |
|
00:10:00 |
| Module 03: Data Manipulation |
|
Manipulate Data |
|
00:10:00 |
|
Activity – Manipulate Data |
|
00:05:00 |
|
Insert, Manipulate, and Delete Cells, Columns, and Rows |
|
00:10:00 |
|
Activity – Insert, Manipulate, and Delete Cells, Columns, and Rows |
|
00:10:00 |
|
Search For and Replace Data |
|
00:10:00 |
|
Activity – Search For and Replace Data |
|
00:10:00 |
| Module 04: Spell Check and Fonts |
|
Spell Check a Worksheet |
|
00:05:00 |
|
Activity – Spell Check a Worksheet |
|
00:05:00 |
|
Modify Fonts |
|
00:05:00 |
|
Activity – Modify Fonts |
|
00:10:00 |
| Module 05: Cells |
|
Add Borders and Colors to Cells |
|
00:10:00 |
|
Activity – Add Borders and Colors to Cells |
|
00:10:00 |
|
Apply Number Formats |
|
00:10:00 |
|
Activity – Apply Number Formats |
|
00:05:00 |
|
Align Cell Contents |
|
00:10:00 |
|
Activity – Align Cell Contents |
|
00:05:00 |
| Module 06: Cell Style |
|
Apply Cell Styles |
|
00:30:00 |
|
Activity – Apply Cell Styles |
|
00:05:00 |
| Module 07: Customization |
|
Define the Basic Page Layout for a Workbook |
|
01:00:00 |
|
Activity – Define the Basic Page Layout for a Workbook |
|
00:05:00 |
|
Refine the Page Layout and Apply Print Options |
|
00:30:00 |
|
Activity – Refine the Page Layout and Apply Print Options |
|
00:05:00 |
|
Format Worksheet Tabs |
|
00:30:00 |
|
Activity – Format Worksheet Tabs |
|
00:05:00 |
|
Manage Worksheets |
|
00:30:00 |
|
Activity – Manage the View of Worksheets and Workbooks |
|
00:05:00 |
|
Manage the View of Worksheets and Workbooks |
|
00:30:00 |
|
Activity – Manage the View of Worksheets and Workbooks |
|
00:05:00 |
|
Customize General and Language Options |
|
00:30:00 |
|
Activity – Customize General and Language Options |
|
00:05:00 |
|
Customize Formula Options |
|
00:30:00 |
|
Activity – Customize Formula Options |
|
00:05:00 |
|
Customize Proofing and Save Options |
|
01:00:00 |
|
Activity – Customize Proofing and Save Options |
|
00:05:00 |
|
Customize the Ribbon and Quick Access Toolbar |
|
00:30:00 |
|
Activity – Customize the Ribbon and Quick Access Toolbar |
|
00:05:00 |
|
Customize the Functionality of Excel by Enabling Add-Ins |
|
00:30:00 |
|
Activity – Customize the Functionality of Excel by Enabling Add-Ins |
|
00:05:00 |
|
Customize Advanced and Trust Center Options |
|
00:30:00 |
|
Activity – Customize Advanced and Trust Center Options |
|
00:05:00 |
| Excel Intermediate |
| Module 08: Use of Specialized,Text, Logical, Date and Financial Functions |
|
Apply Range Names |
|
00:30:00 |
|
Use Specialized Functions |
|
00:30:00 |
|
Use Text Functions |
|
00:30:00 |
|
Use Logical Functions |
|
00:30:00 |
|
Use Lookup Functions |
|
00:30:00 |
|
Use Date Functions |
|
00:30:00 |
|
Use Financial Functions |
|
00:30:00 |
| Module 09: Table, Data and Graphical Objects |
|
Create and Modify Tables |
|
00:30:00 |
|
Sort and Filter Data |
|
00:30:00 |
|
Use Subtotal and Database Functions to Calculate Data |
|
00:30:00 |
|
Create Charts |
|
00:30:00 |
|
Modify and Format Charts |
|
00:30:00 |
|
Create a Trendline |
|
00:30:00 |
|
Create Advanced Charts |
|
00:30:00 |
|
Create a PivotTable |
|
00:30:00 |
|
Filter Data by Using Slicers |
|
00:30:00 |
|
Analyze Data with PivotCharts |
|
00:30:00 |
|
Insert and Modify Graphic Objects |
|
00:30:00 |
|
Layer and Group Graphic Objects |
|
00:30:00 |
|
Incorporate SmartArt |
|
00:30:00 |
|
Customize Workbooks |
|
00:30:00 |
|
Manage Themes |
|
00:30:00 |
| Module 10: Templates and File Protection |
|
Create and Use Templates |
|
00:30:00 |
|
Protect Files |
|
00:30:00 |
|
Preparing a Workbook for Multiple Audiences |
|
00:30:00 |
| Excel Advanced |
| Module 11: Workbook Properties and Macro |
|
Update Workbook Properties |
|
00:10:00 |
|
Activity-Update Workbook Properties |
|
00:10:00 |
|
Create and Edit a Macro |
|
00:10:00 |
|
Activity-Create and Edit a Macro |
|
00:10:00 |
| Module 12: Formatting, Validation and Trace Cells |
|
Apply Conditional Formatting |
|
00:10:00 |
|
Activity-Apply Conditional Formatting |
|
00:10:00 |
|
Add Data Validation Criteria |
|
00:05:00 |
|
Activity-Add Data Validation Criteriaty |
|
00:10:00 |
|
Trace Cells |
|
00:05:00 |
|
Activity-Trace Cells |
|
00:05:00 |
|
Troubleshoot Invalid Data and Formula Errors |
|
00:05:00 |
|
Activity-Troubleshoot Invalid Data and Formula Errors |
|
00:05:00 |
|
Watch and Evaluate Formulas |
|
00:05:00 |
|
Activity-Watch and Evaluate Formulas |
|
00:05:00 |
| Module 13: Data list, Scenarios and What-If Analysis |
|
Create a Data List Outline |
|
00:05:00 |
|
Activity-Create a Data List Outline |
|
00:05:00 |
|
Create Sparklines |
|
00:05:00 |
|
Activity_Create Sparklines |
|
00:05:00 |
|
Create Scenarios |
|
00:05:00 |
|
Activity-Create Scenarios |
|
00:10:00 |
|
Perform a What-If Analysis |
|
00:10:00 |
|
Activity-Perform a What-If Analysis |
|
00:10:00 |
|
Perform a Statistical Analysis with the Analysis ToolPak |
|
00:05:00 |
|
Activity-Perform a Statistical Analysis with the Analysis ToolPak |
|
00:10:00 |
| Module 14: Interactive and Consolidated Data |
|
Create Interactive Data with Power View |
|
00:10:00 |
|
Activity-Create Interactive Data with Power View |
|
00:05:00 |
|
Consolidate Data |
|
00:05:00 |
|
Activity-Consolidate Data |
|
00:05:00 |
| Module 15: Cells Linking, Workbooks and Web Query |
|
Link Cells in Different Workbooks |
|
00:05:00 |
|
Activity-Link Cells in Different Workbooks |
|
00:05:00 |
|
Merge Workbooks |
|
00:05:00 |
|
Activity-Merge Workbooks |
|
00:05:00 |
|
Export Excel Data |
|
00:05:00 |
|
Activity-Export Excel Data |
|
00:05:00 |
|
Import a Delimited Text File |
|
00:05:00 |
|
Activity- Import a Delimited Text File |
|
00:05:00 |
|
Integrate Excel Data with the Web |
|
00:05:00 |
|
Activity-Integrate Excel Data with the Web |
|
00:05:00 |
|
Create a Web Query |
|
00:05:00 |
|
Activity-Create a Web Query |
|
00:05:00 |
|
Import and Export XML Data |
|
00:15:00 |
|
Activity-Import and Export XML Data |
|
00:05:00 |
| Excel VBA |
| Module 16: Macro Recorder |
|
Create a Macro Using the Macro Recorder |
|
00:15:00 |
|
Edit a Macro |
|
00:15:00 |
|
Debug a Macro |
|
00:15:00 |
|
Customize the Quick Access Toolbar and Hotkeys |
|
00:15:00 |
|
Set Macro Security |
|
00:25:00 |
|
Insert Text |
|
00:15:00 |
|
Format Text |
|
00:10:00 |
|
Sort Data |
|
00:10:00 |
|
Duplicate Data |
|
00:35:00 |
|
Generate a Report |
|
00:30:00 |
|
Determine the Dialog Box Type |
|
00:05:00 |
|
Capture User Input |
|
00:30:00 |
| Module 17: Worksheets |
|
Insert, Copy, and Delete Worksheets |
|
00:10:00 |
|
Rename Worksheets |
|
00:10:00 |
|
Modify the Order of Worksheets |
|
00:10:00 |
|
Print Worksheets |
|
00:10:00 |
|
Create User-Defined Functions |
|
00:15:00 |
|
Automate SUM Functions |
|
00:20:00 |
| Excel PowerPivot |
| Module 18: PowerPivot |
|
Enable and Navigate |
|
00:15:00 |
|
Import Data from Various Data Sources |
|
00:25:00 |
|
Refresh Data from a Data Source |
|
00:10:00 |
|
Create Linked Tables |
|
00:10:00 |
|
Organize and Format Tables |
|
00:15:00 |
|
Create Calculated Columns |
|
00:10:00 |
|
Sort and Filter PowerPivot Data |
|
00:15:00 |
|
Create and Manage Table Relationships |
|
00:20:00 |
| Module 19: PivotTables, Charts and DAX Functions |
|
Create PivotTables |
|
00:25:00 |
|
Create PivotCharts |
|
00:15:00 |
|
Create Power Views |
|
00:25:00 |
|
Filter Data Using Slicers |
|
00:10:00 |
|
Present PivotTable Data Visually |
|
00:30:00 |
|
Manipulate PowerPivot Data Using DAX Functions |
|
00:15:00 |
|
Extract Data from Tables Using Functions |
|
00:15:00 |
|
Save Reports in Different File Formats |
|
00:15:00 |
|
Work with Time Dependent Data |
|
00:20:00 |
|
Protect Reports |
|
00:15:00 |
| Excel Templates |
|
Excel Templates |
|
00:00:00 |
| Activities and Exercise Files |
|
Activities and Exercise Files – Microsoft Excel 2016 for Beginners |
|
00:00:00 |
|
Activities and Exercise Files – Microsoft Excel 2016 Intermediate |
|
00:00:00 |
|
Activities – Microsoft Excel 2016 Advanced |
|
00:00:00 |
|
Activities and Exercise Files – Microsoft Excel 2016 and VBA |
|
00:00:00 |
|
Activities and Exercise Files – Microsoft Excel 2016 PowerPivot |
|
00:00:00 |
