- 1 year
- Advanced, Intermediate
- Course Certificate
- Number of Units124
- Number of Quizzes6
- 2 days Gift this course
Course Curriculum
Microsoft Excel 2016 Intermediate Training Diploma | |||
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 | ||
Create and Modify Tables | 00:30:00 | ||
Sort and Filter Data3 | 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 | ||
Create and Use Templates | 00:30:00 | ||
Protect Files3 | 00:30:00 | ||
Preparing a Workbook for Multiple Audiences | 00:30:00 | ||
Activities – Microsoft Excel 2016 Intermediate | 00:00:00 | ||
Microsoft Excel 2016 Advanced Level | |||
Update Workbook Properties3 | 00:15:00 | ||
Activity-Update Workbook Properties | 00:05:00 | ||
Create and Edit a Macro3 | 00:15:00 | ||
Activity-Create and Edit a Macro | 00:05:00 | ||
Apply Conditional Formatting | 00:30: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 | ||
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 | ||
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 | ||
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:14: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 | ||
Activities and Exercise Files – Microsoft Excel 2016 Advanced | 00:00:00 | ||
Microsoft Excel 2016 and VBA Training Diploma | |||
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 | ||
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 | ||
Activities – Microsoft Excel 2016 and VBA | 00:00:00 | ||
Microsoft Office 2016 Excel Advanced - Certified Video Training | |||
Use Links and External References | 00:12:00 | ||
Use 3-D References | 00:06:00 | ||
Consolidate Data | 00:05:00 | ||
Use Lookup Functions | 00:12:00 | ||
Trace Cells | 00:09:00 | ||
Watch and Evaluate Formulas | 00:08:00 | ||
Collaborate on a Workbook | 00:19:00 | ||
Protect Worksheets and Workbooks | 00:08:00 | ||
Apply Data Validation | 00:13:00 | ||
Search for Invalid Data and Formulas with Errors | 00:04:00 | ||
Work with Macros | 00:18:00 | ||
Create Sparklines | 00:07:00 | ||
MapData | 00:07:00 | ||
Determine Potential Outcomes Using Data Tables | 00:08:00 | ||
Determine Potential Outcomes Using Scenarios | 00:09:00 | ||
Use the Goal Seek Feature | 00:04:00 | ||
Forecasting Data Trends | 00:05:00 | ||
Microsoft Excel 2016 PowerPivot Advanced | |||
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 | ||
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 – Microsoft Excel 2016 PowerPivot Advanced | 00:00:00 | ||
Mock Exam – Microsoft Excel 2016 Intermediate Training Diploma | |||
Mock Exam – Microsoft Excel 2016 Intermediate Training Diploma | 00:20:00 | ||
Final Exam – Microsoft Excel 2016 Intermediate Training Diploma | |||
Final Exam – Microsoft Excel 2016 Intermediate Training Diploma | 00:20:00 | ||
Mock Exam – Microsoft Excel 2016 Advanced Level | |||
Mock Exam – Microsoft Excel 2016 Advanced Level | 00:20:00 | ||
Final Exam – Microsoft Excel 2016 Advanced Level | |||
Final Exam – Microsoft Excel 2016 Advanced Level | 00:20:00 | ||
Mock Exam – Microsoft Excel 2016 and VBA Training Diploma | |||
Mock Exam- Microsoft Excel 2016 and VBA Training Diploma | 00:20:00 | ||
Final Exam – Microsoft Excel 2016 and VBA Training Diploma | |||
Final Exam- Microsoft Excel 2016 and VBA Training Diploma | 00:20:00 |
Course Ratings
No Ratings found for this course.