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 | 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