Ather  Naqvi

Course available for 1 year after purchase

Take your Excel skills from basic to advanced and master data analysis, reporting, and automation with real-world projects.

Duration: Self-paced | Access: 1 Year

Quick Recap – Excel Basics Refresher:
Lesson 1: Excel Interface & Workbook Structure
Lesson 2: Data Entry Tips – AutoFill, Flash Fill & Shortcuts
Lesson 3: Formatting Cells Like a Pro (Number, Text, Date)
Lesson 4: Understanding Rows, Columns, Sheets & Navigation

Mastering Core Excel Tools:
Lesson 5: Data Validation – Create Professional Dropdowns
Lesson 6: Conditional Formatting – Highlight Data Smartly
Lesson 7: Smart Sorting & Filtering (Multi-level & Custom)
Lesson 8: Freeze Panes, Split View & Tricks for Big Data Handling

Formula & Function Mastery:
Lesson 9: Logical Formulas – IF, IFS, AND, OR, NOT
Lesson 10: Text Functions – LEFT, RIGHT, MID, LEN, TRIM, CONCAT
Lesson 11: Lookup Power – VLOOKUP, HLOOKUP, XLOOKUP (Live Data)
Lesson 12: INDEX + MATCH (Smart Lookup Without Limits)
Lesson 13: Dynamic Excel – UNIQUE, FILTER, SORTBY, WRAPROWS

Excel Data Analysis Tools:
Lesson 14: Creating Pivot Tables from Scratch
Lesson 15: Using Slicers & Filters in Pivots
Lesson 16: Creating Eye-Catching Charts (Bar, Pie, Line, Combo)
Lesson 17: KPI Summary using Pivot Tables + Charts
Lesson 18: Sales Dashboard – Interactive & Printable

Real-World Excel Projects:
Lesson 19: Salary Sheet with Tax & PF Auto-Calculation
Lesson 20: Salary Slip Integration with MS Word
Lesson 21: Attendance Tracker with Conditional Formatting
Lesson 22: Student Report Card Generator with Formulas
Lesson 23: Invoice Generator (Auto Date, Client & Product Logic
Lesson 24: Bank Reconciliation Statement with Tally Format

Additional Free Course - Master Excel & Boost your Career

Excel Basics:
Excel Interface – Navigate like a pro
Data Entry – Fast & error-free
Smart Data Formatting
Conditional Formatting – Highlight trends

Advanced Excel:
What-If Analysis – Goal Seek & Scenarios
Lookup Functions – VLOOKUP, HLOOKUP, XLOOKUP
Series & Mixed Referencing

Essential Skills:
Must-Know Functions – SUM, AVERAGE, etc.
Logical Functions – IF, AND, OR
Sorting, Filtering & Data Validation

Pro Tools:
Paste Special Hacks
Quick Analysis Tool
Charts & Graphs
Financial Functions
Bonus Power Functions

Advanced Excel Mastery Course

IICA Computer Education

Maharashtra

Hey! I’m learning with IICA Computer Education and you can too. Here’s a course you might like: Advanced Excel Mastery Course by Ather  Naqvi
    https://lzedvf.courses.store/734892?utm_source=whatsapp&utm_medium=social&utm_campaign=web-course-share

Hey! I’m learning with IICA Computer Education and you can too. Here’s a course you might like: Advanced Excel Mastery Course by Ather  Naqvi
    https://lzedvf.courses.store/734892?utm_source=facebook&utm_medium=social-fb&utm_campaign=web-course-share

Hey! I’m learning with IICA Computer Education and you can too. Here’s a course you might like: Advanced Excel Mastery Course by Ather  Naqvi
    https://lzedvf.courses.store/734892?utm_source=telegram&utm_medium=social&utm_campaign=web-course-share

Hey! I’m learning with IICA Computer Education and you can too. Here’s a course you might like: Advanced Excel Mastery Course by Ather  Naqvi
    https://lzedvf.courses.store/734892?utm_source=linkedin&utm_medium=social-link&utm_campaign=web-course-share

Hey! I’m learning with IICA Computer Education and you can too. Here’s a course you might like: Advanced Excel Mastery Course by Ather  Naqvi
    https://lzedvf.courses.store/734892?utm_source=copy-link&utm_medium=social&utm_campaign=web-course-share