Excel Semi-Pro
How to Use Microsoft Excel. Learn Online.
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 →
This article shows you how to make a drop down list in excel. It provides two ways for you to quickly and easily make drop down lists in an Excel spreadsheet. You can follow the instructions to …
Continue Reading about The Drop Down Basics: How to Make a Drop Down List in Excel →
Excel's great for displaying data and even better at crunching numbers. Here's how to add cells in Excel to sum up totals automatically... Even when you change the numbers. A great feature that …
Continue Reading about How to Add Cells in Excel to Sum Up Totals Automatically →
Knowing how to merge cells in Excel is a crucial skill. Although it may not seem like necessary information, it can be more useful than you might think. Get the most out of your Excel user …
Continue Reading about How to Merge Cells in Excel (and Split Them) for Better Layouts →
SUMIF and SUMIFS help Excel users to save time and frustration by making it easy to glean valuable information from complex datasets. You can total and analyze everything from grade values to …
Continue Reading about How to Use the SUMIF and SUMIFS Functions in Excel →
