December 2008 Issue #47 |
| | | Welcome! | Finally! We're back and even better! 
Now your Smart & Easy Software Tips eMagazine is packed with: - More Tips and Shortcuts!
- Full color screens, photos, and images to help you be more productive
- Feature Articles, How-To Lessons...and much more in future issues
Let me know what you think at Feedback@SoftwarePro.com |
| A Note From Dawn | There are several reasons why it has been awhile since I've sent out an issue of the Smart & Easy Software Tips eMagazine. First, I'm proud to share that, earlier this year, I  became the first Colorado woman to be awarded the certification as a Microsoft Certified Application Specialist (MCAS) Instructor, which recognizes the highest level of mastery in Microsoft Office 2007. I joined an elite group of less than fifty Microsoft Certified Application Specialist (MCAS) Instructors across the United States and fewer than one hundred MCAS Instructors worldwide. >>Find out more Second, I've been busy with a increase in the number of speaking and training requests for Microsoft Office 2007. Even though this latest version for Windows was released almost 2 years ago, many organizations have delayed the change due to brand new file formats, a dramatically re-designed interface, concerns about lost productivity, and other factors. Are you moving to Microsoft Office 2007 in 2009? >>Explore your training options for Office 2007 to make this an easy move! |
|  | | | | Feature Article | How to Add a File Name to Your Word Documents
One of the frequent questions I hear about formatting Microsoft Word documents is "How  do I add an automatic file name and path to a file?" Think about how helpful this would be--files are often stored in many different folders and drives that can be challenging to manage. And how many times have you named a file with what seemed like a descriptive label, only to waste minutes or even hours trying to locate the document later? Now, with just a few steps, you can add a descriptive file name to a document header or footer. Another choice is to add the document file name at the end of the Word file to simplify filing and tracking. Sounds like a great idea? It is, if you could just find this non-intuitive, hidden option in Microsoft Word. Here are the smart and easy steps to add a file name to a Word document: - Move to the location where you want to see the file name and optional file path.
- In Word 2003 or earlier, go to Insert > Field...
-OR-
In Word 2007, click on the Insert tab and choose Field from the Quick Parts drop-down list (found in the Text group and shown below).
- Choose these options from the Field dialog box (which is essentially the same for all recent versions of Microsoft Word):
a. Categories = Document Information
b. Field name = FileName
c. Format is optional but includes a number of text displays.
d. To include the file path, also choose the option Add path to filename.
e. OK to add the field to your document.
Here's an example of the field results with a lowercase format:
c:\users\dawn\documents\office 2007 example files\chocolate.doc The filename field will automatically update if a file is saved with a new name or in a different location. Now, with just a few clicks, you can easily identify and locate files by adding the file name to your Word documents. |
Dawn Bjork Buzbee
The Software ProŽ |
| Tips & Tactics |  Quickly Create an Excel Chart
To create Excel charts (any version) with easy shortcut keys: - Select the data range you want to chart.
- Press [Alt] + [F1]* to create an embedded chart.
-OR-
Press [F11] to create a chart sheet.
In either case, a chart is automatically built using the default chart type which is usually a column type. - Format the layout and objects in the active chart or even change the chart type under the Chart menu (Excel 2003) or the contextual Chart Tools tabs (Excel 2007).
* In Excel 2007, be careful to press keys at the same time because of the expanded use of the [Alt] key. Fast Scrolling When I was teaching an Advanced Word 2007 class last week, I discovered that over half of the students (with years of document experience) didn't know this trick for quickly scrolling to a key location in a file or on the screen. Try it yourself and you may be using it every day! To quickly scroll onscreen in most Windows programs including Microsoft Office, Adobe Acrobat (and Reader), and Internet Explorer:  Right-click on the vertical scroll bar. - Left-click on location you want to move to, for instance, Bottom.
The size of the scroll box (the "elevator" on the vertical scroll bar) is usually proportional in size to the entire length of the display. This means that if the scroll box is only about 25% of the entire height of the scroll bar, then you are currently viewing only about 25% of the active file. You can use this information to decide where you want to move. As an example, to quickly navigate to the middle of a file or display: - Right-click on the vertical (or horizontal) scroll bar.
Point to the middle of the scroll bar and left-click on Scroll Here.
This tip also works on a horizontal scroll bar. By the way, to navigate to a more specific location such as a page in a Word document or an Excel worksheet cell, press [Ctrl] + G for GoTo. |
| Mouse Bytes | A client and friend recently sent me this video of computer humor. Let's see...I'm 50% Norwegian and often an IT Consultant...great when you need a humor break! |
| Latest Software Productivity Guide | Moving to Microsoft Office 2007 Tips, Tactics and Timesavers to Become More Productive with Microsoft Office 2007 
Top 5 Changes to the Microsoft Office interface How to customize Office 2007 Top Features in Word 2007, Excel 2007, PowerPoint 2007, Outlook 2007, and Access 2007 How to manage new Office 2007 file formats Time-saving tips & tricks for Office 2007...and more!
Now available in digital download format (PDF), printed full-color learning guide, or both! >>Find Out More |
| About Dawn | Dawn Bjork Buzbee is The Software ProŽ with over 24 years experience transforming geek speak into people friendly. A professional software speaker, trainer, consultant, and author, Dawn has helped more than 100,000 individuals to learn smart, easy, and productive ways to use software and technology more effectively.
Microsoft has awarded Dawn with the certification of Microsoft Certified Application Specialist (MCAS) Instructor for her expertise in Microsoft Office 2007 and Windows Vista. Dawn also holds the distinctions as a Certified Microsoft Office Expert and a Certified Microsoft Office Specialist Master Instructor with a proven track record in Microsoft Word, Excel, Outlook, PowerPoint, and Access. >>Find out more |
| |
|
|
>>Back to eMagazine Archives 
