AITVN's Training: DATA ANALYSIS AND PRESENTATION USING EXCEL

Asian Institute of Technology in Vietnam (AITVN) is pleased to announce the opening of the course:

DATA ANALYSIS AND PRESENTATION USING EXCEL (27-29/8/2015)

OBJECTIVES  

After the course, the participants will be able to:

  • use advanced Excel techniques to build sophisticated spreadsheets,
  • perform "what-if" analysis, apply statistical and financial functions,
  • manipulate PivotTables and OLAP cubes and present results to make better decisions for planning, budgeting and more.

TARGET PARTICIPANTS:

NGO officers, , managers, project leaders, analysts 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.

TOPICS

1. Introduction:

  • Data and data analysis
  • Role of Excel in data analysis and presentation
  • Installation of add-in functions
  • Data import/export.
  • Useful functions.

2. Data description and statistical tools

  • Descriptive and Inferential statistics
  • Data summary by statistical functions
  • Data summary by Histogram

3. Trend analysis and forecast

  • Forecast by available functions
  • Forecast by Analysis Toolpak

4. “What If” analysis using Scenario and Goal seek

  • Data analysis process
  • Data analysis modeling

5. Multi-dimension data analysis using Pivot Table

  • Pivot Table and Pivot Chart in data analysis
  • Data consolidation

6. Optimization analysis

  • Goal optimization in business management
  • Goal optimization modeling
  • Using SOLVER for goal optimization
  • Sensitive analysis

7. Introduction to Macro:

  • Create a macro
  • Apply macro for task automation

8. Display the Data

  • Data presentation in Excel
  • Data Presentation at other applications

TUITION FEE

The fee of 8.500.000 VND includes tuition fee, a set of materials in Vietnamese, refreshment during the training time.

TIME AND VENUE

Asian Institute of Technology in Vietnam (AITVN)
Hanoi: B3 building, University of Transport and Communications, Lang thuong, Dong Da

For further information and an application form, please contact:

Ms. Thu Dung
Tel. (04) 37669493; 37669391, ext 142; Fax. (04) 37669490 or Mobile: 0987037766
or Email: [email protected]