Excel Training - CNG
Your Instructor
Course Curriculum
Introduction To Excel
Available in
days
days
after you enroll
-
StartResources - Files For Module Exercises
-
StartModule 1: Creating a Worksheet and a Chart (32:32)
-
StartModule 2: Formulas, Functions, and Formatting Objectives (41:01)
-
StartModule 3: Working with Large Worksheets, Charting, and What-If Analysis - Part 1 (17:17)
-
StartModule 3: Formulas - Absolute and Relative Cell Referencing - Part2 (14:28)
-
StartModule 3 - Charting, and What-If Analysis - Part III (20:15)
-
StartModule 3 - Charting, and What-If Analysis - Part IV (1:39)
Intermediate Excel
Available in
days
days
after you enroll
-
StartModule 4: Financial Functions, Data Tables, and Amortization Schedules (18:55)
-
StartModule 4 - Amortization Schedules- Print Areas- Formula Checking Part 2 (17:05)
-
StartModule 5: Working with Multiple Worksheets and Workbooks (21:09)
-
StartModule 5: Part 2 - Working with Multiple Worksheets and Workbooks (11:56)
-
StartModule 5 - 3-D Pie Charts (5:01)
-
StartModule 5 - Printing Worksheets- Headers, Footers (2:52)
-
StartModule 5 - Consolidating Worksheets in Separate Workbooks (4:43)
-
StartModule 6: Creating, Sorting, and Querying a Table (24:23)
-
StartModule 6 - Queries, Criteria Ranges (12:15)
-
StartModule 6 - Using Database Functions (16:47)
-
StartModule 6 - Summarizing Data and Treemap Charts (9:49)
-
StartModule 7: Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots (17:14)
-
StartModule 7: Importing Data - CSV, Microsoft Access, Web Pages - Part 2 (35:02)
-
StartModule 7: Quick Gallery - Find And Replace- Clustered Bar Chart (12:06)
Advanced Excel
Available in
days
days
after you enroll
-
StartModule 8: Working with Trendlines, PivotTables, PivotCharts, and Slicers (10:41)
-
StartModule 8: PivotTables and PivotCharts (9:53)
-
StartModule 8: Functions, Drilling Down - Expand Collapse Categories - Update PivotTables (8:50)
-
StartModule 8 - Creating and Formating PivotTables and PivotCharts -2 (13:59)
-
StartModule 8: Working with Slicers - Box and Whisker Charts (8:35)
-
StartModule 9: Formula Auditing, Data Validation, and Complex Problem Solving (21:10)
-
StartModule 9 - Complex Problem Solving (12:29)
-
StartModule 10: Data Analysis with Power Tools and Creating Macros
-
StartModule 11: User Interfaces, Visual Basic for Applications (VBA), and Collaboration Features
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.