Excel cheat sheet for beginners with formulas, tables, charts, filters, and spreadsheet basics

Excel Cheat Sheet

by
MICROSOFT EXCEL

This Excel cheat sheet for beginners helps you understand the essential formulas, functions, shortcuts, and spreadsheet tools needed for everyday tasks. Use it to learn cell references, calculations, formatting, tables, charts, sorting, filtering, and basic data organization.

The examples are designed for students, office users, small-business owners, and anyone learning Microsoft Excel for the first time. Begin with workbook navigation and simple formulas, then progress to functions, data tools, and practical productivity techniques.

How to Use This Excel Cheat Sheet for Beginners

Keep this reference open while practicing in a separate workbook. Find the formula, shortcut, or feature you need, reproduce the example with a small dataset, and confirm the result before applying it to important information.

Pay close attention to cell references, parentheses, quotation marks, and range notation. Save your workbook regularly and work on a backup copy when experimenting with sorting, filtering, formulas, or large data ranges.

What’s Included

  • ✓ Excel interface and basic terminology
  • ✓ Essential keyboard shortcuts
  • ✓ Beginner formulas and functions
  • ✓ SUMIF, COUNTIF and logical formulas
  • ✓ Text and data cleaning functions
  • ✓ Downloadable PDF reference
FREE DOWNLOAD

Download the Excel Cheat Sheet PDF

Get a printable version of this Excel Cheat Sheet for offline reference. Perfect for studying, work, or keeping as a quick desktop reference.

📄 Download Free PDF

QUICK REFERENCE

Excel Quick Reference

Quickly jump to the Excel topic you need. This section provides fast access to the most commonly used formulas, shortcuts, and spreadsheet features.

PAGE NAVIGATION

Table of Contents

Jump directly to the Excel formulas, shortcuts, and spreadsheet features you need.

FOUNDATIONS

Basic Terms

Before using formulas and functions, it’s helpful to understand the basic building blocks of an Excel worksheet.

Term Description Example
Workbook An Excel file that contains one or more worksheets. SalesReport.xlsx
Worksheet A single spreadsheet inside a workbook. January Sales
Cell A single box where a row and column intersect. B4
Range A group of selected cells. A1:D20
Row A horizontal line of cells. Row 12
Column A vertical line of cells. Column C
Formula An expression that performs a calculation. =SUM(A1:A10)
Formula Bar Displays and edits the active cell’s contents. =AVERAGE(B2:B12)
Pro Tip: Every cell reference combines a column letter and a row number. For example, C7 means column C, row 7.
FOUNDATIONS

Keyboard Shortcuts

These are the Excel shortcuts you’ll use most often when navigating, editing, and formatting spreadsheets.

Action Windows Mac
Copy Ctrl + C ⌘ + C
Paste Ctrl + V ⌘ + V
Cut Ctrl + X ⌘ + X
Undo Ctrl + Z ⌘ + Z
Redo Ctrl + Y ⌘ + Shift + Z
Save Workbook Ctrl + S ⌘ + S
Find Ctrl + F ⌘ + F
Bold Ctrl + B ⌘ + B
Edit Active Cell F2 Ctrl + U
Insert Current Date Ctrl + ; Control + ;
Insert Current Time Ctrl + Shift + ; Command + ;
AutoSum Alt + = ⌘ + Shift + T
Pro Tip: Learn the shortcuts for Copy, Paste, Undo, Find, and AutoSum first. They save the most time during everyday Excel work.
FOUNDATIONS

Basic Formulas

Every Excel formula begins with an equals sign (=). These core functions cover the most common everyday calculations.

