Date : 26/02/2020 - 27/02/2020
Time : 9:00 am - 5:00 pm
Location : The HUB @ Jaya One, PJ-old
Contact Person : Esther Yong
Email : inquiry@knowledgehub-asia.com
Mobile : +012-2662728
Office Tel : +603-7622 0578
Normal Rate : MYR 1,300.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.comContact Person : Esther Yong
Mobile : +012-2662728
Office Tel : +603-7622 0578