Corporate Frontier Services

Email

info@cfrontier.com

Call Us

+6 088 731 570

Follow us :

MICROSOFT EXCEL ADVANCED LEVEL, 14 - 15 May 2025_Kuching

INTRODUCTION

Microsoft Excel is one of the most widely used spreadsheet and data management programs in organisations today. An understanding of Excel can be a critical factor in being able to carry out a variety of responsibilities.

Over the next two days, this course on Advanced Functions and Data Handling focuses on advanced Excel techniques designed to elevate data management, analysis, and automation skills. Building on a solid foundation of intermediate Excel concepts, it explores advanced functions, data transformation, and visualization.

Through practical, hands-on sessions, participants will optimize workflows, manage complex data sets, and present insights with precision and impact. Each module is designed to provide essential tools for streamlining daily tasks and making confident, data-driven decisions.

This Course Include

CONTACT INFORMATION

COURSE OBJECTIVES

  • Recall advanced Excel functions, including logical, lookup, array, and date/time functions.
  • Identify key features of tools such as PivotTables, Power Query, and Solver. Create Dashboard Report
  • Create dynamic PivotTables, PivotCharts, and specialized charts for professional reporting.
  • Evaluate automation solutions such as macros for improving efficiency in repetitive tasks.