How to order our program online


Step 1) Register a new account
you can view your order history


Step 2) Browse our event listing &
select program you like


Step 3) Select Register Now
Or Enquiry for In-House


Step 4) Fill Up Information & Checkout
via Manual Bank Transfer (or) Ipay88 ipay88 coming soon

Microsoft Excel For Intermediate/Advance

MICROSOFT EXCEL INTERMEDIATE - 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

REQUIRED PREREQUISITES:

Basic knowledge of Microsoft Excel (Foundation & Intermediate) is essential with the follow pre-requisites:

  • Able to switch between task applications
  • Able to create a spreadsheet with simple formatting
  • Create a chart
  • Print a spreadsheet with headers and footers added
  • Insert, Delete and Rename a worksheet
  • Have attended Microsoft Excel – Foundation & Intermediate Level; OR
  • Able to switch between task applications
  • Print a spreadsheet with headers and footers added
  • Insert, Delete and Rename a worksheet
  • Able to perform SUMIF and COUNTIF Functions
  • Able to perform IF Functions
  • Able to perform NESTED Functions
  • Able To define And use Range Names
  • Able To use Auto And Advanced Filter

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

COURSE OBJECTIVES

  • Give participant a systematic understanding of a spreadsheet ad its benefits
  • Equip participant with essential skills of effectively utilizing spreadsheet software in a day-to-day business environment

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

  • Create simple to complex formulas and functions, like:
  • IF Functions
  • Nested Functions
  • Filter data using Auto & Advanced Filters
  • Using Excel with Other Programs
  • Create Subtotal Using The Subtotal Function
  • Analyze data Using Pivot Tables
  • Perform What If Analysis using:
  • Goal Seek
  • Solver
  • Input Table
  • Scenarios

COURSE OUTLINES

INTERMEDIATE (1 DAY)

Module 1 : Working With Functions And Formulas

Lessons 1.1  Working With Formulas And Functions

  • Understanding Relative and Absolute Cell References
  • Basic Mathematical Operators
  • Using Formulas with Multiple Cell References
  • The Formula Auditing Buttons
  • Fixing Formula Errors
  • Displaying and Printing Formulas

Lessons 1.2  Exploring Your Workbook

  • What are Functions?
  • Finding the Right Function
  • Some Useful and Simple Functions
  • Sum If, Count If

Lessons 1.3  Using Functions In Excel

  • Inserting Functions
  • Using Functions and AutoFill to Perform Difficult Calculations
  • Using the IF Function
  • Working with Nested Functions
  • If with And Functions
  • If with Or Function

Lessons 1.4  Working With Names And Ranges

  • What are Range Names?
  • Defining and using Range Names
  • Selecting Non-adjacent Ranges
  • Using AutoCalculate

Module 2 – Managing Tables

Lessons 2.1  Working With Tables

  • What is a Table?
  • Creating Tables
  • Modifying Tables
  • What is the Total Row?

Lessons 2.2 Working With Records And Fields

  • What are Records and Fields?
  • Adding Fields by Inserting Columns
  • Adding records by Inserting Rows
  • Quickly Adding Records to a Data Table
  • Deleting Records or Fields

Lessons 2.3  Working With Tables And Filters

  • Sorting Data in a Table
  • What is an AutoFilter?
  • Custom AutoFilters
  • Using an Advanced Filter
  • Copying Filtered Records

Lessons 2.4  Using Excel As A Database

  • Filtering with Wildcard Characters
  • Validating Your Data
  • What are Database Functions?

ADVANCED (1 DAY)

Module 1 : Getting The Most From Your Data

Lessons 1.1  Pivot Tables

  • What Is A Pivot Table?
  • Creating A Pivot Table
  • Creating A Pivot Table Frame
  • Specifying Pivot Table Data
  • Rearranging Pivot Table Data

Lessons 1.2  More On Pivot Tables

  • Modifying Pivot Table Calculations
  • Formatting A Pivot Table
  • Refreshing A Pivot Table
  • Charting A Pivot Table

Lessons 1.3  Exploring Scenarios

  • What Is A Scenario?
  • Creating A Scenario
  • Creating A Scenario Summary Report
  • Saving Multiple Scenarios

Lessons 1.4  What If Analysis

  • Using A One And Two Input Data Table
  • Using Goal Seek
  • Using Solver

Lessons 1.5  Excel And Internet

  • Excel and Hyperlinks
  • What is a Hyperlink?
  • Inserting Hyperlinks
  • Modifying Hyperlinks
  • Using Hyperlinks in Excel

Module 2 : Advanced Excel Task

Lessons 2.1  Using The VLOOKUP Function

  • Using VLOOKUP to Find Data
  • How to find an Exact Match with VLOOKUP
  • Finding the Closest Match with VLOOKUP

Lessons 2.2  Linking, Consolidating And Combining Workbooks

  • Linking Workbooks
  • Consolidating Workbooks
  • Combining Worksheets

Event Properties

Date 01-23-2020
Event End Date 01-24-2020
Individual Price MYR1,000.00
Venue
Pathway Learning Centre, Taman Equine
Taman Equine, 43300 Seri Kembangan, Selangor, Malaysia Taman Equine, Selangor 43300 Malaysia
Pathway Learning Centre, Taman Equine
MYR1,000.00