MS Excel Intermediate/Advance User

Date : 30/05/2016 - 31/05/2016
Time : 9:00 am - 5:00 pm
Location : Menara PKNS, Petaling Jaya, Malaysia

Contact Person : Esther Yong
Email : inquiry@knowledgehub-asia.com
Mobile : +012-2662728
Office Tel : +603-7622 0578
Normal Rate : MYR 950.00
Promotion Rate : Contact us for discounted rate.

Introduction

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

DAY 1

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

DAY 2

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 registration please Contact :

Email : inquiry@knowledgehub-asia.com
Contact Person : Esther Yong
Mobile : +012-2662728
Office Tel : +603-7622 0578