Microsoft Office Tips and Tricks

Microsoft Access Tips and Tricks

Access VBA Basics	Table Relationships
Storing Data in Variables and Constants
Creating a Lookup with a Microsoft Access Query
Including Parameter Values in a Microsoft Access Report
Microsoft Access Performance Analyzer

Microsoft Word Tips and Tricks

Shortcut keys for editing text
Shortcut keys for formatting text
Comment tool
Document versions
Tracking changes	Using Quick Parts in Word 2007
Shortcut keys for referencing and reveiwing	Shortcut keys for selecting text
Comparing and merging documents	Highlighter toolk
Hightlight Find and Replace Text

Microsoft Excel Tips and Tricks

How to create an absolute reference	Name a range
BODMAS	Compare Two Lists with Vlookup
Dates and Times in Excel	Convert Text to Numbers in Excel
Delimited Text into Columns	Freeze Panes in Excel
Text Functions	Excel Vlookup Function
Cascading Drop Down Lists	Excel Pivot Tables
Countif	Excel Data Validation
Creating a drop down list in Excel	Assign Excel Macro to Toolbar, Menu or Button
Sumif	How to create a Gantt chart in Excel
VBA Message and Input Boxes	Excel shortcuts
Format Elements of a Chart	Excel calendar templates
Split Text Into Columns	Concatenate in Excel
Convert Text or Numbers to Dates	Conditional Formatting
Repeat Column Headings on Each Page	Gantt Chart Software
Mixed Cell References	Gantt Chart Template
Percentages	Transpose and Link Data in Excel
Mortgage Payment formula
Add a Trendline to an Excel Chart
Working with Excel Charts
Excel IF Functions
Excel Advanced Filter
Editing Recorded Excel Macros
Excel Custom Functions
Countifs
VBA Worksheet Events
Sumifs
For next looping
Adding a secondary axis to an Excel chart
Worksheet Protection
Printing Excel - Fit to One Page
Custom Lists - Creating and Sorting By
Name columns in a table

Office 2007 Tips and Tricks

Adding Buttons to the Quick Access Toolbar in Office 2007	Some New Features in Word 2007
The Office 2007 Ribbon	New Features in Excel 2007 Formulas & Functions
The Office 2007 Office Button	New Table Functionality in Excel 2007
Creating New Files in Office 2007	Improved AutoFilter in Excel 2007
Opening Files in Office 2007	Some New Features in Excel 2007
Saving Files in Office 2007	Conditional Formatting in Excel 2007
Miscellaneous Enhancements over Office 2003	Working with Pivot Tables in Excel 2007
Some New Features in PowerPoint 2007	Using Master Slides in PowerPoint 2007
Outlook 2007 To Do Bar	Outlook 2007 Electronic Business Cards (EBC)
Outlook 2007 Email Calendar Snapshot	Outlook 2007 Colour Categories
Outlook 2007 Instant Search	Outlook 2007 Flagging

Office 2010 Tips and Tricks

Customise the Ribbon in Office 2010	Customise the Quick Access Toolbar
Using the Recent List in Backstage View Office 2010	Live Preview

Publisher Tip and Tricks

Pasting Text into a Publisher 2010 Publication	Continued Notices
Connect Text Boxes	Using Styles in Publisher 2010
Creating Tables in Publisher 2010	Inserting Images in Publisher 2010
Using the Graphics Manager in Publisher 2010	Object and Drawing Tools in Publisher 2010

PowerPoint Tip and Tricks

Creating New Slides in PowerPoint 2010	Using SmartArt in PowerPoint Presentations
Change the Layout of a Slide in PowerPoint 2010	How to Embed YouTube Videos in PowerPoint 2007
Delete a Slide in PowerPoint 2010	How to Embed YouTube Videos in PowerPoint 2010
Move a Slide within a Presentation	Using Guides in PowerPoint 2010
Formatting Text in PowerPoint 2010	Alignment Tools in PowerPoint 2010
Using AutoCorrect and AutoFormat Options	Resizing Shapes in PowerPoint 2010
Creating Tables in PowerPoint 2010	Selecting Multiple Objects in PowerPoint 2010
Inserting ClipArt into Slides in PowerPoint 2010	Inserting Charts in PowerPoint 2010
Using Slide Masters in PowerPoint 2010	Applying Slide Transitions in PowerPoint 2010
Applying Builds/Text Animation In PowerPoint 2010	Animating Charts and SmartArt in PowerPoint 2010
Custom Slide Shows in PowerPoint 2010	Kiosk Style Presentations in PowerPoint 2010
Copy slides from other presentations	Package Presentation for CD in PowerPoint 2010
Inserting Video in PowerPoint 2010	Trim Videos in PowerPoint 2010
Add bookmarks to video in PowerPoint 2010	Selecting a video Poster Frame in PowerPoint 2010
Playing Audio Files in PowerPoint 2010	Trim Audio Files in PowerPoint 2010
Add bookmarks to audio in PowerPoint 2010

Project Tips and Tricks

Setting a start date for a project	Setting the Working Times for a Project
Adding exceptions to the project calendar	Manual vs auto scheduled tasks