Course curriculum

  • 1

    Module 1: Basic Terminology of Excel

    • Introduction

    • Launch Excel

    • Save and Save as

    • Open

    • Understanding GUI and Terminology

    • Cut and Paste

    • Copy and Paste

    • Format Painter

    • Font Fill color and Text Color

    • Bold-Italic- Underline

    • Text Alignment

    • Orientation

    • Font Face and Size

    • Border

    • Number Formatting

    • Wrap text, Marge and Center

    • Cell Style

    • Editing Group Spreadsheets

    • Working with Excel Templates

    • Paste Special

  • 2

    Module 2: Layout Formatting and Page Setup

    • How To Split Data In To Multiple Columns

    • Page Setup And Printing Controls

    • Print

    • Print Set background

    • Print set area

    • Insert Icon 3d Object and Screenshort

    • group and ungroup

    • Repeat Row and Column While Print

    • Scale to Fit option

    • Picture
  • 3

    Module 3: Managing Tables

    • 4 Ways To Create Table

    • Table Style and Formatting
  • 4

    Module 4: Sorting and Filtering Data

    • Basic Shorting

    • Multi level Shorting

    • Sort by Color

    • Custom Sorting

    • Filter

    • Expand the selection

    • Advance Filter
  • 5

    Module 5: Custom & Conditional Formats

    • Conditional Formats

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

  • 6

    Module 6: Data Validation

    • Text lenght

    • Decimal

    • Date and Time

    • Data validation vs Data security

    • Custom

    • Dynemic List vs Static List

    • Whole number
  • 7

    Module 7: Master in Data Manipulation and Security

    • How To Add Comments

    • How To Insert Subtotals

    • Undo and Redo

    • Consolidate

    • Remove Duplicate

    • Text to Column

    • Protect Sheet

    • Protect structure

    • Lock the cells

    • Protect Workbook

    • Allow Edit Range
  • 8

    Module 8: Excel Tools

    • Hide and Unhide workbook

    • Consolidate

    • Multiple Consolidate

    • Line Sparkline

    • Column Sparkline

    • Winlosss Sparkline

    • Manual Calculation

    • Trace Dependents

    • Trace Precedent

    • Evaluate the Formula

    • Error Checking

    • Show Formula

    • Watch Window

    • Translate

    • Thesaurus

    • Spelling Check

    • Workbook Statistic

    • Symbols
  • 9

    Module 9: Expertise in Dynamic Presentation and Visualization

    • Introduction and Column Chart

    • Chart Format and Layout

    • Bar Chart

    • Line Chart

    • Area Chart

    • Bubble Chart

    • Doughnut Chart

    • Scatter Chart

    • Combo Chart

    • Pie chart
  • 10

    Module 10: Pro in Pivot Table And Chart

    • Pivot table Tabular

    • Rule no 2 No gap

    • rule no 3 Formatting

    • Change Data Source

    • Pivot table field

    • Filter field

    • Formatting

    • Value field setting

    • Sorting of Data

    • Pivot Subtotal

    • Data Drill Down in Pivot

    • Subtotal

    • Slicer With Pivot table

    • Pivot Chart

    • Pivot Chart Template

    • TimeLine Slicer

    • Pivot Table with Conditional Formatting

    • Enable the Macro

    • Refresh macro Basic macro

    • Data Filter Macros With Button and Shapes

    • Assign Macros to QAT
  • 11

    Module 11: Deep Dive in Lookups

    • Vlookup Hlookup Syntax

    • Basic Vlookup

    • Hlookup

    • Vlookup With Define Name

    • Lookup with Approx Match

    • Vlookup with IFERROR(Find Duplicate)

    • Fine Duplicate

    • Vlookup with IF and ISERROR(Find Duplicate)

    • Vlookup with Widecard

    • VLookup with MultiWorkbooks

    • Vlookup with MultipleSheets

    • Vlookup with IMAGE

    • Vlookup with multicolumn

    • Vlookup with Absolute Reference
  • 12

    Module 12: Xlookup(NEW IN 365)

    • Xlookup Syntax

    • Xlookup Basic Example

    • Xlookup VS Vlookup

    • Xlookup Vs Hlookup

    • Xlookup Vs Index and Match

    • Xlookup Search Mood

    • Xlookup with Exact Match or Next Larger

    • Xlookup with Latest Match

    • Xlookup With Differnt Columns
  • 13

    Module 13: Shortcuts

    • Basic Shortcuts

    • Shortcuts With ALT KEY

    • Shortcut with Ctrl Key

    • Shortcut with Function

    • Shortcut with Tabs

    • Extra Shortcut

  • 14

    Module 14: Working with Range Names

    • Define Name
  • 15

    Module 15: Using Formulas & Functions

    • Logical Functions

    • Info Functions

    • Date Functions

    • Lookup Functions

    • Statistics Functions

    • Text Functions

    • Math Functions

    • Match

    • Index and Match

    • Nested If else
  • 16

    Module 16: Working with Reports

    • Pivot Chart

    • Sorting of Data

    • Pivot Chartwith slicer

    • Filter field

    • Pivot Subtotal

    • Slicer with Pivot table

    • Value field setting

    • Import Data from text and Access

    • Smart Art

    • Hyperlink

    • Shapes

    • Pivot Chart Template
  • 17

    Module 17: What-IF Analysis

    • Scenario Manager

    • Data table

    • Goal Seek
  • 18

    Module 18: Interactive Dashboard Mastery

    • How To Create Dashboard

    • Show Gridlines

    • Parote chart

    • Gantt chart
  • 19

    Module 19 : Absolute and Relative Cell Reference

    • Relative Reference

    • Absolute Reference

    • Mixed Reference
  • 20

    Module 20: Automating Repetitive Tasks in Excel with Macros

    • Introduction

    • My First Macros- 2 way record

    • Delete Macro

    • Assign Macro to Button

    • Create Macro Enable File

    • Absolute Macros Vs Relative Macro

    • Macros with Conditional Formatting

    • Macros with Data Validation

    • Macros with Pivot table
  • 21

    Practical Files

    • Practice Files