Microsoft Excel — Beginner's Complete Course

Microsoft Excel
Complete Beginner's Course

Syllabus · Notes · Formulas · Practice Tips

Level Modules Topics Duration

Beginner 6 30+ ~20 Hours

Basic Excel Notes Page 1

Microsoft Excel — Beginner's Complete Course

Table of Contents

Module 01 — Getting Started with Excel

■ Excel Interface Overview
■ Workbooks & Worksheets
■ Basic Navigation
■ Data Entry & Cell Types
■ Saving & File Formats

Module 02 — Formatting & Data Management

■ Cell Formatting
■ Number Formats
■ Conditional Formatting
■ Sorting & Filtering
■ Find & Replace

Module 03 — Essential Formulas & Functions

■ Formula Basics
■ SUM, AVERAGE, MIN, MAX
■ COUNT Functions
■ IF Function
■ Text Functions
■ Date & Time Functions

Module 04 — Charts & Data Visualization

■ Creating Charts
■ Chart Types
■ Customizing Charts
■ Sparklines

Module 05 — Working with Data

■ Tables & Structured Data
■ VLOOKUP / HLOOKUP
■ Pivot Tables Introduction
■ Data Validation
■ Paste Special

Module 06 — Tips, Shortcuts & Best Practices

■ Keyboard Shortcuts
■ Productivity Tips
■ Common Errors & Fixes
■ Practice Exercises

Basic Excel Notes Page 2

Microsoft Excel — Beginner's Complete Course

01 Getting Started with Excel

1.1 What is Microsoft Excel?

Microsoft Excel is a powerful spreadsheet application developed by Microsoft. It allows users
to store, organize, calculate, and analyze data using a grid of rows and columns. Excel is
widely used in business, education, finance, and everyday life.

Common Uses of Excel:

• Creating budgets and financial reports
• Managing lists (inventory, contacts, schedules)
• Performing mathematical calculations automatically
• Creating charts and graphs for data visualization
• Analyzing large sets of data quickly

1.2 Excel Interface Overview

Element Description

Title Bar Shows the name of the current workbook

Ribbon Toolbar with tabs: Home, Insert, Formulas, Data, Review, View

Formula Bar Displays/edits the content or formula of the selected cell

Name Box Shows the address of the selected cell (e.g., A1)

Worksheet Area The grid made up of rows (numbers) and columns (letters)

Sheet Tabs Tabs at the bottom for switching between worksheets

Status Bar Shows sum, count, average of selected cells at the bottom

Scroll Bars For navigating through large spreadsheets

■ Press Ctrl + Home to jump to cell A1 from anywhere in the sheet.

1.3 Workbooks and Worksheets

Workbook: The entire Excel file (saved as .xlsx). A workbook can contain multiple worksheets.
Worksheet (Sheet): A single tab/page inside a workbook, containing the grid of rows and
columns.

• A new workbook opens with 1 sheet by default (Sheet1)

• Right-click a sheet tab to: Insert, Delete, Rename, Move, or Copy
• Double-click a sheet tab to rename it
• Use the '+' icon next to tabs to add a new sheet

Basic Excel Notes Page 3

Microsoft Excel — Beginner's Complete Course

1.4 Understanding Cells, Rows & Columns

The worksheet is organized as a grid:

Term Description

Columns Labeled A, B, C … Z, AA, AB … (16,384 total)

Rows Labeled 1, 2, 3 … (1,048,576 total)

Cell Intersection of a column and row. Address = Column + Row (e.g., B3)

Cell Range A group of cells. Written as Start:End (e.g., A1:D10)

Active Cell The currently selected cell, highlighted with a green border

1.5 Navigating the Worksheet

Key Action

Arrow Keys Move one cell up/down/left/right

Enter Confirm entry and move down

Tab Confirm entry and move right

Ctrl + Arrow Key Jump to last cell with data in that direction

Ctrl + End Jump to last used cell in the sheet

Ctrl + Home Jump to cell A1

Page Up / Page Down Scroll up or down one screen

Ctrl + G Go To a specific cell address

1.6 Data Entry & Cell Types

Excel recognises three main types of data:

Type Description Alignment Example

