Data Analysis using Excel

Syllabus

Excel Data Analysis – Overview, Range Names, Tables, Data Cleaning, Time Values, Formatting, Sorting, Filtering, Subtotals, Quick Analysis, Lookup Functions. Pivot Tables, Visualization and Validation, Financial Analysis, Multiple Sheets, Formula Auditing, Inquire, Advanced Data Analysis.

Evaluation Pattern

• Assignment score = 40%
• Exam Score = 40%
• Project Score = 20%

Teaching Pedagogy

Online Theory & Practical sessions, Assignments, Quizzes, Assessment Exams, Project