Basic To Advance Excel

Overview

Excel Basics & Foundation

Introduction to Microsoft Excel

• Excel Interface (Ribbon, Tabs, Workbook, Worksheet)
• Rows, Columns, Cells
• Data Entry & Editing
• Cell Formatting
• Font, Borders, Colors
• Alignment & Merge Center
• Number Formatting
• Row Height & Column Width
• Wrap Text
  

Basic Formulas

• SUM
• MAX
• MIN
• AVERAGE
• SMALL
• LARGE
• PERCENTAGE

Intermediate Excel & Formulas

• IF Condition
• Nested IF
• AND
• OR
• How To Calculate Bonus With If Function

Text Formulas

• LEFT
• RIGHT
• MID
• LEN
• LEN2
• UPPER
• LOWER
• PROPER
• CONCATNATE
• TRIM FUNCTION

Maths & Statistical Function

• ABS Function
• Sum if
• Int Function
• Round Function
• Power 
• Subtotal
• Multiplication
• Net Amount Calculation
• Sum Product

Date & Time Functions

• TODAY
• NOW
• DATE
• DAY
• MONTH
• YEAR
• DATEDIF

Additional Function & Option

• COUNTIF
• COUNTA
• COUNTBLANK
• COUNT
• SUMIF
• AVERAGEIF
• COUNTIF
• Data Validation
• Drop-Down List Project
• EMI CALCULATION
• FLASH FILL
• VLOOKUP
• HLOOKUP
• PIVOT TABLE with Charts
• CONSOLIDATE
• Text To Column
• Formatting Sheets
• Salary Sheet
• Stock Management
• Basic Shortcut Keys
• Conditional Formatting
• Filter & Sorting
• Merge Sheet

Advanced Excel

10 TYPES OF VLOOKUP

How To Find Duplicate Value with VLOOKUP

Adv HLOOKUP

LOOKUP

INDEX + MATCH

XLOOKUP

SWITCH FUNCTION

IFS Condition

Advance EMI Calculation

CONCATE FUNCTION

Advance Conditional Formatting

What is Analysis

Making Invoice Bill with Function

Advance Filter

AI Functions

Copilot AI

Dashboard Creation

MIS Report

Sales Report

Attendance Report

Fee Sheet Design

Macro Basics

Record Macro