• LOGIN
  • No products in the cart.

Login

Course Curriculum

Course Curriculum

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

Microsoft Excel Complete Training

4.9( 7 REVIEWS )
2097 STUDENTS
$ 249.00
Excel Crash Course

Behavioral Problems Enrichment and Training

Behavioral Problems Enrichment and Training

Testimonial

Hear what our happy students want to say

Setup Menus in Admin Panel