Function Purpose Example
SUM Adds all numbers in a range. =SUM(B2:B10)
AVERAGE Calculates the arithmetic mean. =AVERAGE(B2:B10)
COUNT Counts cells containing numbers. =COUNT(B2:B10)
COUNTA Counts all non-empty cells. =COUNTA(B2:B10)
MAX Returns the highest value. =MAX(B2:B10)
MIN Returns the lowest value. =MIN(B2:B10)
Pro Tip: Use a colon to define a continuous range. For example, B2:B10 includes every cell from B2 through B10.
Remember: If you omit the equals sign, Excel treats the formula as ordinary text instead of calculating a result.
FOUNDATIONS

Golden Rules

Follow these simple best practices to build cleaner, more reliable, and easier-to-maintain spreadsheets.

Rule Why It Matters
Always start formulas with = Without it, Excel treats the entry as plain text.
Keep one type of data per column Makes sorting, filtering, and formulas more reliable.
Use cell references instead of hard-coded values Your formulas update automatically when data changes.
Format data consistently Dates, currency, and percentages become easier to read.
Save your workbook frequently Reduces the risk of losing important work.
Use Excel Tables for larger datasets Tables expand automatically and simplify formulas.
Pro Tip: Keep your raw data on one worksheet and your reports or charts on another. This makes large workbooks easier to manage.
FUNCTIONS

Logical Functions

Logical functions evaluate conditions, compare values, and perform calculations only when specific criteria are met.

Function Purpose Example
IF Returns one value if a condition is TRUE, another if FALSE. =IF(A2>=50,"Pass","Fail")
IFS Tests multiple conditions without nested IF statements. =IFS(A2>=90,"A",A2>=80,"B")
AND Returns TRUE only if every condition is TRUE. =AND(A2>0,B2<100)
OR Returns TRUE if at least one condition is TRUE. =OR(A2>90,B2>90)
NOT Reverses a logical result. =NOT(A2>100)
SUMIF Adds values that match a condition. =SUMIF(A:A,"North",B:B)
COUNTIF Counts cells matching a condition. =COUNTIF(A:A,"Completed")
Pro Tip: Combine IF with AND or OR to build more powerful conditional formulas without creating multiple nested statements.
FUNCTIONS

Text Functions

Text functions help you extract, combine, clean, and reformat text stored in spreadsheet cells.

Function Purpose Example
LEFT Returns characters from the beginning of text. =LEFT(A2,3)
RIGHT Returns characters from the end of text. =RIGHT(A2,4)
MID Returns characters from a specified position. =MID(A2,3,5)
LEN Counts the number of characters. =LEN(A2)
TRIM Removes extra spaces from text. =TRIM(A2)
UPPER Converts text to uppercase. =UPPER(A2)
LOWER Converts text to lowercase. =LOWER(A2)
PROPER Capitalizes the first letter of each word. =PROPER(A2)
CONCAT Combines text from multiple values. =CONCAT(A2," ",B2)
TEXTJOIN Combines values using a chosen separator. =TEXTJOIN(", ",TRUE,A2:A5)
SUBSTITUTE Replaces matching text with new text. =SUBSTITUTE(A2,"old","new")
TEXT Formats a number or date as text. =TEXT(A2,"$0.00")
Pro Tip: Use TRIM before lookup formulas when imported data contains hidden spaces. Extra spaces can prevent otherwise correct lookups from finding a match.
FUNCTIONS

Date Functions

Date functions help you insert today's date, calculate time differences, and manipulate dates within Excel formulas.

Function Purpose Example
TODAY() Returns today's current date. =TODAY()
NOW() Returns the current date and time. =NOW()
DATE() Creates a valid date from year, month and day. =DATE(2026,7,20)
YEAR() Extracts the year from a date. =YEAR(A2)
MONTH() Extracts the month number. =MONTH(A2)
DAY() Extracts the day of the month. =DAY(A2)
DATEDIF() Calculates the difference between two dates. =DATEDIF(A2,B2,"d")
EDATE() Adds or subtracts months from a date. =EDATE(A2,6)
EOMONTH() Returns the last day of a month. =EOMONTH(A2,0)
Pro Tip: Store dates as real Excel dates instead of text. Real dates can be sorted, filtered, formatted, and used in calculations without errors.
FUNCTIONS

