Summarizing and Analyzing Business Data using Pivot Table and Data Representation thru Excel Charts
Pivot Tables are powerful data analysis tools, yet most Excel users don’t use them to their fullestpotential. This class shows you why PivotTables are so versatile for Business data analysis andhow you can leverage PivotTables to rapidly spot trends and make fast business decisions onmountains of data.
Kindly contact Ms Kim Tan, at 019 2569053, or email firstname.lastname@example.org for reservation and details.
Microsoft Excel VBA Macro Programming
This course is designed for users new to Excel macros, with little or no programming experience. In this training, you will learn how to apply three basic constructs: sequence, selection and iteration, into your problems; and create VBA programs to interact with multiple worksheets and workbooks. Microsoft Excel VBA (Macro) is a programming language attached with Excel. It help you create automated spreadsheets for your repetitive tasks such as:
Participants enrolling in this course should have basics knowledge on Excel.
|Venue||:||Level 1, Menara PJ@AMCORP Petaling Jaya|
|Date||:||21st – 2nd September 2015|
|Time||:||9.00AM – 5.00PM|