Mastering Excel 2016, Intermediate

SKU: RV-3273Duration: 270 Minutes

The World Is Filled With Two Kinds Of People: A Handful Of People Who Are Masters Of Excel, And The Millions Of Others Who Wish They Were. If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business critical questions like ROI, budget allocations, tracking expenditures, and more. This course builds on your existing knowledge of Excel basics and teaches you how to manage data, charts, and tables, and how to use powerful tools such as PivotTables, Pivot Charts, Slicers, Timelines, and more. Note: When combined with the Basics and Advanced versions of this course, these cover all the objectives required in the Microsoft Office Specialist exam 77-727

Course Details


Training Time: 270 minutes

Compatibility: Desktop Only

Based on: Industry Standards and Best Practices

Languages: English

Learning Objectives

  • By the end of this course, you will be able to:
  • Explain the importance of named ranges
  • Write nested functions
  • Create and modify tables of data
  • Develop visuals on your table, based on the data, using conditional formatting
  • Organize large amounts of data into smaller, more specific tables using PivotTables
Added to Cart! Click here to view your cart.