January 2011
13 posts
Top 10 Excel Articles for 2010 →
A link to the most popular blog articles since starting Excel Semi-Pro in June of this year.
December 2010
12 posts
Vote for Excel Functions You Want Explained
Vote here for the Functions you want to see for: 30 Excel Functions in 30 Days coming January 2nd on the Contextures website.
Debra Dalgleish is putting together a 2011 Challenge in January to improve your skills with Excel functions. My wish is for her to explain the INDIRECT Function.
She has a list of Text, Information and Lookup and Reference functions you can vote on now to help her decide...
Debugging VBA →
Pearson has put together one great reference. I liked the fact you can execute code snippets in the VBA immediate window. Brilliant!
Check out his article and bookmark it.
Google Docs: Revisions in Spreadsheets →
A new feature for spreadsheets. Google Docs keeps getting better.
Excel Function Key Reference
Confusion abounds when going from Excel on a Windows machine to Excel on a Mac. Part of the problem is not knowing what the Function keys will do. Here’s a couple of links to help straighten things out.
Excel for Windows - Function Key Reference
Excel for Mac - Function Key Reference (click Function Keys after the jump)
You can find out more about Function Keys on the Mac by checking out...
How To: Printing Services Spreadsheet →
I ran across this article at Lifehacker:
Spreadsheet Tells You Whether to Print Photos at Home or Order Out
which takes you to the How-To Geek site, and this article:
Is Your Desktop Printer More Expensive Than Printing Services?
Last Day for Christmas Card Contest
Make a Christmas Card in Excel and you can win a $50 gift card. Details at Chandoo.org Contest is closes on 13th December Midnight Pacific Time.
Excel 2011 - Things They Forgot to Update
In some respects the new Excel 2011 either leaves out features or doesn’t upgrade them to current standards, i.e., Excel 2010. Here’s the list I started:
Status Bar Functions - Still back in the Excel 2003 era with only one function shown at a time
No Evaluate Formula dialog box !!!
What’s on your list?
Quickly Access Recent Workbooks
At the bottom of the Recent Workbooks jump list, Excel 2010 has an option that you can check to: Quickly access this number of Recent Workbooks: xx
Checking this box adds recent files to the left pane of the File Menu so you can always see the file names. Any files you have pinned to the top of the list will be at the top, even if they haven’t been opened in a while.
This is nice...
Drop-Down List Tip for Excel 2003 and 2008
The only way to have the source data for a cell-drop down list on another worksheet in Excel 2003 is to create a named range. In the Data Validation dialog box any reference to another worksheet range gets the following warning message.
You can put your values on the same worksheet, but mostly they tend to overcrowd the worksheet and its really much nicer if you stick all lookup values on...
Drop-Down List Change in Excel 2010 and 2011
Excel removed the requirement of having List Source data on the same worksheet for Data Validation in the newest versions of Excel, 2010 and 2011. The picture below shows a Data Validation dialog box from cell A2 on Worksheet 1, and you can see the Source reference for the List is on Worksheet 2.
Other Versions of Excel
Excel 2007 won’t let you select a data range on another sheet, but if...
Microsoft Equation in Excel
I found out today through a reader comment (by @Eric) in my Excel Semi-Pro blog, that there’s something called Microsoft Equation 3.0 that’s in Excel versions 2003, 2007, and 2010. It creates an embedded object and is different than the new Equation Editor in Excel 2010 and Word 2011, which I wrote a article about yesterday. I’ve never used this Microsoft Equation Editor 3.0...
