Microsoft Excel 2019 Advanced | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Microsoft Excel 2019 Advanced

Location

Format What’s this?
Starting From
RM 199.00
  1. 2 Days
  1. HRDF SBL Claimable
  2. Lunch & refreshment provided
  3. Certificate of Attendance available

All of our private classes are customized to your organization's needs.


Click on the button below to send us your details and you will be contacted shortly.

  1. 2 Days

Microsoft Excel 2019 Advanced

AUDIENCE

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.

PREREQUISITES

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

• Have attended Microsoft Excel – Foundation & 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


METHODOLOGY

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

COURSE OBJECTIVES

Upon completion of this program, participants should be able to:

• Create Subtotal Using the Subtotal Function

• Analyze data Using Pivot Tables

• Perform What If Analysis using:

o Goal Seek

o Solver

o Input Table

o 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


Expand All

Modules

Module 1: Getting Different Views on Your Data

Topic A: Outlining and Grouping Data

• Using Automatic Outlining
• Displaying and Collapsing Levels
• Grouping Data Manually
• Creating Subtotals

Module 2: Planning, Forecasting & Projection of Your Data

Topic A: Using Data Analysis Tools

• Using a One or Two Input Data Table

• Using Goal Seek


Topic B: Exploring Scenarios

• What is a Scenario?

• Creating a Scenario

• Saving Multiple Scenarios

• Creating a Scenario Summary Report


Topic C: Using Solver

• Understanding Solver

• Generating Reports and Scenarios with Solver

• Changing Solver Values

• Managing Solver Constraints

• Using Solver as a Goal Seek Tool


Module 3: Advanced Functions

Topic A: Working with Array Formulas

• What are Array Formulas?

• Using Functions within Array Formulas


Topic B: Using the LOOKUP Function

• Using VLOOKUP to Find Data

• Find Exact Match with VLOOKUP

• Find Closest Match with VLOOKUP

• Find with HLOOKUP


Topic C: Alternative LOOKUP Function

• Using the INDEX Function

• Using the MATCH Function

• Combining the MATCH and INDEX functions


Topic D: Linking, Consolidating, and Combining Data

• Linking Workbooks

• Consolidating Workbooks

• Combining Worksheets


Module 4: Present Data with Visual Report

Topic A: Create Combo Chart

• Comparing 2 Types of Values with high Variance

• Creating Combo Chart

• Editing Combo Chart


Module 5: Summarizing and Analyzing Data with PivotTable, Slicer and PivotCharts

Topic A: Create a PivotTable

• Create PivotTable Dialog Box

• PivotTable Fields Pane

• Summarize Data in a PivotTable

• Show Values as Functionality of a PivotTable

• Personalize the default PivotTable layout


Topic B: Filter Data by Using Slicer

• Slicers

• Insert Slicers Dialog Box


Topic C: Analyzing Data with PivotChart

• Creating PivotChart

• Editing a PivotChart


Module 6: Navigating Large Workbooks

Topic A: Customizing Workbooks

• Inserting Hyperlinks
• Editing Hyperlinks
• Formatting Hyperlinks
• Using Hyperlinks in Excel

Module 7: Macros

Topic A: Macros

• Recording Macros

• Saving to Macros Enabled Workbook

• Closing and Re-Opening a Macro Workbook

• Security Warning Message

• Playing a Macro

• Assigning a Keystroke to a Macro


Module 8: Prevent User Changes with Protection

Topic A: Protecting Worksheet and Workbook

• Protecting the Current Sheet

• Protecting an Entire Workbook

• File Protection


Azrulnizam Bin Ahmad

Azrulnizam Bin Ahmad

Azrulnizam Ahmad has been working in the business industry since 2004 and has been exposed to all the common challenges faced by business personnel. With his years of experience working with business and management, IT services and end users, he understands the importance of business value, infrastructure efficiency and user productivity.He shares his training passion in Microsoft Office 2007 Application - Excel, PowerPoint, and Word; Microsoft Office 2010 Application - Excel, PowerPoint, and Word and also emphasizes on the criticality of this aspect in any implementation.He is an energetic, independent, goal-oriented individual that has a high work standard and is committed to his work. He is also a good planner, is creative and resourceful, has great leadership charisma and works well with others. Read More

Jarina Muhamad Ismail

Jarina Muhamad Ismail

Since 2005, Jarina is involved in delivering learning programmes for Microsoft Excel, PowerPoint, Project, Outlook, Access, Word, Publisher and Visio. As a Microsoft Office Specialist (MOS) in all versions (2003-2013), she is using her expertise to provide timely solutions to the end-user which ranges from basic to advanced level including power users. She has experience in training and coaching various teams of professionals like executives, engineers, managers and directors to organize, analyze, create report and present business data more efficiently.
Read More

Course Reviews

No Remarks

0

0 Ratings