The following are descriptions for the MS Excel 2010 classes we currently offer. Please note that clicking on the registration links will open a new window and take you to our online registration system. Please be sure to disable any pop-up blockers you might have running to complete our registration process.
Microsoft Excel 2010 – Level 1
Analyze, manage, and share data of all kinds using Microsoft® Office Excel. The Level 1 class (full course outline) provides all the basics for creating and editing basic worksheets and workbooks. Students will explore the Microsoft® Excel 2010 environment and create a basic worksheet, perform calculations, modify and format worksheets and manage large workbooks.
Microsoft Excel 2010 – Level 2
In the Level 2 class apply visual elements and advanced formulas to a worksheet to display data in various formats. Learn to calculate with advanced formulas, organize worksheet and table data using various techniques, create and modify charts, analyze data using PivotTables and PivotCharts, insert graphic objects.
Microsoft Excel 2010 – Level 3
In the Level 3 class you will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, and share Excel data with other applications. Students will create and edit macros, apply conditional formatting and validation criteria, set revision tracking, audit worksheets, analyze data using trendlines, scenarios and what-if analysis.
Microsoft Excel PivotTables
In this class students will create and analyze PivotTable data. Upon successful completion of this course, students will be able to: build a PivotTable; analyze data using PivotTables; present PivotTable data visually.