Lookup Functions

Lookup functions search tables and return matching values. XLOOKUP is the modern Excel standard, while VLOOKUP and INDEX/MATCH remain common in existing spreadsheets.

Function Best Used For Example
XLOOKUP ⭐ Modern replacement for VLOOKUP. =XLOOKUP(E2,A2:A20,B2:B20)
VLOOKUP Vertical table lookups. =VLOOKUP(E2,A2:C20,2,FALSE)
HLOOKUP Horizontal table lookups. =HLOOKUP(B1,A1:H5,3,FALSE)
INDEX Returns a value by row and column. =INDEX(B2:B20,5)
MATCH Returns the position of a value. =MATCH(E2,A2:A20,0)
INDEX + MATCH Flexible alternative to VLOOKUP. =INDEX(B2:B20,MATCH(E2,A2:A20,0))
Pro Tip: If you're using Microsoft 365 or Excel 2021+, choose XLOOKUP() whenever possible. It is easier to read, more flexible, and removes many of VLOOKUP's limitations.
Remember: Use an exact match whenever you are looking up IDs, names, or product codes. Approximate matching can return unexpected results.
DATA ANALYSIS

Excel Tables

Excel Tables automatically organize your data, making it easier to sort, filter, format, and build formulas that expand as new rows are added.

Feature Benefit
Automatic Formatting Applies a consistent professional table style.
Built-in Filters Sort and filter data instantly.
Structured References Use column names instead of cell ranges in formulas.
Auto Expansion Tables automatically grow when new rows are added.
Total Row Quickly calculate sums, averages, counts and more.
Shortcut 
Ctrl + T
Shortcut: Select your data and press Ctrl + T to convert it into an Excel Table.
Pro Tip: Whenever possible, store your data in an Excel Table instead of a normal range. Most modern Excel features work better with tables.
DATA ANALYSIS

Charts

Choose a chart based on the story your data needs to tell. The right chart makes comparisons, trends, and relationships easier to understand.

Chart Best For Avoid When
Column Comparing values across categories. There are too many categories.
Bar Rankings and long category labels. Showing continuous time trends.
Line Showing changes and trends over time. The categories have no time order.
Pie Showing simple parts of one whole. There are many slices or similar values.
Scatter Showing relationships between two numeric variables. Comparing ordinary categories.
Area Showing totals or magnitude over time. Overlapping series become difficult to read.
Recommended Charts Shortcut 
Alt + F1
Shortcut: Select your data and press Alt + F1 to insert an embedded chart using Excel's default chart type.
Pro Tip: Use column or bar charts for comparisons and line charts for time-based trends. Avoid 3D effects because they can make values harder to compare.
DATA ANALYSIS

Pivot Tables

Pivot Tables summarize large datasets in seconds, allowing you to group, filter, calculate, and analyze information without writing complex formulas.

Feature Purpose
Rows Groups records into categories.
Columns Creates side-by-side comparisons.
Values Calculates totals, averages, counts and more.
Filters Shows only the data you want to analyze.
Slicers Adds clickable filters for interactive reports.
Refresh Updates the Pivot Table after source data changes.
Insert Pivot Table 
Alt, N, V
Shortcut: Press Alt, then N, then V to quickly open the Pivot Table dialog in Excel.
Pro Tip: Convert your source data into an Excel Table (Ctrl + T) before creating a Pivot Table. This allows new rows to be included automatically after refreshing.
PRODUCTIVITY

Conditional Formatting

Conditional Formatting changes a cell's appearance automatically when its value matches a rule, making patterns and important results easier to spot.

