Advanced Excel | Barattson - Employability through education!

Advanced Excel

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

 

Duration -   32 hours

Fee: 99 AZN

 

Register

 

 

Social messengers