Course Description
What You'll Learn
- Compare Excel 2010's features with the older Excel 2007 version, including basic feature additions and corrections
- Explore new features that support general productivity and business presentations and calculations
- Use new tools such as enhanced photo editing, paste preview, conditional formatting, charting improvements, sparklines, and slicers for PivotTables
- Apply improved functions and work with PivotTables and PowerPivot
- Manage files using the File button, saving options, AutoRecover, recent workbooks, and Protected View
- Share Excel work and access Excel material through the Web using the Excel Web Application
Key Takeaways
- Excel 2010 introduces new and enhanced features compared with the older Excel 2007 version, including basic feature additions and corrections.
- The course covers features designed to help with general productivity and to assist in making business presentations and calculations.
- New tools include enhanced photo editing, new paste preview, conditional formatting, charting improvements, sparklines, slicers for PivotTables, improved functions, and PowerPivot.
- File-handling capabilities covered include saving options, AutoRecover, getting workbook information, working with recent workbooks, Protected View, and customizing the Ribbon.
- Excel 2010 lets you share your work and access Excel material through the Web via the Excel Web Application.
Frequently Asked Questions
What does this Excel 2010 course cover?
It covers the new and enhanced features of Microsoft Excel 2010, comparing them with the older 2007 version, exploring features for general productivity and for business presentations and calculations, and learning how to share Excel work and access Excel material through the Web.
Does the course compare Excel 2010 with earlier versions?
Yes. It begins by comparing Excel 2010's features with the older Excel 2007 version, including basic feature additions and corrections, and covers Compatibility.
What new productivity and analysis features will I learn about?
You will learn about enhanced photo editing tools, new paste preview, conditional formatting, charting improvements, sparklines, slicers for PivotTables, improved functions, PivotTables and PowerPivot, and adding hyperlinks.
Can I share my Excel work and access it online with Excel 2010?
Yes. The course teaches how to use new features to share your Excel work and access Excel material through the Web, including the Excel Web Application.
What skills does this course help build?
It supports skills in Microsoft Excel, Excel Formulas, Excel Macros, Excel Services, Excel Solver, and Microsoft Office Specialist (MOS) - Excel.
