Course Duration 10h 15m
- Parts of the Excel 2007/2010 course are available for free - register here.
- The entire course is available to paying customers.
- Only paying customers get to download and keep the practice workbooks.
Session 1: Introduction
| Free | Premium | ||
| 1.01 | Introduction | 0:00:55 | 0:00:55 |
| 1.02 | Interface | 0:03:30 | 0:03:30 |
| 1.03 | Tabs and Ribbons | 0:02:30 | 0:02:30 |
| 1.04 | Document Windows | 0:11:50 | 0:11:50 |
| 1.05 | Navigation Tips | 0:04:59 | 0:04:59 |
| 1.06 | Office Button and Save (2007) Backstage (2010) | 0:02:13 | 0:02:13 |
| 0:25:57 | 0:25:57 |
Session 2: Entering, Editing and Formatting Data
| Free | Premium | ||
| 2.01 | Introduction | 0:01:31 | 0:01:31 |
| 2.02 | Entering Data | 0:02:58 | 0:02:58 |
| 2.03 | Fonts, Fills, and Alignment | 0:06:59 | 0:06:59 |
| 2.04 | Cut, Copy & Paste | 0:06:01 | 0:06:01 |
| 2.05 | Paste Special |  |
0:05:18 |
| 2.06 | Undo and Redo | |
0:02:45 |
| 2.07 | Moving, Finding, and Replacing a Value | |
0:07:50 |
| 2.08 | Cell Styles | |
0:04:17 |
| 2.09 | Comments | |
0:02:52 |
| 2.10 | Copy as Picture (2010 only) | |
0:02:48 |
| 0:17:29 | 0:40:28 |
Session 3: Formatting Numbers
| Free | Premium | ||
| 3.01 | Introduction | 0:01:00 | 0:01:00 |
| 3.02 | Currency Format | 0:03:11 | 0:03:11 |
| 3.03 | Format Painter | 0:03:15 | 0:03:15 |
| 3.04 | Formatting Dates | 0:03:30 | 0:03:30 |
| 3.05 | Custom and Special Formats | 0:06:08 | 0:06:08 |
| 0:17:04 | 0:17:04 |
Session 4: Managing Worksheets
| Free | Premium | ||
| 4.01 | Introduction | 0:01:25 | 0:01:25 |
| 4.02 | Naming and Moving Worksheets | 0:03:26 | 0:03:26 |
| 4.03 | Copying Worksheets | 0:02:37 | 0:02:37 |
| 4.04 | Adding, Deleting and Hiding Worksheets | 0:02:43 | 0:02:43 |
| 4.05 | Grouping Worksheets | |
0:02:40 |
| 4.06 | Moving, Copying, Deleting and Hiding Grouped Worksheets | |
0:03:51 |
| 0:10:11 | 0:17:02 |
Session 5: Modifying Rows and Columns
| Free | Premium | ||
| 5.01 | Introduction | 0:01:13 | 0:01:13 |
| 5.02 | Inserting and Deleting Columns and Rows | 0:04:17 | 0:04:17 |
| 5.03 | Inserting & Deleting Cells | 0:03:01 | 0:03:01 |
| 5.04 | Inserting Multiple Columns & Rows | 0:02:03 | 0:02:03 |
| 5.05 | Modifying Cell Width and Height | 0:05:44 | 0:05:44 |
| 5.06 | Hiding and Unhiding Rows and Columns | 0:01:51 | 0:01:51 |
| 0:18:09 | 0:18:09 |
Session 6: Understanding Formulas
| Free | Premium | ||
| 6.01 | Introduction | 0:01:31 | 0:01:31 |
| 6.02 | Using Operations | 0:03:11 | 0:03:11 |
| 6.04 | Creating Formulas | 0:04:27 | 0:04:27 |
| 6.04 | AutoSum | 0:03:40 | 0:03:40 |
| 6.05 | Common Formulas | 0:04:48 | 0:04:48 |
| 6.06 | Searching for Formulas | 0:03:52 | 0:03:52 |
| 6.07 | Copying Formulas | 0:03:01 | 0:03:01 |
| 6.08 | Using Relative and Absolute References | |
0:08:19 |
| 0:24:30 | 0:32:49 |
Session 7: Changing Views
| Free | Premium | ||
| 7.01 | Introduction | 0:01:47 | 0:01:47 |
| 7.02 | Workbook Views | 0:05:13 | 0:05:13 |
| 7.03 | Show/Hide | 0:02:00 | 0:02:00 |
| 7.04 | Zoom Features | 0:02:34 | 0:02:34 |
| 7.05 | Freeze Panes | |
0:03:21 |
| 7.06 | Split Windows | |
0:01:49 |
| 7.07 | Viewing Multiple Windows | |
0:05:05 |
| 7.08 | Minimize The Ribbon | |
0:01:01 |
| 7.09 | Worksheet Backgrounds | |
0:01:44 |
| 7.10 | Watermarks | |
0:04:06 |
| 0:11:34 | 0:28:40 |
Session 8: AutoFill and Custom Lists
| Free | Premium | ||
| 8.01 | Introduction | 0:01:30 | 0:01:30 |
| 8.02 | AutoFill a Series | 0:03:28 | 0:03:28 |
| 8.03 | AutoFill Non-Adjacent Cells | |
0:02:09 |
| 8.04 | AutoFill on Multiple Sheets | |
0:01:39 |
| 8.05 | Creating Custom Lists | |
0:04:05 |
| 8.06 | Series Formatting | |
0:01:29 |
| 0:04:58 | 0:14:20 |
Session 9: Conditional Formatting
| Free | Premium | ||
| 9.01 | Introduction | 0:01:02 | 0:01:02 |
| 9.02 | Highlight Cells Rules | |
0:02:41 |
| 9.03 | Top/Bottom Rules | |
0:02:34 |
| 9.04 | Data Bars | |
0:01:19 |
| 9.05 | Color Scales | |
0:01:39 |
| 9.06 | Custom Formatting Rule | |
0:03:14 |
| 0:01:02 | 0:12:29 |
Session 10: Tables
| Free | Premium | ||
| 10.01 | Introduction | 0:01:03 | 0:01:03 |
| 10.02 | Insert a Table and Style Options | |
0:03:26 |
| 10.03 | Add Rows and Columns | |
0:02:39 |
| 10.04 | Perform a Function in a Table | |
0:04:18 |
| 10.05 | Summarise With Pivot Table | |
0:02:58 |
| 0:01:03 | 0:14:24 |
Session 11: Data Tools
| Free | Premium | ||
| 11.01 | Introduction | 0:01:38 | 0:01:38 |
| 11.02 | Data Validation | |
0:06:27 |
| 11.03 | Drop-Down Lists | |
0:04:04 |
| 11.04 | Removing Duplicates | |
0:02:35 |
| 11.05 | Text To Columns | |
0:04:19 |
| 11.06 | Goal Seek | |
0:03:43 |
| 11.07 | Scenario Manager | |
0:04:38 |
| 11.08 | Importing and Exporting Data | |
0:11:16 |
| 0:01:38 | 0:38:41 |
Session 12: Referencing Formulas
| Free | Premium | ||
| 12.01 | Introduction | 0:01:53 | 0:01:53 |
| 12.02 | Multiple Sheet References | |
0:01:37 |
| 12.03 | Consolidating Data - With or Without Links | |
0:06:37 |
| 12.04 | Trace the Precedents and Dependents | |
0:03:10 |
| 12.05 | Using the Watch Window | |
0:02:47 |
| 0:01:53 | 0:16:04 |
Session 13: Ranges and Dates
| Free | Premium | ||
| 13.01 | Introduction | 0:01:11 | 0:01:11 |
| 13.02 | Cell Names | |
0:04:21 |
| 13.03 | Named Ranges | |
0:01:44 |
| 13.04 | Formulas with Cell Names | |
0:02:17 |
| 13.05 | Date Formulas | |
0:05:22 |
| 0:01:11 | 0:14:55 |
Session 14: Lookups
| Free | Premium | ||
| 14.01 | Introduction | 0:01:27 | 0:01:27 |
| 14.02 | VLOOKUP | |
0:06:20 |
| 14.03 | VLOOKUP Exact Match Tool | |
0:09:17 |
| 14.04 | HLOOKUP | |
0:03:52 |
| 14.05 | HLOOKUP Exact Match | |
0:01:36 |
| 14.06 | CHOOSE | |
0:06:12 |
| 14.07 | INDEX & MATCH | |
0:07:05 |
| 0:01:27 | 0:35:49 |
Session 15: Conditional Logic
| Free | Premium | ||
| 15.01 | Introduction | 0:01:14 | 0:01:14 |
| 15.02 | IF Statement | |
0:07:43 |
| 15.03 | Nested IF | |
0:04:21 |
| 15.04 | IF AND | |
0:03:01 |
| 15.05 | IF OR | |
0:02:43 |
| 15.06 | IF NOT | |
0:01:52 |
| 15.07 | IFERROR | |
0:02:19 |
| 15.08 | SUMIF and SUMIFS | |
0:04:15 |
| 15.09 | AVERAGEIF and AVERAGEIFS | |
0:04:41 |
| 15.10 | COUNTIF and COUNTIFS | |
0:09:46 |
| 15.11 | SUMPRODUCT | |
0:10:18 |
| 0:01:14 | 0:51:53 |
Session 16: Text Formulas
| Free | Premium | ||
| 16.01 | Introduction | 0:01:30 | 0:01:30 |
| 16.02 | Case Formulas | |
0:01:41 |
| 16.03 | Fix Number Fields | |
0:02:47 |
| 16.04 | Trim Spaces | |
0:01:23 |
| 16.05 | Substitute Text | |
0:02:14 |
| 0:01:30 | 0:09:35 |
Session 17: Introduction to Charts
| Free | Premium | ||
| 17.01 | Introduction | 0:00:50 | 0:00:50 |
| 17.02 | Chart Types | |
0:02:01 |
| 17.03 | Instant Chart | |
0:01:33 |
| 17.04 | Update Chart | |
0:02:56 |
| 17.05 | Column Chart | |
0:03:47 |
| 17.06 | Picture Fill | |
0:02:21 |
| 17.07 | Adjust Chart Size | |
0:02:44 |
| 17.08 | Line Chart | |
0:02:43 |
| 17.09 | Scatter Chart | |
0:02:05 |
| 17.10 | Sparklines (Excel 2010) | |
0:12:08 |
| 0:00:50 | 0:33:06 |
Session 18: Formatting Charts
| Free | Premium | ||
| 18.01 | Introduction | 0:01:05 | 0:01:05 |
| 18.02 | Chart Styles | |
0:02:26 |
| 18.03 | Chart Layouts | |
0:03:39 |
| 18.04 | Add Labels | |
0:03:28 |
| 18.05 | Axis Options | |
0:03:40 |
| 18.06 | Chart Title | |
0:03:40 |
| 18.07 | Legends | |
0:02:15 |
| 18.08 | Data Labels | |
0:03:40 |
| 0:01:05 | 0:23:53 |
Session 19: Adding Graphics to Spreadsheets
| Free | Premium | ||
| 19.01 | Introduction | 0:01:07 | 0:01:07 |
| 19.02 | Insert Pictures | |
0:02:36 |
| 19.03 | Modifying Pictures | |
0:03:44 |
| 19.04 | Insert Shapes | |
0:04:01 |
| 19.05 | Insert SmartArt | |
0:05:11 |
| 19.06 | Apply Themes | |
0:03:42 |
| 19.07 | Arrange | |
0:06:36 |
| 0:01:07 | 0:26:57 |
Session 20: Outline, Sort, Filter, and Subtotal
| Free | Premium | ||
| 20.01 | Introduction | 0:00:57 | 0:00:57 |
| 20.02 | Group and Ungroup | |
0:03:05 |
| 20.03 | Sort Data | |
0:01:52 |
| 20.04 | Sort Multiple Levels | |
0:02:37 |
| 20.05 | Filter Data | |
0:03:18 |
| 20.06 | Advanced Filter | |
0:05:41 |
| 20.07 | Conditional Sorting and Filtering | |
0:01:47 |
| 20.08 | Sorting with Custom Lists | |
0:02:54 |
| 20.09 | Subtotal | |
0:04:22 |
| 0:00:57 | 0:26:33 |
Session 21: PivotTables
| Free | Premium | ||
| 21.01 | Introduction | 0:01:14 | 0:01:14 |
| 21.02 | Creating PivotTables | |
0:02:48 |
| 21.03 | Choosing Fields | |
0:04:07 |
| 21.04 | PivotTable Layout | |
0:03:29 |
| 21.05 | Filtering PivotTables | |
0:02:04 |
| 21.06 | Modifying PivotTable Data | |
0:02:10 |
| 21.07 | PivotCharts | |
0:03:38 |
| 21.08 | Slicers (2010 only) | |
0:05:04 |
| 0:01:14 | 0:24:34 |
Session 22: Protecting Data
| Free | Premium | ||
| 22.01 | Introduction | 0:00:40 | 0:00:40 |
| 22.02 | Workbook Passwords | |
0:03:40 |
| 22.03 | Protecting Workbooks | |
0:03:08 |
| 22.04 | Unlocking Cells | |
0:04:00 |
| 0:00:40 | 0:11:28 |
Session 23: Collaboration
| Free | Premium | ||
| 23.01 | Introduction | 0:01:07 | 0:01:07 |
| 23.02 | Document Properties | |
0:04:26 |
| 23.03 | Inserting Hyperlinks | |
0:04:23 |
| 23.04 | Sharing a Workbook | |
0:02:45 |
| 23.05 | Track Changes | |
0:03:55 |
| 23.06 | Accept/Reject Changes | |
0:02:30 |
| 23.07 | Mark as Final | |
0:03:08 |
| 0:01:07 | 0:22:14 |
Session 24: Printing
| Free | Premium | ||
| 24.01 | Introduction | 0:01:04 | 0:01:04 |
| 24.02 | Page Orientation | 0:01:54 | 0:01:54 |
| 24.03 | Page Breaks | 0:03:02 | 0:03:02 |
| 24.04 | Print Area | 0:02:37 | 0:02:37 |
| 24.05 | Margins | 0:06:11 | 0:06:11 |
| 24.06 | Print Titles | |
0:03:08 |
| 24.07 | Headers and Footers | |
0:07:16 |
| 24.08 | Scaling | |
0:04:07 |
| 24.09 | Sheet Options | |
0:04:48 |
| 0:14:48 | 0:34:07 |
Session 25: Saving a Workbook
| Free | Premium | ||
| 25.01 | Introduction | 0:01:41 | 0:01:41 |
| 25.02 | Save As Previous Version | 0:03:40 | 0:03:40 |
| 25.03 | AutoRecover Save Options | |
0:04:08 |
| 25.04 | Templates | |
0:04:28 |
| 25.05 | Save As PDF | |
0:01:50 |
| 25.06 | Save As Web Page | |
0:03:15 |
| 25.07 | Macro-Enabled Workbook | |
0:05:14 |
| 0:05:21 | 0:24:16 |
Session 26: Macros
| Free | Premium | ||
| 26.01 | Introduction and Macro Security | |
0:03:40 |
| 26.02 | Recording a Macro | |
0:04:37 |
| 26.03 | Assign a Macro to a Button or a Shape | |
0:03:33 |
| 26.04 | Run a Macro upon Opening a Workbook | |
0:02:57 |
| 26.05 | How to Inspect and Modify a Macro | |
0:03:41 |
| 0:00:00 | 0:18:28 |
Course Duration 16h 45m
- Parts of the Excel 2013 course are available for free - register here.
- The entire course is available to paying customers.
- Only paying customers get to download and keep the practice workbooks.
Session 1: Introduction
| Free | Premium | ||
| 1.01 | Interface | 0:07:33 | 0:07:33 |
| 1.02 | Tabs and Ribbons | 0:08:05 | 0:08:05 |
| 1.03 | File Tab | 0:06:52 | 0:06:52 |
| 1.04 | Navigation Tips | 0:06:25 | 0:06:25 |
| 0:28:55 | 0:28:55 |
Session 2: Entering, Editing and Formatting Data
| Free | Premium | ||
| 2.01 | Entering Data, Undo and Redo | 0:06:35 | 0:06:35 |
| 2.02 | Fonts Fills and Alignment | 0:19:38 | 0:19:38 |
| 2.03 | Mini Toolbar | 0:02:11 | 0:02:11 |
| 2.04 | Cut, Copy & Paste | 0:11:37 | 0:11:37 |
| 2.05 | Paste Special | 0:11:57 | 0:11:57 |
| 2.06 | Find and Replace | |
0:11:52 |
| 2.07 | Cell Styles | |
0:15:35 |
| 2.08 | Comments | |
0:09:55 |
| 2.09 | Copy as Picture | |
0:04:22 |
| 0:51:58 | 1:33:42 |
Session 3: Formatting Numbers
| Free | Premium | ||
| 3.01 | Currency Format | 0:08:12 | 0:08:12 |
| 3.02 | Formatting Dates | 0:10:19 | 0:10:19 |
| 3.03 | Format Painter | 0:06:11 | 0:06:11 |
| 3.04 | Custom and Special Formats | |
0:09:30 |
| 0:24:43 | 0:34:13 |
Session 4: Managing Worksheets
| Free | Premium | ||
| 4.01 | Name, Copy, Move, Add, Delete & Hide Worksheets | 0:09:33 | 0:09:33 |
| 4.02 | Grouping Worksheets | |
0:03:37 |
| 4.03 | Move, Copy, Delete and Hide Grouped Worksheets | |
0:05:18 |
| 0:09:33 | 0:18:28 |
Session 5: Modifying Rows and Columns
| Free | Premium | ||
| 5.01 | Inserting and Deleting Columns, Rows and Cells | 0:13:39 | 0:13:39 |
| 5.02 | Modifying Cell Width and Height | 0:13:39 | 0:13:39 |
| 5.03 | Hiding and Unhiding Rows and Columns | 0:02:53 | 0:02:53 |
| 0:23:07 | 0:23:07 |
Session 6: Changing Views
| Free | Premium | ||
| 6.01 | Workbook Views | 0:09:59 | 0:09:59 |
| 6.02 | Show/Hide | 0:06:57 | 0:06:57 |
| 6.03 | Zoom Features | 0:03:48 | 0:03:48 |
| 6.04 | Freeze Panes and Split Windows | |
0:04:37 |
| 6.05 | Viewing Multiple Windows | |
0:05:43 |
| 6.06 | Minimize the Ribbon | |
0:07:02 |
| 0:20:44 | 0:37:41 |
Session 7: Saving a Workbook
| Free | Premium | ||
| 7.01 | Save As and Save | 0:06:57 | 0:06:57 |
| 7.02 | Saving Different File Types | 0:07:45 | 0:07:45 |
| 7.03 | Auto Recover and Save Options | |
0:05:35 |
| 7.04 | Templates | |
0:10:11 |
| 7.05 | Save As PDF | |
0:04:44 |
| 7.06 | Save As Web Page | |
0:06:20 |
| 7.07 | Macro-Enabled Workbook | |
0:04:58 |
| 0:14:42 | 0:46:30 |
Session 8: Print Set Up
| Free | Premium | ||
| 8.01 | Set Print Area, Margins, Orientation and Size | 0:08:07 | 0:08:07 |
| 8.02 | Page Break and Titles | 0:06:30 | 0:06:30 |
| 8.03 | Headers and Footers | |
0:09:51 |
| 8.04 | Sheet Options | |
0:04:08 |
| 8.05 | Worksheet Backgrounds | |
0:05:19 |
| 0:14:47 | 0:33:55 |
Session 9: Introduction to Formulas
| Free | Premium | ||
| 9.01 | Using Operations | 0:08:47 | 0:08:47 |
| 9.02 | Creating Formulas and Common Functions | 0:05:46 | 0:05:46 |
| 9.03 | Searching for Functions | 0:06:04 | 0:06:04 |
| 9.04 | Cutting and Copying Formulas | 0:04:56 | 0:04:56 |
| 9.05 | Date Formulas | |
0:12:27 |
| 9.06 | Using Relative and Absolute References | |
0:10:50 |
| 9.07 | Multiple Sheet References | |
0:05:26 |
| 0:25:33 | 0:54:16 |
Session 10: Lookups
| Free | Premium | ||
| 10.01 | VLOOKUP Sorted List | |
0:07:19 |
| 10.02 | VLOOKUP Exact Match | |
0:05:36 |
| 10.03 | HLOOKUP Sorted List | |
0:05:32 |
| 10.04 | HLOOKUP Exact Match | |
0:04:18 |
| 10.05 | CHOOSE | |
0:07:14 |
| 10.06 | INDEX and MATCH | |
0:11:44 |
| 10.07 | FORMULATEXT | |
0:02:38 |
| 0:00:00 | 0:44:21 |
Session 11: Conditional Logic
| Free | Premium | ||
| 11.01 | IF | |
0:04:39 |
| 11.02 | Nested IF | |
0:07:54 |
| 11.03 | IF AND | |
0:07:19 |
| 11.04 | IF OR | |
0:04:42 |
| 11.05 | IF NOT | |
0:05:56 |
| 11.06 | XOR | |
0:07:32 |
| 11.07 | IFERROR & IFNA | |
0:06:06 |
| 11.08 | SUMIF & SUMIFS | |
0:05:09 |
| 11.09 | AVERAGEIF & AVERAGEIFS | |
0:04:19 |
| 11.10 | COUNTIF & COUNTIFS | |
0:03:43 |
| 11.11 | SUMPRODUCT | |
0:06:03 |
| 0:00:00 | 1:03:22 |
Session 12: Text Formulas
| Free | Premium | ||
| 12.01 | Case Formulas - UPPER, LOWER, PROPER | |
0:02:39 |
| 12.02 | Convert Text to Numbers with VALUE | |
0:03:09 |
| 12.03 | Remove Spaces with TRIM | |
0:03:16 |
| 12.04 | Substitute Text with SUBSTITUTE | |
0:03:47 |
| 12.05 | Convert Numbers to Text with FIXED | |
0:03:26 |
| 0:00:00 | 0:16:17 |
Session 13: Named Ranges
| Free | Premium | ||
| 13.01 | Cell Names | |
0:05:45 |
| 13.02 | Named Ranges | |
0:05:36 |
| 13.03 | Writing Formulas with Cell Names | |
0:03:01 |
| 13.04 | Named Formulas | |
0:05:05 |
| 0:00:00 | 0:19:27 |
Session 14: Formula Tools
| Free | Premium | ||
| 14.01 | Trace the Precedents and Dependents | |
0:05:04 |
| 14.02 | Using the Watch Window | |
0:05:24 |
| 14.03 | Evaluate Formula Tool | |
0:05:04 |
| 14.04 | Show Formulas and Error Checking | |
0:08:22 |
| 0:00:00 | 0:23:54 |
Session 15: AutoFill and Custom Lists
| Free | Premium | ||
| 15.01 | AutoFill a Series | 0:10:49 | 0:10:49 |
| 15.02 | AutoFill Non-Adjacent Cells | |
0:04:52 |
| 15.03 | AutoFill on Multiple Sheets | |
0:04:09 |
| 15.04 | Flash Fill | |
0:03:16 |
| 15.05 | Creating Custom Lists | |
0:06:53 |
| 15.06 | Series Formatting | |
0:03:25 |
| 0:10:49 | 0:33:24 |
Session 16: Conditional Formatting
| Free | Premium | ||
| 16.01 | Highlight Cells Rules | 0:07:14 | 0:07:14 |
| 16.02 | Top/Bottom Rules | 0:06:17 | 0:06:17 |
| 16.03 | Data Bars | 0:04:09 | 0:04:09 |
| 16.04 | Color Scales | 0:04:34 | 0:04:34 |
| 16.05 | Custom Formatting Rule | |
0:05:23 |
| 16.06 | Quick Analysis | |
0:04:27 |
| 16.07 | Icon Sets | |
0:03:46 |
| 0:22:14 | 0:35:50 |
Session 17: Tables
| Free | Premium | ||
| 17.01 | Insert a Table and Style Options | 0:04:38 | 0:04:38 |
| 17.02 | Add Rows and Columns | |
0:04:42 |
| 17.03 | Perform a Function in a Table | |
0:04:15 |
| 17.04 | Slicers for Tables | |
0:08:38 |
| 0:04:38 | 0:22:13 |
Session 18: Introduction to Charts
| Free | Premium | ||
| 18.01 | Chart Types | 0:07:55 | 0:07:55 |
| 18.02 | Recommended Charts | 0:06:32 | 0:06:32 |
| 18.03 | Update Chart | |
0:09:45 |
| 18.04 | Column Chart | |
0:08:09 |
| 18.05 | Picture Fill | |
0:08:23 |
| 18.06 | Adjust Chart Size | |
0:05:46 |
| 18.07 | Line Chart | |
0:05:48 |
| 18.08 | Scatter and Bubble Charts | |
0:05:54 |
| 18.09 | Sparklines | |
0:08:14 |
| 0:14:27 | 1:06:26 |
Session 19: Formatting Charts
| Free | Premium | ||
| 19.01 | Chart Styles | |
0:05:02 |
| 19.02 | Chart Layouts | |
0:08:46 |
| 19.03 | Quick Fine Tune | |
0:07:57 |
| 19.04 | Animation in Charts | |
0:03:22 |
| 0:00:00 | 0:25:07 |
Session 20: Adding Graphics
| Free | Premium | ||
| 20.01 | Insert Pictures | 0:06:25 | 0:06:25 |
| 20.02 | Modifying Pictures | 0:15:06 | 0:15:06 |
| 20.03 | Insert Shapes | 0:08:55 | 0:08:55 |
| 20.04 | Insert SmartArt | 0:09:52 | 0:09:52 |
| 20.05 | Apply Themes | |
0:04:48 |
| 20.06 | Arrange | |
0:09:47 |
| 0:40:18 | 0:54:53 |
Session 21: Data Tools
| Free | Premium | ||
| 21.01 | Data Validation | |
0:07:18 |
| 21.02 | Removing Duplicates | |
0:03:49 |
| 21.03 | Text to Columns | |
0:05:20 |
| 21.04 | Goal Seek | |
0:02:26 |
| 21.05 | Scenario Manager | |
0:09:15 |
| 21.06 | Importing and Exporting Data | |
0:16:26 |
| 21.07 | Consolidating Data | |
0:05:38 |
| 0:00:00 | 0:50:32 |
Session 22: Sort, Filter and Subtotal
| Free | Premium | ||
| 22.01 | Sort Data | 0:02:31 | 0:02:31 |
| 22.02 | Sort Multiple Levels | |
0:03:55 |
| 22.03 | Filter Data | |
0:04:31 |
| 22.04 | Advanced Filter | |
0:09:19 |
| 22.05 | Conditional Sorting and Filtering | |
0:08:01 |
| 22.06 | Sorting with Custom Lists | |
0:04:50 |
| 22.07 | Group and Ungroup | |
0:05:25 |
| 22.08 | Subtotal Tool | |
0:05:56 |
| 0:02:31 | 0:44:28 |
Session 23: PivotTables
| Free | Premium | ||
| 23.01 | Creating PivotTables | |
0:05:57 |
| 23.02 | Choosing Fields | |
0:06:05 |
| 23.03 | PivotTable Layout | |
0:06:11 |
| 23.04 | Filtering PivotTables | |
0:04:17 |
| 23.05 | Modifying PivotTableData | |
0:04:41 |
| 23.06 | PivotCharts | |
0:03:52 |
| 23.07 | Slicers | |
0:04:28 |
| 23.08 | Timelines | |
0:05:12 |
| 0:00:00 | 0:41:43 |
Session 24: Protecting Data
| Free | Premium | ||
| 24.01 | Workbook Passwords | |
0:05:43 |
| 24.02 | Protecting Workbooks | |
0:05:03 |
| 24.03 | Unlocking Cells | |
0:05:33 |
| 0:00:00 | 0:16:19 |
Session 25: Collaboration
| Free | Premium | ||
| 25.01 | Document Properties | |
0:08:20 |
| 25.02 | Inserting Hyperlinks | |
0:11:57 |
| 25.03 | Sharing Workbook | |
0:06:58 |
| 25.04 | Track Changes | |
0:06:50 |
| 25.05 | Accept/Reject Changes | |
0:03:11 |
| 25.06 | Mark as Final | |
0:05:03 |
| 0:00:00 | 0:42:19 |
Session 26: Macros
| Free | Premium | ||
| 26.01 | Macro Security | |
0:07:15 |
| 26.02 | Recording a Macro | |
0:07:28 |
| 26.03 | How to Assign a Macro to a Button or Shape | |
0:05:55 |
| 26.04 | How to Run a Macro upon Opening a Workbook | |
0:05:47 |
| 26.05 | How To Inspect and Modify a Macro | |
0:06:43 |
| 0:00:00 | 0:33:08 |
Course Duration 13h 09m
- The Excel 2016 course and practice workbooks are only available to paying customers.
Session 1: Introduction 0:38:14
| 1.01 | Interface | 0:04:51 |
| 1.02 | Tabs & Ribbons | 0:08:04 |
| 1.03 | File Tab | 0:12:27 |
| 1.04 | Navigation Tips | 0:07:16 |
| 1.05 | Tell Me | 0:02:30 |
| 1.06 | Touch Mode | 0:03:06 |
Session 2: Entering, Editing & Formatting Data 0:45:50
| 2.01 | Entering Data, Undo & Redo | 0:04:31 |
| 2.02 | Fonts, Fills & Alignment | 0:07:33 |
| 2.03 | Mini Toolbar | 0:01:29 |
| 2.04 | Cut, Copy & Paste | 0:04:37 |
| 2.05 | Paste Special | 0:05:43 |
| 2.06 | Find & Replace | 0:07:02 |
| 2.07 | Cell Styles | 0:04:20 |
| 2.08 | Comments | 0:06:53 |
| 2.09 | Copy as Picture | 0:03:42 |
Session 3: Formatting Numbers 0:15:48
| 3.01 | Currency Format | 0:05:19 |
| 3.02 | Formatting dates | 0:02:49 |
| 3.03 | Format Painter | 0:02:27 |
| 3.04 | Custom & Special Formats | 0:05:13 |
Session 4: Managing Worksheets 0:17:44
| 4.01 | Name, Copy, Move, Add, Delete & Hide Worksheets | 0:08:09 |
| 4.02 | Grouping Worksheets | 0:02:25 |
| 4.03 | Move, Copy, Delete and Hide Grouped Worksheets | 0:07:10 |
Session 5: Modifying Rows and Columns 0:18:45
| 5.01 | Inserting and Deleting Columns, Rows and Cells | 0:08:46 |
| 5.02 | Modifying Cell Width and Height | 0:04:44 |
| 5.03 | Referencing another Calculated Column | 0:01:28 |
Session 6: Changing Views 00:25:09
| 6.01 | Workbook Views | 00:03:24 |
| 6.02 | Show/Hide and Custom Views | 00:05:13 |
| 6.03 | Zoom Features | 00:03:34 |
| 6.04 | Freeze Panes and Split Windows | 00:07:15 |
| 6.05 | Viewing Multiple Windows | 00:05:43 |
Session 7: Saving a Workbook 00:30:50
| 7.01 | Save As and Save | 00:06:26 |
| 7.02 | Saving Different File Types | 00:03:47 |
| 7.03 | AutoRecover Save Options | 00:05:35 |
| 7.04 | Templates | 00:06:04 |
| 7.05 | Save As PDF | 00:04:27 |
| 7.06 | Macro-Enabled Workbook | 00:04:31 |
Session 8: Print Set Up 00:35:06
| 8.01 | Set Print Area, Margins, Orientation and Size | 00:12:01 |
| 8.02 | Page Break and Titles | 00:05:25 |
| 8.03 | Headers and Footers | 00:08:39 |
| 8.04 | Sheet Options | 00:04:10 |
| 8.05 | Worksheet Backgrounds | 00:04:51 |
Session 9: Introduction to Formulas 00:39:35
| 9.01 | Using Operations | 00:08:24 |
| 9.02 | Creating Formulas and Common Functions | 00:04:47 |
| 9.03 | Searching for Functions | 00:05:24 |
| 9.04 | Using Relative and Absolute References | 00:08:29 |
| 9.05 | Cutting and Copying Formulas | 00:04:01 |
| 9.06 | Date Formulas | 00:04:48 |
| 9.07 | Multiple Sheet References | 00:03:42 |
Session 10: Lookups 00:30:39
| 10.01 | VLOOKUP Sorted List | 00:04:55 |
| 10.02 | VLOOKUP Exact Match | 00:03:09 |
| 10.03 | HLOOKUP Sorted List | 00:04:18 |
| 10.04 | HLOOKUP Exact Match | 00:02:28 |
| 10.05 | CHOOSE | 00:04:44 |
| 10.06 | INDEX and MATCH | 00:11:05 |
Session 11: Conditional Logic 00:48:17
| 11.01 | IF | 00:03:40 |
| 11.02 | Nested IF | 00:07:16 |
| 11.03 | IF AND | 00:05:37 |
| 11.04 | IF OR | 00:04:19 |
| 11.05 | IF NOT | 00:03:07 |
| 11.06 | AGGREGATE | 00:05:05 |
| 11.07 | IFERROR & IFNA | 00:04:32 |
| 11.08 | SUMIF & SUMIFS | 00:03:37 |
| 11.09 | AVERAGEIF & AVERAGEIFS | 00:03:16 |
| 11.10 | COUNTIF & COUNTIFS | 00:02:41 |
| 11.11 | SUMPRODUCT | 00:05:07 |
Session 12: Text Formulas 00:27:50
| 12.01 | Case Formulas – UPPER, LOWER, PROPER | 00:03:16 |
| 12.02 | Convert Text to Numbers with VALUE | 00:04:12 |
| 12.03 | Remove Spaces with TRIM | 00:05:46 |
| 12.04 | Substitute Text with SUBSTITUTE | 00:04:20 |
| 12.05 | SEARCH & FIND | 00:10:16 |
Session 13: Named Ranges 00:19:45
| 13.01 | Cell Names | 00:04:13 |
| 13.02 | Named Ranges | 00:05:38 |
| 13.03 | Writing Formulas with Cell Names | 00:04:45 |
| 13.04 | Named Formulas | 00:05:09 |
Session 14: Formula Tools 00:22:32
| 14.01 | Trace the Precedents and Dependents | 00:05:30 |
| 14.02 | Using the Watch Window | 00:05:35 |
| 14.03 | Evaluate Formula Tool | 00:03:39 |
| 14.04 | Show Formulas and Error Checking | 00:07:48 |
Session 15: AutoFill and Custom Lists 00:28:16
| 15.01 | AutoFill a Series | 00:07:42 |
| 15.02 | AutoFill Non-Adjacent Cells | 00:04:46 |
| 15.03 | AutoFill on Multiple Sheets | 00:04:04 |
| 15.04 | Flash Fill | 00:04:10 |
| 15.05 | Creating Custom Lists | 00:05:49 |
| 15.06 | AutoFill Series Formatting | 00:01:45 |
Session 16: Conditional Formatting 00:34:21
| 16.01 | Highlight Cells Rules | 00:07:12 |
| 16.02 | Top/Bottom Rules | 00:05:16 |
| 16.03 | Data Bars | 00:03:44 |
| 16.04 | Color Scales | 00:03:13 |
| 16.05 | Custom Formatting Rule | 00:05:54 |
| 16.06 | Quick Analysis | 00:04:41 |
| 16.07 | Icon Sets | 00:04:21 |
Session 17: Tables 00:22:37
| 17.01 | Insert a Table and Style Options | 00:03:47 |
| 17.02 | Add Rows and Columns | 00:04:56 |
| 17.03 | Perform a Function in a Table | 00:06:25 |
| 17.04 | Slicers for Tables | 00:07:29 |
Session 18: Charts 00:42:25
| 18.01 | Inserting Charts | 00:04:52 |
| 18.02 | Format Charts | 00:10:51 |
| 18.03 | Editing Chart Source Data | 00:05:49 |
| 18.04 | Filtering Charts | 00:01:45 |
| 18.05 | New Charts Types in Excel 2016 | 00:09:59 |
| 18.06 | Sparklines | 00:09:09 |
Session 19: PivotTables 00:48:13
| 19.01 | Creating PivotTables | 00:04:48 |
| 19.02 | Choosing Fields | 00:06:44 |
| 19.03 | PivotTable Layout | 00:05:13 |
| 19.04 | Filtering PivotTables | 00:03:30 |
| 19.05 | Changing Calculation Methods | 00:06:09 |
| 19.06 | PivotCharts | 00:00:00 |
| 19.07 | Slicers | 00:08:51 |
| 19.08 | Timelines | 00:03:20 |
| 19.09 | Introduction to the Data Model | 00:05:54 |
Session 20: Adding Graphics 00:43:47
| 20.01 | Insert Pictures | 00:08:23 |
| 20.02 | Modifying Pictures | 00:10:15 |
| 20.03 | Shapes | 00:05:04 |
| 20.04 | SmartArt | 00:06:00 |
| 20.05 | Apply Themes | 00:04:55 |
| 20.06 | Arrange | 00:09:10 |
Session 21: Data Tools 00:48:15
| 21.01 | Data Validation | 00:08:12 |
| 21.02 | Removing Duplicates | 00:03:22 |
| 21.03 | Text to Columns | 00:04:55 |
| 21.04 | Importing and Exporting | 00:08:43 |
| 21.05 | Introduction to Get and Transform (Power Query) | 00:03:24 |
| 21.06 | Goal Seek | 00:02:58 |
| 21.07 | Scenario Manager | 00:05:41 |
| 21.08 | Consolidating Data | 00:05:17 |
| 21.09 | Forecast | 00:05:43 |
Session 22: Sort, Filter and Subtotal 00:31:45
| 22.01 | Sort Data | 00:05:15 |
| 22.02 | Sorting with Custom Lists | 00:02:50 |
| 22.03 | Filter Data | 00:05:32 |
| 22.04 | Advanced Filter | 00:05:33 |
| 22.05 | Conditional Sorting and Filtering | 00:03:58 |
| 22.06 | Subtotal Tool | 00:04:31 |
| 22.07 | Group and Ungroup | 00:04:06 |
Session 23: Protecting Data 00:14:10
| 23.01 | Workbook Passwords | 00:04:52 |
| 23.02 | Protecting Passwords | 00:03:55 |
| 23.03 | Protecting Worksheets and Cells | 00:05:23 |
Session 24: Collaboration 00:36:05
| 24.01 | Document Properties | 00:09:28 |
| 24.02 | Inserting Hyperlinks | 00:06:56 |
| 24.03 | Sharing a Workbook | 00:06:56 |
| 24.04 | Track Changes | 00:05:00 |
| 24.05 | Accept/Reject Changes | 00:03:02 |
| 24.06 | Mark as Final | 00:04:03 |
Session 25: Introduction to Macros 00:23:12
| 25.01 | Macro Security | 00:04:04 |
| 25.02 | Recording a Macro | 00:05:13 |
| 25.03 | How to Assign a Macro to a Button or a Shape | 00:05:13 |
| 25.04 | How to Run a Macro upon Opening a Workbook | 00:03:45 |
| 25.05 | How to Inspect and Modify a Macro | 00:04:57 |
