Microsoft® Excel for Intermediate/Advance User

Date : 02/07/2019 - 03/07/2019
Time : 9:00 am - 5:00 pm
Location : The HUB @ Jaya One, PJ

Contact Person : Esther Yong
Email : inquiry@knowledgehub-asia.com
Mobile : +012-2662728
Office Tel : +603-7622 0578
Normal Rate : MYR 1,350.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

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