Microsoft Excel Training > Microsoft Excel Data Analysis and Pivot Table

Microsoft Excel Data Analysis and Pivot Table

Course Objectives

PivotTable and PivotCharts
Useful formulas
Conditional Formatting
Working with Charts
Working with Sparklines
Analytical Tools
Macro

Target Audience

Managers
Executives
Training Coordinator
Training Officer
HR Officer
Vocational Education Trainer
Lecturer
Tutor
Corporate Trainer
Instructors
Team Leaders
Supervisors in organization who wish to provide structured training and conduct relevant and fair assessment in their organization so as to achieve PEAK PERFORMANCE

Methodology

To ensure your success in this course, it is recommended that you have completed Microsoft Excel – Managing Data and Large Workbooks or possess equivalent knowledge. Microsoft Excel 2013 and above.

Course Modules

Lesson 1 : PivotTables and PivotCharts
Lesson 2 : Useful Functions
Lesson 3 : Conditional Formatting
Lesson 4 : Working with Charts
Lesson 5 : Working with Sparklines
Lesson 6 : Analytical Tools
Lesson 7 : Macros

Get To Know The Trainer

Trainer Gobinath

4.5

Gobi is an experienced Microsoft Office Trainer, specializing in the Microsoft Office 2010, 2013 and 2016.With over 10 years’ experience in the IT Industry he has experience in Hardware and software support, Software Design & Development, Project Management and Microsoft Office Training. He designs and delivers Microsoft Office training through open courses and bespoke inhouse courses for public and private companies across a number of industry sectors.

VIEW PROFILE