Air A | search
Click here to view Air A news from 60+ newspapers.
Bookmark or Share- Enable or disable macros in Microsoft 365 filesBlock suspicious macros in Office on Windows 10 S. How malware can infect your PC. Improve security, evaluate and mitigate the risks of running macros, and see how to enable or disable macros for Microsoft 365.
- Repair an Office application - Microsoft SupportRepair an Office application. If a Microsoft 365 application such as Word or Excel isn’t working correctly, sometimes restarting it will fix the problem. If that doesn’t work, you can try repairing it. When you’re done, you might need to restart your computer.
- Create a flow chart with SmartArt - Microsoft SupportThere are many different SmartArt layouts that you can use to illustrate the steps in a process, including layouts that can contain pictures. This article explains how to create a flow chart that contains pictures. You can use the methods described in this article to create or change almost any SmartArt graphic.
- Use the Analysis ToolPak to perform complex data analysisIf 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.
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportThe VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work.
More