Text (Labels) Names, headings, descriptionsLeft-aligned by default 'John', 'Sales'

Numbers Values used in calculations Right-aligned by default 150, 3.14

Formulas Start with = sign Shows calculated result =A1+B1

■ To enter a number as text (e.g. phone number), start with an apostrophe: '0123456789

1.7 Saving Your Work

• Ctrl + S — Save the current file
• Ctrl + Shift + S — Save As (choose location and format)
• .xlsx — Default Excel format (recommended)
• .xls — Older Excel format (Excel 97–2003)
• .csv — Comma-separated values (plain text, no formatting)
• Use AutoSave (top left) when using OneDrive/SharePoint

Basic Excel Notes Page 4

Microsoft Excel — Beginner's Complete Course

02 Formatting & Data Management

2.1 Cell Formatting Basics

Formatting makes your spreadsheet easier to read. Access formatting via the Home tab or
right-click → Format Cells (Ctrl + 1).

Format Option How to Use

Font Style Bold (Ctrl+B), Italic (Ctrl+I), Underline (Ctrl+U)

Font Size/Color Change text size and color from Home tab

Fill Color Background color of a cell (paint bucket icon)

Borders Add lines around/inside cells for a table look

Alignment Left, Center, Right; Top, Middle, Bottom; Wrap Text

Merge & Center Combine multiple cells into one (great for headings)

2.2 Number Formats

Apply number formats from the Home tab → Number group, or Ctrl+1 → Number tab.

Format Description Example

General Default — no specific format 1500

Number Decimal places, thousands separator 1,500.00

Currency With currency symbol ■1,500.00

Accounting Currency aligned, negatives in brackets ■ 1,500.00

Percentage Multiplies by 100, adds % 75%

Date Various date display options 11-05-2026

Time Hours, minutes, seconds 10:30 AM

Text Treats cell value as text 007

2.3 Conditional Formatting

Conditional Formatting automatically applies colors or icons to cells based on their values. Go
to Home → Conditional Formatting.

Rule Type Description

Highlight Cell Rules Color cells Greater Than, Less Than, Equal To, or containing specific text

Top/Bottom Rules Highlight top 10 items, bottom 10%, above/below average

Basic Excel Notes Page 5

Microsoft Excel — Beginner's Complete Course

Rule Type Description

Data Bars Adds a colored bar inside the cell proportional to the value

Color Scales Applies a color gradient (e.g., red → yellow → green)

Icon Sets Displays traffic lights, arrows, or stars based on value ranges
■ Use Data Bars to create an instant visual bar chart inside your cells!

2.4 Sorting Data

Sort data via Data → Sort or the A→Z / Z→A buttons.
• Select any cell in your data range before sorting
• Ascending (A→Z / Smallest→Largest): Data → Sort A to Z
• Descending (Z→A / Largest→Smallest): Data → Sort Z to A
• Multi-level Sort: Data → Sort → Add Level (e.g., sort by Region then by Sales)
• Check 'My data has headers' so the header row is not sorted

2.5 Filtering Data

AutoFilter lets you show only the rows that match your criteria.
• Select your data → Data → Filter (or Ctrl+Shift+L)
• Click the dropdown arrow in any column header to filter that column
• Use Number Filters or Text Filters for advanced conditions
• Filter by color if conditional formatting is applied
• Clear a filter by clicking the arrow again → Clear Filter From Column

2.6 Find & Replace

Find (Ctrl+F): Locate specific text or values in your sheet.
Replace (Ctrl+H): Find a value and replace it with another.
Useful options: Match Case, Match Entire Cell Contents, Look in Formulas/Values.

Basic Excel Notes Page 6

Microsoft Excel — Beginner's Complete Course

03 Essential Formulas & Functions

3.1 Formula Basics

Every formula in Excel starts with an = (equals) sign. Excel then calculates the expression
and displays the result.

= A1 + B1 → Adds values in A1 and B1

= 100 * 0.18 → Multiplies 100 by 0.18 (calculates 18% of 100)
= SUM(A1:A10) → Adds all values from A1 to A10

Arithmetic Operators
Operator Meaning Example

+ Addition =A1+B1

- Subtraction =A1-B1

* Multiplication =A1*B1

/ Division =A1/B1

