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...
by fccadmin | Jul 26, 2013 | Access, Microsoft, SQL
Access gives you the easy to use query design grid interface for combining data from tables that share one or more related fields. It’s simple to use and generally effective. However, there are still some times when the query design grid isn’t enough to...
by fccadmin | Feb 25, 2013 | Microsoft, Microsoft Office, Outlook
You can use AutoCreate to quickly create new items from existing ones. With AutoCreate, you can drag and drop Outlook items from the view area to another folder on the Navigation Pane or Folder List. Say you’ve received an email from a colleague with details on...
by fccadmin | Nov 13, 2012 | Excel, Microsoft, Microsoft Office
Thousands, Millions, etc. — Learn about number formats in Excel! If you use a number format like 0, Excel simply writes the number with no decimal point or decimal digits. To truncate the last three digits of a number in the thousands, append a comma to the...
by fccadmin | Nov 13, 2012 | Microsoft, Microsoft Office
In Microsoft Word 2007 and 2010, you can save an individual document in Word 2003 version by clicking the Office button in 2007 or the File Menu in 2010, then Save As, and changing the Save As Type to Word 97 – 2003 as shown below. If you’ve used Word...
by fccadmin | Nov 13, 2012 | Access, Microsoft, Microsoft Office
This wizard will show duplicate records in a single Microsoft Access table, based upon the values of a field in the table. In an Access database, there may be times when you’d like to make sure that there are no duplicate records in a table. The Find Duplicates...
Recent Comments