Advanced Excel with MIS

Course Overview

Advanced Excel is a professional computer course designed for students, office workers and job seekers who want to improve their data handling and reporting skills. In this course, students learn formulas, functions, charts, pivot tables, dashboards, MIS reports and data analysis with practical lab sessions.

This course is highly useful for office jobs, data entry work, business reporting and accounting-related tasks.

What You'll Learn

• ✓Excel interface and workbook management
• ✓Formulas and functions
• ✓Conditional formatting
• ✓Data validation
• ✓Charts and graphs
• ✓Pivot table and pivot chart
• ✓Dashboard creation
• ✓MIS reporting
• ✓Lookup functions
• ✓Data analysis tools
• ✓Printing and page setup
• ✓Shortcut keys

Syllabus

FAQs