In a previous post, I covered how you can customize the Excel ribbon in what was a pretty manual process. The good news is there is a much easier way to make changes to the ribbon using the Custom UI Editor. Below, I'll cover how you can add and rem ...
In Excel, IF statements give you way to handle multiple scenarios. You can determine which result to return based on another value or input that a user makes. A common example is where a cell contains no value. You can create a formula to say if the ...
Want to estimate how much you might owe in taxes next year? If you are self-employed or have other income besides what you get from an employer, then you may find it useful to plan ahead of time and determine how much you might owe to ensure that yo ...
Using pivot tables to summarize data can be a great way to display information quickly and total everything up. However, in some cases, data that you download is already in what you might call a pivot table format where it is summarized and you want ...
A big advantage of using Google Sheets is that the data is readily accessible online and you don't need to worry about if people are running different versions of it like you would with Excel. One of the areas where it may be lacking is in creating ...
Do you have a report in Excel that lists the months as the numbers 1 through 12 and you want to convert that into the actual month names? Below, I'll show you how you convert a month number into a month name in Excel. https://www.youtube.com/wat ...
If you are creating an invoice and need to account for taxes, usually you just need to multiply the subtotal by the percentage due for taxes. However, it gets trickier when the tax amount is already included within the invoice total and you need to ...
In this post, I'm going to show you how you can easily calculate variances in Excel. I will also go over how to group variances and how using pivot tables, charts, and conditional formatting can help save you time in reviewing them. https://www ...
If a stock you invested in dropped in price, it could be a good opportunity to buy more shares and bring your average down. You can use the average down calculator on this page to do a quick what-if calculation to determine how many more shares you ...
In an old post, I went over how to parse data using various different functions. This time around, I'm going to show you how much easier it is do that in Power Query. If you're not comfortable using LEN or MID functions, then this will make your lif ...
