Learn Excel
Our experts write step-by-step guides on functions, create spreadsheet templates, and offer guidance on data visualizations.ย
Here, you’ll find our most recent and most popular guides to Microsoft Excel. Looking for something specific? Use our search bar to find exactly what you’re looking for.
Excel Formulas
We love to break down Excel formulas. Whether you use Mac or PC, our guides always include a syntactical breakdown. That means you’ll see what a formula looks like, its arguments, and whether there’s anything optional to include.
Here’s an example of an Excel function from our IF CONTAINS guide:
=IF(test, if-true, if-false)
Our guide then breaks down each argument to show what it means. We also include screenshots and real-world examples. We also have popular guides for:
- The COUNTIF Excel Function
- Excel Keyboard Shortcuts
- The CHOOSE Function
- The Excel NOT Function
- And many others!
Excel Spreadsheet Templates
Our team regularly creates spreadsheet templates for Google Sheets. Many of these double as Excel workbooks. Just make a copy of our sheet, click File > Download, and choose the Excel option.ย
That means you’ll be able to work from one of our financial analysis templates (like budget templates) without having to start from scratch.
Data Visualization and Formatting
Of course, we also help with Excel’s robust formatting tools. That means we help you explore chart makers, modify existing Excel files, and hide or unhide data in your worksheet. Here are a few of our most popular formatting guides:
- How to Remove Dashes
- Creating Excel Dashboards
- Edit Table Formatting
- How to Swap Cells
- How to Find Duplicates
Advanced Tips for Excel
Microsoft’s spreadsheet powerhouse continues to adapt to changing times. Now, teams can use Excel to work anywhere.ย
Our free guides include advice and templates with key insights for all the latest features.
For example, we cover how to use Python in Excel. This connection enables much more complex functionality, regardless of the size of your data set.ย
Whether you need to modify a large dataset or just edit chart labels, our Excel advice shows exactly how to do it.ย
A Community of Experts
We have a thriving community on YouTube, and we regularly respond to reader comments. If you find any of our guides helpful, please share them with your team!
Find a Specific Guide
Recent Guides
The ABS function in Excel is a game-changer for anyone working with data, offering a simple way to focus on the magnitude of numbers without worrying about their direction. Whether…
This guide explains the =SWITCH() function in Excel. I share what it does and when it is most helpful. I’ll also share some practical examples of its use. The Excel…
I often use an Excel drop-down list In my line of work to improve the efficiency of my data entry tasks by limiting my choices. This saves me a lot…
Merging files in Excel is a pretty common need for many users and a challenging one at that. Luckily, Excel provides several features that allow you to merge Excel files,…
Video Guides on Excel
Popular Excel Guides
The ABS function in Excel is a game-changer for anyone working with data, offering a simple way to focus on the magnitude of numbers without worrying about their direction. Whether…
Essentially, to use HLOOKUP in Excel you just have to enter the function name, the lookup value, table array, row index, and range. Need a more detailed explanation? This guide…
To access Excel version history, you simply have to enable autosaves and decide the intervals. You can boil this down to the file path of File > Options > Save…
There are a few different ways you can remove blank rows in Excel. The simplest of which is to simply highlight the row headers that you wish to delete while…
Duplicates in your spreadsheet may be a minor inconvenience, but theyโre still frustrating to deal with. Most spreadsheet tools like Google Sheets donโt have a straightforward way of removing duplicates…
There are many reasons why you may need to compare Excel files, such as ensuring data integrity and consistency and data analysis. This can be quite difficult if you have…
Year over Year analysis provides valuable insights into the changes and trends in various metrics, such as revenue, sales, or profit, over a twelve-month period. Knowing how to calculate YoY…
If you’ve ever spent precious time manually searching through a sea of data to find a particular value, VLOOKUP could save you a ton of time. With VLOOKUP as your…