So many online tutorials - so little time. Here's a sifted list of some of the best I've been able to find. Let me know if you have other favorites (firstname.lastname@example.org). And here's some help if you'd just like to concentrate on new features,
Excel: Online Training and help
Microsoft has a lot of really good Web pages and videos to help ease into Excel 2007. Here's a pick-list:
- » If you know Excel XP or 2003 and get frustrated trying to find commands in 2007, you've got to try this Command Translator—from old (Office XP or 2003 to new (Office 2007): You pull down a menu on a screen from the old Excel, and it automatically changes into a Excel 2007 screen showing the new location. Use on the Web or download to your own (Windows) computer: http://tinyurl.com/2wwc59
- » Quick Reference Card: Guide to most-used features and links to demos and training, including some listed here:
- » Microsoft Excel 2007 Home page: Subject listing. Longer training modules with text, pictures and video segments arranged by topic. Mostly really well done.
- » What’s new in Excel 2007: A handy listing of help on many Excel 2007 features.
- » Guide to keyboard shortcuts: http://tinyurl.com/2u4mvz
- » Microsoft Excel Online Training: : http://tinyurl.com/25o9lg
Some other sources
Here are some of the best links I've been able to find:
- Quick Reference card: Packed with information on Excel 2007.
- The Excel 2007 site: http://www.msexcel07.com/
A table of contents that ranges from What's New through: The Ribbon, Mini Toolbars, Quick Access, Toolbar, Key Tips, Office Button, Styles, Themes, SmartArt, Format Painter, File Formats and more. Links to many videos (some done in a charming accent from the North of England).
- Florida Gulf Coast University: http://www.fgcu.edu/support/office2007/Excel/index.asp
Another Table-of Contents guide to virtually every aspect of Excel 2007.
- University of Wisconsin-Eau Claire: http://www.uwec.edu/HELP/excel07.htm
From basics through details of Charting, Managing multiple worksheets, etc.
- Excel 2007 Tips and Tricks for beginners and more advanced users. Uses Indian English....
- YouTube has many tutorial videos on the new versions of Excel - just search in the site.
More space, new interface
Excel's worksheet size is now 1 million rows by 16,000 columns. That's just for one sheet in a workbook, of course.
The biggest immediate change is the way the menu bar has dissolved into the Ribbon with individual tabs. The advantage of the tab system is that it displays commands that were hidden deep inside pulldown menus. Some of these newly exposed possibilities may help you do your work; most won't. I've pulled out some of the most commonly useful features in the New Features page.
And I've vetted the online resources on this page so that you can be sure that each one is really useful.
Here's how to type common International characters on a Windows PC or a Mac.