Microsoft Office Tips

<----Back to DataSchenk Home

Access

Microsoft Access Delete Duplicates
Access Conditional Format
Add a Comment to an Access Report
Access Allow Only Weekdays
Export from Access to Excel
Access Reporting Suppress Repetitive Data
Import a Word Table into Access
Access Reset Page Numbers for Report Groups
Access Hyperlink to a File
Access Compact and Repair on Close
Print Multiple Copies of the Same Label in Access
Access Dynamic Form Captions
Access Prevent Copying Form Field Data
Access Report Alternate Colored Lines
Access Email Report Macro
Access Macro to Increment Numbers: Set Value
Microsoft Access Not in List
Access: Change the Start of an Autonumber Field
Access Query for Current Year or Month
Access:  Calculate percentage of records in a group
Access: take the guesswork out of sizing controls
Concatenation - Access and Excel

Word

Word: Use Autocorrect to Insert a Picture
Word : Change Case
MS Word: Change paragraph alignment from
the keyboard
Make your Word table 3D
Word Table Heading Row Repeat on Each Page
Word:  Addresses as Autotext
Word Document Versions
Word Drop Capital Letter
Word Set Tabs With a Leader
Microsoft Word Hidden Text
Word: Move Paragraphs or Rows Using Only the Keyboard
Microsoft Word Split Screen
Word Shortcuts to Open Dialog Boxes
Word Watermark
Word Select block of text
Making Accented Letters in Word
Microsoft Word Calculator
Microsoft Word Captions
Search a Word document for formatting
Word Create Lines Shortcuts
Rearrange paragraphs Word
Microsoft Word Restart Page Numbers
Word Flat Natural Sharp Musical
Microsoft Word Synonyms
Tab in a Table Word
Word Tip Random Text
Word Select Text F8
Word Distribute Columns
Word Split Screen
Microsoft Word Character Spacing
Microsoft Word Change Default Font
Microsoft Word Footnotes Endnotes

Outlook

Microsoft Outlook Delegates Send Email on Behalf of
Outlook 2003 Customize Calendar Colors Labels
MS Outlook:  Vote!
Microsoft Outlook Create New Field Contacts
Outlook keyboard shortcuts
Outlook Tip - Text Dates
Write a letter in Outlook
Outlook Print Calendar Without Private Appointments
Outlook Display Multiple Days in the Calendar
Outlook Stupid Notes Trick
Outlook Display Multiple Folders
Microsoft Outlook Rule to Print Messages
Microsoft Outlook Remove From Autocomplete Cache

FrontPage/Web Design

Change the Scroll Bar Colors
FrontPage HTML Page Border
FrontPage hyperlink rollover
FrontPage Background Not Tile

Excel

Excel Calculate number of workdays
Microsoft Excel Formula Notation
Excel Print Gridlines
Excel Wrap Text Carriage Return in Cell
Excel Hide Duplicates Using Conditional Formatting
Excel Format the highest number Conditional Formatting Max
Excel Link Drawn Objects and Word Art
Excel Change Text to Numbers
Excel Datedif Function
Excel Calculate difference as a percentage
Excel Count Blank Cells With CountBlank()
Concatenation - Access and Excel
Excel Rounding Numbers
Use a Picture as a Comment in Excel
Excel Transpose Data
Microsoft Excel Styles Formatting
Excel Rank Function
Excel Background Graphic
Excel: Enter the same labels on multiple sheets
Excel Add Watch
Excel Line Break
Excel Formatting Keyboard Shortcuts
Display text vertically in a cell
Excel And Function
Use a Picture as a Comment in Excel
Excel Date Fomatting Codes
Excel DateDif
Excel DateStamp Date Stamp
Excel Dedupe Records in a List
Excel Enter Fractions
Excel Multiple Conditions Sum
Excel Or Function
Excel Rank Function
Excel Substitute Function
Excel Text Date
Microsoft Excel Sumproduct Function
Excel Dots Leader
Excel Conditionally Sum Data Sumif
Excel Conditional Formatting
Microsoft Excel Styles Formatting
Microsoft Excel Formula Notation
Excel Shade Alternate Rows
Excel Data Entry Tips
Link Part of an Excel Worksheet
MS Excel:  The CountA function
MS Excel: The Countif function
Excel: the Left and Len functions
Microsoft Excel Create Chart
Microsoft Excel Display Sheet Name
 

PowerPoint

PowerPoint Move Objects by Nudging
PowerPoint: Select Small or Hidden Objects
PowerPoint Slideshow Shortcuts
PowerPoint Next Button
PowerPoint Transparent Picture Color
Microsoft PowerPoint Widescreen
PowerPoint Credits
PowerPoint Open to Slide Show View
PowerPoint Picture Border
PowerPoint Hyperlink Without the Underline
PowerPoint Recolor Picture
PowerPoint: Suppress the Slide Master's background graphic on one slide
Export PowerPoint slides to Word

Publisher

Microsoft Publisher Shortcut Keys
Microsoft Publisher Create Color Scheme

Miscellaneous

Microsoft Office Tip Zoom
Windows XP Shortcut Keys
Windows Keyboard Shortcuts
How to Kill a Process on a Remote Machine
How to set Focus on a Partucular HTML Element
Create Shortcut Keys to a Folder, Program, or Web Page
Print Screen - Get a screen shot
Quickly copy information between Office applications
Google tip: translate text or even translate a Web site
Google Tip: Track your packages
Google Toolbar
Google Calculations
Quick way to get to a dot com
Microsoft Office Turn Off Adaptive Menus
Microsoft Office Tip Zoom
Windows XP Shortcut Keys