
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.
.
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