Phân tích và trình bày dữ liệu bằng Excel

Trong khóa học này, học viên có cơ hội sử dụng các kỹ thuật tiên tiến của Excel để xây dựng các bảng tính phức tạp.

03/07/2018 tại TP. HCM
hoặc 24/07/2018 tại Hà Nội

2 days


Hanoi: Building B3, University of Transport and Communications, Lang Thuong, Dong Da, Hanoi; HCMC: 45 Dinh Tien Hoang Street, Ben Nghe Ward, District 1   View map


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.


  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.