Course Objectives:

1. Develop advanced Excel skills to enhance efficiency and reduce risk in data management and analysis.
2. Gain proficiency in using advanced functions, formulas, and techniques to solve complex problems.
3. Acquire knowledge of data validation, conditional formatting, and charting techniques to improve data visualization.
5. Master the utilization of external data sources, PivotTables, and PowerPivot for advanced data analysis and reporting.
This part-time course spans three months and is designed to provide Indian students with comprehensive knowledge and practical skills in Advanced Excel. Through a combination of theoretical concepts and hands-on exercises, students will learn to harness the power of Excel for self-employment and career advancement. The course covers a wide range of topics, from basic to advanced, enabling learners to develop expertise in data management, analysis, visualization, and reporting using Excel.

Syllabus

Module 1: Foundations of Advanced Excel

* Basics of Excel

* Auto fill and using formulas in excel

* Using Basic Functions (SUM,MIN etc)

* Tabs and Menu commands

* Increasing Efficiency and Reducing Risk

* Data Validation

* Advanced Techniques

Module 2: Advanced Functions and Formulas

* 100 advanced function and its use

* Array

* Filters

* Sorting Techniques

Module 3: Data Analysis and Visualization

* What If Analysis

* Problem Solving

* Excel Interactivity

* Conditional Formatting

* Charts that Inspire

* Sparklines

* Graphics Tricks and Techniques

Module 4: Advanced Data Management and Reporting

* Turning Data into Decisions

* Working with External Data

* Pivot Table

* Advanced Uses of PivotTables

* PowerPivot

Module 5: Lookup

* V-Lookup

* H-Lookup

* X-Lookup

* Picture Lookup

* Lookup

Module 6: More than 15 Tips and Tricks

5 Real World Project

-- Appointment Form Ends -->