BE Eye June 2008
Tech Tips
for End Users
Using the Fill Handle (Excel)
Excel can auto-fill cells in very smart ways. Instead of manually typing a sequence in cells, you can simply type the first few values of the sequence and drag the fill handle to auto-fill the rest of the cells. If you only type in one value and drag the fill handle Excel will copy that value into the other cells. If there are multiple values Excel will use the pattern that has been established and complete it.
The fill handle is the small black square at the lower right corner of a selected cell. Drag it to automatically fill adjacent cells.
Status Bar Statistics (Excel 2007)
The status bar in Excel shows handy statistics when multiple cells are selected. In Excel 2007, the status bar shows the selected cells' average, count, and sum. This is an easy way to quickly analyze data without bothering with formulas. In this example we’re looking at the average daily high temperature in San Francisco during the end of June.
Moving and Copying Cells by Dragging Selection Borders (Excel 2007)
Excel provides the ability to move and copy cells by dragging selection borders.
 For instance, to move Rio de Janeiro to below Auckland (you might want to put all the cities in the Southern Hemisphere together) drag the selection border while holding down the Shift key in order to insert it in its new position. If you drag the border without holding down the Shift key, the selected cells will instead replace the cells you drop them on. Conversely, if you hold down Ctrl while dragging a selection border, the selected cells are copied to their new location.
BEI Announcements
Seminars
Back by popular demand, we have two seminars that were presented this past winter:
Spyware: Wednesday, 7/23 (to register, click here)
- How spyware operates, what it does and how it spreads
- Tips for avoiding it & how to educate your employees
- How to create/administer policies and not alienate your workforce!
- Overview of current solutions
Offsite Backups: Wednesday, 8/27 (to register, click here)
- Why look at offsite backups?
- What should you consider backing up offsite?
- Where should you go for offsite backups?
- How should you go about it?
(originally scheduled for 8/20, this seminar has been moved to 8/27)
Questions? – contact Ellen Jennings at 703-528-8300 x125 or ellen.jennings@beinetworks.com.
Microsoft Windows XP – Available
until 6.30.08
Microsoft Windows XP will not be available after June 30, 2008,
except as a downgrade from Windows Vista when the software is purchased
as part of Volume Licensing from Microsoft. Let us know if you have
questions about this.
Holiday Schedule – Independence Day
BEI will be closed on Independence Day, Friday, July 4. As always, our clients can reach us for emergency support during that time period.
|
