Microsoft Excel
Excel now has a **Zip Code data type**. The Zip Code data type is new and is currently available to only Beta Channel Excel users. It should be released soon to all Microsoft 365 subscribers and Excel for the web. To use the Zip Code data type 1. Select your
Microsoft Excel
The AVERAGE function is one of the most popular functions in Excel. This video shows how to use the Average function, handles zero values when using the Average function. Zero values vs. blank cells will give different results with Average. As a bonus, using the AverageIF function with zero values.
Microsoft Excel
Excel for Microsoft 365 subscribers now have Workbook Statistics. Workbook Statistics is a window that shows a summary of the workbook statistics, including the number of sheets, tables, formulas, charts, and pivottables. You access Workbook Statistics by going to the **Review** tab - Proofing group - **Workbook Statistics** in Excel
Microsoft Excel
Microsoft brings 8000 royalty-free images and icons to Office 365. These images work in Word, Excel, PowerPoint, and Outlook. Right now, these are only available to Office 365 Fast Insiders. Steps to use the images and icons 1. Click the Insert Tab 2. Click Picture 3. Select Stock Images... 4.
Microsoft Excel
The Future Value function in Excel, or the FV function, will give you the future value on an investment. It is one of the financial function in Excel. Future Value Function - arguments The Future Value function has five arguments. Three of the five are required. Two arguments are optional.
Microsoft Excel
You should know the difference between the Annual Percentage Yield (APY) and the Interest Rate. APY takes compounding into account while the interest rate does not. APY is a better reflection on what you will earn on a savings or CD account and even some checking accounts. APY is based
Microsoft Excel
Power Query in Excel for Office 365 performs fuzzy matches. Imagine you need to compare two lists of customers. One list is the master list, and the 2nd list is also a customer list, but not an exact match. For example, the master list has "The Home Depot"
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