This Excel cheat sheet for beginners explains the essential spreadsheet skills needed for everyday work. Learn how workbooks, worksheets, cells, and ranges work, then practice entering, formatting, organizing, sorting, and filtering data.
The guide is designed for students, office users, small-business owners, and anyone learning Microsoft Excel for the first time. It includes a focused set of beginner formulas, essential keyboard shortcuts, Excel Tables, simple charts, and practical habits that help prevent common spreadsheet mistakes.
How to Use This Excel Cheat Sheet for Beginners
Keep this reference open while practicing in a separate workbook. Begin with Excel terminology and basic navigation, then work through data entry, formatting, formulas, tables, and charts in order.
Recreate each example with a small practice dataset before using it in an important workbook. Check cell references, number formats, headings, and ranges carefully, and save your work regularly as you learn.
What You’ll Learn
- ✓ Workbook, worksheet, cell, and range basics
- ✓ Entering, editing, sorting, and filtering data
- ✓ Simple formatting and Excel Tables
- ✓ Essential shortcuts and beginner formulas
- ✓ Basic charts and data-quality tools
- ✓ Common mistakes and practical workflows
Table of Contents
Jump directly to the Excel formulas, shortcuts, and spreadsheet features you need.
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) |
C7 means column C,
row 7.
Essential Excel Keyboard Shortcuts
Start with these six shortcuts for everyday navigation, editing, and calculations in Excel.
| Action | Windows | Mac |
|---|---|---|
| Copy | Ctrl + C |
⌘ + C |
| Paste | Ctrl + V |
⌘ + V |
| Undo | Ctrl + Z |
⌘ + Z |
| Save Workbook | Ctrl + S |
⌘ + S |
| Find | Ctrl + F |
⌘ + F |
| AutoSum | Alt + = |
⌘ + Shift + T |
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) |
B2:B10 includes every cell from B2 through
B10. For a complete formula reference with worked examples,
see our Excel Formulas Cheat Sheet.
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. |
Basic Logical Functions
These three beginner-friendly functions help you test conditions, add matching values, and count matching cells.
| Function | Purpose | Example |
|---|---|---|
IF |
Returns one value if a condition is TRUE and another if it is FALSE. | =IF(A2>=50,"Pass","Fail") |
SUMIF |
Adds values that match one condition. | =SUMIF(A:A,"North",B:B) |
COUNTIF |
Counts cells that match one condition. | =COUNTIF(A:A,"Completed") |
IFS,
AND, OR, and NOT, see the
Excel Formulas Cheat Sheet
.
Clean Imported Text
Imported text often contains extra spaces that can interfere with sorting, filtering, and matching values.
=TRIM(A2) to remove extra spaces from the value in
cell A2 before working with the data.
For text extraction, case changes, joining, replacements, and formatting, see the Excel Formulas Cheat Sheet .
Dates & Formatting
Excel can sort, filter, format, and calculate with dates when they are stored as real date values instead of ordinary text.
| Task | Beginner Approach |
|---|---|
| Enter dates | Use a date format recognized by your Excel language and regional settings. |
| Format dates | Choose Short Date, Long Date, or another Date format from the Number Format menu. |
| Sort and filter | Keep dates in one column with a clear heading, then use the Data tab to sort or filter. |
| Check text dates | If sorting is incorrect or date formatting has no effect, the values may be stored as text. |
TODAY, NOW,
DATE, YEAR, DATEDIF,
EDATE, and related functions, see the
Excel Formulas Cheat Sheet
.
Understanding Lookups
A lookup searches for a known value, finds the matching row in a table, and returns related information from that row.
| Step | What Happens |
|---|---|
| Choose a lookup value | Start with an ID, product code, name, or another value you already know. |
| Find the matching row | Excel searches the lookup table for the same value. |
| Return a related value | Excel returns information such as a price, status, category, or email address. |
XLOOKUP, VLOOKUP, INDEX,
MATCH, and worked examples, see the
Excel Formulas Cheat Sheet
.
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. |
Ctrl + TCtrl + T to convert it into an Excel Table.
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. |
Alt + F1Alt + F1 to insert an embedded
chart using Excel’s default chart type.
PivotTable Basics
A PivotTable summarizes a dataset without changing the original rows. Use it to group categories and calculate totals, averages, or counts.
| Step | What to Do |
|---|---|
| 1. Prepare the data | Use clear column headings, one row per record, and no completely blank columns. |
| 2. Insert a PivotTable | Select the dataset, choose Insert > PivotTable, and place the result on a new worksheet. |
| 3. Build the summary | Place a category field in Rows, a numeric field in Values, and refresh after source data changes. |
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. |
Continue learning: For formula-based rules, KPI logic, and advanced visual analysis, see the Advanced Excel Cheat Sheet .
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. |
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. |
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:
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.
FREE DOWNLOAD
Download the Excel Cheat Sheet PDF
Get the printable A4 version of this Excel cheat sheet for offline reference, studying, or keeping beside your computer.
- 7 printable A4 pages
- Formulas and practical examples
- No sign-up required