Course curriculum

  • 1

    Module 1: Basic Terminology of Excel

    • Introduction

    • Understanding GUI

    • Save

    • Sort and Filter

    • Things to Know Before You Start

    • Open

    • Editing spreadsheets

    • Data Formatting in Excel

    • Spreadsheet basics

    • Basic 30 Shortcuts

    • Formatting

    • Working with Excel Templates

    • Basic Skills( Status bar)
  • 2

    Module 2: Layout Formatting and Page Setup

    • Exploring Page Layout Methods

    • Page Setup And Printing Controls

    • Print Size

    • Print Set Area

    • Print

    • Formatting Data in an Excel Worksheet

    • Inserting Images and Shapes into an Excel Worksheet

    • How To Split Data In To Multiple Columns

    • Group and Ungroup

    • Paste Special
  • 3

    Module 3: Managing Tables

    • Create Table By 4 Way

    • Managing Tables
  • 4

    Module 4: Sorting and Filtering Data

    • Sort Basic

    • Sort by Color

    • Multi level Shorting

    • Custom Sorting

    • Sort and Filter

    • Advance Filter

  • 5

    Module 5: Custom & Conditional Formats

    • Conditional Formatting with Highlight cell and Top Bottom Rules

    • Custom Conditional Formatting

    • Manage Edit and Delete Rules

    • Conditional Formats with Data bar, Color Scale And Icon Set

  • 6

    Module 6: Data Validation

    • Data Validation with Number

    • Data Validation with Text

    • Data Validation with Date

    • Data Validation with Time

    • Data Validation with Dynemic List

    • Custom Remove Extra Space
  • 7

    Module 7: Master in Data Manipulation and Security

    • How To Split Data In To Multiple Columns

    • Consolidating Data

    • How To Add Comments

    • How To Insert Subtotals in English

    • Linking Worksheets

    • AutoFill Data Entry Methods

    • Protect Worksheet

    • Allow Edit Range

    • Protecting Specific Cells in a Worksheet

    • Protecting the Structure of a Workbook

    • Adding a Workbook Password

    • Undo and Redo

    • Remove Duplicate
  • 8

    Module 8: Excel Tools

    • Trace Precedents and Dependents

    • Formula Auditing

    • Flash Fill

    • Quick Access Toolbar

    • Go to Function Tab – F5 Special

    • Data From Access

    • Freezing of Panes –Freeze Top Row, Freeze First Column, Freeze Customization

    • Hide Row & Columns,Worksheets,Workbook

    • Sparklines

    • Splitting

    • Inserting Text and Special Symbol

    • Window View

    • Proofing

    • Nested IF

    • Match

    • Index and Match
  • 9

    Module 9: Expertise in Dynamic Presentation and Visualization

    • Column Chart

    • Bar Chart

    • Line Chart

    • Pie Chart

    • Area Chart

    • Combo Chart

    • Bubble Chart

    • Scatter Chart

    • Pareto Chart
  • 10

    Module 10: Pro in Pivot Table And Chart

    • Pivot Table

    • Field Values

    • Slicer

    • Timeline Slicer

    • Drill Down Pivot Data

    • Pivot Chart Example

    • Design in Pivot Chart

    • Pivot Chart with Slicer

    • Pivot Chart Template

    • Conditional Formatting with Pivot table

    • Start Macros

    • First Basic Macros

    • Data Filter Using Macros

    • Assign Macros with QAT

    • Pivot Table Grouping

  • 11

    Module 11: Shortcuts

    • Basic Shortcuts

    • Shortcuts With ALT KEY

    • Shortcut with Ctrl Key

    • Shortcut with Function

    • Shortcut with Tabs

    • Extra Shortcut

  • 12

    Module 12: Deep Dive in Lookups

    • VlookUp-Syntax

    • Basic Vlookup

    • HlookUp

    • Vlookup With Define Name

    • Vlookup with Absolute Reference

    • Vlookup with IFERROR(Find Duplicate)

    • Vlookup with IF and ISERROR(Find Duplicate)

    • Vlookup with Wide Card

    • Vlookup Duplicate

    • Vlookup with Approx Match

    • Vlookup with MultipleSheets

    • Vlookup with Match

    • Vlookup with Multicolumn

    • Vlookup with IMAGE
  • 13

    Module 13: Xlookup(NEW IN 365)

    • Xlookup-Syntax and First Example

    • Xlookup- Different Columns

    • Vlookup Vs XlookUp

    • Index Match VS Xlookup

    • Xlookup Vs Hlookup

    • Xlookup Search mode

    • Xlookup with Search
  • 14

    Module 14: Working with Range Names

    • Define Name

    • Another Way to Define Name Range

    • Define name Use with Formula

    • Edit Name Range

    • Delete Define Name
  • 15

    Module 15: Using Formulas & Functions

    • Info Formulas

    • Statistics Formulas

    • Lookup Formulas

    • Logical Formulas

    • Date Formulas

    • Maths Formulas
  • 16

    Module 16: Working with Reports

    • Basic rules for starting pivot table

    • Create and change data source update

    • Pivot table field

    • Report filter

    • Layout group in pivot

    • slicer design

    • Pivot Subtotal

    • Pivot chart

    • Consolidating data from multiple sheets and files using Pivot tables

    • Enable the Macro
  • 17

    Module 17: What-IF Analysis

    • Scenario Manager

    • Goal Seek

    • Data table
  • 18

    Module 18: Interactive Dashboard Mastery

    • Dashboard

    • Exercise

    • Monthly Sales Revenue- Infographic Chart

    • Weekly Sales Chart- Infographic Chart
  • 19

    Module 19 : Absolute and Relative Cell Reference

    • Relative Cell Reference

    • Absolute Cell Reference

    • Mixed Cell Reference
  • 20

    Module 20: Automating Repetitive Tasks in Excel with Macros

    • Macros

    • Macros - Relative Reference with Button

    • Macros with Conditional Formatting

    • Macros with Data Validation

    • Macros with Pivot table
  • 21

    Practice Files

    • Practice Files