Geeky Gadgets: How to write Excel formulas using the Advanced Formula Environment (AFE)
Excel’s formula bar has limitations that make writing, debugging, and managing complex formulas challenging. A new tool, the Advanced Formula Environment (AFE), developed by Microsoft for Excel 2019 ...
Geeky Gadgets: How to use MS Excel advanced formulas for data analysis
In this guide, you will learn how to use Excel’s advanced formulas such as INDEX-MATCH, OFFSET, and INDIRECT to enhance your data analysis capabilities. First, let’s explore the INDEX-MATCH ...
To see options for working with Outlook, select File > Options > Advanced. Options are categorized by Mail, Calendar, Groups, People, and so on. Outlook panes Customize Outlook panes Select Navigation to choose the number of items shown in the navigation bar at the bottom of the Outlook window.
Advanced search options Find what you're looking for in less time. Use the following symbols to quickly modify your search term or search function:
Overview of advanced filter criteria Advanced Filter works differently from Filter in several important ways. It displays the Advanced Filter dialog box instead of the AutoFilter menu. You create a criteria range (separate cells above your data) where you enter your filter conditions, then tell the Advanced Filter dialog box to use that range.
The Advanced Word options control features that affect editing, display, printing, and file compatibility. Most users do not need to change these settings. To select your advanced Word options, select File > Options, and on the left pane, select Advanced. You may need to scroll within the Advanced pane to find the specific option you are looking for.