Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Training - CNG
Introduction To Excel
Resources - Files For Module Exercises
Module 1: Creating a Worksheet and a Chart (32:32)
Module 2: Formulas, Functions, and Formatting Objectives (41:01)
Module 3: Working with Large Worksheets, Charting, and What-If Analysis - Part 1 (17:17)
Module 3: Formulas - Absolute and Relative Cell Referencing - Part2 (14:28)
Module 3 - Charting, and What-If Analysis - Part III (20:15)
Module 3 - Charting, and What-If Analysis - Part IV (1:39)
Intermediate Excel
Module 4: Financial Functions, Data Tables, and Amortization Schedules (18:55)
Module 4 - Amortization Schedules- Print Areas- Formula Checking Part 2 (17:05)
Module 5: Working with Multiple Worksheets and Workbooks (21:09)
Module 5: Part 2 - Working with Multiple Worksheets and Workbooks (11:56)
Module 5 - 3-D Pie Charts (5:01)
Module 5 - Printing Worksheets- Headers, Footers (2:52)
Module 5 - Consolidating Worksheets in Separate Workbooks (4:43)
Module 6: Creating, Sorting, and Querying a Table (24:23)
Module 6 - Queries, Criteria Ranges (12:15)
Module 6 - Using Database Functions (16:47)
Module 6 - Summarizing Data and Treemap Charts (9:49)
Module 7: Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots (17:14)
Module 7: Importing Data - CSV, Microsoft Access, Web Pages - Part 2 (35:02)
Module 7: Quick Gallery - Find And Replace- Clustered Bar Chart (12:06)
Advanced Excel
Module 8: Working with Trendlines, PivotTables, PivotCharts, and Slicers (10:41)
Module 8: PivotTables and PivotCharts (9:53)
Module 8: Functions, Drilling Down - Expand Collapse Categories - Update PivotTables (8:50)
Module 8 - Creating and Formating PivotTables and PivotCharts -2 (13:59)
Module 8: Working with Slicers - Box and Whisker Charts (8:35)
Module 9: Formula Auditing, Data Validation, and Complex Problem Solving (21:10)
Module 9 - Complex Problem Solving (12:29)
Module 10: Data Analysis with Power Tools and Creating Macros
Module 11: User Interfaces, Visual Basic for Applications (VBA), and Collaboration Features
Module 7: Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock