Agile Experts Meetup GroupAgile and Project Management Experts LinkedIn GroupeConsulting Group YouTube Videos
DAE5001 - DATA ANALYSIS FOR FINANCIAL MANAGERS USING EXCEL

DAE5001 - DATA ANALYSIS FOR FINANCIAL MANAGERS USING EXCEL

Duration: 4 days
Price: $1,399.00
32 PDUs (3.2 CEUs), 32 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

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

West Suburbs Location:
1415 West 22nd Street, Tower Floor
Oak Brook, IL 60523

North Suburbs Location:
Deerfield Corporate 500
500 Lake Cook Road | Suite 350
Deerfield, IL 60015

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