This course provides students with the knowledge and skills to use the features and functions of Microsoft Office Excel PivotTable to accomplish analysis tasks. Furthermore, the power of Microsoft Excel is further enhanced when we use Formulas together with graphics. This course combines the usage of PivotTable together with Formulas and several Graphical Tools to create a highly interactive and analytical Excel Dashboard report which allows dynamic data filtering and live updates.
Date: 12th & 13th February 2020
Venue: Benchmark Electronics (M) Sdn. Bhd., Bayan Lepas, Penang
Course Objectives:
Upon completion of this program, participants should be able to:
Make Data work for you
Manipulating the PivotTable
Digging Deeper
Beyond the Basics
More PivotTable Calculations
Optional Topics.
Insert Graphics to provide a visual view of a PivotTable.
Insert Visual Filtering tools to create an interactive Dashboard report.
Use Formulas to further analyse and enhance the Dashboard.
Pre-requisites:
Have attended Microsoft Excel Level 3 (Advanced), Formulas & Functions, PivotTable OR able to:
Inserting and Deleting Worksheets, Rows, Columns and Cells.
Perform Cell Formatting and AutoFill.
Perform Mathematical calculations – Addition, Subtraction, Multiplication and Division.
Perform basic Functions – SUM, AVERAGE, COUNT, MAX and MIN.
Freeze Cell references.
Perform Named Range.
Create and format a PivotTable.
Create and format a Chart.
Who Should Attend:
This course is intended for users of Microsoft Office Excel who want to learn about the features of PivotTable. This course suitable for Microsoft Excel users who frequently perform data crunching, analysis and graphical reports such as Sales and Production; as well as users who wish to enhance their Excel Knowledge.
Training Methodology:
This program will be conducted through interactive lectures, practical exercises and group assignments.
Feel free to contact TSY Consultancy by Call / WhatsApp to +6017-4036965 or email to marketing@tsy.my
Cheers.