Monthly Archives: May 2012

Excel charts 101

Excel is used for numbers, lots of numbers. But if you want to get a message across quickly, a chart is a great way to do it! We are going to start with a small range of data, but this … Continue reading

Posted in Office

Deleting blank rows in Excel

There are several ways to delete blank rows in Excel. Let’s start with some sample data with two blank rows. Please notice that there is “extra stuff” to the right and the rows are not sorted by store number on … Continue reading

Posted in Office

Excel and named ranges

Named ranges are a way to reference groups of cells by a single name, rather than beginning and ending cells. This can help you when entering formulas or navigating a large worksheet. The range below can be referenced as A1:D5. … Continue reading

Posted in Office

Selecting text in Word

There are many ways to select text in Word, some using the mouse and some using the keyboard. Below are some tips for using the mouse to grab just the text you want. Double click on a word selects a … Continue reading

Posted in Office