Advanced Excel

What Will Students Learn?

  • Microsoft Excel 2016 Advanced Essentials

  • Microsoft Excel 2016 has lots of time-saving tools. Do you know how to make the most of them? The modules in the course will show you how! This advanced course covers a wide range of topics, including advanced formula tasks, working with named ranges, using advanced functions, resolving formula errors, managing data, outlining and grouping data, working with scenarios, using Solver, the Analysis ToolPak, PivotTable features, using PowerPivot, and developing macros.  

What Topics are Covered?

  • Advanced Formula Tasks

  • Working with Named Ranges

  • Using Advanced Functions

  • Resolving Formula Errors

  • Managing Data

  • Outlining and Grouping Data

  • Creating Scenarios

  • Analyzing Data

  • Advanced PivotTable Features

  • Using PowerPivot

  • Using Macros

 

Register