How to Use Excel

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.

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:

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

There's no way to insert checkboxes in the web version of Excel. There is an easy way to do it with the desktop app. Just add the developer tab....
Excel has replaced the original tracking feature with co-authoring. This guide will show you exactly how to get the track changes in Excel feature back....
This guide will show you step-by-step with screenshots of how the consolidate feature works in Microsoft Excel....
Want to learn how to turn off scroll lock in Excel? Follow this simple guide to enable and disable the scroll lock feature in 2 minutes!...
A multiple project tracking template for Excel can make it much easier to manage your team's goals. Luckily, you can download two excellent ones here. ...

Video Guides on Excel

Popular Excel Guides

The guide will show you how to calculate year over year growth in Google Sheets and Excel and provide you with a template....
Using the VLOOKUP Excel function can save you a ton of time when searching your spreadsheets. Learn how to use it here....
In this article, you will learn how to lock cells in Excel worksheets through our comprehensive step-by-step guides. Click here to learn more....
There are a few different reasons why the file could be read-only. Luckily we cover how to remove read only from Excel in every way possible in this article....
Can Excel find circular reference errors without having to do any complex calculations? The short answer is yes. learn how here....
There are a few different ways you can combine rows in Excel. All of them are fairly easy, even for beginners. Learn them all here....
this guide will show you how to pull data from another sheet in Excel using cell references, menus, or LOOKUP formulas with screenshots and simple instructions....
Using does not equal in Excel is as simple as using the () operator. Check out our full guide with step-by-step instructions to see how powerful it can be. ...