IT ProgramIndustry Ready Course

Advance Excel

Dive deep into pivot tables, VLOOKUP, macros, and advanced data analysis techniques in Microsoft Excel.

Duration

2 Months

Eligibility

10th Pass

Course Curriculum

A structured learning path to take you from zero to job-ready.

Module 1

Advanced Formatting: Custom number formats, cell styles, and themes.
Conditional Formatting: Rule-based formatting, data bars, color scales, and icon sets.
Data Validation: Creating Dropdown Lists, restricting input, and custom error messages.
Advanced Sorting & Custom Filtering, including multiple criteria and color sorting.
Text to Columns, Flash Fill, and Data Cleanup techniques to remove duplicates.
Using Name Manager, defining Named Ranges, and using them in complex formulas.

Module 2

Lookup Functions: Mastering VLOOKUP, HLOOKUP, INDEX, MATCH, and the new XLOOKUP.
Logical Functions: Nested IF, AND, OR, IFERROR, and IFS.
Text Functions: LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN, LEN, and FIND.
Date & Math Functions: TODAY, EOMONTH, NETWORKDAYS, SUMIFS, COUNTIFS, AVERAGEIFS.
Array Formulas, dynamic arrays (FILTER, SORT, UNIQUE), and Advanced Calculations.
Troubleshooting Formula Errors (e.g., #N/A, #VALUE!, #REF!) and using formula auditing.

Module 3

Pivot Tables: Grouping data, calculated fields, and summarizing large datasets quickly.
Pivot Charts: Creating dynamic charts that update automatically with Pivot Tables.
What-If Analysis: Using Goal Seek, Scenario Manager, and Data Tables for forecasting.
Creating Interactive Dashboards with KPIs and professional layouts.
Slicers and Timelines for visually filtering data in Dashboards.
Consolidating Data from Multiple Worksheets and Workbooks into a master sheet.

Module 4

Introduction to Macros: Recording, running, and assigning macros to shapes/buttons.
VBA Basics: Understanding the Visual Basic Editor (VBE) and writing simple scripts.
Automating repetitive tasks like formatting reports or copying data daily.
Data Import/Export: Introduction to Power Query for transforming and loading data.
Protecting Worksheets and Workbooks with passwords and restricting cell editing.
Collaboration: Tracking changes, sharing workbooks, and co-authoring techniques.

Upon successfully completing this course, you will be prepared for the following roles in top IT companies:

Talk to our expert counselors to find the right path for you.