Microsoft Excel articles
Formulas are those wonderful features in Excel that do all the work for folks like me who are not all that adept dealing with numbers. Am I OK letting the program do that work for me? Heck yeah! Follow the steps below to allow Excel …
Do not ask me why, but some users find the Paste icon to be distracting when they are working on an Excel worksheet. It does not bother me but to each his own! Should you be one of those folks it does bother, as was …
I do not claim to be an expert in Excel, but I do like to learn about it and use it when warranted. As such, it behooves me to try to keep abreast of what is going on in the world of Excel. In that …
Say you have a large Excel Worksheet and you need to be able to quickly access rows that are buried way down. Fortunately, there is a built-in method to accomplish this task. Follow the steps below to learn how: Press F5 which will display the …
I have been working from home for the last three weeks for which I feel very lucky. Even when working from home, my boss still needs projects done and turned in on time. I was recently given the task of creating a PowerPoint presentation for …
Most know how to use a spreadsheet to do basic operations like add, subtract, multiply, and divide. We know some basic functions like =SUM and =AVERAGE. These simple operations are good for lots of useful spreadsheets. We can keep track of our checking account, track …
As a former programmer, I use the term “Julian Date” to mean any serial date integer from any arbitrary beginning, but usually from the beginning of the 20th century. The Excel date code uses 1/1/1900 as the starting date as does Google Sheets. The date …
As you may already know, in Excel, you are able to add shapes, images, objects, photos, etc. to your worksheet. The issue is that at times these items can be hidden or can overlap each other so that you are unable to see/find them. There …
Have you ever had the need to update a worksheet using data that you found online? Well if you have, you can now end the agony of repeatedly navigating to the web page, copying the data and then pasting it into Excel. Now you can …
How To Import, Refresh Data From The Web In Excel Read More »
Yes, of course, you can use the Chart Wizard to create your chart, but there are some occasions when going through even the Wizard seems too long. So if you feel the need for speed, this tip is for you! Follow the steps below to …
For most folks entering content into an Excel worksheet is a common task. Below are keyboard shortcuts that will automate some of these chores. You might know some of them, but I bet you will find some that you were not aware of! CTRL + …
Charting data entered into an Excel spreadsheet does not have to be a complicated procedure. This article shows you step-by-step how to make that happen. First, we will create a simple worksheet and add some random data. Then we will create a quick chart of …
Columns of names in a spreadsheet are often entered as full names (first and last). This works great for mailing labels where the complete name is used. It is not convenient when only the first or last name is needed, like when you need to …
You can create a simple list for your users to select from in your worksheet. This will greatly reduce errors because you are limiting input from the user’s keyboard and makes things quick and easy for them as well. Everyone loves quick and easy, right? …
