Microsoft Excel for Intermediate-Advance User

Microsoft Excel for Intermediate/Advance User Microsoft Excel for Intermediate/Advance User
By Knowledge Hub Asia
Course Title:
Microsoft® Excel for Intermediate/Advance User
Training Category:
Information Technology
Target Audience:
This course is designed for clerks, officers, executives and managers of all level, and personnel who want to learn more in-depth knowledge, and practical uses of Microsoft Excel. Duration:
2 Days
Public Program* Now Available! »
Feb 2020 ›
The Hub, Jaya One, Petaling Jaya, Malaysia
Wed 26 Feb 2020 - Thu 27 Feb 2020
9:00AM - 5:00PM

Fee Per Person:
Additional fee for bank charges and currency exchange will be imposed for payment made by foreign currency.
  • Please call for Discounts & Promotions.
Register Now!

* Other terms & conditions apply.
For In-house Training »
Request for Quotation Request for Quotation
For Customization & Other Inquiries »
Contact Knowledge Hub Asia
Contact customer service +6012-266-2728
Email customer service
Delivery Methods
  • Language: English
  • PowerPoint Presentation
  • Workshop
  • Presentation Handouts
  • Computer Lab Work
  • Certificate of Participation
Ad by Google
*Terms & Conditions
Microsoft Excel Training Series:

Microsoft® Excel for Intermediate/Advance User

“Move your Microsoft Excel skills to the next level with this intermediate and advance Microsoft Excel course!”

By Knowledge Hub Asia

PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Register for Public TrainingRegister for Public Training
Email Customer Service Contact Customer Service+6012-266-2728


Microsoft Excel provides you with the relevant tools to transform data into formatted and meaningful information. It also allows you to generate great business reports, graph and charts for business analysis and presentation. It is an essential tool for today business. If you already have the basics of Microsoft Excel, this course will help bringing you to the next level for greater efficiency and productivity.

Course Objectives

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

  • Outline and Group Data
  • Work with PivotTables
  • Hyperlink Excel and The Internet
  • Creating and Using Shared Workbooks
  • Work with Visual Basic and Macros
  • Perform Advanced File Management
  • Customize Excel and Use Excel With Other Programs

Course Outline


Unit 1: Outlining And Grouping Your Data

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

Unit 2: Pivot Tables

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

Unit 3: More On Pivot Tables

  • Modifying Pivot Table Calculations
  • Formatting A Pivot Table
  • Refreshing A Pivot Table
  • Charting A Pivot Table
  • Creating A Pivot Table Based On Data From
  • An External Database

Unit 4: What If Analysis

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

Unit 5: Hyperlink Excel and The Internet

  • Hyperlinks And The Internet
  • Inserting Hyperlinks
  • Modifying Hyperlinks
  • Using The Web Toolbar
  • Browsing Hyperlinks In Excel


Unit 6: Creating and Using Shared Workbooks

  • Sharing A Workbook
  • Requesting Reviews
  • Reviewing A Workbook
  • Tracking Changes
  • Merging And Revising A Shared Workbook

Unit 7: Visual Basic And Macros

  • Adding Code To Your Macro
  • Adding Comments To VBA Code
  • Declaring Variables
  • Prompting For User Input
  • Iteration Over A Range
  • Using If Then Else Statements

Unit 8: Advanced File Management

  • Identifying File Properties
  • Searching For Files
  • Protecting Personal Information
  • Creating Back Up Files
  • Changing Auto-Recovery Settings

Unit 9: Custom And Advanced Features In Excel

  • Customizing Excel By Changing Options
  • Using Custom Auto-Fill Lists
  • What Is Text To Speech?
  • Using Detect And Repair

Unit 10: Using Excel With Other Programs

  • Using Excel In Word
  • Inserting Excel Data In Word
  • Modifying Excel Data After Insertion

For In-house Training:

Request for Quotation

Request for Quotation Now

For Content Customization & Other Inquiries:

Contact Knowledge Hub Asia

Contact Customer Service


Email Customer Service

Ad by Google

Related Training Courses:

More Other Training Courses:

Published by: ,
Contact Us

"Hi, I'm your Contact Assistant! I'll help you to reach the right party for the right information. Click me to get started!"

Contact Assistant