by fccadmin | May 19, 2021 | Microsoft Office, Outlook
Flagging a Message in Microsoft Outlook You can insert a follow-up flag next to a message as a reminder or to call attention to the item. You can also send a message with a flag as a reminder for the message recipient. Follow-up flags are also called Quick Flags....
by fccadmin | Jun 26, 2020 | Excel, Microsoft Office
You can easily create a function to look up information! The VLOOKUP function consists of three required arguments, in the following order: lookup value, table array, and column index number. The lookup value is the value for which you want to find matching data and...
by fccadmin | Sep 18, 2019 | Excel, Microsoft Office
Assigning a Password to an Excel File Passwords are used to protect a file. You can assign one password to open a file, and a different password to modify a file. If you assign both types of passwords to a file, only those users who know the open password can open the...
by fccadmin | Mar 22, 2019 | Excel, Microsoft Office
Did you know that you can use Excel IF statements along with VLOOKUPs? For example, if you wanted to enter a value from a table into a cell, based on what was in another cell, you could start with an IF statement and then enter the VLOOKUP in the “value if true” part...
by fccadmin | Dec 19, 2018 | Excel, Microsoft Office
Automatic Time Grouping, a nice feature in Excel, helps use time-related fields in a PivotTable by auto-detecting and grouping them on your behalf. The automatic grouping creates new Date/Time functionality and automatically populates the PivotTable in one action when...
by fccadmin | Dec 19, 2018 | Excel, Microsoft Office
Here’s a nice tip on Excel FlashFill…when you need to combine fields or create a new format (e.g., telephone numbers with hyphens), Flash Fill can do the work for you. Type the first entry into the cell (e.g., telephone number with hyphens). Press Enter to...
Recent Comments