Microsoft Excel 2010 Advanced: Working with Tables

Product Rating
Not yet rated
File Type
Compressed Zip File
Be sure that you have an application to open this file type before downloading and/or purchasing.
How to unzip files.
17.49 MB   |   35 pages

PRODUCT DESCRIPTION

This lesson teaches how to create and format Tables in Microsoft Excel 2010.

UPDATED: Now includes copies of the completed Excel spreadsheets!

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
35
Answer Key
Included
Teaching Duration
30 Minutes

Average Ratings

N/A
Overall Quality:
N/A
Accuracy:
N/A
Practicality:
N/A
Thoroughness:
N/A
Creativity:
N/A
Clarity:
N/A
Total:
0 ratings
COMMENTS AND RATINGS:
Please log in to post a question.
PRODUCT QUESTIONS AND ANSWERS:
$2.00
Digital Download
ADD ONE TO CART
User Rating: 3.9/4.0
 (61 Followers)
$2.00
Digital Download
ADD ONE TO CART
Microsoft Excel 2010 Advanced: Working with Tables
Microsoft Excel 2010 Advanced: Working with Tables
Microsoft Excel 2010 Advanced: Working with Tables
Microsoft Excel 2010 Advanced: Working with Tables