Office Productivity Training – Microsoft Office 2016 Excel – Basic Series


This series covers the basic functions and features of Excel 2016. Students will get to know Excel 2016 by performing calculations. They will learn to modify and format worksheets. They will learn to print and manage workbooks.

Career Path: In high-growth industries, entry-level employees who hold a Microsoft Office Specialist (MOS) certification can earn up to $16,000 more, annually, than their peers. Five times as many high-growth/high-salary positions require experience with Office than all non- Microsoft software skills combined. Twenty-nine percent of tomorrow’s high-growth/high-wage positions require Office or Office- related skills.

Certification Details

Successful candidates for the Microsoft Office Specialist Excel 2016 certification exam will have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They will know and demonstrate the correct application of the principle features of Excel 2016. Candidates will create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

Certification Exam Details:
This training will prepare you for the Microsoft Office Specialist Certification. To learn more, please go to Click here for certification details.

Series Taught By: Patrick Loner

Available CEUs for Course Series Completion: 8
Students can earn up to 8 CEUs for fully completing this course series. This information will be displayed on the certificate of completion. Learn More


  • There is no required prerequisite for this course however, the candidates are expected to have a working knowledge of the Microsoft Office suite of products.

$49.00Add to cart

Course Modules

(Duration: — m )

  1. Workbook
  2. Course Introduction
  3. Topic A: Work with Ranges
  4. Cell and Range Names
  5. Names and the Name Box
  6. The New Name Dialog Box
  7. The Create from Selection Command
  8. The Name Manager Dialog Box
  9. Naming and Editing Ranges
  10. Cell and Range Names in Formulas
  11. The Use in Formula Command Method
  12. The Formula Auto Complete Method
  13. Using Defined Names in a Formula
  14. Topic B: Use Specialized Functions
  15. The Excel Function Reference
  16. Function Syntax
  17. Criteria Argument Syntax
  18. Locating and Using Specialized Functions
  19. Topic C: Work with Logical Functions
  20. Logical Values
  21. Comparison Operators
  22. The IF Function
  23. The AND Function
  24. The OR Function
  25. The NOT Function
  26. Working with Logical Functions
  27. Nesting
  28. Nested Function Syntax
  29. Guidelines for Combining Functions
  30. Combining Function
  31. Topic D: Work with Date and Time Functions
  32. The TODAY Function
  33. The NOW Function
  34. The DATE Function
  35. The NETWORKDAYS Function
  36. The WEEKDAY Function
  37. The WORKDAY Function
  38. The ISOWEEKNUM Function
  39. Working with Date and Time Functions
  40. Topic E: Work with Text Functions
  41. The LEFT Function
  42. The FIND Function
  43. The RIGHT Function
  44. Convert Text to Columns Wizard
  45. The MID Function
  46. The CONCAT Function
  47. Text Concatenation with the Ampersand
  48. The UPPER Function
  49. The LOWER Function
  50. The PROPER Function
  51. Working with Text Functions
  52. Chapter 01 Review
  53. Review Quiz (Number of attempts allowed: Unlimited)

(Duration: — m)

  1. Workbook
  2. Topic A: Sort Data
  3. Sorting
  4. Multiple Column/Row Sorting
  5. Quick Sorts
  6. The Sort Dialog Box
  7. The Sort Options Dialog Box
  8. Sorting Data
  9. Topic B: Filter Data
  10. Filtering
  11. AutoFilters
  12. The Custom AutoFilter Dialog Box
  13. Advanced Filtering
  14. The Criteria Range
  15. Filtering Data
  16. Topic C: Query Data with Database Functions
  17. Database Functions
  18. Database Function Syntax
  19. Using Database Functions
  20. Topic D: Outline and Subtotal Data
  21. Outlines
  22. The SUBTOTAL Function
  23. The Subtotals Feature
  24. The Subtotal Dialog Box
  25. Using Subtotals to Summarize Data
  26. Review Chapter 02
  27. Review Quiz (Number of attempts allowed: Unlimited)