^ Exponent =A1^2 (A1 squared)

% Percent =A1*10%

Cell References
Type Syntax Behaviour

Relative A1 Changes when formula is copied to another cell

Absolute $A$1 Does NOT change when copied — locked (press F4)

Mixed $A1 Column locked, row changes (or vice versa: A$1)
■ Press F4 while editing a formula to cycle through $A$1 → A$1 → $A1 → A1

3.2 SUM, AVERAGE, MIN, MAX

Function Syntax Description

SUM =SUM(A1:A10) Adds all numbers in range A1 to A10

AVERAGE =AVERAGE(B1:B20) Calculates the mean of the range

MIN =MIN(C1:C100) Returns the smallest value in range

MAX =MAX(C1:C100) Returns the largest value in range

SUMIF =SUMIF(A1:A10,"Sales",B1:B10) Sum cells in B where A = 'Sales'

AVERAGEIF =AVERAGEIF(A1:A10,">50") Average only values greater than 50

Basic Excel Notes Page 7

Microsoft Excel — Beginner's Complete Course

3.3 COUNT Functions

Function Syntax Description

COUNT =COUNT(A1:A20) Counts cells with NUMBERS only

COUNTA =COUNTA(A1:A20) Counts all non-empty cells

COUNTBLANK =COUNTBLANK(A1:A20) Counts empty cells

COUNTIF =COUNTIF(A1:A20,"Yes") Counts cells matching a condition

COUNTIFS =COUNTIFS(A:A,"Yes",B:B,">100") Multiple conditions

3.4 IF Function
The IF function tests a condition and returns one value if TRUE, another if FALSE.
=IF(condition, value_if_true, value_if_false)
=IF(A1>=50, "Pass", "Fail")
=IF(B1>1000, "High", IF(B1>500, "Medium", "Low")) ← Nested IF

Comparison Operators used in conditions:

Operator Meaning

= Equal to

<> Not equal to

> Greater than

< Less than

>= Greater than or equal to

<= Less than or equal to

■ Use AND() or OR() inside IF: =IF(AND(A1>0, B1>0), "Both positive", "No")

3.5 Text Functions

Function Syntax Description

LEN =LEN(A1) Number of characters in a cell

UPPER =UPPER(A1) Converts text to UPPERCASE

LOWER =LOWER(A1) Converts text to lowercase

PROPER =PROPER(A1) Capitalises Each Word

TRIM =TRIM(A1) Removes extra spaces

LEFT =LEFT(A1,3) First 3 characters from left

RIGHT =RIGHT(A1,4) Last 4 characters from right

MID =MID(A1,2,5) 5 chars starting at position 2

CONCATENATE =CONCATENATE(A1," ",B1) Joins text from multiple cells

Basic Excel Notes Page 8

Microsoft Excel — Beginner's Complete Course

Function Syntax Description

& (operator) =A1&" "&B1 Shortcut to join text (same as above)

FIND =FIND("@",A1) Position of @ character in A1

SUBSTITUTE =SUBSTITUTE(A1,"old","new") Replace text within a cell

3.6 Date & Time Functions

Function Syntax Description

TODAY() =TODAY() Returns today's date

NOW() =NOW() Returns current date and time

DAY() =DAY(A1) Extracts the day number from a date

MONTH() =MONTH(A1) Extracts the month number

YEAR() =YEAR(A1) Extracts the year

DATE() =DATE(2026,5,11) Creates a date from year/month/day

DATEDIF() =DATEDIF(A1,TODAY(),"Y") Years between two dates

WEEKDAY() =WEEKDAY(A1,2) Day of week (1=Mon if type=2)

NETWORKDAYS() =NETWORKDAYS(A1,B1) Working days between two dates

■ Dates in Excel are stored as numbers (1 = Jan 1, 1900). Format a number as Date to see it
correctly.

Basic Excel Notes Page 9

Microsoft Excel — Beginner's Complete Course

04 Charts & Data Visualization

4.1 Creating a Chart

Charts allow you to visualize data patterns and trends instantly.

Steps to Create a Chart:

