Blogs about: Office 2003 Tips
Featured Blog
How do I find my Templates? Windows 7
If you create any templates (with the .dot, dotx, .xlt, xltx, .ppt, pptx extensions – even Chart Templates in Excel 2007 & 2010), they are automatically saved outside of the My Documents st… more →
Uhas Computer Training Weblog
How do I find my Templates? Windows 7
wrote 1 month ago: If you create any templates (with the .dot, dotx, .xlt, xltx, .ppt, pptx extensions – even Ch … more →
How do I find my Templates? Windows XP and Vista
wrote 1 month ago: If you create any templates (with the .dot, dotx, .xlt, xltx, .ppt, pptx extensions – even Cha … more →
Issue with Percentages, Currency Values, or Zip Code Formats in a Word Mail Merge
wrote 3 months ago: When you create a mail merge document in Word with Excel as the data source, often you find that Per … more →
PIVOTTABLE PREP: RULES FOR ORGANIZING SOURCE DATA IN EXCEL
wrote 8 months ago: Before you begin creating a PivotTable you need to be certain that the data is set up so the PivotTa … more →
Strong Passwords
wrote 11 months ago: I talk about using a STRONG PASSWORD in my training classes. My friend Mark from MLANS has an excel … more →
Uses for the Function Keys in Word
wrote 1 year ago: I always include Function Keys in the Appendix of my Excel training manuals but have not included th … more →
Freeze Panes in Excel
wrote 1 year ago: Many are confused about where the active cell should be before you Freeze Panes. I explain it this w … more →
Tips for Using TAB and ENTER in Excel
wrote 1 year ago: When you are entering data in Excel and need to enter left to right, you might use the right arrow k … more →
See Multiple Excel Workbooks on One Screen
wrote 1 year ago: There are times when it would be easier if you could see several different Excel workbooks side-by-s … more →
Uses for the Function Keys in Word
wrote 1 year ago: My client this past week wanted to see a list of the Function Keys in Word. Here you go …. Pr … more →
Find Invalid Data when Using Data Validation
wrote 1 year ago: Often you create Data Validation rules on worksheets that have existing data. This tip is to help y … more →
Easily Identify the Active Sheet Using Sheet Tab Colors
wrote 1 year ago: When you work with multiple sheets in Excel you can identify the active sheet – it is the sheet tab … more →
Excel’s SUMIF Function
wrote 1 year ago: The SUMIF function is used to add up the values in cells in a selected range that meet certain crite … more →
Excel’s COUNTIF Function
wrote 1 year ago: The COUNTIF function, one of Excel’s COUNT functions, is used to count the number of cells in … more →
Tables – Align Both $ Signs and Decimal Points
wrote 1 year ago: If you create a Word Table and want to align the dollar signs away from the numbers, you might disco … more →
Sorting in Word's Table of Authorities
wrote 1 year ago: A Table of Authorities always enters the items in each category alphabetically. However, there are … more →
Add New Data to an Excel Chart - THE EASY WAY
wrote 1 year ago: Problem: You created a chart in Excel and now you have added more data to the source, i.e., the cha … more →
Force a New Line within an Excel Cell
wrote 1 year ago: If you don’t like where Word Wrap breaks a line of text, you can force a new line within a cel … more →
Close All Open Files without Closing Excel or Word
— 2 comments
wrote 1 year ago: I often have multiple files open in the same application, i.e., Excel and Word. I hate having to cl … more →