(Duration: –m)

  1. Workbook
  2. Topic A: Create and Modify Tables
  3. Tables
  4. Table Components
  5. The Create Table Dialog Box
  6. The Table Tools Design Contextual Tab
  7. Table Styles and Quick Styles
  8. The New Table Style Dialog Box
  9. Quick Analysis
  10. Creating and Modifying Tables
  11. Using Summary Functions in Table
  12. Topic B: Apply Intermediate Conditional Formatting
  13. The New Formatting Rule Dialog Box
  14. The Conditional Formatting Rules Manager Dialog Box
  15. Rule Precedence
  16. Applying Intermediate Conditional Formatting
  17. Topic C: Apply Advanced Conditional Formatting
  18. The Use a Formula to Determine Which Cells to Format Rule
  19. Cell References and Conditional Formatting
  20. Guidelines for Applying Conditional Formatting to Cells Based on Values in Other Cells
  21. Using Logical Functions to Apply Conditional Formatting
  22. Chapter 03 Review
  23. Review Quiz (Number of attempts allowed: Unlimited)

(Duration: — m)

  1. Workbook
  2. Topic A: Create Charts
  3. Charts
  4.  Chart Basics
  5. Chart Insertion Methods
  6. Chart Types
  7.  Recommended Charts
  8. Creating Charts
  9. Topic B: Modify and Format Charts
  10. Chart Modifications
  11. Chart Formatting
  12. Chart Elements
  13. Guidelines for Modifying Chart Elements
  14. The Design Tab
  15. The Format Tab
  16. The Format Task Pane
  17. The Chart Tools Buttons
  18. The Select Data Source Dialog Box
  19. Modifying and Formatting Charts
  20. Topic C: Use Advanced Chart Features
  21. Dual-Axis Charts
  22. Forecasting
  23. Trendlines
  24. The Format Trendline Task Pane
  25. Creating a Dual-Axis Chart with a Trendline
  26. Chart Templates
  27. Creating a Chart Template
  28. Chapter 04 Review
  29. Review Quiz (Number of attempts allowed: Unlimited)

(Duration: –m)

  1. Workbook
  2. Topic A: Create a PivotTable
  3. Pivoting
  4. PivotTables
  5. Transactional Data
  6. The Create Pivot Table Dialog Box
  7. The PivotTable Fields Task Pane
  8. Creating a PivotTable
  9. Topic B: Analyze PivotTable Data
  10. Start with Questions, End with Structure
  11. The Value Field Settings Dialog Box
  12. SUM Function Only
  13. Percentage of Total
  14. Difference From Option
  15. The Analyze Tab
  16. The Design Tab
  17. The GETPIVOTDATA Function
  18. Analyzing PivotTable Data
  19. Topic C: Present Data with PivotCharts
  20. PivotCharts
  21. The PivotChart Fields Task Pane
  22. PivotChart Filters
  23. Presenting Data with PivotCharts
  24. Topic D: Filter Data by Using Timelines and Slicers
  25. Slicers
  26. The Insert Slicers Dialog Box
  27. The Slicer Tools Contextual Tab
  28. The Report Connections Dialog Box
  29. Timelines
  30. The Insert Timelines Dialog Box
  31. The Timeline Tools Contextual Tab
  32. Filtering Data by Using Slicers and Timelines
  33. Chapter 05 Review
  34. Review Quiz (Number of attempts allowed: Unlimited)

(Duration: — m)

  1. Workbook
  2. Topic A: Insert Graphical Objects
  3. Graphical Objects
  4. The Insert Picture Dialog Box
  5. The Insert Online Pictures Window
  6. Shapes
  7. Icons
  8. 3D Models
  9. Screenshots
  10. Text Boxes
  11. WordArt
  12. Topic B: Modify Graphical Objects
  13. The Picture Tools Contextual Tab
  14. The Image Editor
  15. The Drawing Tools Contextual Tab
  16. The Graphics Tools Contextual Tab
  17. The 3D Model Tools Contextual Tab
  18. The Selection Task Pane
  19. The Format Task Panes
  20. Object Properties
  21. Topic C: Work with SmartArt
  22. SmartArt Graphics
  23. SmartArt Shapes
  24. The Choose a SmartArt Graphic Dialog Box
  25. The Text Pane
  26. The SmartArt Tools Contextual Tab
  27. Chapter 06 Review
  28. Review Quiz (Number of attempts allowed: Unlimited)

Training Final Exam ?

Are you ready to earn your certificate of completion?

Launch The Exam

This course includes

  •  On-demand video
  • 6 downloadable Pdf Workbooks
  • Unlimited time access (During Membership)
  • Access on mobile and Desktop
  • Certificate of Completion