Finding your way around Excel 2007
November 16th, 2007 by
Jared Bothwell
For anyone that has made the move from Office 2003 to Office 2007 you will be aware of the mind shift the 2007 interface requires. While it took me a good month to find my way around Excel 2007 what I did find handy was this little tip card.
What the tip card does is make finding yourself around the ribbon that much easier. Personally I love the new office look. I spend a large amount of time working with Excel and have found that Excel 2007 has made my life a lot easier. There are some great new functions and the pivot tables are fantastic.
I was surprised to find that MS Query has not been updated and the pre-existing bugs from 2003 are still there. I suppose not many people use MS Query but for those that don’t know MS Query and Excel and create some pretty cool database and reporting functions.
Posted in Ideas | 2 Comments »
August 28th, 2009 at 4:47 am
Jared
Tip card is great – I’m sure that Excel 2007 will be fantastic eventually but it sucks when you first use it!
Another very useful but little known tip that I use all the time is Ctrl[ (open square bracket) - this takes you to the first source in the formula, even opening up another workbook if it is linked. Ctrl] takes you to cells that use the cell you are in but doesn’t work so well as several cells can be involved. Hope that this will repay your link to the tip card in some small way.
Best wishes
John
August 28th, 2009 at 9:18 am
Thanks for the tip John,