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
We are no longer accepting registration for this event
MYR1,000.00