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 | Feb 5, 2019 | Tableau
Using Tableau Desktop 2018, you can create Visualizations from information stored in your spreadsheets and databases, giving you the ability to quickly perform data analysis with dynamic and great looking Dashboards. It’s easy to customize your Tableau...
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...
by fccadmin | Dec 19, 2018 | Excel, Microsoft Office
PivotTables and PivotCharts are fantastic Excel features that allow you to analyze data. Sometimes you need an easy way to manipulate only specific data and view it. This Trainer Tip will show you how to filter data in PivotTables and PivotCharts using Slicers. Though...
Recent Comments