Register as Member or Log In To View Our Class Modules Log In | Register

MOF 014- Excel Mastery: Pivot Tables, Charts & Formulas, 28 April 2026

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Microsoft Excel course will equip participant with hands-on knowledge to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.  In addition, Microsoft Excel Pivot Table and Dashboard Reporting course, participant will gain the widely sought after skills necessary to effectively analyze large sets of data.  Once the data has been analyzed, clean and prepared for presentation, participant will learn how to present the data in an interactive dashboard report.  It also enhance participant understanding  to view the differences in a big very set of information, making it crucial for organizing large amounts of data quickly.

 

.

Show More

What Will You Learn?

  • This course introduces participants to the Intermediate levels of Microsoft Excel. Participant will learn the skills work with functions for reporting, analyze data, customize workbooks, manage themes and create pivot table and use pivot function for reporting. They will learn how to manage their data working with tables, sorting, and filtering, highlight important data using conditional formats. At the end of the course, the participant will be able to demonstrate the ability to perform complex calculation and manage data efficiently with Microsoft Excel.

Course Content

DAY 1

  • MODULE 1 : INTRODUCTION TO MICROSOFT EXCEL
  • MODULE 2 : EXCEL BASIC FORMULAS
  • MODULE 3 : DATA VALIDATION IN EXCEL
  • MODULE 4 : HOW TO CREATE CHARTS IN EXCEL
  • MODULE 5 : EXCEL FUNCTIONS
  • MODULE 6 : INSERTING GRAPHICS
  • MODULE 7 : BASIC MACRO
  • MODULE 8 : PIVOT TABLE

Student Ratings & Reviews

No Review Yet
No Review Yet