Live Virtual Training (Most Popular!) > Microsoft Excel 2019 Advance

Microsoft Excel 2019 Advance

Course Objectives

Create Subtotal Using the Subtotal Function
Analyze data Using Pivot Tables
Perform What If Analysis using:
Goal Seek
Solver
Input Table
Scenarios
Use VLOOKUP function to extract data
Nesting INDEX and MATCH Function
Combining & Consolidating Data
Summarizing & Analyzing with Pivot Table and Pivot Charts
Record and Run a Macro

Target Audience

Basic knowledge of Microsoft Excel is essential with the following pre-requisites:

Have attended Microsoft Excel – Foundation and Intermediate Level; OR
Able to switch between task applications
Able to create simple to complex formulas and functions
Able to validate data in a Worksheet
Able to apply Filter data using Auto & Advanced Filters
Able to clean Duplicate Records

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.

Course Modules

Module 1: Organize Summary and Details on Your Data

Topic A: Outlining and Grouping Data
Module 2: Planning, Forecasting & Projection of Your Data

Topic A: Using Data Analysis Tools
Topic B: Exploring Scenarios
Topic C: Using Solver
Topic D: Linking, Consolidating, and Combining Data
Module 4: Present Data with Visual Report
Topic A: Create Combo Chart
Module 5: Summarizing and Analyzing Data with PivotTable, Slicer and PivotCharts
Topic A: Create a PivotTable
Topic B: Filter Data by Using Slicer
Topic C: Analyzing Data with PivotChart
Module 6: Navigating Large Workbooks
Topic A: Customizing Workbooks
Module 7: Automate Task with Macros
Topic A: Macros
Module 8: Prevent User Changes with Protection
Topic A: Protecting Worksheet and Workbook

Get To Know The Trainer

Trainer Jarina

4.5

Managing and maintaining a Microsoft Windows Server 2003 Environment - educate the IT professionals who implement, manage, and troubleshoot existing network and system environments based on the Windows Server 2003 platform. Implementation responsibilities include installing and configuring parts of systems. Management responsibilities include administering and supporting systems

VIEW PROFILE

Trainer Shalina

4.5

Shalina has 20 years of experience in IT related fields including 11 years in conducting public courses. She specializes in Corporate IT infrastructure planning (networking, troubleshooting and system integration), conducts applications training programs such as Microsoft, Adobe, Lotus and COMPtia products as well as organizes and conducts exhibitions and seminars.

VIEW PROFILE

Trainer Slyvia

Sylvia has been in the IT Training Industry for the past 20 years She began her career as a Corporate Trainer and her personal areas of expertise are wide; encompassing Microsoft and Adobe applications. In addition to that; she also specializes in corporate coaching for government, multi-national companies to local SMEs

VIEW PROFILE

Trainer Izham

4.5

Izham has 14 years of teaching background with 4 years in the academic department of a public university followed by corporate clienteles in the later years. Since becoming a corporate trainer, Izham has been helping office workers all over cope with data and document volumes in digital form to become efficient and come out being smart office workers.

VIEW PROFILE

View more trainers