Looking for a comprehensive Excel cheat sheet? You’re in the right place. This guide covers 50+ essential formulas and shortcuts that will help you work faster and smarter in Microsoft Excel.

All Excel formulas start with an equals sign (=). From there, you can build everything from simple sums to complex financial calculations. This cheat sheet organizes the most important functions into categories: 

• Math
• Logic
• Lookup
• Date/time
• Financial
• New Microsoft 365 Functions

Whether you’re a beginner learning the basics or an experienced user looking for a quick reference, bookmark this page. And when you’re ready to go deeper, brush up on your skills with our Advanced Excel article.

Essential Excel keyboard shortcuts

Shortcuts save you time by eliminating the need to search through menus. Instead of manually copying and pasting, just press Ctrl+D. Once you memorize these, you’ll work noticeably faster.

Here are the most useful shortcuts organized by category:

Navigation shortcuts

The double-click trick is one most people don’t know: double-click the border of a cell to instantly jump to the last used cell in that column or row.

Data entry and editing shortcuts

Table Shortcuts

Basic Excel formulas everyone should know

These are the formulas you’ll use most often. Master these seven, and you can handle the majority of spreadsheet tasks.

The 7 basic Excel formulas:

• SUM — adds numbers together
• AVERAGE — calculates the mean of a range
• COUNT — counts cells containing numbers
• MIN — finds the smallest value
• MAX — finds the largest value
• IF — returns different values based on a condition
• VLOOKUP — searches for data in a table