AIT
Alumni
Webmail

ONLINE STATISTICS

There were 2313175 page views
6 members are online
IEM12 - Data Analysis and Presentation using Excel
Start time 03/03/2016
Duration
3 days
Objectives
In today's fast-paced business climate, managers, project leaders, analysis and others need to make decisions quickly and more accurately than ever before. Microsoft Excel can be used to analyze business problems, identify solutions and make sound decisions to achieve a competitive advantage. 
In this course, participants use advanced Excel techniques to build sophisticated spreadsheets, learn to perform "what-if" analysis, apply statistical and financial functions, and manipulate Pivot Tables and OLAP cubes and present results to make better decisions for planning, budgeting and more.

Topic
Main topics in training course:
     1. Data description and statistical tools
     2. Histogram tool in Analysis Toolpak
     3. Data processing
        - Sorting in Custom list
        - Advance Filter
        - Conditional Formatting
        - Duplicated data ...    
     4. “What If” analysis using Scenario, Goal seek and Solver
     5. Multi-dimension data analysis using Pivot Table & Pivot Chart
     6. Data Validation
     7. Macro
     8. Protect in Excel, shortcuts...

Target Participants
This course is valuable for everyone who makes business analysis and decisions based on data. Experience with Excel at an introductory level is assumed.

Language
Vietnamese
Schedule
Ho Chi Minh City: 03-05 March 2016
    - Morning: 8:30 - 11:30
    - Afternoon: 13:30 - 16:30

Fee
The fee of 8.500.000 VND per participant includes tuition fee, a set of training materials, refreshment during the training time.

RESERVE YOUR PLACE TODAY!

  

Fee per delegate

EARLY BIRD RATE

Register and Pay on or before 18/2/2016

SPECIAL RATE

Alumni

NORMAL RATE

Register and Pay after 18/2/2016

Individuals

VND 7,650,000

VND 7,650,000

VND 8,500,000

Special Group Discount

Book a group of 3-4 delegates and pay per delegate

VND 7,650,000   

Book a group of 5 delegates and pay per delegate

VND 6,800,000   


Venue
Asian Institute of Technology in Vietnam (AIT-VN)
Hanoi: B3, University of Transportation and Communication, Lang Thuong, Dong Da
HCM: 6th floor, FCC Building, 45 Dinh Tien Hoang, Ben Nghe, District 1

Contact