Excel Semi-Pro
How to Use Microsoft Excel. Learn Online.
This article consists of all the basics of how to make a scatter plot in Excel. By using this guide, you will be able to generate your own plots as well as format them and add design …
Continue Reading about Ready, Set, Scatter: How to Make a Scatter Plot in Excel →
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 →
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 →
I recently began using the NETWORKDAYS function in Excel 2007, yet my file was going to be widely used by people with Excel 2003 (both are Windows versions). The NETWORKDAYS function is a standard …
Continue Reading about Check the Analysis ToolPak Add-In in Excel 2003 [VBA Code] →
In one of my posts on using VBA to select a column of data, I received a comment asking if the macro could be modified to select data like the screen shot you see to the left. This data is …
Continue Reading about Select a Column of Non-Sequential Data →
The other day I read an article on how to prepare my MacBook Pro for Lion, the new Mac OS X coming out this month, and discovered that any application that requires PowerPC is incompatible with Lion …
Continue Reading about Microsoft Query Incompatible with Mac OS X Lion [Updated] →
