Category - Microsoft


How to Filter Excel Data Using Slicers

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 you can filter data in a PivotTable using filters and by …


Why use SQL when you have Access?

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 get the job done. Consider the situation where you have two …


Build a Drop Cap in Publisher

Ever wonder how to create those awesome looking letters at the beginning of a storybook…like the “O” in “Once upon a time…”?  You can do it with a Drop Cap, and in Publisher, they are simple to do! Drop caps are stylistic typographic elements, typically an oversized initial letter, which extend down into a paragraph …


Using AutoCreate in 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 an upcoming dinner meeting. It’s not set up as …


Create Custom Number Formats in Microsoft Excel

Thousands, Millions, etc. 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 number format, like this: 0,. Two commas drop off two sets of three digits, etc. …


Save a Microsoft Word Document in a Prior Version

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 2007/2010 features that aren’t available …


Access 2010/2007 Find Duplicates Query Wizard

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 Query Wizardwill quickly find the duplicate records …


What is a PivotTable?

Sharing the Wonder of PivotTables! The PivotTable is a powerful tool for summarizing, analyzing, exploring and presenting data, extracted from larger amounts of data elsewhere in your workbook. It enables you to query the data in user-friendly ways, subtotal and aggregate numeric data, summarize data by categories and subcategories, and create custom calculations and formulas. …


Arranging Drawing Objects in Microsoft Office

In all of the Microsoft Office products, Drawing Objects allow for the addition of graphics in the form of simple, basic shapes such as lines, arrows, rectangles, ellipses and even text boxes. These shapes can overlap on each other, much like a felt board allows various pieces of felt to lay on top of each …


Find and Replace in Microsoft Access

Searching for a specific record You can search for a specific record in a table or form by using the Find tab in the Find and Replace dialog box. This is an effective choice for locating a specific record when the record that you want to locate satisfies specific criteria, such as search terms, and …

Page 1 of 3