Microsoft Excel - Beginner to Advance

Microsoft Excel is a versatile spreadsheet application created by Microsoft that helps users manage, examine, and present data effectively. It is widely used in various industries and is a key component of the Microsoft Office suite, offering powerful features for calculations, automation, reporting, and financial analysis.

Excel primarily works by organizing information into rows and columns, enabling users to apply formulas, perform calculations, generate charts, and develop financial models. Available on both Windows and macOS platforms, Excel is commonly used for a wide range of personal, academic, and professional purposes.

Course Highlight / Content

  • Introduction to MS Excel

  • Workbook & Worksheet

  • Rows, Columns, Cells

  • Cell Address & Range

  • Data Types (Text, Number, Date)

  • Save, Save As, Open

  • Excel Interface Overview

  • Cell Formatting

    • Font, Size, Color

    • Alignment

    • Wrap Text

    • Merge & Center

  • Number Formatting

    • Currency

    • Percentage

    • Date & Time

  • Conditional Formatting (Basic)

  • Formula Basics

  • Arithmetic Operators (+, -, *, /)

  • AutoSum

  • Basic Functions

    • SUM

    • AVERAGE

    • COUNT

    • MAX

    • MIN

    • Sort (Single & Multiple Level)

    • Filter (Auto Filter, Custom Filter)

    • Data Validation

      • Dropdown List

    • Remove Duplicates

    • Text to Columns

    • Flash Fill

  • Column Chart

  • Bar Chart

  • Line Chart

  • Pie Chart

  • Area Chart

  • Chart Formatting

  • Sparklines

Logical Functions

  • IF

  • AND

  • OR

  • IFERROR

Text Functions

  • LEFT

  • RIGHT

  • MID

  • LEN

  • TRIM

  • UPPER / LOWER / PROPER

  • CONCAT / CONCATENATE

    • VLOOKUP

    • HLOOKUP

    • XLOOKUP

    • INDEX

    • MATCH

  • TODAY

  • NOW

  • DATE

  • DATEDIF

  • DAY / MONTH / YEAR

  • Conditional Formatting (Advanced)

  • Pivot Table

  • Pivot Chart

  • Slicers & Timelines

  • What-If Analysis

    • Goal Seek

    • Scenario Manager

    • Data Table

    • Protect Sheet

    • Protect Workbook

    • Hide / Unhide Rows & Columns

    • Freeze Panes

    • Page Setup

    • Print Titles

    • Print Area

  • Introduction to Macros

  • Record Macro

  • Macro Security

  • Basic VBA Concepts

  • Sales Report

  • Attendance Sheet

  • Salary Sheet

  • Invoice Format

  • Stock Management Sheet

  • MIS Report

  • Common Keyboard Shortcuts

  • Excel Tips & Tricks

  • Error Handling

  • Best Practices

Price

Duration

Every session is divided into three sections.

  1. Doubt Section (15 min) : Before Session starts, Recap and doubt Sessions
  2. Learning Section (45 min) : Learning Discussion as per syllabus.
  3. Practice Section (30 min) : Practice Evaluation once Discussion is over.

Review