Excel Semi-Pro
How to Use Microsoft Excel. Learn Online.
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 →
I sold my 15" MacBook Pro yesterday and am waiting on a 21.5" iMac to arrive in 2-3 weeks. So no more adventures with Excel 2011 for a bit. Time to dust off the Dell desktop and reacquaint myself …
I received a comment asking if a dynamic dependent drop-down list in Excel could have a list where the "table headers were actually rows and not columns?" Since I've already detailed how this is done …
Continue Reading about A Dynamic Dependent Drop Down List with a Horizontal Table Reference →
I avoid the use of Volatile Functions, especially OFFSET, which is commonly used to update a list or range. They can slow down the operation of your workbook. For very large workbooks with lots of …
Continue Reading about How to Update a List or Range without OFFSET →
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] →
I bought a MacBook Pro and installed Windows 7 with Boot Camp Assistant so I could access the "normal" Excel. This was important to me at the time because I was doing Excel development work in …
Continue Reading about An Excel Crossroads – Mac and Windows →
