Microsoft Excel articles
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?
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?
Have you ever wanted to print a large poster, but you only have a standard printer? In the past, I would take a flash drive to one of the local Office Supply stores and have them print it for me. But that is an expensive
Two-Line Custom Formats Excel is very flexible in how it will allow you to set up custom formats for displaying all manner of values. Most custom formats are straightforward and easy to figure out once you have an understanding of how custom formats work. Suppose
