Cancel/Close Window

>>Back to eMagazine Archives
>>Back to The Software Pro Home

software tips, tricks, tactics; Microsoft Office expert 
November 2009                                                                                             Issue #54
Greetings!   
snow, colorado, blizzardIn Colorado, we're finally starting to melt after a blizzard which dropped more than 2 feet of heavy snow at our home. If this keeps up, it could be a long winter!
 
Windows 7 is Here!
In the past few months, friends, colleagues, and clients have been asking me about Windows 7--is it better than Windows Vista? Should I wait to buy a new computer until Windows 7 is available? What's new? Learn more about the highlights of this latest version of Windows 7.
 
More Excel Shortcuts
Editing large Excel worksheets? Add new timesaving shortcuts to your bag of Excel tricks.

Moving to Microsoft Office 2007 Videos
Still struggling with Office 2007? What can you expect when you are upgraded to Microsoft Office 2007? My popular webinar series is now available as easy-to-follow training videos. Save weeks of frustration and take away timesaving tips, tactics, and techniques in these content-packed learning videos. Find out how to easily work with the new features in Office 2007 at www.Office2007Videos.com.

In This Issue
Feature Article-5 Great Improvements in Windows 7
Quick Tips & Tactics-Excel Shortcuts
Mouse Bytes
About Dawn
Forward this issue to a Friend
Quick Links
Contact The Software ProŽ

Book Dawn for your next meeting
 
 
Feature Article
windows75 Great Improvements in Windows 7
Did you know that even though Windows Vista was first released almost three years ago, 86% of corporate PCs continue to rely on Windows XP.* Vista offered a flashy new interface but its sluggish performance, nagging software, incompatibility with too many third-party peripherals and programs, and lack of compelling features kept most people sticking with the Windows XP operating system Microsoft launched in 2001, a lifetime ago in the tech world.

With such a weak acceptance to Vista, is the recent release of Windows 7 worth the wait? It's not revolutionary and it didn't have to be. It just needed to be better. Overall, Windows 7 appears to be the worthy successor to Windows XP that Vista never was. Putting aside glitzy effects, Windows 7 finally focuses on giving back control to the user with a practical, well-designed, and slightly faster upgrade over Vista. Let's look at some of the top features in Windows 7:

1. The Taskbar Gets a Facelift
The Windows Taskbar has been given a thorough makeover with larger, unlabeled icons for running programs replacing the old small icons and text labels. If you don't like it, you can shrink the icons and/or bring the labels back. Windows 7 eliminates Quick Launch which gives you one-click access to programs. Now, just drag an application's icon from the Start menu or desktop to the Taskbar, and Windows will pin it there so you can quickly launch a program without digging around the Start menu. You can also organize icons in the Taskbar by moving them to new positions.

In Windows Vista, hovering the mouse pointer over a program's Taskbar icon created a thumbnail window view known as a Live Preview. But when you have multiple windows open, you see only one preview at a time. Windows 7's version of this feature is better designed and more efficient: hover the pointer on an icon, and thumbnails of the windows slide into position above the Taskbar, so you can quickly find the one you're looking for.

2. The Convenience of Jump Lists
Right-clicking a program pinned to the Taskbar introduces you to Jump Lists, a menu of options that includes everything from Web sites you've recently visited to tasks appropriate to the application such as opening a document. Jump Lists have neat headers for recently-used documents, tasks, and other actions but you won't see the full value of the feature until these menus are written into other non-Microsoft software programs.

3. Snapping Windows
One small but extremely useful improvement in the Windows interface is the ability to snap windows to the left or right side of the desktop by either dragging them to the side or hitting the Windows key and one of the arrow keys. When snapped, a window takes up half the desktop. This slick feature makes comparing two windows easy. If you nudge a window into the top of the screen, it will maximize to fill all of the display's real estate. Another cool, fun, and useful feature is the Aero Shake feature which allows users to grab the title bar of a window and shake it back and forth, flinging all other open windows to the bottom of the screen, where they'll be minimized.

4. Grab Control of the System Tray
In the past, no feature of Windows generated more frustration than the System Tray (the area in the bottom-right corner of the Taskbar). New controls in Windows 7 prevent the System Tray from overflowing with unwanted programs and distracting you with unhelpful, irrelevant messages such as a prompt that you have unused icons on your desktop. It's easy to drag programs into the System Tray or out of it again so you enjoy complete control over which applications reside there.
 
