Microsoft Excel
One of my YouTube scribers asked me, "How to Exclude Dates With No Data From Charts in Excel?" When you chart data, months with no data appear. For example, if you chart January through December and March and August do not have any data, they will show on
Microsoft Excel
The XLOOKUP function is one of my absolute favorites in Excel. It allows you to quickly look up various values in one range and return a corresponding value from another range. Unlike VLOOKUP, XLOOKUP looks both ways, and is more versatile and flexible, particularly when you move ranges around or
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