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.
The Excel SUMIF() and SUMIFS() functions can be used to add values based on a date range, such as between two dates, before a date, and after a date. Being able to add values within date ranges is an important skill in many different industries. This is especially true for finance, where you may need …
Use Excel SUMIFS() With a Date Range (Before, After, Between) Read More »
The Excel SUMIF() function allows you to add values conditionally. However, it will also fail if you have a #N/A error, #DIV/0 error, or any other error in your range of data. Thankfully, this is quick and easy to solve! In this tutorial, you’ll learn how to ignore the #N/A error in the Excel SUMIF() …
How to Ignore #N/A Error in Excel SUMIF() (#DIV/0 etc.) Read More »
Being able to count cells that fall in a date range in Excel is an important skill. In many cases, for example, you’ll need to count how many sales happened over a period of time. Or perhaps, you need to know how often a specific user logged into an application during a specific date range. …
You’ll often need to find a fiscal year in many industries, such as finance or government. These years often start in April, which may also vary. In this tutorial, you’ll learn how to get the fiscal year from a date in Excel. Because Excel doesn’t provide a built-in function to get a fiscal year, we’ll …
Working with dates is an important skill for anyone working with Excel. In this tutorial, you’ll learn how to use Excel to calculate the day of the year in Excel for any given date. This can be very helpful when you need to understand how far into the year a given date is. By the end …
The Excel DATEDIF() function can be used to calculate the difference between two dates in Excel. Knowing how to do this is an important skill, given how much data analysis involves working with dates. So many real-world tasks involve working with dates, regardless of the industry you work in. In this tutorial, you’ll learn how …
How to Calculate the Difference Between Two Dates in Excel Read More »
Working with dates is an important skill for anyone working with Excel. In this tutorial, you’ll learn how to use Excel to check if a date falls between two dates. This can be very helpful when you’re checking whether or not payments were made during a reporting period. By the end of this tutorial, you’ll …
How to Check if a Date Is Between Two Dates in Excel Read More »
Being able to generate random dates in Excel is a valuable skill to have. For example, you may need to create some mock data. However, it can be tedious to think of random dates manually. Because of this, in this tutorial, you’ll learn how to generate random dates in Excel. In order to do this, …
Working with dates is an essential skill for anyone working in Excel. For example, in project management, you may need to be able to work with date duration. In finance and accounting, you’ll often need to aggregate data across different periods of time. In this tutorial, you’ll learn how to get the quarter from a …
How to Get the Quarter (and Year) from a Date in Excel Read More »
Being able to work with dates is an essential skill for anyone working in Excel. This is true, regardless of industry. For example, in project management you may need to be able to work with date duration. In finance and accounting, you’ll often need to aggregate data across different periods of times. In this tutorial, …
