Course curriculum

  • 1

    Avail the Discount - Limited Seats

    • Discount On Excel

    • Get Access Of Ready to Use Templates- 21
  • 2

    Module - 1 Essential of Excel

    • Home Tab

    • Insert Tab

    • Print Layout Tab

    • View Tab

    • Review Tab
  • 3

    Module - 2 Common Mistakes You should Avoid During Excel

    • How to Edit the Selected Cells

    • View All Shortcuts From Excel Excel Worksheet

    • Autocorrect the Spelling Mistake

    • Custom Auto fill

    • Count Numeric Only

    • Count Blank Only

    • Create Table With ShortCut

    • Custom List

    • Custom List

    • Enter the repetitive data entry within a column

    • Format Cell

    • Go To The Reference

    • Create new Chart Shortcut

    • Capitalize each word in a given string

    • Create Random Value

    • Create Custom Random Value

    • Zoom in Zoom Out in Excel- Shortcut

    • Create Theme in Excel

    • Remove Extra Space from String
  • 4

    Module - 3 Excel Smart Tricks and Hacks

    • Hide Data In Cell

    • Hide Formulas

    • Advance Select

    • copy of WorkSheet

    • Consolidate

    • Custom Header Footer

    • Change Gridline Color

    • Convert number

    • Change Default File Location

    • Large

    • Diagonal Cell

    • Drag Data

    • Formula text

    • Find and replace

    • REPT

    • Multiple selection

    • Insert Gif

    • Multiple Rows and Cols

    • Count Holidays by specific day

    • T Function

    • Count Holidays

    • QAT

    • Remove Blank

    • Find 2nd or 3rd Smallest value

    • Indirect Function

    • Transpose

    • Transpose Dynamic

    • Change Reference

    • Subtotal

    • Flash fill

    • Roman

    • Select all data

    • Resize

    • Status bar

    • Text to Column

    • Yearfrac Function

    • Show formula

    • Format Painter

    • Use of Slicer

    • Select Data From Different WorkBook

    • Date Custom Format

    • Sort and Filter

    • Sum in multiple way
  • 5

    Module - 4 Master in 100+ Shortcuts

    • 30 Basic Shortcuts

    • 15 Shortcuts With ALT Key

    • 50 Shortcuts With CTRL

    • 10 Shortcuts Functions Key

    • Tabs with Shortcuts-7

    • all one Key shortcuts
  • 6

    Module - 5 Play With 100+ Formula

    • Text Formulas

    • Date Formulas

    • Maths Formulas

    • Statistics Formulas

    • Logical Formulas

    • Lookup Formulas

    • Info Formulas
  • 7

    Module - 6 Conditional Formatting

    • Conditional Formatting
  • 8

    Module - 7 Excel Protection and Security

    • Data Validation

    • Data Security
  • 9

    Module - 8 Design Dynamic Charts

    • Column Chart

    • Bar Chart

    • Area Chart

    • Bubble Chart

    • Pie Chart

    • Line Chart

    • Scatter Chart

    • Combo Chart

    • Pareto Chart
  • 10

    Module - 9 Pro in Pivot Table

    • Pivot Table

    • Pivot Chart
  • 11

    Module -10 Lookups and Xlookup

    • VlookUp-Syntax

    • Basic Vlookup

    • Vlookup with Absolute Reference

    • Vlookup With Define Name

    • HlookUp

    • Xlookup - Syntax and First Example

    • Vlookup Vs XlookUp

    • Hlookup Vs Xlookup

    • Xlookup Vs Index Match

    • Xlookup- Different Columns

    • Xlookup Search mode

    • Xlookup with latest Search
  • 12

    Module - 11 Automating in Excel with Macros

    • Macros

    • Macros - Relative Reference with Button
  • 13

    Module - 12 Mastery in Dashboard

    • Dashboard