This has been a pensive and exciting summer for SET Consulting. We are in no rush to grow but are steadily building an infrastructure so that we can respond to the needs of our clients as more business develops. Some of our most recent news:
We’re fortunate enough to participate in a large-scale Office XP training program. In September, SET will personally train over 250 employees from a major government agency in such cities as New Orleans, Sacramento, Buffalo, and Houston!
We’re still writing! Keep your eyes peeled for an article titled “Being Productive Online” which will likely appear in the Daily Record...
One of the most frequently performed tasks in Excel is to repeat a summation or formula down a column or across a row. While there are numerous keyboard shortcuts that correspond to the various fill commands, this little trick presents an easier and more visual alternative.
After having entered a formula or value into a cell, click on the cell so that it appears outlined. Then, move your mouse cursor over the bottom-right corner of the cell, so that the thick white cross cursor turns into a thin black cross. Click on this cell-corner and drag the cursor in any direction. This will automatically populate the cells you drag over with the relative formula, saving you the trouble of retyping or cutting-and-pasting!
If you have trouble with this trick, be sure that your Excel is configured for this behavior. In the Tools menu, choose Options. In the dialog box, click on the Edit tab. Be sure that “Allow cell drag and drop” is checked.
While companies like Symantec and Network Associates deserve the most credit this month for their quick responses to the many recent virus threats, I shouldn’t have to mention how important it is to keep your antivirus software current. Instead, I’ll focus on an application that offers a great deal of convenience: AvantGo. AvantGo provides Pocket PC and Palm users handy access to news, magazines, special interest publications, and even flight schedules. Better yet, it’s a free service that nearly anyone with a personal digital assistant (PDA) can use.
Anytime you’re in a waiting area or have a free moment, it’s nice to have the daily paper in your pocket. AvantGo makes this possible by incorporating itself into your regular PDA synchronizations. To add AvantGo to your portable organizer, visit www.avantgo.com. You’ll never regret it!
©2017 SET Consulting, Inc. All Rights Reserved.