Microsoft Excel-Level 2

Overview
In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. In addition, this course helps prepare students who desire to prepare for the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.
Pre-requisite(s): Microsoft Excel - Level 1
Lesson 1: Creating and Applying Templates Create a Workbook from a Template Create a Custom TemplateWorking with CommentsCreate a HyperlinkUse Web-based Research Tools
Lesson 2: Creating and Modifying Charts Create a ChartFormat Chart ItemsChange the Chart TypeCreate a Diagram
Lesson 3: Working with Graphic Objects Insert GraphicsCreate AutoShapesFormat Graphic ObjectsChange the Order of Graphic Objects Group Graphic ObjectsMove, Copy, and Resize Graphic Objects
Lesson 4: Calculating with Advanced Formulas Create and Apply a Name for a Range of Cells Calculate Across WorksheetsCalculate with Date and Time Functions Calculate with Financial Functions Calculate with Statistical FunctionsCalculate with Lookup and Reference Functions Calculate with Logical Functions
Lesson 5: Sorting and Filtering Data Sort Data ListsFilter Data ListsCreate and Apply Advanced Filters Calculate with Database FunctionsAdd Subtotals to a Worksheet
Lesson 6: Using Excel with the Web Export Excel DataPublish a Worksheet to the Web Import Data from the Web Create a Web Query

"The web site is awesome!" 
Crystal Davis, CWP
The Manufacturers' Association
160 Roosevelt Avenue
York, PA 17401
(717) 843-3891
office@mascpa.org