• 1. Select your data range (including headers)
• 2. Go to Insert → Charts section
• 3. Choose a chart type (Column, Line, Pie, etc.)
• 4. A chart appears — drag it to position on your sheet
• 5. Use Chart Design and Format tabs to customize
■ Press F11 to instantly create a chart on a new sheet from selected data.

4.2 Chart Types

Chart Type Best For Example Use

Column Chart Compare values across categories Monthly Sales by Region

Bar Chart Horizontal version of column chart Product Rankings

Line Chart Show trends over time Stock prices over months

Pie Chart Show parts of a whole (use with few slices)

Market share %

Area Chart Like line chart, filled below the line Revenue over years

Scatter Plot Relationship between two numeric variables

Height vs Weight

Combo Chart Two chart types combined Revenue (bar) + Growth % (line)

4.3 Customizing Charts

Customization How To

Chart Title Click the title area to type a new name

Axis Titles Chart Design → Add Chart Element → Axis Titles

Data Labels Right-click a bar → Add Data Labels (shows value on bar)

Legend Chart Design → Add Chart Element → Legend

Chart Style Chart Design → Chart Styles (pre-built color themes)

Change Chart Type Right-click chart → Change Chart Type

Move Chart Chart Design → Move Chart (place on new sheet or existing)

Resize Drag the handles at the corners/edges of the chart

Basic Excel Notes Page 10

Microsoft Excel — Beginner's Complete Course

4.4 Sparklines
Sparklines are tiny charts inside a single cell, great for showing trends in a table.
• Select the output cell → Insert → Sparklines (Line / Column / Win/Loss)
• Select the data range for the sparkline
• Use the Sparkline tab to change color, style, or highlight max/min points
• Sparklines are compact and perfect for dashboards

Basic Excel Notes Page 11

Microsoft Excel — Beginner's Complete Course

05 Working with Data

5.1 Excel Tables

Converting a range to an Excel Table gives it powerful automatic features.
• Select your data → Insert → Table (or Ctrl + T)
• Tables automatically expand when you add new data
• Each column gets a filter dropdown automatically
• Table rows alternate in color automatically
• Formulas in a column auto-fill to new rows
• Use Table Design tab to rename the table and change style
■ Give your table a meaningful name (e.g. 'SalesData') in the Table Design tab for use in
formulas.

5.2 VLOOKUP
VLOOKUP (Vertical Lookup) searches for a value in the first column of a range and returns a
value from another column in the same row.
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
=VLOOKUP(A2, $E$2:$G$100, 2, FALSE)

Argument Description

lookup_value The value you are searching for (e.g., an ID or name)

table_array The range to search in (lock with $ for copying)

col_index_num Column number to return (1=first column in range)

range_lookup FALSE = exact match (recommended); TRUE = approximate match

■ VLOOKUP only looks to the RIGHT. For flexible lookups in any direction, use
INDEX+MATCH.

5.3 Introduction to Pivot Tables

Pivot Tables summarize large datasets with a few clicks — no formulas needed!

Creating a Pivot Table:

• 1. Click anywhere in your data
• 2. Go to Insert → PivotTable
• 3. Choose where to place it (New Worksheet recommended)
• 4. Drag fields into: Rows, Columns, Values, Filters
• 5. Values field calculates automatically (Sum, Count, Average, etc.)

Basic Excel Notes Page 12

Microsoft Excel — Beginner's Complete Course

Area Purpose

Rows Categories shown on the left side (e.g., Product, Region)

Columns Categories across the top

Values What gets calculated (e.g., Sum of Sales)

Filters Slice the entire pivot table by a field (e.g., Year)

■ Right-click a Pivot Table → Refresh to update after your source data changes.

5.4 Data Validation

Data Validation restricts what users can enter into a cell.
Go to Data → Data Validation.

Validation Type Description

Whole Number Only integers within a range (e.g., 1–100)

Decimal Numbers with decimal places

List A dropdown list of allowed values

Date Only dates within a range

Text Length Limit the number of characters

Custom Use a formula to define allowed values

■ Use a List validation to create dropdown menus — great for forms!

5.5 Paste Special

Paste Special (Ctrl + Alt + V) gives you control over exactly what gets pasted.

Paste Option Description

Values Paste only the calculated result, not the formula

Formats Paste only the formatting (colors, fonts)

Formulas Paste only the formulas

