Lynda.com Access and Excel 2010 New Features - QUASAR | 197 MB Gender: eleaning
In Excel 2010 New Features author Bob Flisser demonstrates the powerful new characteristics and capabilities in Excel 2010. This course covers Excel's Backstage view, improved sharing and collaboration capabilities, its graphics features, and enhanced data analysis and visualization tools. Exercise files accompany the course.
Topics include: * Using the Slicer feature for dynamic PivotTable filtering * Sharing workbooks via e-mail, the Excel Web App, and SharePoint * Using Paste Preview for more effecient copying and pasting * Inserting Sparklines to see patterns in data * Taking advantage of enhancements to the Conditional Formatting feature * Analyzing data from multiple sources using the PowerPivot for Excel add-in * Maintaining file compatibility with older versions