This course will give you a deep understanding of the advanced formulas and functions that transform Microsoft Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, we teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways. We will not train you to regurgitate functions and formula syntax; We will teach you how to THINK like Excel.

We’ll dive into a broad range of Microsoft Excel formulas & functions, including:

Lookup/Reference functions
Statistical functions
Formula based formatting
Date & Time functions
Logical operators
Array formulas
Text functions
Powerful analytics tools and formulas like INDIRECT, HYPERLINK, WEBSERVICE & FILTERXML

---

Advanced Excel Course

Course Content:

Module-I – Excel Foundation 

Getting Started with Excel
Data Entry, Data Editing, and Number Formatting
Data Formatting
Working with Cells and Ranges in Excel
Managing Worksheets
Using Sub-Total
Save Your Worksheets

Module-II – Formula | Data | Charts Concepts
Formula Basics & Cell References
Auto Fills & Custom Lists
Working with Basic Excel Functions
Using Smart Tables
Sorting & Filtering Data
Working with Conditional Formats
Working with Charts

Module-III –  Using Advanced Functions
Working with Named Ranges
Using Complex Excel Functions
Using Multi-sheet Formulas
Using Advanced Filters
Data Validation & Protection
Consolidation & List Management
Automating with Macros

Module-III – Reporting & Dashboards 
Business Reporting with Excel Dashboards
Advanced Charting & Visualizations
Using Sparkline Charts
Creating Interactive Dashboard Reports

Module-IV – Working with Macros & Custom Functions 
Writing Customized Macros
Using What-If-Analysis
Working with Financial Functions
Creating Custom Excel Functions

---

International Student Fee : 150 USD