There are no items in your cart
Add More
Add More
| Item Details | Price | ||
|---|---|---|---|
ETL Testing
5.0 (2238 ratings)
Enrolled - 4530
5.0 (2238 ratings)
Enrolled - 4530
Advanced Excel Training
Advanced Excel skills include complex formulas, pivot tables, data analysis, macros, VBA, Power Query, dynamic charts, and conditional formatting.
star
star
star
star
star
5.0 (1063 ratings)
Language : English
Validity Period : Lifetime
₹15,000 37% OFF
Language : English
Validity Period : Lifetime
₹15,000 37% OFF
₹9,500/- Excluding 18% GST
Key Highlights
28 hours Total Duration
Access on mobile, TV & Laptop
14 Sessions
CV Preparation
Mentor Support
Lifetime Free Upgrade
Lifetime Recording Access
Certificate of completion
▶Description:
| Advanced Excel skills encompass a wide range of techniques, including complex formulas (like INDEX/MATCH, array formulas), pivot tables for data analysis, creating dynamic charts, utilizing Power Query for data transformation, automating tasks with VBA macros, and applying conditional formatting to highlight trends, helping users manage and interpret large datasets efficiently. Key Highlights:
|
▶Session 1: Introduction to Excel (Basics)
| Understanding the Excel Interface |
| Workbook, Worksheets, Rows, Columns, and Cells |
| Data Entry, Editing, and Formatting |
| Saving, Opening, and Printing Excel Files |
| Class Notes |
| Assignment |
▶Session 2: Formatting Excel Worksheets
| Cell Formatting (Fonts, Colors, Borders, Alignment) |
| Conditional Formatting (Color Scales, Data Bars, Custom Rules) |
| Applying and Customizing Themes |
| Working with Tables (Table Styles, Quick Formatting) |
| Class Notes |
| Assignment |
▶Session-3: Data Manipulation & Organization
| Sorting and Filtering Data |
| Data Validation (Creating Drop-Down Lists) |
| Removing Duplicates |
| Grouping and Subtotaling Data |
| Custom Number Formatting |
| Class Notes |
| Assignment |
▶Session-4: Functions and Formulas (Intermediate)
| Mathematical and Statistical Functions (SUM, AVERAGE, COUNT, COUNTA, etc.) |
| Logical Functions (IF, AND, OR, NOT) |
| Lookup and Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH) |
| Text Functions (CONCATENATE, LEFT, RIGHT, MID, TRIM, LEN) |
| Date and Time Functions (TODAY, NOW, DATEDIF, EDATE) |
| Class Notes |
| Assignment |
▶Session-5: PivotTables and PivotCharts
| Creating and Customizing PivotTables |
| Using Filters, Slicers, and Timelines in PivotTables |
| Grouping Data in PivotTables |
| PivotCharts: Visualization of PivotTable Data |
| PCalculated Fields in PivotTables |
| Class Notes |
| Assignment |
▶Session-6: Data Visualization with Excel
| Creating and Customizing Charts (Bar, Line, Pie, Combo) |
| Sparklines and Mini Charts |
| Advanced Chart Techniques (Dual-Axis Charts, Customizing Labels) |
| Dynamic Charts Using Data Validation Lists |
| Class Notes |
| Assignment |
▶Session-7: Advanced Formulas and Functions
| Advanced Lookup (XLOOKUP, INDIRECT, OFFSET) |
| Array Formulas and Dynamic Arrays (FILTER, SORT, UNIQUE) |
| Financial Functions (NPV, IRR, PMT) |
| Error Handling Functions (IFERROR, ISERROR, IFNA) |
| Class Notes |
| Assignment |
▶Session-8: Data Analysis Tools
| What-If Analysis (Goal Seek, Data Tables, Scenario Manager) |
| Solver Tool (Optimization) |
| Descriptive Statistics Using Data Analysis Toolpak |
| Using Power Query for Data Import and Transformation |
| Class Notes |
| Assignment |
▶Session-9: Macros and Automation
| Introduction to Macros and VBA (Recording Macros) |
| Editing and Customizing Macros (Basic VBA Code) |
| Creating Buttons and Assigning Macros |
| Automating Repetitive Tasks with Macros |
| Class Notes |
| Assignment |
▶Session-10: Collaboration and Sharing
| Protecting Worksheets and Workbooks (Password Protection) |
| Sharing and Collaborating on Excel Workbooks |
| Track Changes and Version History |
| Co-authoring in Excel |
| Class Notes |
| Assignment |
▶Session-11: PowerPivot and Power BI Integration
| Introduction to PowerPivot |
| Creating Data Models with PowerPivot |
| DAX (Data Analysis Expressions) Functions |
| Excel to Power BI Integration |
| Class Notes |
| Assignment |
▶ Project
| Practice on Realtime Project-1 |
| Practice on Realtime Project-2 |
| Practice on Realtime Project-3 |
| Practice on Realtime Project-4 |
| Practice on Realtime Project-5 |
With 18 years of experience in the IT industry, our team of experts has established itself as a trusted authority in trending technologies.
Important Links
Packages
Live Sessions
Copyright © 2026