Advanced Excel

Builds dynamic dashboard reports.

Course Overview

Focuses on creating dynamic dashboards, automating lookups, complex data manipulation, and building macro tools for documentation. Unlocks powerful corporate data mining capabilities using arrays, advanced pivot logic, and power query automation.

What You Will Learn

Creation of personalized templates

Knowledge on how to work with sparklines

Basic knowledge on how to create and manage scenarios

Use of Goal Seek and Solver

Creation, management, and formatting pivot tables and pivot charts

Use of Excel mathematical functions

Creation and writing knowledge on complex formulas

Perform data lookups

Creation and use IF statements

Use of Excel's data functions

Creation and use data validation rules

Application of custom and prebuilt conditional formatting

How to work with functions to manipulate strings of text and data

Creation and use of macros

Creation of pivot tables and pivot charts

Use of queries to import external data

Import and clean data

How to link and consolidate worksheets and workbooks

Advanced Excel 24 Hours

Duration

24 Hours

Mode

Offline / Online

Placement

100% Assistance

Certificate

Yes

Enquire Now View all in Software Development