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