Takeaway: Finding and fixing errors in formulas and functions can be tedious and time-consuming. Here are some practical tips to help you cut to the chase.
By Susan Harkins February 7, 2012, 8:09 AM PST
Takeaway: Show users how to open the most recently used file when launching Word. Or, provide them with a shortcut that does the same thing.
Some of us begin most work sessions opening the last file we were working with. When this is the case, users can save a few keystrokes by opening the most recently used file when they launch Word. Fortunately, doing so is simpler than you might think - just flip a switch.
To launch Word with the most recently used file, do the following:
By Susan Harkins
January 27, 2012, 6:42 AM PST
Takeaway: When you just need to see matching values and you don’t want to filter or sort, try this Excel keyboard trick.
There are numerous ways to find matching data in an Excel sheet. Filters are probably the most versatile. Sorting is probably the easiest way, but even that’s unnecessary if all you want to do is review matching values. In other words, if you don’t need the values rearranged or filtered, there’s a quicker way. Excel offers a keyboard shortcut trick that’s quick to implement and easy to remember.
By Brien Posey January 12, 2012, 12:56 PM PST
Takeaway: Before you take a new laptop on the road, make sure it’s correctly configured, secured, and provisioned to meet your needs.