Bestseller
Bestseller
Microsoft Excel is a spreadsheet editor developed by Microsoft for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Introduction & Basics: Understanding the Excel interface, Ribbon, worksheets, rows, columns, saving, printing, and navigation.
Data Entry & Formatting: Cell formatting, formatting tables, using the Format Painter, and data validation.
Formula & Functions: Basic functions (
SUMcap S cap U cap M
𝑆
𝑈
𝑀
, AVERAGEcap A cap V cap E cap R cap A cap G cap E
𝐴
𝑉
𝐸
𝑅
𝐴
𝐺
𝐸
, COUNTcap C cap O cap U cap N cap T
𝐶
𝑂
𝑈
𝑁
𝑇
, IFcap I cap F
𝐼
𝐹
) to complex formulas (VLOOKUPcap V cap L cap O cap O cap K cap U cap P
𝑉
𝐿
𝑂
𝑂
𝐾
𝑈
𝑃
, HLOOKUPcap H cap L cap O cap O cap K cap U cap P
𝐻
𝐿
𝑂
𝑂
𝐾
𝑈
𝑃
, Index/Match, Nested functions).
Data Analysis & Visualization: Sorting, filtering, conditional formatting, Sparklines, and creating charts (Bar, Column, Pie, Line).
PivotTables & Dashboards: Creating, customizing, and filtering PivotTables, Slicers, and creating interactive reports.
Advanced Tools & Automation: Goal Seek, Scenario Manager, Data Table, Macros (VBA), and importing/exporting data.
New Features (Excel 365/2019/2021): Treemap, Waterfall, Power Map, and Dynamic Array functions
Copyright © 2026 DITRP INDIA. All Rights Reserved
