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 are
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, the
I have just posted my first class on Udemy: Excel Basics: Learn While Creating a Personal Budget. It is a course for those new to Excel beginners or those that want to fill in some gaps. This is a project-based course that takes you through creating a personal yearly budget.
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.
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-eyed
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 what
(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 format
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 of
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,”
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 you