Microsoft Excel Blog: Tutorials and How-Tos

Excel - 5 easy ways to identify numbers stored as text

In Excel, numbers that are stored as text can cause unexpected results. It is important before you analyze numbers to make sure there are not stored as text. In this video, I'll demonstrate five methods to quickly find numbers stored as text. Numbers as text usually happens when you pull data from another data source into Excel.

PMT Function in Excel - how to use it to calculate loan payment

The PMT function will calculate your payments for a loan based on the interest rate, loan amount, and the number of periods.

Excel file size out of control? Learn how to reduce Excel spreadsheet file size

Sometimes Excel spreadsheet file size can get out of control, for no reason, despite not having a lot of data. Find out what to do to reduce the size again.

Margin of Safety vs. Break-even point in Excel

Break-even point (BEP) is the level of sales where the total cost - fixed cost and variable cost - equals total revenues. Break-even is where Net Income is zero. There is no profit and no loss. The Margin of Safety (MoS) is a difference between actual/budgeted sales and the level of breakeven sales.

Excel MONTH Function - extract the month from a date | Excel One-Minute Quick Reference

The MONTH function in Excel allows you to extract the month from the date. In this video, I show you how the month function works in Excel, the formula to use, reference the fields, formatting it so that you only see the month and nothing else.

Excel LARGE function | Find the second, third, n-th largest value | Excel One-Minute Quick Reference

The LARGE function in Excel returns the k-th largest value in a data set. For example, you can use LARGE to return the customer with the highest revenue, 2nd highest revenue, third-highest revenue, and so on.

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.