Conejo Valley Adult School- fall, 2014 Microsoft Excel 2010: Comprehensive Course Syllabus Instructor: Erik Amerikaner Course Description Microsoft Excel 2010: Level 2 covers intermediate Microsoft Excel skills. Intermediate topics covered include formatting worksheets, importing web data, sorting worksheet rows, freezing headings, and more. Level 3 covers advanced Microsoft Excel skills. Advanced topics covered include locking/unlocking cells, PivotTables and PivotCharts, PMT and FV functions, grouping worksheets, trendlines, creating shared workbooks, tracking changes, Windows Live SkyDrive, and integration with other Office applications. Class Meetings We will have 8 class meetings from Sept 10- October 29. The class meets from 5:30 pm—8:30 pm. Course Objectives By the end of this course, you will be able to:              Create a variety of different types of charts Sort worksheet rows Create formulas Sort data using various specifications Insert and modify pictures on worksheets Protect workbooks and worksheet content Create PivotTables and PivotCharts Create what-if models in the Scenario Manager Use text functions to reformat data Group worksheets Manage and print comments in workbooks Share workbooks using Windows Live SkyDrive Integrate Excel with other Office applications Work Standards    Please arrive on time for each class meeting. The second class meeting will begin with a review of topics covered during the first day. Please notify me if you must leave early for any class session. Follow the ground rules of the course. Ground Rules    Two-minute Rule: When you work at the computer, don’t struggle with a task that is not working for more than two minutes before asking for help. NDQ Rule: There are no dumb questions in our classroom. All questions are welcome. Interruption Rule: Interruptions are welcome. Feel free to raise your hand to ask a question at any time. Contact Information You can send me email at [email protected] Course Materials Will be hosted at www.erikamerikaner.com Students will need to complete exercises and online reviews from home. Course Schedule 9/10/14 9/17/2014 9/24/2014 Course Text 10/01/2014   10/08/2014 Titles: Microsoft Excel 2010: Level 2 and Level 3 Publisher: Labyrinth Learning The http://labyrinthelab.com/excel10 web page provides various links for students. Students can access the following: Student exercise files Lesson overview presentations (saved in PDF) 10/15/2014 10/22/2014 10/29/2014 WORKING WITH LARGE WORKSHEETS MANAGING MULTIPLE-SHEET WORKBOOKS CREATING TABLES AND OUTLINES ADDING GRAPHICS TO WORKSHEETS CREATING PIVOTTABLES AND MACROS USING FINANCIAL FUNCTIONS AND DATA ANALYSIS APPLYING ADVANCED FUNCTIONS AND AUDITING USING ADVANCED FORMATTING AND ANALYSIS TOOLS