MOS5003 - Advanced Microsoft Excel 2010 Training
Duration: 1 day
Price: $226.69
Description
One of the most important Excel features is Pivot Tables. This course covers creating Pivot Tables as well as using calculated fields and filters. You will learn to connect to external data sources such as Access and web queries. You will learn to use lookup functions and data tables to allow more sophisticated data conversion functions. This course will also show how to record and execute simple macros. This course is designed for students who need to use Pivot Tables and more advanced functions in Microsoft® Office Excel® 2010
Learning Objectives
• Working with Advanced Functions
• Analyzing Data
• Working with Data
• Creating and Working with PivotTables
• Enhancing PivotTables
• Working with Data Analysis Tools
• Working with Macros
Method of Delivery
• Onsite/Live class instructions or Online web seminar
• Lectures
• Open discussion
• Case studies
• Surveys
Chicago Downtown Location:
20 N. Wacker Dr. Suite 1200
Chicago, IL 60606
Direct: +1 (312) 804-9992
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.