the MOST

Data theft and identity theft often occur because someone left a computer logged on and walked away long enough for someone else to sit down and use their passwords. Here at the University of Texas, students, faculty and staff should lock their computers any time they step away from their computers. Many of us have [...]

[Read more →]

In Excel 2003 and earlier versions, when I tried to select a large block of data using my mouse, I would often overshoot, and accidentally select more rows than I meant to.  Then I would go back, and select too few.  I often had the same problem scrolling within a spreadsheet.  I would go too fast, [...]

[Read more →]

I can’t tell you how many times I’ve typed a few sentences, then realized that Caps Lock was on.  And then there are all the times I’ve typed a title in a document, then decided that I wanted to capitalize the first letter of every word.  In the past, I would retype the text, or [...]

[Read more →]

Last week I learned a really cool Excel keyboard shortcut I’d like to share with you.  It lets you enter an AutoSum function really fast.  Much faster than going to the ribbon and clicking on the AutoSum button.
Keyboard Shortcut:
Alt + =
Press Enter to complete the formula.
What it does:
Inserts the Sum function and guesses what you [...]

[Read more →]

This post is for all of you out there who love keyboard shortcuts.  This is also for anyone who thinks they might love keyboard shortcuts, if only they knew some.  Also for laptop users who hate the track pad and little button in the middle of the keyboard (I particularly dislike the button).  For those [...]

[Read more →]