Functions, formatting, data tools, conditional logic, text formulas, date & time functions, lookup functions, pivots, dashboards, macros, Excel 365 new features, and charts.
Advanced Excel and VBA Macros are powerful tools for automating tasks and performing complex data analysis. With Advanced Excel, users can work with pivot tables, advanced formulas, data validation, and charts. Mastering these skills is valuable for roles like Data Analyst, Financial Analyst, and Excel Automation Specialist.
✅ Advanced Formulas & Functions
✅ Pivot Tables & Pivot Charts
✅ Power Query & Power Pivot
✅ Data Cleaning & Filters
✅ What-If Analysis, Scenarios
✅ Excel Dashboards & Pivot
✅ VBA Macros & Task Automation
✅ Data Validation, Formatting
✅ End-to-End Real-Time Project
✅ 1:1 Mentorship, Interview Guidance
Module 1: Excel Concepts & Functions
Ch 1: Basic Functions
- SUM, AVERAGE, MAX, MIN, COUNT, COUNTA
- Absolute, Mixed
- Relative Referencing
Ch 2: Formatting and Proofing
- Currency Format
- Format Painter
- Formatting Dates
- Custom and Special Formats
- Formatting Cells
Ch 3: Functions
- SUMIF, SUMIFS, COUNTIF
- COUNTIFS, AVERAGEIF
- AVERAGEIFS, NESTED IF
- IFERROR STATEMENT
- AND, OR, NOT
Ch 4: Protecting Excel
- File Level Protection
- Workbook
- Worksheet Protection
- Security Concepts
- Realtime Issues, Solutions
Ch 5: Text Functions
- Upper, Lower, Proper
- Left, Mid, Right
- Trim, Len, Exact
- Concatenate
- Find, Substitute
Ch 6: Date & Time Functions
- Today, Now
- Day, Month, Year
- Date, Date if, Date Add
- EOMONTH
- Weekday Functions
Ch 7: Adv. Techniques
- Paste Formulas
- Paste Formats
- Paste Validations
- Transpose Tables
Ch 8: New in Excel & 365
- Charts – Tree map & Waterfall
- Sunburst, Box and whisker Charts
- Combo Charts – Secondary Axis
- Adding Slicers Tool in Pivot & Tables
- Using Power Map and Power View
- Forecast Sheet, park lines
Ch 9: New in Excel & 365
- Using 3-D Map
- New Controls in Pivot Table
- Various Time Lines
- Auto complete a data range
- Quick Analysis Tool
- Smart Lookup manage Store
Ch 10: Printing Workbooks
- Setting Up Print Area
- Customizing Headers
- Templates
- Print Titles –Repeat Rows
Ch 11: Sorting and Filtering
- Filtering on Text
- Numbers & Colors
- Sorting Options
- Advanced Filters
- Filter Criteria
Module 2 : Advanced Excel
Ch 12: What If Analysis
- Goal Seek
- Scenario Analysis
- Data Tables (PMT Function)
- Solver Tool
Ch 13: Logical Functions
- If Function
- How to Fix Errors – if error
- Nested If
- Complex if and or functions
Ch 14: Data Validation
- Number, Date & Time
- Text and List Validation
- Custom validations formulas
- Dynamic Dropdowns
Ch 15: Lookup Functions
- V lookup / H Lookup
- Index and Match
- Smooth User Interface
- Nested V Lookup
- Reverse Lookup
- Worksheet linking
- V lookup with Helper Column
Ch 16: Pivot Tables – 1
- Creating Simple Pivot Tables
- Classic Pivot table
- Choosing Field
- Filtering PivotTables
- Modifying PivotTable Data
- Grouping
- Calculated Fields
Ch 17: Pivot Tables – 2
- Array with IF, LEN
- MID function
- Array with Lookup
- Various Charts
- SLICERS, Filter data
- Manage Primary Axis
- Manage Secondary Axis
Ch 18: Excel Dashboard
- Planning a Dashboard
- Adding Tables and Charts to Dashboard
- Adding Dynamic Contents to Dashboard
Ch 19: VBA Macro – Level 1
- Using Outlook Namespace
- Send automated mail
- Outlook Configurations, MAPI
- Worksheet Operations
- Workbook Operations
Ch 20: VBA Macro – Level 2
- Merge Worksheets using Macro
- Merge multiple excel files into one sheet
- Split worksheets using VBA
- Worksheet copiers
What is the Advanced Excel Training?
This program teaches complete Excel skills including formulas, functions, data cleaning, dashboards, pivot tables, slicers, charts, advanced analysis, VBA macros, and real-time business reporting.
Who can join this Advanced Excel course?
Students, working professionals, MIS executives, Data Analysts, Business Analysts, HRs, Accountants, and anyone working with data.
Do I need to know Excel basics before joining?
Basic Excel knowledge is helpful, but not mandatory. The training covers fundamentals before moving into advanced topics like pivot tables, dashboards, and VBA.
What are the commonly used basic Excel functions taught?
SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, absolute referencing, relative/mixed references.
Does the course include Formatting and Proofing?
Yes. Currency formats, format painter, date formatting, custom formats, special formats, and cell formatting.
What logical and conditional functions will I learn?
IF, SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, nested IF, IFERROR, AND, OR, NOT.
Do you teach text functions in Excel?
Yes. LEFT, RIGHT, MID, LEN, TRIM, EXACT, PROPER, UPPER, LOWER, FIND, SUBSTITUTE, CONCATENATE.
Will I learn Date & Time functions?
Yes. TODAY, NOW, DAY, MONTH, YEAR, DATE, DATEADD, EOMONTH, WEEKDAY.
Does the course include Excel 365 new features?
Yes. Waterfall, Tree Map, Sunburst, Box & Whisker charts, 3D Maps, Power View, Power Map, Quick Analysis, Auto-Complete, Smart Lookup, Slicers & Timelines.
Will I learn Sorting and Filtering?
Yes. Sorting by text, numbers, color; advanced filters; filter criteria.
Does the course include What-If Analysis?
Yes. Goal Seek, Scenario Manager, Data Tables using PMT, and Solver tool.
What Lookup functions will I learn?
VLOOKUP, HLOOKUP, INDEX, MATCH, Nested VLOOKUP, Reverse Lookup, Linked worksheets, Helper Columns.
Do you teach Pivot Tables in detail?
Yes. Creating pivots, grouping, filtering, calculated fields, arrays with LEN/MID, slicers, charts, and primary/secondary axis management.
Will I learn Excel Dashboards?
Yes. Dashboard planning, adding tables, charts, dynamic elements, slicers, and visual design techniques.
Is VBA Macro included?
Yes. Sending automated emails, workbook/worksheet operations, merging & splitting sheets, copying data, and using Outlook Namespace.
Will I learn to automate tasks with Macros?
Yes. You will learn Macro recording, editing, building custom automation, and performing repetitive tasks quickly.
Is this course practical and job-oriented?
Yes. The PDF highlights 100% practical, step-by-step classes with real-time project implementations for job work.
What kind of real-time problems will I learn to solve?
Data cleaning, data transformation, monthly reports, dashboards, pivot-based summaries, automation tasks, and worksheet-level security.
What training modes are available?
Live Online Training, Self-Paced Videos, Practical Labs, Resume Preparation, Mock Interviews, and 1-on-1 assistance.
Placement Partners
SQL SCHOOL
24x7 LIVE Online Server (Lab) with Real-time Databases.
Course includes ONE Real-time Project.
#Top Technologies
Why Choose SQL School
- 100% Real-Time and Practical
- ISO 9001:2008 Certified
- Weekly Mock Interviews
- 24/7 LIVE Server Access
- Realtime Project FAQs
- Course Completion Certificate
- Placement Assistance
- Job Support