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:05:00 | ||
Create a Basic Worksheet | 01:00:00 | ||
Activity – Create a Basic Worksheet | 00:05:00 | ||
Use the Help System | 00:30:00 | ||
Activity – Use the Help System | 00:05:00 | ||
Module 02: Formulas and Functions | |||
Create Formulas in a Worksheet | 01:00:00 | ||
Activity – Create Formulas in a Worksheet | 00:05:00 | ||
Insert Functions in a Worksheet | 00:30:00 | ||
Activity – Insert Functions in a Worksheet | 00:05:00 | ||
Reuse Formulas | 00:30:00 | ||
Activity – Reuse Formulas | 00:05:00 | ||
Module 03: Data Manipulation | |||
Manipulate Data | 00:30:00 | ||
Activity – Manipulate Data | 00:05:00 | ||
Insert, Manipulate, and Delete Cells, Columns, and Rows | 00:30:00 | ||
Activity – Insert, Manipulate, and Delete Cells, Columns, and Rows | 00:05:00 | ||
Search For and Replace Data | 00:30:00 | ||
Activity – Search For and Replace Data | 00:05:00 | ||
Module 04: Spell Check and Fonts | |||
Spell Check a Worksheet | 00:30:00 | ||
Activity – Spell Check a Worksheet | 00:05:00 | ||
Modify Fonts | 00:30:00 | ||
Activity – Modify Fonts | 00:05:00 | ||
Module 05: Cells | |||
Add Borders and Colors to Cells | 01:00:00 | ||
Activity – Add Borders and Colors to Cells | 00:05:00 | ||
Apply Number Formats | 00:30:00 | ||
Activity – Apply Number Formats | 00:05:00 | ||
Align Cell Contents | 00:30: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 Worksheets | 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:15:00 | ||
Activity-Update Workbook Properties | 00:05:00 | ||
Create and Edit a Macro | 00:15:00 | ||
Activity-Create and Edit a Macro | 00:05:00 | ||
Module 12: Formatting, Validation and Trace Cells | |||
Apply Conditional Formatting | 00:15:00 | ||
Activity-Apply Conditional Formatting | 00:05:00 | ||
Add Data Validation Criteria | 00:15:00 | ||
Activity-Add Data Validation Criteriaty | 00:05:00 | ||
Trace Cells | 00:15:00 | ||
Activity-Trace Cells | 00:05:00 | ||
Troubleshoot Invalid Data and Formula Errors | 00:15:00 | ||
Activity-Troubleshoot Invalid Data and Formula Errors | 00:05:00 | ||
Watch and Evaluate Formulas | 00:15:00 | ||
Activity-Watch and Evaluate Formulas | 00:05:00 | ||
Module 13: Data list, Scenarios and What-If Analysis | |||
Create a Data List Outline | 00:15:00 | ||
Activity-Create a Data List Outline | 00:05:00 | ||
Create Sparklines | 00:15:00 | ||
Activity_Create Sparklines | 00:05:00 | ||
Create Scenarios | 00:15:00 | ||
Activity-Create Scenarios | 00:05:00 | ||
Perform a What-If Analysis | 00:15:00 | ||
Activity-Perform a What-If Analysis | 00:05:00 | ||
Perform a Statistical Analysis with the Analysis ToolPak | 00:15:00 | ||
Activity-Perform a Statistical Analysis with the Analysis ToolPak | 00:05:00 | ||
Module 14: Interactive and Consolidated Data | |||
Create Interactive Data with Power View | 00:15:00 | ||
Activity-Create Interactive Data with Power View | 00:05:00 | ||
Consolidate Data | 00:15:00 | ||
Activity-Consolidate Data | 00:05:00 | ||
Module 15: Cells Linking, Workbooks and Web Query | |||
Link Cells in Different Workbooks | 00:15:00 | ||
Activity-Link Cells in Different Workbooks | 00:05:00 | ||
Merge Workbooks | 00:15:00 | ||
Activity-Merge Workbooks | 00:05:00 | ||
Export Excel Data | 00:15:00 | ||
Activity-Export Excel Data | 00:05:00 | ||
Import a Delimited Text File | 00:15:00 | ||
Activity- Import a Delimited Text File | 00:05:00 | ||
Integrate Excel Data with the Web | 00:15:00 | ||
Activity-Integrate Excel Data with the Web | 00:05:00 | ||
Create a Web Query | 00:15: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 | 01:00:00 | ||
Edit a Macro | 01:00:00 | ||
Debug a Macro | 00:30:00 | ||
Customize the Quick Access Toolbar and Hotkeys | 00:30:00 | ||
Set Macro Security | 01:00:00 | ||
Insert Text | 00:30:00 | ||
Format Text | 00:30:00 | ||
Sort Data | 00:30:00 | ||
Duplicate Data | 01:00:00 | ||
Generate a Report | 01:00:00 | ||
Determine the Dialog Box Type | 00:15:00 | ||
Capture User Input | 01:00:00 | ||
Module 17: Worksheets | |||
Insert, Copy, and Delete Worksheets | 00:30:00 | ||
Rename Worksheets | 00:30:00 | ||
Modify the Order of Worksheets | 00:15:00 | ||
Print Worksheets | 00:30:00 | ||
Create User-Defined Functions | 00:30:00 | ||
Automate SUM Functions | 00:30:00 | ||
Excel PowerPivot | |||
Module 18: PowerPivot | |||
Enable and Navigate | 00:30:00 | ||
Import Data from Various Data Sources | 01:00:00 | ||
Refresh Data from a Data Source | 00:30:00 | ||
Create Linked Tables | 00:30:00 | ||
Organize and Format Tables | 00:30:00 | ||
Create Calculated Columns | 00:30:00 | ||
Sort and Filter PowerPivot Data | 00:30:00 | ||
Create and Manage Table Relationships | 01:00:00 | ||
Module 19: PivotTables, Charts and DAX Functions | |||
Create PivotTables | 01:00:00 | ||
Create PivotCharts | 00:30:00 | ||
Create Power Views | 01:00:00 | ||
Filter Data Using Slicers | 00:30:00 | ||
Present PivotTable Data Visually | 01:00:00 | ||
Manipulate PowerPivot Data Using DAX Functions | 01:00:00 | ||
Extract Data from Tables Using Functions | 00:30:00 | ||
Save Reports in Different File Formats | 01:00:00 | ||
Work with Time Dependent Data | 00:30:00 | ||
Protect Reports | 00:30: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 | ||
Mock Exam | |||
Mock Exam- Microsoft Excel Complete Bundle | 00:30:00 | ||
Final Exam | |||
Final Exam- Microsoft Excel Complete Bundle | 00:30:00 | ||
(Optional) Assignment | |||
Assignment – Microsoft Excel Complete Bundle | 01:30:00 |
Membership renews after 12 months. You can cancel anytime from your account.