Microsoft Excel For Office Productivity Public Class @ Subang, Selangor

Microsoft Excel For Office Productivity Public Class @ Subang, Selangor

MS Excel for Business Productivity


This 2 days course is practical, solution-based, dealing with real-life business situations and problems Excel users come across frequently in their jobs.

Learn to design your worksheet by maximizing the power of Excel’s rich function and its features. You will learn to utilize some of the most powerful features such as macros, Pivot tables, PowerPivot, and PowerQuery.

When you can generate faster, dynamic and accurate reports, it means your company can respond faster to the ever-changing business environment, improving work productivity and efficiency.

If you are a company owner or a professional looking to enhance your performance or increase your employability and career prospects, then Excel is truly one of the best productivity tools to master. Microsoft Excel skills are in high demand among businesses, as the increased availability of information means that effective data analysis is essential to stay competitive.

Learning how to use Excel effectively is a really smart career move.


Learning Objective:

By the end of the MS Excel for Business Productivity training, you will bring home the following advanced skills:

  • Understand and applying Excel Advanced functions and formulas for various job function
  • Create and modify static charts and dynamic charts.
  • Analyze data using Pivot Tables and Pivot Charts
  • Data cleansing technique using PowerQuery
  • Work with different worksheets and multiple workbooks
  • Export data with just a click instead of several clicks
  • The fastest way to export data in PDF format


This is not a beginning level class. Participants should know how to create file, folder in Windows Operating System. They should already have at least 1-year current experience working with Excel such as using SUM, AVERAGE, COUNT, MAX, MIN.


For course outline, please download the PDF file below. Thank you.

Microsoft Excel For Office Productivity
Microsoft Excel For Office Productivity
898.2 KiB