Excel 2010 Basics
This course is designed for users to learn a basic understanding of Microsoft Excel. The File menu returns begin exploring the Backstage view environment. As well as all of the basics explore the improved Ribbon. Learn how to format and editing data in cells, working with columns and rows, printing functions and workbook views, and configuring page setup will be covered in this level 1 course.
Excel 2010 Level 2
Level 2 continues to build skills while working within workbooks. Formula and chart basics will be covered as well as copying worksheets, how to setup a workspace to view more than one workbook at a time, and basic formulas.
Analyzing Data Using PivotTables and PivotCharts
A PivotTable can quickly combine and compare data and enable you to select data in an interactive way. Each column of data becomes a field that can be used in a PivotTable. A PivotTable can automatically sort, count, and total the data from an Excel spreadsheet and create a second table displaying the summarized data. New features of 2010 include, ShowValues a way to try out several different calculations, six new calculations, and the ability to turn On or Off Visual totals.