fbpx
  • Training
  • Training

Excel 2016 | Office 2016

Learn how to be more productive with WheelHouse IT’s in-depth Microsoft Office 2016 training. With 12 distinct courses, you’ll benefit from improving your skills with the entire Microsoft Office Suite. Are you looking for a past version? The WheelHouse IT Library includes lessons all the way back through Office 2003.

Lessons

Excel 2016 Essentials

  • Lesson 1: Getting Started (6m 4s)
  • Lesson 2: Ribbon Tabs: Exploring (2m 10s)
  • Lesson 3: Ribbon Tabs: Home (1m 4s)
  • Lesson 4: Ribbon Tabs: Insert (1m 34s)
  • Lesson 5: Ribbon Tabs: Page Layout (1m 3s)
  • Lesson 6: Ribbon Tabs: Formula (0m 47s)
  • Lesson 7: Ribbon Tabs: Data (1m 11s)
  • Lesson 8: Ribbon Tabs: Review (0m 41s)
  • Lesson 9: Ribbon Tabs: View (1m 0s)
  • Lesson 10: Ribbon Tabs: Exploring the Font Group (4m 44s)
  • Lesson 11: Ribbon Tabs: Understanding the Number Group (2m 59s)
  • Lesson 12: Ribbon Tabs: Exploring the Alignment Group (3m 59s)
  • Lesson 13: Ribbon Tabs: Using the Alignment Dialog Box (1m 21s)
  • Lesson 14: Ribbon Tabs: Understanding the Number Group (2m 59s)
  • Lesson 15: Ribbon Tabs: Using the Number Dialog Box (1m 35s)
  • Plus 35 More Lessons – Total Running Time (2h 3m)

Excel 2016 Power Users

Conditional Formatting

  • Lesson 1: Using Data Bars (4m 22s)
  • Lesson 2: Configuring Data Bars (3m 28s)
  • Lesson 3: Using Color Scales & Icon Sets (7m 36s)
  • Lesson 4: Configuring Highlight Cell Rules (4m 28s)
  • Lesson 5: Working with Top/Bottom Rules (3m 1s)
  • Lesson 6: Manage Multiple Rules (5m 25s)
  • Lesson 7: Using Cross Sheet (3m 32s)
  • Lesson 8: Working in Ranges with Errors (2m 57s)

Functions

  • Lesson 9: Creating Formulas (4m 47s)
  • Lesson 10: Understanding Functions (4m 17s)
  • Lesson 11: AutoSum (3m 59s)
  • Lesson 12: Using Average & Count (5m 46s)
  • Lesson 13: Using Min & Max (5m 22s)
  • Lesson 15: Using Insert Function (4m 13s)
  • Plus 30 More Lessons – Total Running Time (3h 20m)

Excel 2016 Pro

Conditional Formatting

  • Lesson 1: Using Data Bars (4m 22s)
  • Lesson 2: Configuring Data Bars (3m 28s)
  • Lesson 3: Using Color Scales & Icon Sets (7m 36s)
  • Lesson 4: Configuring Highlight Cell Rules (4m 28s)
  • Lesson 5: Working with Top/Bottom Rules (3m 1s)
  • Lesson 6: Manage Multiple Rules (5m 25s)
  • Lesson 7: Using Cross Sheet (3m 32s)
  • Lesson 8: Working in Ranges with Errors (2m 57s)

Functions

  • Lesson 9: Creating Formulas (4m 47s)
  • Lesson 10: Understanding Functions (4m 17s)
  • Lesson 11: AutoSum (3m 59s)
  • Lesson 12: Using Average & Count (5m 46s)
  • Lesson 13: Using Min & Max (5m 22s)
  • Lesson 15: Using Insert Function (4m 13s)
  • Plus 30 More Lessons – Total Running Time (3h 20m)

Browse our library of courses

Training

Windows 10

Training

Excel 2016

Training

Office 365

Training

Office 2016