Excel Semi-Pro
How to Use Microsoft Excel. Learn Online.
The other day I was reading a post over at the Contextures blog about Dynamic Dependent Excel Drop Downs and realized that using an Excel Table would provide an alternative method that is both simple …
Continue Reading about A Dynamic Dependent Drop Down List in Excel →
I'll review each hard-to-find item on the Ribbon's Home Tab in Excel 2010 (Windows) and let you know where they are located in Excel 2011 (Mac). I've even got some nifty pictures to speed along that …
Continue Reading about Ribbon Home Tab Comparison – Excel 2010 Windows and 2011 Mac →
The Mini Toolbar is nice to have when you need to do basic formatting and the Home tab is not displayed. Introduced in Excel 2007 and available in Excel 2010, the Mini Toolbar appears above the …
Add a one-click Freeze Panes command to the Quick Access Toolbar in Excel 2010 and 2007. This command icon is conveniently hidden from the Ribbon and is named Freeze Sheet Panes. In a previous post …
Continue Reading about Add Freeze Sheet Panes to the Quick Access Toolbar →
Excel 2010 and 2007 for Windows have the option to import data from the web. Excel for Mac users don't. An integral part of working with Excel is using keyboard shortcuts. They make your life so …
I always thought the F4 key was used to Repeat the last command, and the keyboard shortcut Ctrl+Y was used to activate the Redo command. I don't use Redo very much, but the keyboard shortcut Ctrl+Z …
Continue Reading about Redo and Repeat Commands in Excel [Updated] →
