Lee Ann | search
Click here to view Lee Ann news from 60+ newspapers.
Bookmark or Share- How to correct a #N/A error in the VLOOKUP functionIf your lookup value is not in the first column of the array, you will see the #N/A error. In the following table, we want to retrieve the number of units sold for Kale. The #N/A error results because the lookup value “Kale” appears in the second column (Produce) of the table_array argument A2:C10.
- Undo, redo, or repeat an action - Microsoft SupportYou can undo, redo, or repeat many actions in Microsoft Word, PowerPoint, and Excel. You can undo changes, even after you have saved, and then save again, as long as you are within the undo limits (By default Office saves the last 100 undoable actions). Windows macOS Web.
- View previous versions of Office files - Microsoft SupportMicrosoft 365 Office 2016 - 2021 macOS Web. Learn how Version History helps you see what changes have been made in a file, compare different versions, or restore the version you want: Open the file you want to view. Click the title of your file and select Version history.
- Load the Analysis ToolPak in Excel - Microsoft SupportIf you need to develop complex statistical or engineering analyses, you can save steps and time by using the Analysis ToolPak. You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macro functions to calculate and display the results in an output table.
- Create an organization chart in Office by using SmartArtUse a SmartArt graphic to create an organization chart in Excel, Outlook, PowerPoint, or Word to show the reporting relationships in an organization, such as department managers and non-management employees.
More
