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 wrote a post stating that I could not find the Windows Ctrl+Home keyboard shortcut equivalent on a Mac. Well I'm here to tell you that I found the keyboard shortcut combination that does the same …
Continue Reading about Where is Control+Home for Excel on a Mac →
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 …
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 →
