I have been teaching an online class for a couple of years now at a local community college. I have my students introduce themselves on our discussion board and I always have several students who are new to an online class. Of course, they express fears and concern. There areContinue Reading

Did You Know? A worksheet is organized into a grid of cells, which are formed by the intersection of rows and columns. Rows are identified by numbers. Row numbers can range from 1 to 1,048,576. Column labels are identified by letters and start with A to Z. After Z, theContinue Reading

Here is a great tip to save you some time when entering phone numbers into Excel. When entering a phone number into a cell, it is faster to just type the number without the dashes or parenthesis. You can format a cell to automatically format the phone number for you.Continue Reading

Excel. Chances are, that word alone stirs visions of lengthy spreadsheets and budgets with complicated formulas and charts. It is true—Excel has become the standard in offices for pretty much anything that requires management of large amounts of data. But, if you think Excel is only good for making you cross-eyedContinue Reading

My years working as an IT trainer, I’ve helped with many issues. One of the most common had to do with data entry and knowing what heading (column) the data was being added to.   My office had a conference table that could seat 4 people comfortably. I often had whatContinue Reading

(Excel versions from 2007 to current) When entering a phone number into a cell, it is faster to just type the number without the dashes or parenthesis. You can format a cell to automatically format the phone number for you. Excel provides a special number format that lets you formatContinue Reading

An active cell is outlined by a heavy border, which allows you to easily see where the cell is that is being worked with and where data will be entered. It can also be referred to as the current cell or selected cell. Why is this important to know? I have a couple ofContinue Reading

I was in Shannon’s office, sitting in her visitor’s chair across from her desk. She had requested a one-on-one Excel training session and I was waiting for her to finish up whatever she was working on currently. “I just need to get these last few numbers entered into our department budget,”Continue Reading

Microsoft Word has some nice shortcuts that are not well known. One of those is the Shift + F5 shortcut. Use this to cycle between your most recent edits. With a large document, Shift+F5 is handy to see what you have edited most recently. And, you can use it when youContinue Reading