Excel 2010 - Advanced Level

Full Day: In this course you will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Streamlining Workflow
•    Create a Macro
•    Edit a Macro
•    Apply Conditional Formatting
•    Add Data Validation Criteria
•    Update a Workbook’s Properties
•    Modify Excel’s Default Settings

Collaborating with Others
•    Protect Files
•    Share a Workbook
•    Set Revision Tracking
•    Review Tracked Revisions
•    Merge Workbooks
•    Administer Digital Signatures
•    Restrict Document Access

Auditing Worksheets
•    Trace Cells
•    Troubleshoot Errors in Formulas
•    Troubleshoot Invalid Data and Formulas
•    Watch and Evaluate Formulas
•    Create a Data List Outline

Analyzing Data
•    Create a Trendline
•    Create Scenarios
•    Perform What-If-Analysis
•    Perform Statistical Analysis with the Analysis ToolPak

Working with Multiple Workbooks
•    Create a Workspace
•    Consolidate Data
•    Link Cells in Different Workbooks
•    Edit Links

Importing and Exporting Data
• Export Excel Data
• Import a Delimited Text File

Using Excel with the Web
•    Publish a Worksheet to the Web
•    Import Data from the Web
•    Create a Web Query

Download this outline as a PDF.

Safe Home Connections, a division of KidsTerrain, Inc. assists individuals with the option to age in place, that is, to live in one's home while having access to services and support as needs change.

To learn more about Safe Home Connections services and support, visit our web site or Contact our Certified Aging-In Place Specialist for more information.

What Our Clients Are Saying...

[The trainer]had a great handle on the information . . . Good structure to the presentation… Excellent examples…very impressed by the instructor. She brought a lot of insight into her presentation. I found this class very helpful and I am very glad that I came…well worth it. ~ City of Waltham (condensed)

We Are SDO Certified!

WorkTerrain, through its parent company KidsTerrain, has received certification from the Commonwealth Supplier Diversity Office (SDO). This is a vitally important designation for companies, organizations, and agencies that want to establish business relationships with women-owned business vendors. Read more about SDO...

Keep Up-To-Date On The Latest News From WorkTerrain

Submit your e-mail address (see the banner above) to receive notifications of free webinars, vital news, and more. At WorkTerrain we respect your privacy. Your e-mail address will not be shared and you may unsubscribe at any time.

Click Here to preview our FREE informational program

Webinars -- A 21st Century Business Tool
Discover how this cost-effective technology can help your business or organization.

---------------

Interested in On-Site Training?
About Our Trainers

---------------

Interested in Internet-Based Webinar Programs?

Webinars are multi-media programs that enable you to view a presentation, lecture, or seminar from the comfort of your office or home. Available 24/7 via the Internet, webinars are an effective alternative to on-site presentations.

Webinars in our library are just 15.00!

Achieve Your Goals

Bullying In The Workplace

Finding Your Value: The Art Of Self-Promotion