Offered by: TechnoUpskills

📘 Course Description:

The Advance Excel course is designed for students, professionals, accountants, and business owners who want to take their Excel skills to the next level. It covers advanced functions, formulas, data analysis tools, and automation basics used in MIS reporting, accounting, data management, and day-to-day office work.

This is a job-ready program that enhances productivity and equips learners with practical Excel knowledge for corporate and freelance work.

✅ Course Coverage / Covering Lessons

🔹 1. Advanced Lookup Formulas

• VLOOKUP & HLOOKUP

• XLOOKUP (Intro – if Excel version supports it)

• INDEX & MATCH

• Dynamic Data Search Techniques

🔹 2. IF Conditions & Logical Formulas

• IF Formula (Single Condition)

• Nested IF (Multiple Conditions)

• IFS Function (Advanced Multi-Condition Handling)

• AND, OR, NOT Logical Operators

• Combining IF with AND/OR for smart logic

🔹 3. COUNT & SUM Formulas

• COUNT, COUNTA, COUNTBLANK

• COUNTIF, COUNTIFS

• SUMIF, SUMIFS

• Practical Use for Reports & Filters

🔹 4. Absolute & Relative Cell Referencing

• Understanding $ Symbol in Excel

• Fixing Rows, Columns, or Both

• Real-time practice to master referencing in formulas

🔹 5. Financial Formulas

• PMT – Calculate EMI

• FV – Future Value

• PV – Present Value

• Real examples like loans, SIP, investment tracking

🔹 6. Data Analysis & Visualization

• Creating and Customizing Charts (Bar, Pie, Line, Column)

• Using Data Validation for Drop-Downs

• Sorting & Filtering Large Data Sets

• Conditional Formatting – Color Scales, Icons, Rules

🔹 7. Pivot Table & Pivot Chart

• Creating Pivot Tables from Raw Data

• Filtering & Grouping within Pivot Table

• Slicer & Timeline Tools

• Creating Pivot Charts for Visual Analysis

🔹 8. Data Tools & Extra Features

• Text to Columns, Flash Fill

• Remove Duplicates

• Freeze Panes, Split Screen

• Protecting Sheets & Workbook

• Workbook Linking & Consolidation

🔹 9. Real-life Projects & Applications

• MIS Reports

• Salary Sheets

• Sales Dashboard

• Attendance Sheet with Auto Summary

• Billing Formats

🎯 Outcome:

After completing this course, students will:

• Master Excel’s most powerful formulas

• Analyze and visualize data with ease

• Build professional dashboards & reports

• Automate routine Excel tasks

• Become job-ready for any office, accounting, or data management role