Rule Type Best Used For
Highlight Cells Finding values above, below, equal to, or containing specific text.
Top / Bottom Rules Highlighting highest, lowest, or above-average results.
Data Bars Comparing numeric values directly inside cells.
Color Scales Creating heatmap-style comparisons across a range.
Icon Sets Displaying KPI symbols such as arrows, flags, or traffic lights.
Duplicate Values Finding repeated entries in lists or datasets.
Formula Rule Applying custom formatting based on a formula.
Example Formula Rule 
=$B2>1000
Example: Apply the formula to a selected range to highlight rows where the value in column B is greater than 1000.
Pro Tip: Use formatting to emphasize exceptions and trends, not every cell. Too many colors or icons can make a spreadsheet harder to read.
PRODUCTIVITY

Data Validation

Data Validation controls what users can enter into a cell, helping prevent errors and keep spreadsheet data consistent.

Validation Type Best Used For
List Creating drop-down menus with approved choices.
Whole Number Allowing only integers within a specified range.
Decimal Restricting entries to valid decimal values.
Date Allowing dates within a defined period.
Time Restricting entries to valid times.
Text Length Limiting the number of characters entered.
Custom Formula Creating advanced rules based on a formula.
Custom Validation Formula 
=COUNTIF($A$2:$A$100,A2)=1
Example: Use this custom formula on cells A2:A100 to prevent duplicate values from being entered.
Pro Tip: Add an input message to explain what users should enter and an error alert to clearly describe why an invalid value was rejected.
PRODUCTIVITY

Best Practices

Use these habits to keep Excel workbooks accurate, readable, and easier to maintain.

Practice Why It Helps
Use clear headers Makes sorting, filtering, formulas, and Pivot Tables easier.
Keep one record per row Creates a clean dataset that Excel can analyze correctly.
Avoid merged cells in data Prevents problems with sorting, filtering, and copying ranges.
Use Excel Tables Automatically expands ranges and keeps formulas consistent.
Separate inputs and calculations Makes formulas easier to audit and reduces accidental changes.
Use consistent formats Keeps dates, percentages, and currencies easy to interpret.
Document complex formulas Helps other users understand and maintain the workbook.
Keep backup versions Allows recovery after accidental edits or formula errors.
Avoid: Do not place totals, blank rows, notes, or unrelated tables inside the middle of a dataset. Keep each data table continuous and structured.
Pro Tip: Use descriptive worksheet names such as Raw Data, Calculations, and Dashboard instead of generic names like Sheet1.

Excel Cheat Sheet for Beginners Resources

Use these official Microsoft resources to learn spreadsheet fundamentals, verify formulas, and continue practicing:

RESOURCES

Frequently Asked Questions

Quick answers to some of the most common questions about Microsoft Excel, formulas, functions, and spreadsheets.

What is Microsoft Excel used for?

Microsoft Excel is a spreadsheet application used to organize, calculate, analyze, and visualize data. It's widely used for budgeting, reporting, data analysis, financial modeling, and business dashboards.

What is the difference between a workbook and a worksheet?

A workbook is the entire Excel file, while a worksheet is a single spreadsheet (tab) inside that workbook.

What is the most useful Excel formula?

There isn't one single best formula, but SUM(), IF(), XLOOKUP(), COUNTIF(), and AVERAGE() are among the most commonly used in everyday spreadsheets.

Should I use XLOOKUP or VLOOKUP?

If your version of Excel supports XLOOKUP, it's usually the better choice. It is easier to read, more flexible, and removes many of the limitations found in VLOOKUP.

What is an Excel Table?

An Excel Table is a structured range that automatically expands as new rows are added. It also provides filtering, structured references, and built-in formatting.

What are Pivot Tables used for?

Pivot Tables summarize large datasets by grouping, filtering, and calculating totals, averages, counts, and other statistics without requiring complex formulas.

How do I prevent users from entering incorrect data?

Use Data Validation to restrict allowed values, create drop-down lists, or apply custom validation rules.

Can I download this Excel Cheat Sheet as a PDF?

Yes. Use the Download PDF section on this page to access a printable version for offline reference.