| 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 | ||
Motivating, Performance Managing and Maintaining Team Culture in a Remote Team
Testimonial
