Advanced Excel

Duration: 2 Months

★★★★★ 4.9 out of 5 based on 10164 reviews
ENROLL NOW
DOWNLOAD CURRICULUM GET QUICK CALL BACK SCHEDULE A DEMO

Why Learn With Us – Our Expertise

Professionals Trainers

Industry Expert Trainers

Online / Offline

Placement Assistance

Course Duration

2 Months

Certificate

Yes

Live Project

Yes

Training Mode

Classroom / Online

Detailed Course Curriculum

PART 1 - GETTING STARTED

  • What is Microsoft Excel and why it matters
  • What's new in Excel 2024
  • Installing and setting up Excel 2024
  • Understanding the Excel interface (Ribbon, Quick Access Toolbar, Formula Bar, Sheet Tabs)
  • Workbooks vs. Worksheets
  • Navigating cells, rows, and columns
  • Saving, opening, and closing files (.xlsx, .csv, .xlsm formats)
  • Entering text, numbers, and dates
  • Editing and deleting cell content
  • Copy, cut, paste, and Paste Special
  • Autofill and Flash Fill
  • Find & Replace
  • Undo and Redo
  • Data types and cell formats (General, Number, Currency, Date, Text)
  • Formatting numbers, dates, and text
  • Font styles, sizes, colors, and alignment
  • Cell borders and background colors
  • Merge & Center
  • Conditional Formatting basics
  • Row height and column width
  • Freeze panes and split views
  • Headers and footers

