Archives - November 2012

13
Nov

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

13
Nov

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 …

13
Nov

Adobe Dreamweaver allows you to insert a Photoshop Image in a web page as a “Smart Object”

Stay connected to your original Photoshop document.  In Dreamweaver Design View, position your cursor where you’d like to insert an image.Choose Insert Image, then browse to your original Photoshop document (.psd), select the file, then click OK.In the Image Preview dialog box, on the Options tab, select your preferred image format from the Format drop-down …

13
Nov

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 …

13
Nov

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 Bar (comparing like data), Pie (showing pieces of a whole), Line, Doughnut, 3D, Gantt, …

13
Nov

Great Use for a Spry Tooltip in Dreamweaver

Use a Spry Tooltip in Dreamweaver to display a larger version of an image when you “mouse over” a thumbnail. Create two versions of an image — one a small thumbnail, and the other the full size version of an image. Insert the thumnail image into your html page with the Insert/Image command. Click on …

13
Nov

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

13
Nov

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 …

13
Nov

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 …

13
Nov

Grouping & Summarizing Data in Microsoft Access Reports

The Report Wizardprovides options for grouping and summarizing report data. You can organize your report by selecting the fields into which you want to group data. If you create more than one group, you can prioritize the groups into levels.In addition to grouping data by a field, you can add grouping intervals. Grouping intervals vary, …

13
Nov

Setting Default Values for Fields in Microsoft Access

Looking for another great time saver? Make the data entry job just a little bit easier! You can set a default value for a field — that value will automatically appear in the field for all new records. You can still modify the default field value as needed when entering a new record. For example, …

13
Nov

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 fill. Type the starting value for the series. Type a value …

13
Nov

Using Excel Data Bars to Show Conditional Formatting

Conditional Formatting helps you explore and analyze data visually, detect critical issues and identify patterns and trends. A conditional format changes the appearance of a cell range based on a condition or criteria. You can use Highlight Cells Rules, Top or Bottom Rules, Data Bars, Color Scales or Icon Sets to visualize data easily, highlight …

13
Nov

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. To select a sentence, press CTRL and click …

13
Nov

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 to format your heading as 16-point, bold, Cambria, you can do it …

13
Nov

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 beside each line of text. For Word 2003 and prior versions: 1.     File …

13
Nov

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 an example… In the case where you need to highlight inventory …

13
Nov

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 email message with a pre-defined recipient already filled into …

13
Nov

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 Definition page, you type a name for the …

13
Nov

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, or HR reports for a specific department or subset of …

13
Nov

Making Microsoft Access Form & Report Controls Grow

Did you ever notice that when you print an Access report, some of the text is missing from variable-length fields (e.g., a text or memo field)? If there is too much text to display in the text box, the text is truncated (cut off).   Instead of resizing the control to be a set length, …

13
Nov

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 -> Keyboard Shortcut Click the New Set button to create a new set of keyboard …

13
Nov

Here’s a few of our favorite Excel tips…

To summarize your 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 subtotal by (the Sorted Column) Select the Function that you would like to use Select …

13
Nov

Using the Microsoft Access Calendar for Date Picking

Open your Form in Design View. Press F4 to open the Property Sheet. Select the desired date field from the Selection Type dropdown list at the top of the Property Sheet. Select the Format tab on the Property Sheet. In the Show Date Picker field, select For dates. Select Save, then close form. Note when …

13
Nov

Microsoft Access – Align Your Text with a Stroke of the Keyboard

Here are a few keyboard formatting tips when viewing a form or report in Design View or Layout view: To align the text in a selected control to the left, press CTRL+L. To align the text in the selected control to the right, press CTRL+R. To center the text in the selected control, press CTRL+E. …

13
Nov

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 Table, and then click More …

13
Nov

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 better way. Instead of manually entering start or …

13
Nov

Simulate Motion with Tweening and Blurring in Photoshop

Open the desired Photoshop file. Create layers to be used in the animation. Choose Window –> Animation to display the ANIMATION (FRAMES) panel. Create animation frames. Set the layer visibility in animation frames. Tween the frames. Set the required frames. At the bottom of the ANIMATION (FRAMES) panel, click the Tweens animation frames button. In …