Microsoft Excel Blog: Tutorials and How-Tos

How to Import Excel Events CSV into Google Calendar: Tips, Supported Fields, How-to

Save time adding your Google Calendar events by importing them in bulk using a CSV you can easily create in Excel.

The Rule of 72 explained using Excel and the NPER Function

Need to know when your investment will double? In finance, the rule of 72 is an easy method for deterring when an investment will double. Take the number 72 and divide it by the interest rate, which gives you the number of years.

How to use the SUM Function and AUTOSUM in Microsoft Excel | Tutorial for Absolute Beginners

The SUM function is the most popular and widely-used function in Microsoft Excel, along with its automated version: AutoSum. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.

Excel compare two or more text strings

To compare two text strings in Excel, you can use the EXACT Function or you can use =A1=B1. The EXACT function checks for case sensitivity. Example "Chris" is not the same as "CHRIS" if you use the EXACT function. With =A1=B1, Chris would appear as the same.

Excel: Combining Unique and Sort functions

The UNIQUE function in Excel is one of my favorite functions. Unique returns a list of unique values in a range. The SORT function in Excel sorts the contents of a range or array.

Excel Report Filters: Tips of creating multiple reports from one PivotTable

PivotTables are great for summarizing and analyzing data. Report Filters is a great way to generate multiple reports.

Year-Over-Year Growth - Excel PivotTable

Year-Over-Year (YOY) growth compares one period, usually a quarter or a month, against the same period twelve months before. You can compare Q3 of 2021 against Q3 of 2020. Another example is comparing the month of September 2021 to September 2020.

Excel PivotTable - Summarize data by Month or Day of the week

I need to know what day of the week is my most profitable. PivotTables and the TEXT function in Excel can easily determine this for me.

Excel Charts - three methods for filtering Chart Data

Filtering data in Excel charts is easy to do. The method you use should be based on the amount of data you have. In this video, I show three methods of filtering chart data. Method 1 is using Chart Filters. This is the easiest method.

Excel: Covert decimal hours Excel's hours & minutes (8.25 to 8:15)

I'm frequently asked how do I change decimal hours to Excel's hour and minute format. A couple examples: 7.75 need to show as 7:45, and 30.25 needs to show as 30:15. The solution is to divide by 24 hours. The formula is hours/24.

Working with Time in Microsoft Excel | Time Functions and Conversion

Do you need to add or subtract time in Excel? Some time calculations are easy, but depending on how the time is entered, you may need to use the TIME function or formula to add or subtract time. For example, if you have 9am in B2, and in cell C2, you have 3, for three hours, you can't add them with B2+C2 and get the correct answer without the TIME function.

Today Function in Excel

The TODAY function is a date/time function that shows the current date based on your computer time. The TODAY function will update automatically.