Agile Experts Meetup GroupAgile and Project Management Experts LinkedIn GroupeConsulting Group YouTube Videos
DAE5008 - Data Analysis using Excel Training

DAE5008 - Data Analysis using Excel Training

Duration: 5 days
Price: $1,599.00
40 PDUs, 40 CPEs

Requirements
Associate degree, or global equivalent, plus 1-3 years of information and management systems experience.

Description
Many of us struggle to make sense of all the data that is available in this information age. With such a deluge of reports and statistics which don’t mean anything or can’t be made sense of, it’s no wonder that data is often misinterpreted or not communicated at all. Learn how to synthesise information into a logical framework, summarise it into a meaningful format, and then display the summary into easy-to-read tables and graphs. Covering dashboard reporting, balanced scorecards, visual design of charts and tables, we will also discuss the new charting and analysis features of Excel. This course is very hands-on and practical. Each participant will be expected to create their own reports, charts and models utilising the tools and techniques covered during the course.

Learning Objectives

• Appreciate some of the frequently used functions in Excel
• Working with conditional structures and related functions
• Exploring the various components of Pivot Tables and Charts
• Building interactive dashboards
• Exploring Financial functions of MS Excel
• Understanding co-relation of financial data and forecast related values

Who Should Attend

Managers, team leaders, supervisors and functional managers.

Method of Delivery
• Onsite/Live class instructions or Online web conference
• Lectures
• Open discussion
• Case studies
• Surveys

eCG Logo XS

 
 

eConsulting Group, Inc.
20 N. Wacker Dr. Suite 1200
Chicago, IL 60606, USA

Direct: +1 (312) 804-9992
Office: +1 (312) 804-0772
Fax: +1 (312) 803-2223
Toll Free: (866) IT 2 TASK

E-mail: info@ecgmn.com
Web: www.ecgmn.com

All logos are registered marks of their respective owners.

eConsulting Group®, Agile Expert™, Business Analyst Expert™, Database Management Expert™, Hands On Project Management™, Health Care IT Expert™, Healthcare IT Expert™, Human Resource Expert™, Link2Project™, Link2Task™, 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.

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

Search