Software Tips for Microsoft Office 2003, BlueZone, and Internet Explorer

Subscribe to receive tips by email

Access  |  BlueZone  |  Excel  | Internet Explorer |  Outlook  |  PowerPoint  |  Publisher  |  Word

Access

Tables Setting default values Filtering by selection Move between records or fields Primary keys Importing file formats Adding fields Selecting data or records Place an Access table in Word Open in Design view Sending a portion of a datasheet Add a table to a Word document Link an Excel database table	Data entry Zoom in Require that certain fields contain data Keyboard shortcuts for data entry Repeat the value from the previous record Simplify data entry with an input mask Record selector symbols Importing a Word table
Queries Preload a table into a new query Search for fields with no data Sorting query results Rename a field in a query Mastering terminology Adding fields Rearranging query columns	Forms Forms:  Switching to form view Multi-table forms and reports Size a control to fit text Center a form or report within the application window Forms Navigation Quick forms Inserting current date/time
Reports Conditional formatting in reports Size a control to fit text Multi-table forms and reports Center report titles Create controls that grow with report data Eliminate repetitive data in reports Center a form or report within the application window Reducing report margins	Security Adding a password

BlueZone

Display Full screen view Display options Display the cursor guide Enabling HotSpots Customize the Toolbar Changing the font	Print Copying to a printer Print Multiple Screens
Data Entry Reset the keyboard Open a new session window Close all open sessions Copy and paste Copy to file options Erase a word

Excel

Data Entry Enter the same value in several cells at once Self-numbering rows Inserting line breaks Keyboard shortcuts for entering date and time Disable automatic creation of hyperlinks Completing a series using the fill handle Enter data in multiple worksheets simultaneously Create a list box for data entry accuracy Double click the Fill Handle to automatically fill data Autofill dates Shared Workbooks	Working with data Freezing column/row headings Sort by More than 1 Column Transpose Data Selecting cells with hyperlinks Finding all occurrences of a word at once Enhancing drag and drop Limiting the scope of Excel's Find and Replace Backtracking during an Excel Find or Replace Dividing column contents Selecting a portion of a column Ensure all cells are empty before deleting a column or row Selecting cells Use a spreadsheet like a database Saving workspaces Select  entire worksheet AutoFilter Lock cells Autocalculate
Formatting Adjusting column width Change the default font Shortcut keys for number formats Changing number format for numbers stored as text Clear formatting Adding headers and/or footers Adjusting row height Merge and Center Underline Formats Conditional Formatting Format Painter Display text vertically	Formulas/functions Multiple Sums Distinguish formula results from constant values Keep formula details hidden from users Display formulas Quick sum
Printing Scaling worksheets when you don't know the final size Start counting pages from a specific number Display Excel row and column headings on printouts Conserve ink and time when printing Controlling page breaks Inserting an automatic date and time stamp Manual page breaks Printing gridlines Inserting page numbers Centering data Print a portion of a worksheet Print multiple worksheets at the same time	Charts Display chart axis values in specific scale units Quick chart Changing chart type
Customizing Default number of worksheets Coloring worksheet tabs Show Excel's complete Standard and Formatting toolbars Displaying zero values Controlling behavior of Enter key Hiding gridlines Inserting Comments	Navigation Navigating shortcuts Quickly move to the ends of an Excel worksheet Easily switch to a specific sheet in an Excel workbook Go To Special Navigating a large number of worksheets

Internet Explorer

Display a list of typed addresses
Google's Search by Number feature
Sorting Favorites
Quickly find text on a page
Quickly enter web address
Google maps
Keyboard shortcut to open Home page
Create a desktop shortcut to a web page
Moving to the Address bar
Clearing AutoComplete entries

Display the menu bar (IE 7)

Quick Tabs (IE 7)

FrontPage

Graphics Reducing image size Create an AutoThumbnail Decrease download time for graphics Mapping components Cropping graphics Remove blue border from image links	Links Creating Hyperlinks Hyperlink screentips Creating a link to open in a new window Remove blue border from image links
Formatting Removing extra line breaks Adding line breaks Remove formatting from pasted text	Tables Aligning with tables Adding a caption to a table Convert table to text Easy table formatting
Managing Browser Preview Switching between open pages Displaying the folder list Refreshing the page	Editing Copy and paste Display date and time page was last edited

Outlook

Email Mailbox Cleanup Editing Received Messages An easy way to create a message to several Outlook contacts Turning a message into an appointment Saving multiple attachments Find all messages from a particular person Message reply reminder Permanently delete junk e-mail Find related messages Follow up flag Signatures Locate large attachments Working offline Scheduling delivery of messages Converting e-mail addresses in Excel to a distribution list Arranging messages by size Color coding messages About AutoComplete Expanding a distribution list Creating a distribution list from received message Replies to multiple addresses Mark a message as not junk Request a read receipt

Calendar Deleting all calendar entries Making Calendar notes visible Changing time periods in the calendar grid Displaying nonconsecutive dates in the calendar Print a blank calendar Color coding appointments Changing your calendar view Adding holidays Create additional calendars Change display of weekend

Contacts Quickly save an address to Contacts Change the number of columns in the Contact list

Customizing Changing the startup folder Favorite Folders

PowerPoint

Creating slide shows Create a photo album Mouseless formatting Reducing file size Drawing the perfect circle Adding screenshots Slide shows in mini-window Changing the color scheme of multiple slides Combine slides from multiple presentations while maintaining original slide backgrounds Adding watermarks Saving a presentation to auto launch Package for CD Saving a presentation as a template Importing PDF content Create a chart Reduce picture file size More design templates Adding comments Setting a default view Removing/changing design template Changing orientation Custom shows Using web backgrounds Drawing curves Adding animation to diagrams Finding Clip Art

Playing slide shows Starting slide shows using the keyboard Hiding the pop up menu button Giving a better presentation Blank the screen Return to first slide in Slide Show mode Jump slides by numbers Start a slide show automatically PowerPoint Viewer End slide

Printing Printing an outline Printing multiple slides simultaneously Printing notes pages Changing notes page layout

Publisher

Working with text Creating columns in a text box Importing a Word document Zoom in Automatically resize text Create multiple text boxes quickly Connecting text boxes Wrapping text around a picture Updating personal information	Working with Objects Position objects precisely Selecting Objects Duplicating pages Proportional resizing Drawing a perfect circle Group objects Convert a picture to a watermark Add a color to the margins in a picture frame Rotate text or pictures Add text to shape Empty picture frame
Formatting Using the Master Page Adding new pages Moving pages Using layout guides to set up text columns Copying formatting Keep your designs uncluttered Boost the impact of your Word documents Font schemes Check your publication for problems	Sending a publicationl Embedding TrueType fonts Create a calendar E-mail wizard

 

Word

Working with text Return to the last place edited in Word "Automatic" text Keyboarding your Accents Viewing text boundaries Using the Thesaurus Highlighting large blocks of text Customizing footnote separators Opening a Microsoft Works document	Formatting Changing the default font Changing margins Apply superscript or subscript formatting from the keyboard Keep formatting consistency in check as you type Paste format options
Printing Print a portion of a document Shrink to Fit Print an envelope without printing its attached letter	Tables Inserting additional rows in a table. Repeat Table Headings at the top of each page Transform a table into a chart