Learn to Build Maps in Tableau

Using Tableau Desktop, 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. Using Maps in Tableau allows you to perform geographic...

Create a Dynamic Tableau Dashboard

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

Using Excel FlashFill

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

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

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

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

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

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

Crystal Report Charting Features

Charts are simple to create using Crystal Reports and usually, but not always, require at least one group to be defined.  In Crystal, you’ll be able to select from a variety of chart styles to visually present your organization’s information. Select from...

What is an Excel PivotTable?

Sharing the Wonder of Excel 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...

Get a Handle on Excel AutoFill!

Use AutoFill to fill in data…With the AutoFill feature, you can have Excel automatically continue a series of numbers, number and text combinations, dates, or formulas, based on a pattern that you establish. Select the first cell in the range that you want to...

Formatting Text in Microsoft Word

Here are some great tips on formatting text using your keyboard in Word 2007 or 2010. To format a word without selecting it, click the word and apply the formatting that you want. For example, press CTRL+B to apply bold formatting. To select a word, double-click it....

Word Styles can make a difference!

Are you using styles yet?  If not, it’s time to get efficient!   A style is a set of formatting characteristics, like font, size, color, alignment and spacing, used to format your document quickly, easily and consistently. Instead of taking three separate steps...

Inserting Line Numbers in Microsoft Office Word Documents

In legal documents, line numbers are placed on the left-hand side of the printout to assist in referencing specific lines in the document.  Microsoft Office Word can do this for you automatically, counting the lines in a document and displaying the appropriate number...

Highlighting Data in Crystal Reports

Did you ever want to make certain information in your reports stand out?  The Highlighting Expert feature in Crystal Reports can help you.  For instance, if you are trying to indicate negative numbers or numbers that are under or over a set threshold.   Here’s...

Hyperlinking Objects in Crystal Reports

Use hyperlinks to your advantage in Crystal. Did you know that many Crystal Reports objects can be used as hyperlinks?  A hyperlinked object allows a report user to click the object (in preview view) and be automatically directed to another file, a web page, or an...

Creating a Custom Report in MS Project

You can create custom reports by creating a new report or by copying an existing report and modifying it. Custom reports reflect only the information you need. When you create a custom report, you work in the Reports dialog box, which has three tabbed pages. On the...

Using Crystal to Create Dynamic Reports…

Displaying selection criteria in your report header One of the most powerful features in Crystal Reports is the ability to allow users to set selection criteria on demand.  For instance you may want to run sales reports for a specific territory, region or sales rep,...

Creating a Keyboard Shortcut in Adobe InDesign

Tired of going to the menus to select the same action over and over again?  Having trouble memorizing some of InDesign’s complex keyboard shortcuts?  It’s very easy to create your own custom keyboard shortcuts! From the main menu, select Edit ->...

Here’s a few of our favorite Excel tips…

Learn some new tricks in Microsoft Excel! To summarize your Excel data without using formulas: Sort the data by what you would like to subtotal Go to the Data tab On the right of the ribbon, click Subtotal in the Outline group. Choose the field you’d like to...

MS Project Gantt Chart Tips

In MS Project, it is possible to print a Gantt Chart view without any table information. To do this, you must apply a table that has all the column widths set to zero. Note that a Gantt Chart view always requires some table to be applied. On the View menu, click...

View and Track Task Deadlines in MS Project

Deadlines are a fact of life when managing any project, and missing a critical deadline can be costly in more ways than one! MS Project users are often tempted to override the calculated start or finish dates of a task to reflect deadlines, but there’s a much...
Loading cart ...