Transpose Swap rows and columns when pasting

Add/Subtract Mathematically add or subtract the copied value from destination

Column Widths Copy the column widths from source to destination

Basic Excel Notes Page 13

Microsoft Excel — Beginner's Complete Course

06 Tips, Shortcuts & Best Practices

6.1 Essential Keyboard Shortcuts

Shortcut Action

Ctrl + C / X / V Copy / Cut / Paste

Ctrl + Z / Y Undo / Redo

Ctrl + S Save

Ctrl + P Print

Ctrl + F Find

Ctrl + H Find & Replace

Ctrl + A Select All

Ctrl + B / I / U Bold / Italic / Underline

Ctrl + 1 Open Format Cells dialog

Ctrl + T Create Table

Ctrl + Shift + L Toggle AutoFilter

Alt + = AutoSum selected range

F2 Edit the active cell

F4 Toggle absolute/relative reference in formula

F11 Create chart on new sheet

Delete Clear cell contents

Ctrl + D Fill Down (copy formula/value from cell above)

Ctrl + R Fill Right (copy formula/value from cell to left)

Shift + Space Select entire row

Ctrl + Space Select entire column

Ctrl + + Insert row/column

Ctrl + - Delete row/column

Ctrl + Page Up/Down Switch between worksheets

6.2 Common Errors & How to Fix Them

Basic Excel Notes Page 14

Microsoft Excel — Beginner's Complete Course

Error Cause Fix

#DIV/0! Division by zero Check if divisor cell is empty or 0. Use =IF(B1=0,0,A1/B1)

#VALUE! Wrong data type Check that you're not mixing text with numbers in formula

#REF! Invalid cell reference A cell referenced in formula was deleted. Re-enter formula

#NAME? Unrecognised formula name Check for typos in function name. Ensure no spaces after =

#N/A Value not found In VLOOKUP — the lookup value doesn't exist in the table

#NULL! Incorrect range operator Use a colon (:) not a space between range references

#NUM! Invalid numeric value Formula result is too large/small or argument is invalid

######## Column too narrow Double-click the column border to auto-fit width

6.3 Productivity Tips

• Use Flash Fill (Ctrl+E) to auto-complete patterns — e.g., splitting first/last names.
• Use Freeze Panes (View → Freeze Panes) to keep headers visible while scrolling.
• Use Named Ranges (Formulas → Define Name) to make formulas easier to read.
• Double-click the Format Painter brush to apply formatting to multiple cells.
• Hold Ctrl while clicking to select multiple non-adjacent cells.
• Right-click a column/row header and choose Hide to hide it from view.
• Use Ctrl + ` (backtick) to toggle between showing formulas and values.
• Add a comment to a cell via Review → New Comment to document your work.
• Use View → New Window to view two parts of the same sheet simultaneously.
• Press Alt + Enter inside a cell to add a new line within the same cell.

6.4 Best Practices

• Always use headers — label every column clearly
• Keep one type of data per column — don't mix dates and text
• Avoid merged cells in data ranges — they break sorting and filters
• Use tables for structured data — they auto-expand and handle ranges
• Don't use spaces in sheet names — use underscores or CamelCase
• Backup your files — save copies, use version names (v1, v2)
• Document your work — use comments and a 'Notes' sheet
• Use absolute references for values that shouldn't change when copying formulas

6.5 Practice Exercises

Exercise Task Description

Exercise 1 Create a student marks sheet with Name, 5 subjects, Total, Average, and Grade (IF formula)

Exercise 2 Build a monthly budget tracker with Income, Expenses, and Balance with conditional formatting

Exercise 3 Make a product inventory list and use VLOOKUP to fetch the price when entering a product code

Basic Excel Notes Page 15

Microsoft Excel — Beginner's Complete Course

Exercise Task Description

Exercise 4 Import a sales dataset and create a Pivot Table summarising sales by Region and Month

Exercise 5 Create a chart showing monthly sales for the year with a formatted title and data labels

■ Congratulations! You now have a solid foundation in Microsoft Excel.

Keep practising by applying these skills to real-world tasks. Explore advanced topics like
Power Query, XLOOKUP, and Macros as your next steps.

Basic Excel Notes Page 16