A collection of tutorials explaining how to do common Excel tasks or take on common problems you might face when working in Excel. For example, you’ll learn how to work with errors, text, dates and times, formatting, and data clean up.
Working with dates and weeks is an essential skill for any Excel user. Whether you’re working in accounting or putting together a planner in Excel, knowing how to get the first day of the week in Excel is a valuable skill. In this tutorial, you’ll learn how to get the first day of the week …
The Excel #NUM! error occurs when an Excel formula can’t perform a calculation. It may not be immediately clear, however, why Excel can’t perform a calculation. In this tutorial, you’ll learn how to identify and resolve the main causes of the Excel #NUM! error. There are three main causes of the Excel #NUM! error, including …
Excel #NUM! Error: What It Means and How to Fix it Read More »
Being able to work with text in Excel is an incredibly valuable skill. Because text data is often messy, you’ll likely find yourself wanting to strip or remove the first or last characters from a cell in Excel. In this tutorial, you’ll learn how to use Excel to remove characters from both the left and …
How to Remove Characters from Left or Right in a String in Excel Read More »
The Excel #DIV/0 error occurs when a value is divided by 0. Because dividing a number by zero returns an infinity value, Excel shows you an error. Excel provides you with a number of helpful ways to resolve this error. In this tutorial, you’ll learn how to resolve the Excel #DIV/0 error. Similarly, trying to …
Excel #DIV/0 Error: What It Means and How to Fix it Read More »
The Excel #REF! error occurs when a reference in Excel is invalid. This usually happens because sheets, columns, or rows have been removed. In this tutorial, you’ll learn what the #REF! error means and how to fix it. Because of how common this error is, having a good understanding of the error can make you …
Excel #REF! Error: What It Means and How to Fix It Read More »
