by fccadmin | Sep 3, 2021 | Excel, Microsoft Office
Use Excel Charting to visualize data in your spreadsheets! In Excel, table data can be a great way to showcase values in columns and rows. You can sort, filter, and even summarize the data to better understand the information. But when you use charts, you can...
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 new feature in Excel 2016, 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...
Recent Comments