PART 2 - FORMULAS & FUNCTIONS

  • How formulas work in Excel
  • Arithmetic operators (+, -, *, /, ^)
  • Cell references: Relative, Absolute ($), and Mixed
  • Order of operations
  • Common formula errors (#DIV/0!, #VALUE!, #REF!, #NAME?)
  • Tracing and debugging errors
  • SUM, AVERAGE, MIN, MAX, COUNT, COUNTA
  • IF, AND, OR, NOT
  • ROUND, ROUNDUP, ROUNDDOWN
  • TEXT, UPPER, LOWER, PROPER, LEN, TRIM, CONCATENATE
  • TODAY, NOW, DATE, YEAR, MONTH, DAY
  • VLOOKUP and HLOOKUP
  • XLOOKUP (Excel 2024 enhanced)
  • INDEX & MATCH
  • IFERROR and IFNA
  • COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS
  • CHOOSE, SWITCH
  • LEFT, RIGHT, MID, FIND, SEARCH, SUBSTITUTE
  • DATEDIF, NETWORKDAYS, WORKDAY, EDATE
  • Dynamic Arrays and Spill Ranges
  • FILTER, SORT, SORTBY, UNIQUE
  • SEQUENCE, RANDARRAY
  • TEXTSPLIT, TEXTBEFORE, TEXTAFTER (Excel 2024)
  • LAMBDA and custom functions
  • LET function
  • BYROW, BYCOL, MAP, REDUCE, SCAN
  • Array formulas with Ctrl+Shift+Enter

PART 3 - DATA MANAGEMENT

  • Sorting data (single and multi-level)
  • Filtering data with AutoFilter
  • Advanced Filter
  • Removing duplicates
  • Text to Columns
  • Data Validation (dropdown lists, restrictions, custom rules)
  • Named Ranges
  • Creating and formatting Excel Tables
  • Table styles and options (Total Row, Banded Rows)
  • Structured references in formulas
  • Adding and removing columns/rows in tables
  • Slicers for tables
  • Importing data from CSV, TXT, and databases
  • Getting data from the web
  • Power Query introduction (Get & Transform)
  • Cleaning and transforming data with Power Query
  • Exporting to PDF, CSV, and other formats
  • Connecting to external data sources

PART 4 - DATA VISUALIZATION

  • Creating basic charts (Bar, Column, Line, Pie, Area)
  • Chart elements (Title, Legend, Axes, Data Labels)
  • Formatting and customizing charts
  • Combo charts
  • Sparklines (Line, Column, Win/Loss)
  • Dynamic charts with named ranges
  • Waterfall and Funnel charts
  • Histogram and Box & Whisker charts
  • Sunburst and Treemap charts
  • Map charts (geographic data)
  • Creating interactive dashboards with charts
  • Chart templates

PART 5 - PIVOT TABLES & ANALYSIS

  • What is a PivotTable and when to use it
  • Creating your first PivotTable
  • Rows, Columns, Values, and Filters
  • Sorting and filtering in PivotTables
  • Value field settings (Sum, Count, Average, %)
  • Grouping data (dates, numbers, text)
  • Calculated fields and calculated items
  • Slicers and Timelines
  • PivotCharts
  • Multiple consolidated ranges
  • Power Pivot introduction
  • Data Model and relationships
  • DAX basics (CALCULATE, SUMX, RELATED)

PART 6 - PRODUCTIVITY & AUTOMATION

  • Goal Seek
  • Scenario Manager
  • Data Tables (one-variable and two-variable)
  • Solver add-in
  • Forecasting with FORECAST.ETS
  • Trendlines in charts
  • What are Macros and why use them
  • Recording a macro
  • Running and editing macros
  • Introduction to the VBA Editor (IDE)
  • Writing basic VBA code
  • Variables, loops, and conditionals in VBA
  • Creating simple automation scripts
  • Assigning macros to buttons
  • Working with Workbooks and Worksheets in VBA
  • Manipulating cells and ranges via code
  • UserForms and dialog boxes
  • Error handling in VBA
  • Creating custom functions (UDFs)
  • Automating reports and emails

PART 7 - COLLABORATION & SECURITY

  • Sharing workbooks on OneDrive and SharePoint
  • Co-authoring in real time
  • Comments and Notes
  • Track Changes
  • Protecting sheets and workbooks (passwords)
  • Managing permissions and access
  • Excel with Teams, Outlook, and Word
  • Power Automate with Excel
  • Using Excel on mobile and web
  • Copilot in Excel 2024 (AI-powered features)
  • Excel Online limitations vs. Desktop

PART 8 - PROFESSIONAL APPLICATIONS

  • Building a basic financial model
  • Financial functions: PMT, PV, FV, NPV, IRR, RATE
  • Amortization schedules
  • Budget vs. Actual analysis
  • Sensitivity analysis
  • Descriptive statistics with the Analysis ToolPak
  • Regression analysis
  • Histogram and frequency distribution
  • Correlation and Covariance
  • Sampling and hypothesis testing basics
  • Dashboard design principles
  • KPI cards and dynamic metrics
  • Combining charts, slicers, and tables
  • Form controls (dropdowns, scrollbars, buttons)
  • Making dashboards printable and presentation-ready

What You Will Learn

Master Python Programming

From basics to advanced concepts including OOP and data structures

Build 10+ Real-World Projects

Hands-on experience with practical applications and portfolios

Database Management

SQL and NoSQL databases with Python integration

Web Development

Django and Flask frameworks for full-stack applications

Cloud Deployment

Deploy applications on AWS and other cloud platforms

100% Job Assistance

Interview preparation and placement support

Meet Our Expert Trainers

Trainer 1

Rahul Sharma

10+ Years Industry Experience

SAP ABAP Developer.

Trainer 2

Dr. Ritesh Kumar

15+ Years Teaching Experience

15+ years teaching experience, 30+ book written, Passionate about teaching and mentoring.

Trainer 3

Dhirender Kumar

15+ Years Industry Experience

DevOps engineer with deep knowledge in cloud deployment and containerization technologies.

Trainer 4

Neha Gupta

7+ Years Industry Experience

Data scientist and Python expert with strong background in machine learning and AI.

Our Students Are Placed In

2500+

Students Placed

|

6–18 LPA

Average Salary

What Our Students Say

★★★★★

"The Python Full Stack course at Gyan Vandana was exceptional. The trainers are highly experienced and the curriculum is industry-relevant. I got placed in a top MNC with a great package."

Student 1

Arun Singh

Python Developer at TCS

★★★★★

"Amazing learning experience! The practical projects and real-world scenarios helped me understand concepts deeply. The placement support was outstanding."

Student 2

Sakshi Viswkarma

Java Developer

★★★★★

"Best decision to join Gyan Vandana! The trainers are patient and knowledgeable. The curriculum covers everything from basics to advanced topics."

Student 3

Tushar

Web Developer at Capgemini

★★★★★

"The course structure is well-designed and the placement assistance is remarkable. I'm now working as a Python developer thanks to Gyan Vandana!"

Student 4

Himanshu

Web Developer

Student Photo

Varun Yadav is Placed in Capgemini

Data Analyst | Package: 12 LPA

Ready to Start Your Journey?

Contact Details

Faridabad

195, 4th Floor, Sector 37

Faridabad

Faridabad NIT

Opening Soon

Faridabad

Enquiry Form