eConsulting Group, Inc.eConsulting Group YouTube VideoseConsulting Group on FacebookAgile Experts Meetup GroupAgile and Project Management Training and Consulting Experts in LinkedIn
MOS5004 - Comprehensive Microsoft Excel 2010 Training

MOS5004 - Comprehensive Microsoft Excel 2010 Training

Duration: 3 days
Price: $1156.11

Description

In this course, the participant will be introduced to the more advanced features of Microsoft Excel 2010. The participant will learn how to manage, filter and generate reports from Excel data. The course also shows the participant how to summarize and analyze data using tools such as Pivot Tables, Scenarios and Goal Seek. Additionally, participants will learn how to create macros to automate some repetitive tasks, as well as how to protect worksheets and workbooks. At the end of the course, the participant will be able to demonstrate the ability to manage and analyze data efficiently with Microsoft Excel 2010.

Learning Objectives

• Using Conditional and Custom Formats
• Using Templates
• Working with Databases
• Working with Advanced Filters
• Revising Charting Features
• Creating/Revising PivotTables
• Using Auditing Tools and Range Names
• Exporting and Importing Data
• Using Advanced Functions
• Using Scenarios
• Using Worksheet Protection
• Tracking and Merging Workbooks
• Recording Macros
• Comments

Method of Delivery

• Onsite/Live class instructions or Online web seminar
• Lectures
• Open discussion
• Case studies
• Surveys

eCG Logo XS

Chicago Downtown Location:
20 N. Wacker Dr. Suite 1200
Chicago, IL 60606

Direct: +1 (312) 804-9992
Office: +1 (312) 804-0772
Fax: +1 (312) 803-2223
Toll Free: (866) 482 8275

E-mail: info@ecgmn.com

 

All names and logos are registered trademarks of their respective owners.

eConsulting Group®, Agile Expert™, Business Analyst Expert™, Database Management Expert™, Hands On Project Management™, Healthcare IT Expert™, Human Resource Expert™, Link2Task™, Link2Project™, Management Expert™, Network Security Expert™, Office Management Expert™, Programming Expert™, Project Book™, Project Management Expert™, Project Management Specialist™, Project Manager Master Level™, Project2Market™, Renewable Energy Management Expert™, Six Sigma Expert™, Social Media Expert™, We Build Project Managers™, and Web Development Expert™ are registered certificates and trademarks of eConsulting Group, Inc.

PMI-ACP, PMI, CAPM, PMP, Project Management Professional, and PMBOK® Guide are registered marks of the Project Management Institute, Inc.

GI Bill® is a registered trademark of the U.S. Department of Veterans Affairs (VA). More information about education benefits offered by VA is available at the official U.S. government Web site at https://www.benefits.va.gov/gibill.

Copyright © 2019 eConsulting Group, Inc. All Rights Reserved. Please read our Privacy Policy.

Search