Ainwik Infotech · Course Curriculum

Microsoft Excel
Beginner to Advanced

Build a strong foundation in Excel and progress toward advanced concepts, practical knowledge,hands-on learning approach.

Beginner friendlyCore and Advance Macros & Automations VBA & Custom Functions
Explore Course Curriculum 
# Your Excel journey starts here
VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]):
    HLOOKUP(lookup_value,table_array,row_index_num,[range_lookup]

# Learn. Practice. Build.
Beginner → AdvancedProgressive learning path
Practical ApproachLearn concepts through practice
Core + ApplicationsReal Time Dashboard & Transformation
About the course

Start from the basics. Grow with confidence.

This curriculum is designed for learners with no prior technical background as well as those who already know programming and want to explore Excel in depth.

What you’ll learn

Understand Excel fundamentals, work with spreadsheets and formulas, organize and analyze data, create professional reports, and build interactive dashboards.

  • Excel basics and spreadsheet fundamentals
  • Cells, rows, columns, formulas, functions and formatting
  • Data sorting, filtering, validation and conditional formatting
  • Charts, PivotTables, PivotCharts and interactive dashboards

How the course is approached

Learn interactively from the very basics, with practical explanations, real-world examples and hands-on exercises. The curriculum also includes doubt clarification sessions.

  • Step-by-step progression through core Excel concepts
  • Explore commonly used Excel formulas, functions and tools
  • Practice working with real-world datasets and reports
  • Additional advanced concepts may be covered as tasks require
Detailed syllabus

Explore the Excel curriculum

Open each module to view the topics covered. The listed headings may include multiple subtopics, and additional concepts may be included during the course.

01Excel Introduction
  • An overview of the screen, navigation and basic spreadsheet concepts
  • Various selection techniques
  • Shortcut Keys
  • Customizing the Ribbon
  • Using and Customizing AutoCorrect
  • Changing Excel’s Default Options
  • Using Functions – Sum, Average, Max,Min, Count, Counta
  • Absolute, Mixed and Relative Referencing
02Formatting & Proofing
  • Currency Format
  • Format Painter
  • Formatting Dates
  • Custom and Special Formats
  • Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
  • Basic conditional formatting
03Mathematical Functions
  • SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs
  • Nested IF
  • IFERROR Statement
  • AND, OR, NOT
04Protecting Excel & Text Functions
  • File Level Protection
  • Workbook, Worksheet Protection
  • Upper, Lower, Proper
  • Left, Mid, Right
  • Trim, Len, Exact
  • Concatenate
  • Find, Substitute
05Date and Time Functions & Advanced Paste Special Techniques
  • Today, Now
  • Day, Month, Year
  • Date, Date if, DateAdd
  • EOMonth, Weekday
  • Paste Formulas, Paste Formats
  • Paste Validations
  • Transpose Tables
06New in Excel 2013 / 2016 & 365
  • New Charts – Tree map & Waterfall
  • Sunburst, Box and whisker Charts
  • Combo Charts – Secondary Axis
  • Adding Slicers Tool in Pivot & Tables
  • Using Power Map and Power View
  • Forecast Sheet
  • Sparklines -Line, Column & Win/ Loss
  • Using 3-D Map
  • New Controls in Pivot Table – Field, Items and Sets
  • Various Time Lines in Pivot Table
  • Auto complete a data range and list
  • Quick Analysis Tool
  • Smart Lookup and manage Store
07Sorting and Filtering & Printing Workbooks
  • Filtering on Text, Numbers & Colors
  • Sorting Options
  • Advanced Filters on 15-20 different criteria(s)
  • Setting Up Print Area
  • Customizing Headers & Footers
  • Designing the structure of a template
  • Print Titles –Repeat Rows / Columns
08Advance Excel & What If Analysis
  • Goal Seek
  • Scenario Analysis
  • Data Tables (PMT Function)
  • Solver Tool
09Logical Functions & Data Validation
  • If Function
  • How to Fix Errors – if error
  • Nested If
  • Complex if and or functions
  • Number, Date & Time Validation
  • Text and List Validation
  • Custom validations based on formula for a cell
  • Dynamic Dropdown List Creation using Data Validation – Dependency List
10Lookup Functions
  • Vlookup / HLookup
  • Index and Match
  • Creating Smooth User Interface Using Lookup
  • Nested VLookup
  • Reverse Lookup using Choose Function
  • Worksheet linking using Indirect
  • Vlookup with Helper Column
11Pivot Tables
  • Creating Simple Pivot Tables
  • Basic and Advanced Value Field Setting
  • Classic Pivot table
  • Choosing Field
  • Filtering PivotTables
  • Modifying PivotTable Data
  • Grouping based on numbers and Dates
  • Calculated Field & Calculated Items
  • Arrays Functions
  • What are the Array Formulas, Use of the Array Formulas?
  • Basic Examples of Arrays (Using ctrl+shift+enter).
  • Array with if, len and mid functions formulas
  • Array with Lookup functions.
  • Advanced Use of formulas with Array.
12Charts and slicers & Excel Dashboard
  • Various Charts i.e. Bar Charts / Pie Charts / Line Charts
  • Using SLICERS, Filter data with Slicers
  • Manage Primary and Secondary Axis
  • Planning a Dashboard
  • Adding Tables and Charts to Dashboard
  • Adding Dynamic Contents to Dashboard
13Introduction to VBA & Variables in VBA
  • What Is VBA?
  • What Can You Do with VBA?
  • Recording a Macro
  • Procedure and functions in VBA
  • What is Variables?
  • Using Non-Declared Variables
  • Variable Data Types
  • Using Const variables
14Message Box and Input box Functions & If and select statements Modules
  • Customizing Msgboxes and Inputbox
  • Reading Cell Values into Messages
  • Various Button Groups in VBA
  • Simple If Statements
  • The Elseif Statements
  • Defining select case statements
15Looping in VBA & Mail Functions – VBA
  • Using Outlook Namespace
  • Send automated mail
  • Outlook Configurations, MAPI
  • Worksheet / Workbook Operations
  • Merge Worksheets using Macro
  • Merge multiple excel files into one sheet
  • Split worksheets using VBA filters
  • Worksheet copiers

The curriculum headings are indicative. Multiple subtopics may be covered under each heading, along with additional concepts based on task requirements.

Learning journey

Build your Python skills step by step

A structured path through the major areas of the course.

⌘

Excel Foundations

Understand the Excel interface, workbooks, worksheets, cells, rows, columns, data entry, formatting and basic spreadsheet concepts.

{}

Formulas & Functions

Work with formulas, cell references, mathematical functions, logical functions, text functions, date functions and essential Excel calculations.

⚙

Data Management

Organize and manage data using sorting, filtering, tables, data validation, conditional formatting and data-cleaning techniques.

▤

Data Analysis

Analyze business data using lookup functions, PivotTables, PivotCharts, subtotals and other powerful Excel analysis tools.

λ

Advanced Excel Skills

Explore advanced formulas, dynamic functions, advanced lookups, what-if analysis, named ranges and automation techniques.

✦

Interactive Learning

Learn through practical exercises and real-world datasets, create professional reports and dashboards, and use doubt clarification sessions to support your progress.

Ready to begin your Excel journey?

Start with the fundamentals and work your way toward advanced Excel concepts with Ainwik Infotech.

Visit Ainwik Infotech ↗