Popular Excel Guides
When working with large datasets or organizing information in a structured manner, you may encounter a scenario where you would like to insert multiple rows to accommodate new data or…
Using a table in Excel offers a powerful and structured way to organize and analyze data. It is a collection of related data organized in rows and columns, with several…
Excel dashboards are a great way to present vital data at a glance while offering incredible technology and user interactivity. This Excel dashboard tutorial will show you the step-by-step process…
Randomizing data is essential for specific calculations in spreadsheets. But, it can be tricky for some newer users to figure out how to randomize a list in Excel. Luckily, this…
The quickest way to learn how to collapse rows in Excel is to use the context menu by selecting the rows you want to hide and clicking “Hide.” Read on…
Strikethrough in Excel is pretty easy to do. The simplest way is to highlight the text that you want to add strikethrough formatting to and use the keyboard shortcut Ctrl…
Excel’s dark theme has been popular since it was introduced in Office 2013. With our guide, you’ll discover everything you need to know about Excel dark mode with step-by-step instructions…
Leading zeros are useful for maintaining consistent data formatting or number length. For example, if you have a series of ID numbers or codes that are supposed to have a…
Rows and columns alone aren’t always enough to effectively communicate information in Excel. In such cases, using bullet points is a great way to make your data more readable. They…
Even experienced Excel users occasionally encounter puzzling errors that can disrupt their workflow. One such error is the dreaded #SPILL error in Excel. This error can be frustrating, especially when…
Learning how to find duplicates in Excel isn’t a complex task — but it’s an important one. Excel provides several methods to locate duplicates, whether you’re highlighting them, filtering them…
If you’re working with larger data sets, you’ll commonly encounter duplicates in your spreadsheets. This is the main reason you’ll have to count unique values in Excel. Luckily, Excel has…
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
Spreadsheet programs have become increasingly vital for individuals and businesses to track finances, manage projects, analyze data, and more. From a professional standpoint, formal training can significantly improve your value…
Excel dashboards are a great way to present vital data at a glance while offering incredible technology and user interactivity. This Excel dashboard tutorial will show you the step-by-step process…
The best error handling function is IFERROR (in Excel). Let’s explore its applications. To show how much this can impact the readability of your workbook, I’ll focus on a specific example…