Post covering sorting, filters, getting started with Excel, Excel functions, subtotals, PivotTables, and other Excel features.
Excel - 5 easy ways to identify numbers stored as text
Posted by Chris Menard on 08/18/2021
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.
Margin of Safety vs. Break-even point in Excel
Posted by Chris Menard on 06/25/2021
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.
The Rule of 72 explained using Excel and the NPER Function
Posted by Chris Menard on 04/29/2021
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.
Excel compare two or more text strings
Posted by Chris Menard on 04/20/2021
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
Posted by Chris Menard on 04/14/2021
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.