How To Un-Pivot Your Data In Excel
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 […]
Microsoft Excel
Microsoft Excel articles
How To Quickly Navigate In Excel
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
How To Change Animation Timing In PowerPoint
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
How To Use Lookup In Excel
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
How To Work With Dates In Excel
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
How To View, Arrange, Hide Shapes In Excel
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
How To Import, Refresh Data From The Web In Excel
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 »
How To Create Super Fast Charts in Excel
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
13 Handy Excel Data Entry Shortcuts
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 +
How To Easily Create Excel Charts
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
How To Parse Names In Excel
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
How To Add A Drop-Down Box To A Cell
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?
How To Add A Drop-Down List To A Cell
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?
How To Print Posters In Excel
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