In other areas as well, Windows Vista is notorious for pelting you with alerts, warnings, and requests. In Windows 7, system messages are collected in the new Action Center so you can respond to them on your schedule-not when Windows feels like interrupting you. With Windows 7, you also have more account controls to skip the constant prompts and screen dimming in Vista which angered many users and annoyed just about everyone else.

5. Reasonable Hardware Demands
In the past, new versions of Windows have required twice the amount of CPU power and RAM needed by their predecessors. But Windows 7 runs a bit better than Vista on the same system. It's even manageable on a netbook. Microsoft's official hardware configuration requirements of Windows 7 are nearly identical to those it recommends for Windows Vista: at minimum a 1-GHz CPU, 1 or 2 GB of RAM, 16 or 20 GB of free disk space, and high-end graphics. More power, however, is always better in the computing world and Windows 7 is no exception.
 
Upgrading to Windows 7 from Vista is straightforward; all you have to do is insert a disk and follow the on-screen steps. Unless you like tinkering with software and hardware, however, a move from Windows XP to Windows 7 is arduous and may be best saved for your next PC purchase. Once you upgrade, you'll find that Windows 7 not only corrects Vista's annoying and frustrating actions, but provides a more intuitive interface, stronger performance, and it's the upgrade we've been waiting for.
 
* Source: Forrester Research
To your success,
dawn signature 
Dawn Bjork Buzbee
The Software ProŽ 
Feedback@SoftwarePro.com
Quick Tips & Tactics 
quicktipsTimesaving [Ctrl]-key Tricks in Excel
TRICK #1: Speedy Navigation
When you press [Ctrl] and any arrow key (left, right, up, or down), you jump to the last "filled" or populated cell in that direction. This tip is a huge timesaver in worksheets packed with hundreds or thousands of rows of data. Bonus tip: Hold down the [Shift] key while also pressing any [Ctrl] + arrow key shortcut to select all the cells between where you started and where you jump with the [Ctrl] key.
 
TRICK #2: Non-contiguous selections
To select any cells in your Excel worksheet even if they aren't touching each other, just hold down the [Ctrl] key while you click on a cell or click and drag through a range of cells. As long as you hold down the [Ctrl] key, you can click and select as many cells as you want. Then, just follow-up with an editing or formatting action.
 
Moving to Microsoft Office 2007 VideosWord2007
Video training on Office 2007 to master the new Ribbon, manage the Office 2007 interface, and learn new features in each of the popular Office 2007 programs. Watch and learn from actual recordings from the popular webinar series on Moving to Microsoft Office 2007.
Find out more at: www.Office2007Videos.com.
 
office 2007, webinarsMoving to Microsoft Office 2007-Part 1
Office 2007 is the most significant update in over 10 years. Even though the core function of each program remains, the look and feel of Office 2007 is dramatically different. Familiar menus and toolbars are gone, a radical user interface was added, and well-known steps need to be re-learned.

In Part 1 explore (1 hour):

  • 5 key changes to the Microsoft Office 2007 interface
  • How to manage new file formats and file compatibility
  • Microsoft Office 2007 tips, tricks, and shortcuts
Find out more at Microsoft Office 2007 Videos.

Moving to Microsoft Office 2007-Part 2
Are your favorite commands in Office 2007 missing in action? Frustrated by new features and hidden commands? What improvements does Microsoft Office 2007 offer you in the programs you use every day? Even though the core function of each program remains, the look and feel of Office 2007 is dramatically different. In addition to a brand new user interface, a number of features in the top Office 2007 programs have been added or updated. What was changed and how can you easily take advantage of these improvements?

In Part 2 explore (1 hour):

  • Top New Features in Word 2007
  • Top New Features in Excel 2007
  • Top New Features in Outlook 2007
  • Top New Features in PowerPoint 2007
Grab your own learning videos at www.Office2007Videos.com.
Mouse Bytes 
geek, think geekThink Geek...or Just Have Some Fun! 
While working recently with a large IT department on their company Microsoft Office 2007 upgrade, I was reminded once again about the silly and even practical items found at www.ThinkGeek.com. As a long day of work wrapped up, a hilarious Nerf war broke out as several help desk techs fired foam darts across their cubicles. Perhaps I'll pick up a Doctor Who sonic screwdriver or a set of Star Trek tribbles to adorn my office (yes, I am a sci-fi nerd). ;-)
About Dawn
Dawn Bjork Buzbee is The Software ProŽ with over 25 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 certifications Microsoft Certified Trainer (MCT), Microsoft Office 2007 Master Instructor, and 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. Training and coaching is also available on many other popular desktop programs. 
>>Find out more
 

>>Back to eMagazine Archives
>>Back to The Software Pro Home