Microsoft Excel
Microsoft Excel can find duplicates easily with Conditional Formatting. The issue is Conditional Formatting finds duplicates based on the cell value, but I want to find duplicate rows. I use three methods in the video to find duplicate rows. Excel conditional formatting - duplicates are based on cell value, not
Microsoft Excel
The **TODAY** function returns the current date and is updated automatically when you open an Excel file. The TODAY function has no arguments. I'll use the TODAY function in an accounting exercise using Accounts Receivable in this blog post and video. You would use the same for Accounts
Microsoft Excel
Need to convert text to numbers in Excel? I'll demonstrate four methods in the easy-to-follow article and video. If you need to analyze data in Excel, numbers frequently come in as text and need to be converted. **Excel convert text to numbers** The four methods to convert text
Microsoft Excel
In Excel, numbers that are stored as text can cause unexpected results. It is important before you analyze numbers to make sure there are no numbers or values stored as text. This detailed article with a video shows 5 methods for identifying numbers stored as text. **Identify numbers stored as
Microsoft Excel
One of Excel's most popular financial functions is the PMT function. The PMT function will calculate your payments for a loan based on the interest rate, loan amount, and the number of periods. You would use the PMT function to calculate a car or house loan. **PMT function
Microsoft Excel
**Sometimes working in Excel, moving data around, creating worksheets and removing, copy pasting, all that work can lead to huge file sizes, without realizing. I've had a situation like this recently, with an Excel spreadsheet that didn't have a lot of data, but the file size
Microsoft 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
Microsoft Excel
The MONTH function in Excel allows you to extract the month from the date. The MONTH function returns a number from 1 to 12. - January would be the number 1 - July would be the number 7 - December would be the number 12. In this article and video
Microsoft Excel
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. Another example is to use the LARGE function to see the highest test score,
Microsoft Excel
**If adding events to your Google Calendar is tedious or you have many events you need to add quickly, you can use a CSV file you can generate in Microsoft Excel, to populate your calendar quickly and easily. Read below to find out how to do it, what fields are
Microsoft Excel
Need to know when your investment will double? In finance, the rule of 72 is an easy method for determining when an investment will double. Take the number 72 and divide it by the interest rate, which gives you the number of years. For example, a 5,000 investment at
Microsoft Excel
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. In this video, I demonstrate the SUM function and show you a few