Course number: 084677
Course length: 1.0 day(s)
Certification: MOS: Microsoft Office Excel 2010 Exam 77–882, MOS: Microsoft Office Excel 2010 Expert Exam 77–888
Course Objective: You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.
Target Student: This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.
Prerequisites: Before starting this course, students are recommended to take the following Element K course or have equivalent knowledge: Microsoft® Office Excel® 2010: Level 1.
This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS and certification program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products.
For this course, you will need one computer for each student and the instructor. Each computer should have the following hardware configuration:
Each computer requires the following software:
Upon successful completion of this course, students will be able to:
Lesson 1: Calculating Data with Advanced Formulas
Lesson 2: Organizing Worksheet and Table Data
Lesson 3: Presenting Data Using Charts
Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
Lesson 5: Inserting Graphic Objects
Lesson 6: Customizing and Enhancing the Excel Environment
Appendix A: Microsoft Office Excel 2010 Exam 77–882Appendix B: Microsoft Office Excel 2010 Expert Exam 77–888
SKU | 084677SEB |
---|---|
Weight | 0.0000 |
Coming Soon | No |
Days of Training | 1 |
Audience | Student |
Product Family | Select |
Product Type | Digital Courseware |
Electronic | Yes |
ISBN | No |
Language | English |
Page Count | No |
Curriculum Library | Excel |
Year | 2010 |
Manufacturer's Product Code | No |
Current Revision | 1 |
---|---|
Revision Notes | No Revision Information Available |
Original Publication Date | 2012-01-02 00:00:00 |