Excel Semi-Pro
How to Use Microsoft Excel. Learn Online.
Those wondering how to create a drop down list in Excel will be relieved to know that it is easier than it sounds. As you may already know, drop down lists make data entry a breeze. For example, if …
Continue Reading about How to Create a Drop Down List in Excel with Data Validation →
Recently I was asked how to subtract time in Excel (time difference) or how to calculate the number of hours between two points in time on different days. Since this was in a reader comment, I gave a …
Continue Reading about How To Calculate Hours Between Two Dates in Excel →
In this article, I will show you how to remove duplicates in Excel. While having duplicate data can be useful sometimes, it can also make it more difficult to understand your data. I’ll use …
Continue Reading about How to Remove Duplicates in Excel: An Easy Guide →
One of Excel’s most important features is the ability it gives users to quickly and easily sort through data. With this said, learning how to alphabetize in Excel is critical. If you are not familiar …
Continue Reading about How to Alphabetize in Excel: Fast & Simple →
When working with Excel spreadsheets, it can be difficult to extract the information you need from large sets of data. Pivot Tables (pv table) offer a great way to quickly condense and analyze, and …
Continue Reading about Pivot Tables (PV Table): Everything You Need to Know →
I have a worksheet that tracks start and stop times for different events throughout the day, all during the week. Sometimes I have to pull out the Time of Day, irrespective of the Date, with the TIME …
Continue Reading about Extract Time from a Date-Time Number in Excel →
