Infobright

Advanced Excel Expert

Courses Overview

This comprehensive course is designed for individuals who want to gain advanced skills in Microsoft Excel, one of the most powerful and widely used spreadsheet applications in the business world.

The course covers sophisticated features and functions of Excel, enabling participants to handle complex data analysis, financial modeling, and data visualization tasks. This course is ideal for professionals seeking to enhance their Excel expertise for improved productivity and efficiency in their roles.

Course Objectives

To provide an in-depth understanding of advanced Excel functions and features.
To develop skills in complex data analysis and financial modeling.
To teach advanced techniques for data visualization and reporting.
To enable participants to automate tasks using macros and VBA (Visual Basic for Applications).
To impart knowledge on managing and analyzing large datasets effectively.

The Course Curriculum

Syllabus

Logical functions
VLookup, HLookup
Employee sheet
EMI
Pivot table, Charts
Advanced Lookup
Merge workbook
Custom View
All logical functions
Macro with Developers Tab
Track changes
Power Pivot, KPI
XOR
Dashboard
Job training
Online content

Enroll Now

Course Features :

Duration

2 Months
Level

Expert
Lectures

As per schedule
Language

English/Hindi