Excel and Advance Excel 18 hours
Career Options
- Accounts / Billing Assistant (Foundation)
- Student Academic & Project Use
- Data Analyst (Entry Level)
- Business Analyst (Foundation Level)
- MIS Executive / Reporting Analyst
- Office Administrator
- Accounts Executive
- Business Analyst (Foundation Level)
- Freelancing & Work-From-Home Roles
Contact Us
Module 4 – Basic & Advanced Excel – 18 Hrs
- Basic Excel
- Formulas and Functions: SUM, AVERAGE, IF, VLOOKUP, HLOOKUP
- Data Formatting: Conditional formatting, tables, sorting
- Basic Charts: Bar, line, and pie charts
- Advanced Excel
- Pivot Tables: Creating and customizing pivot tables
- Data Analysis ToolPak: Regression, correlation, statistical analysis
- Macros and VBA: Automating tasks with simple scripts