MS EXCEL BUISENESS COURSE

Microsoft Excel – Complete Course Notes
This document contains complete Excel course notes including Interface, Tabs,
Tools, Data Processing, Business Concepts, Charts, PivotTables, Power Query basics,
and 200+ Excel formulas.


1. Introduction to Excel
• Excel is a spreadsheet program used for calculations, data analysis, visualization,
automation, and reporting.

• Workbook: An Excel file containing worksheets.

• Worksheet: A grid of rows and columns used to store and manipulate data.

• Cell: The basic data unit identified by Column + Row (e.g., A1).

2. Excel Interface: Tabs, Groups, Commands
Home Tab
• Clipboard

• Font

• Alignment

• Number

• Styles

• Cells

• Editing

Insert Tab
• Tables

• Illustrations

• Add-ins

• Charts

, • PivotTables

• Filters

• Sparklines

• Text

• Symbols

Page Layout
• Themes

• Page Setup

• Scale to Fit

• Sheet Options

• Arrange

Formulas
• Function Library

• Defined Names

• Formula Auditing

• Calculation

Data
• Get & Transform

• Sort & Filter

• Data Tools

• Forecast

• Outline

Review
• Proofing

• Accessibility