Excel Semi-Pro
How to Use Microsoft Excel. Learn Online.
I recently saw a spreadsheet with the following function =LEFT(A2,8) where cell A2 was equal to 08/06/12 12:23 PM. The user was trying to extract the Date from the Date-Time value. The problem for me …
Continue Reading about Extract a Date from a Date-Time Number in Excel →
You can add an icon to the toolbar in Excel 2011 for your Personal Workbook Macro. In an earlier post I created a short macro to imitate the Control+Home keyboard shortcut in Excel for Windows. You …
Continue Reading about Add Macro Button to the Toolbar in Excel 2011 →
One of my all-time favorite keyboard shortcuts in Excel is CTRL+Home, but on a Mac there is no Home button. Hence a constant source of frustration these last two years. I finally decided to do …
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 read a good blog post over at Contextures about selecting the actual used range on an Excel sheet, both manually and with VBA. However, using Excel on a Mac makes you keenly aware that …
