Skip to main content

Corporate Frontier Services

Microsoft Excel - Intermediate and Advanced Level, 26-27 August 2026_Kota Kinabalu

INTRODUCTION

Designed for those who are geared up to speed with Microsoft Excel but you would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets. This course is aimed at someone desiring to gain the skills necessary to learn advanced formulas, creating macros, using What If Analysis tools, create Pivot Tables and Pivot Charts, subtotaling and securing your data.

This Course Include

CONTACT INFORMATION

COURSE OBJECTIVES

  • Functions & formulas.
  • Database Management.
  • Pivot Tables & Charts.
  • Learn Conditional Formatting, Data Validation.
  • Audit worksheets.
  • Analyse and present Data through Sparklines.
  • Create Dashboard Report.

 

Pre-requisites:
Participants should be familiar with using computers and have used a mouse and keyboard. Participants should be comfortable in the Windows environment and be able to use Windows to manage information on their computer.

To get the most out of this course, we recommend completion of one of the following courses, or equivalent knowledge from another source: Windows 7 and above & Microsoft Excel 2019 Basic.