Advanced Microsoft Excel

Overview

If you work within an office, then there is a good chance that you will need to use Microsoft Excel daily. This is particularly true if your role has elements of finance, accounts, or bookkeeping involved. The more features calculation or computation data capabilities aspects your role entails, the more skills you will require in Excel, with many companies asking their employees to show Advanced skills in Microsoft Excel.

Having employees skillful in Excel features including calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications, they will have the ability to calculate, organize, and evaluate quantitative data, allowing managers and senior staff to have the information they need to make important decisions that can affect the company. They can better present their information to upper management. It is also a critical skill for employees hoping to climb to the top themselves.

This training program will offer an in-depth tutorial of all the formulas and functions trainees must master to become well equipped with some of the more specialized and advanced capabilities of Excel including the ability to produce graphs and tables, use spreadsheets efficiently, perform calculations of large volumes of data, apply advanced analysis techniques to more complex data sets, and collaborating on worksheets with others.

Objective

This training program aims to enable spreadsheet and worksheet users who are already performing professional work to become more proficient users of and gain a more detailed understanding of advanced features and learn how to utilize the tools effectively for daily Microsoft Excel-related tasks. As a result, upon completion of this training program, the trainees are expected to have the ability to:

  • Practice advanced functions and formulas
  • Use data validation tools, conditional formatting tools and data tools effectively
  • Organize and manage worksheets through data management tool function effectively
  • Practice a calculation, and then test that result against a required figure or value using Logical functions
  • Organize worksheet and table data using Data Analysis and Reporting Techniques
  • Create table, bar chart, line chart, and pie chart.

Content

This training program will offer an in-depth tutorial of all the formulas and functions trainees must master to become well-equipped with some of the more specialized and advanced capabilities of Excel including the ability to produce graphs and tables, use spreadsheets efficiently, perform calculations of large volumes of data, apply advanced analysis techniques to more complex data sets, and collaborating on worksheets with others. Specifically, our training will cover the most important 6 modules:

  • Module 1: Overview of Excel
  • Module 2: Data Validation
  • Module 3: Data Management
  • Module 4: Logical Function
  • Module 5: Data Analysis and Reporting
  • Module 6: Data Presentation and Interpretation

Who should Attend?

This course will benefit Excel users with extensive knowledge of basic Excel skills and anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level. Specifically, this course is perfect for:

  • Sales and marketing professionals
  • accounting and finance professionals
  • Data Analysts
  • Business Analysts
  • supervisors/leaders/managers who are using Excel applications to speed up their tasks.

Trainer's Profile

He is currently working as a M&E Consultant for a reputable sustainable economic development and human development organization in Cambodia. His role involves in developing and updating the M&E system, including M&E plans, data flow, data management, data analysis, and reporting.

Fee Charged

The course fee is USD 270.00. It is inclusive of course materials, handouts, meals, refreshments, and certificates of completion but do exclude 10% of VAT amount.

We are offering an early bird registration fee to anyone who registers earlier. Interested participants or companies are encouraged to view the course details and early bird registration deadline. For further details on early bird fee, please find following:

USD 230 (Register before 17 May 2024)
USD 250 (Register before 24 May 2024)