Microsoft Excel
Creating a two-color column chart in Excel can be done with an IF statement to make it dynamic. You can manually change the column colors by right-clicking each column you want to change, but that is a lot of work, and if the numbers change, the column could show the
Microsoft Excel
Paste Values in Excel is an excellent feature. It copies only the value of a cell, not the formula.
Microsoft Excel
In Excel, use the Power Query Editor (Get and Transform data) to unpivot columns and transform your data. If your data is set up cross tabular, you can't sort, filter, subtotal, or create PivotTables. To transform your data, use Power Query Editor. It changes your columns into rows.
Microsoft Excel
The SORTBY Function is one of six new dynamic array functions in Microsoft Excel. SORTBY function allows you to sort one range, based on another range. Example: You have a list of employees with the following fields: Name, Department, and Salary. You want to sort it on a separate workbook
Microsoft Excel
XLOOKUP is the latest function for Microsoft Excel. It came out on **August 28, 2019**. If you like VLOOKUP and Index/Match, you are going to love the XLOOKUP function. There are over 450 functions in Excel. Rarely does a new function come out that is a game-changer. XLOOKUP is
Microsoft Excel
The SumIfs Function is an awesome Excel function. It came out with Excel 2007. It is superior to the Sumif function. The Sumif function only allows one criterion. The Sumifs function allows 29 criteria. In this video I look at referencing cells with Sumifs, using operators with sumifs. Examples of
Microsoft Excel
You can find the lowest or highest values for rows or columns in Excel using Conditional Formatting. You will need to use eihter the MIN Function, which finds the lowest value, or the MAX function, which finds the highest value. To find the lowest value by Rows 1. Select your
Microsoft Excel
The break-even point is when a company has Net Income of zero ($0.00). The revenues generated covered the expenses. There are two types of costs: - fixed - variable To find the break-even point, you need to know the **Contribution Margin**. The contribution margin can be shown as either
Microsoft Excel
The IF function is one of the most popular and powerful functions in Excel. The IF function has three arguments. Two of the arguments are optional. The IF function is **=IF(logical test, value if true, value if false)** Examples of the IF function - I want to give a
Microsoft Excel
Excel users on Android can soon take a photo of a table and turn it into a spreadsheet. This feature is coming for iOS soon. This ai huge timesaver. It beats retyping data in Excel. After taking a picture, you need to crop out the portion of the picture except
Microsoft Excel
We frequently look at quarterly data. If you want to calculate the fiscal quarter from a date, possibly an invoice date or an order date, and the fiscal quarter starts in a month other than January, use the CHOOSE function. For instance, if the fiscal year is from July to
Microsoft Excel
Caution should be used when averaging percentages. As an example, we asked 500 kids and 4500 adults if they like Trix cereal. The kids, 98%, liked Trix cereal. The adults, 42%. Add 98% and 42% and you get 140%. Divide by 2 and that is 70%. (98+42=140 / 2