Whoops! Something went wrong.

Click here to refresh the page

Microsoft Excel 2010 Advanced

Microsoft Excel 2010 Advanced
Product Description
This Guide teaches Advanced Microsoft Excel 2010.

In this program, you will prepare for certification, as you discover how to create, format, and secure professional and creative spreadsheets using Microsoft Excel 2010.


Other Recommended Microsoft Excel 2010 Sample Files (Not Included)
Microsoft Excel 2010 Beginning: Sample Files
Microsoft Excel 2010 Intermediate: Sample Files
Microsoft Excel 2010 Advanced: Sample Files

If you are interested in Microsoft Excel 2010, here are some links you may consider:
Microsoft Excel 2010 Beginning
Microsoft Excel 2010 Beginning: Hello Excel!
Microsoft Excel 2010 Beginning: It All Adds Up
Microsoft Excel 2010 Beginning: A Question of Balance
Microsoft Excel 2010 Beginning: Charts and Chart Tools

Microsoft Excel 2010 Intermediate
Microsoft Excel 2010 Intermediate: Legs, Eggs and Pigs
Microsoft Excel 2010 Intermediate: TEXT, DATE and FINANCIAL Formulas
Microsoft Excel 2010 Intermediate: Using Named Ranges
Microsoft Excel 2010 Intermediate: Using Lookup Tables
Microsoft Excel 2010 Intermediate: Online
Microsoft Excel 2010 Intermediate: In Print

Microsoft Excel 2010 Advanced
Microsoft Excel 2010 Advanced: Working with Tables
Microsoft Excel 2010 Advanced: PivotTables
Microsoft Excel 2010 Advanced: PivotCharts
Microsoft Excel 2010: Creating Forms


Looking for Microsoft Excel 2013?
Microsoft Excel 2013 Beginning
Microsoft Excel 2013 Intermediate
Microsoft Excel 2013 Advanced

Looking for Microsoft Excel 2007?
Microsoft Excel 2007 Beginning
Microsoft Excel 2007 Intermediate
Microsoft Excel 2007 Advanced

This course teaches the following Exam 77-888 Microsoft Excel Expert 2010 Objectives

1. Sharing and Maintaining Workbooks
1.1 Apply workbook settings, properties, and data options
1.2 Apply protection and sharing properties to workbooks and worksheets
1.3 Maintain shared workbooks
2. Applying Formulas and Functions
2.1 Audit formulas
2.2 Manipulate formulas options
2.3 Perform data summary tasks
2.4 Apply functions in formulas
3. Presenting Data Visually
3.1 Apply advanced chart features
3.2 Apply data analysis
3.3 Apply and manipulate PivotTables
3.4 Apply and manipulate PivotCharts
3.5 Demonstrate how to use the slicer
4. Working with Macros and Forms
4.1 Create and manipulate macros
4.2 Insert and manipulate form controls
.

Microsoft Approved Courseware: This course accurately and casually provides an introductory audience with an understanding of the needed information to pass the Microsoft Office Specialist Certification Series. Its uniqueness and accuracy of content stands out among other courseware, (Procert, November 2011)
Total Pages
297 pages
Answer Key
Included
Teaching Duration
1 month
Report this Resource
  • Comments & Ratings
  • Product Q & A
Loading...
$10.00
Digital Download
$10.00
Digital Download
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign up