Microsoft Excel is a powerful tool for anyone who works with data, from students learning Excel basics to analysts doing complex data analysis in Excel windows. This Excel cheat sheet is built for speed. It gives you a quick overview of the most-used commands, common Excel functions, core formulas, and keyboard shortcuts, so you can focus on accurate results instead of hunting through every menu and tab on the ribbon.
We start with basic terminology, then move into data types, formulas, shortcuts, commands, and graphs. If you want deeper step-by-step walkthroughs, see these Excel guides and tutorials. If you need Excel, you can get it from Microsoft.
Download Excel Cheat Sheet
Want a printable version. Use the download button below for the PDF, or bookmark this page and use the table of contents to jump to what you need.
Download the Excel Cheat Sheet (PDF)
If you do not have a PDF yet, publish this page first, then export it to PDF and swap in the final link.
Quick Start, Most-Used Excel Cheat Sheet
If you only learn a few things first, make it these. They cover most daily work, including sales data summaries, quick calculations, and basic cleanup.
Top functions most people use weekly
- SUM, SUMIFS for totals and conditional totals
- IF, IFERROR for logic and error handling
- XLOOKUP for modern lookups (often preferred over VLOOKUP)
- COUNTIF, COUNTIFS for conditional counts
- TEXT, LEFT, RIGHT, MID for formatting and parsing
- DATE, TODAY, NOW for time-based work
Top shortcuts that save time immediately
- F2 edit the active cell, your cursor jumps into the formula bar
- Ctrl + F find, Ctrl + H replace
- Ctrl + Arrow jump to edge of data, Ctrl + Shift + Arrow select a block
- Ctrl + 1 format cells
- Alt + = AutoSum
- Ctrl + T convert a cell range into an Excel Table
Ribbon tip: if you prefer the keyboard, press Alt to show KeyTips for the ribbon menu, then follow the on-screen letters to trigger commands without the mouse.
Basic Terminology
Review your basic vocabulary before looking at functions and commands. Excel feels easier once you understand how it references a cell range using a column letter and a row number, like A1.
| Term | Definition |
|---|---|
| Active Cell | The currently selected cell in the worksheet. This is where your cursor is active. |
| Cell | An individual box in the worksheet that can contain data, text, or a formula. |
| First Cell | The cell in the top-left corner of a selection. For many tasks, you start by clicking the first cell, then selecting the full range. |
| Column | A vertical group of cells. Columns are identified by a column letter (A, B, C, etc.). |
| Row | A horizontal group of cells. Rows are identified by a row number (1, 2, 3, etc.). |
| Cell References | How Excel points to cells in formulas, like A1 or B2. References can be relative, absolute ($A$1), or mixed. |
| Cell Range | A block of cells referenced together, like A1:A10. Many functions perform calculations over a cell range. |
| Formula | A set of instructions that performs calculations on values in the worksheet. Formulas usually start with an equals sign. |
| Function | A predefined formula used to perform standard calculations, like summing a range of values. |
| Worksheet | Also called a spreadsheet, the grid of columns and rows inside a workbook. Each worksheet is a tab. |
| Workbook | The Excel file that holds one or more worksheets. |
The Anatomy of an Excel Sheet
This diagram labels the major parts of a worksheet, including rows, columns, and where key menu and ribbon options live.
Excel Data Types
Excel stores data in several types. Correct data types are the foundation of accurate results, especially when your workbook combines sales data, dates, and imported text.
| Type | What it means |
|---|---|
| Text | Labels and descriptive values. Example: Hello, World! |
| Numbers | Used for calculations and can be formatted as currency, percentages, decimals, and commas for thousands. Example: 1.12 |
| Dates/Times | Track and calculate data over time. Example: 2022-02-02 |
| Logical Values | TRUE or FALSE results used in conditions. |
| Dynamic Arrays | Modern Excel can return results that spill into multiple cells. Example: FILTER(A2:C100, C2:C100="Yes") |
Excel Functions Cheat Sheet
In Excel, a function is a preset formula. They help parse information, run calculations, and summarize data points. Below are some common Excel functions with examples using a range of cells.
| Function | What it does |
|---|---|
| SUM | Adds values in a cell range. Example: SUM(A1:A4) |
| SUMIFS | Sums values that meet criteria. Example: SUMIFS(A1:A4, B1:B4, E1) |
| AVERAGE | Calculates the average of a range. Example: AVERAGE(A1:A4) |
| COUNT | Counts numeric cells in a range. Example: COUNT(A1:A4) |
| MIN | Finds the smallest value in a range. Example: MIN(A1:A4) |
| MAX | Finds the largest value in a range. Example: MAX(A1:A4) |
| TRIM | Removes extra spaces from text. Example: TRIM(A1) |
| IF | Returns one value if a condition is true and another if false. Example: IF(A1="Yes", TRUE, FALSE) |
| CONCATENATE | Combines values into a single cell. Example: CONCATENATE(A1, B1) |
| VALUE | Converts a text number into a number. Example: VALUE(B1) |
| PROPER | Capitalizes words correctly. Example: PROPER(A1) |
| CEILING | Rounds up to a multiple. Example: CEILING(A1, 4) |
| FLOOR | Rounds down to a multiple. Example: FLOOR(A1, 4) |
| LEN | Counts characters in text. Example: LEN(A1) |
| NOW | Returns the current date and time. Example: NOW() |
| TODAY | Returns the current date. Example: TODAY() |
Advanced Excel Functions
These functions are common in reporting and complex data analysis. If you are maintaining a workbook for a team, they help keep results accurate while reducing manual work.
| Function | What it does |
|---|---|
| XLOOKUP | Modern lookup that can return matches from any column. Example: XLOOKUP(E1, A1:A100, C1:C100) |
| VLOOKUP | Looks up a value in the leftmost column and returns from another column. Example: VLOOKUP("Text", A1:C4, 2, FALSE) |
| INDEX | Returns a value at a row and column position. Example: INDEX(A1:C4, 1, 3) |
| MATCH | Returns position of a value in a range. Example: MATCH(E1, A1:A100, 0) |
| FILTER | Returns matching rows that spill into cells. Example: FILTER(A2:C100, C2:C100="Yes") |
| LET | Names calculation parts inside a formula for readability. Example: LET(x, A1*B1, x/12) |
Excel Shortcuts
Shortcuts increase productivity. In Excel windows, you can do most navigation without the mouse once you learn a few core keys.
| Shortcut | Action |
|---|---|
| F2 | Edit the active cell. |
| F5 | Go to a specific cell. |
| Ctrl + Arrow | Move to the edge of the worksheet’s data. |
| Shift + F11 | Insert a new sheet tab. |
| Alt + = | AutoSum the selected cells. |
| Ctrl + Shift + “+” | Insert a new row or column. |
| Ctrl + “-” | Delete a row or column. |
| Ctrl + “*” | Select all cells with formulas. |
| Ctrl + ’ | Copy the value from the cell above. |
| Alt + Enter | Insert a line break inside a cell. |
Excel Commands and Ribbon Menu
Excel commands can be triggered from the ribbon, the right-click menu, or keyboard shortcuts. If you are learning Excel basics, it helps to know where common tools live by tab, especially on the Home tab and Data tab.
| Command | What it does |
|---|---|
| Paste Special | Choose how to paste data, values, formulas, or formats. |
| Format Painter | Copy formatting from one cell and apply it to another cell range. |
| Fill Handle | Fill a cell range with a pattern, dates, or a series. |
| AutoSum | Automatically calculates the sum of selected cells. |
| Sparklines | Small charts inside a single cell for quick trends. |
| Freeze Panes | Keeps row number and column letter headers visible while scrolling. |
| Flash Fill | Detects a pattern and fills values without formulas. |
Data Cleaning and Prep
Most spreadsheet mistakes come from messy inputs. Before you run formulas, make sure your data types are correct, your cell references point to the intended cell range, and your column headers are consistent. If you import sales data, check commas and currency formats so totals and averages stay accurate.
- Flash Fill: useful when you need to split or reformat text quickly without building formulas.
- TRIM and CLEAN: remove extra spaces and non-printing characters that break matching.
- Text to Columns: split combined values into separate columns using a delimiter.
- Remove Duplicates: remove repeated rows after confirming which columns define uniqueness.
- Data bars: a quick conditional formatting option to compare data points at a glance.
- Data tab: where you will find Sort, Filter, Remove Duplicates, and Refresh commands.
Excel Graphs and Charts
Not everything is readable in a grid. When you need something human-readable, build graphs and charts. Excel offers many chart types to compare data points and show trends.
| Chart | Best for |
|---|---|
| Column Charts | Compare data points side-by-side. |
| Bar Charts | Compare categories, often easier for long labels. |
| Line Charts | Show trends over time. |
| Pie Charts | Show proportions, best with few categories. |
| Scatter Plots | Show relationships between two numeric variables. |
Tips and Tricks
Here are a few practical habits that make Excel faster and more reliable.
- Learn keyboard shortcuts. Ctrl+C copies selected cells, Ctrl+V pastes, Ctrl+F finds, and Ctrl+H replaces.
- Use the fill handle for patterns and series. For repeated cleanup tasks, Flash Fill can be faster than formulas.
- Use conditional formatting such as data bars to spot outliers in large tables.
- Use data validation to enforce correct data types and prevent mistakes.
- Convert raw ranges into Excel Tables so formulas, charts, and PivotTables expand automatically as your data grows.
- Freeze panes so column letter and row number headers stay visible while you scroll.
- Consider Excel macros for repeatable tasks. If you go this route, you may encounter Visual Basic and the macro editor.
- Get comfortable with PivotTables and filters to summarize sales data quickly without rebuilding formulas.
Conclusion
An Excel cheat sheet can only do so much. It gives you a quick alternative to building everything from scratch, and it helps users get started quickly. However, all spreadsheet users should learn Excel basics, including how cell references work and how a cell range is defined. Once you understand the capabilities, you should be able to look up what you need using this cheat sheet and then apply it correctly in your own workbook.
Frequently Asked Questions
How do you use the cheat sheet in Excel?
Use this page when you need something specific, like a shortcut, a function name, or a reminder of where a command lives on the ribbon menu. You can also use Ctrl+F to search the page for a specific function, like XLOOKUP or SUMIFS.
What are five functions in Excel I should learn first?
Start with SUM, IF, XLOOKUP, COUNTIF, and SUMIFS. These cover basic totals, logic, lookups, counting, and conditional calculations, which are common across finance and data analytics workflows.
What is the fastest way to learn Excel formulas?
Start by learning how Excel reads cell references like A1, then practice typing formulas into a single cell, checking results, and copying down. When you type “=”, Excel shows suggestions. Choose a function, fill in arguments using your cursor to select the intended cell range, then press Enter.
What are seven basic Excel formulas?
A common starter set is SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, and IF. Add XLOOKUP early if you work with tables and matching.
Where do you get Excel?
You can buy a copy of Excel from Microsoft as a stand-alone product or get it as part of the Microsoft 365 suite. Google Sheets is a free alternative, but Excel is still widely used in professional reporting.
