Microsoft Excel Tips
and Tricks
Count Your Excel Records Based on Multiple Conditions
Enter a Line Break Within a Cell
Perform Quick Operations on Your Excel Data
Import Access Tables into Excel
Another Way to Copy Access Data into Excel
Import Access Data into Excel
Keep Links to Source Workbooks Up-to-Date
Generate Random Numbers in Excel
Create Forms for Easier Data Entry
Keep the Result, Lose the Formula
Use Your Spreadsheet Like a Database with AutoFilter
Give Your Excel Workbooks a Consistent, Professional Look
Navigate Blocks of Data in Excel 2002
Draw Borders in Excel Worksheets
Build a Timesheet with a Simple but Powerful Function in
Excel
Switch Between Absolute and Relative Cell
References in Excel
Use This Shortcut to Insert
Time/Date in Excel or Access
Quickly Calculate a Person's
Age in Excel
Quickly Clear All Spreadsheet
Formatting
Hide Whole Worksheets in Excel
Web Queries Keep Excel
Worksheets Up to Date
Rest Your Eyes with Text to
Speech
Color-Code Your Excel Sheet
Tabs
Get Easy Access to New AutoSum
Functions
Copy an Excel Table and Its
Formatting in Word
|