Lynda - Excel 2007 Essential Training
Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.
Table of Contents
Introduction1. Getting Started2. Setting Up Excel 20073. Modifying Worksheets4. Basic Formatting5. Advanced Formatting6. Using Templates, Styles, and AutoFormat7. Managing Lists in Excel8. Reviewing Worksheets9. Sharing Worksheets10. Printing Workbooks11. Enhancing Worksheets12. Using Templates13. Manipulating the Screen Display14. Importing Data15. Finding and Replacing Data16. Working with Formulas17. Working with Basic Functions18. Working with Advanced Functions19. Charts20. Pivot Tables21. Working with Macros22. Workflow in Excel 2007Conclusion
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.