Advanced Microsoft Excel

Course Objectives
This course aims to increase your productivity by providing the skills and knowledge to use Microsoft Excel 2010/13 effectively.
Course Duration
14 Hours (Part-time or Full-time available)
Who should attend
This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building and formatting simple workbooks.
Prerequisites
This course is designed for current Microsoft Excel users who can build basic workbooks. It is assumed that the users know how to create and save a workbook, create formulas and use functions, and perform simple formatting of the data.
Course Leader
Course Modules
Unit 1 Names Ranges
  • Define Name
  • Name Manager
  • Dynamic Name Range
Unit 2 Protecting Data
  • Lock Cells
  • Protect Sheet
Unit 3 Lookup & Reference Functions
  • VLookup and HLookup
  • Match
  • Index
  • Choose
Unit 4 Financial Functions
  • Pmt
  • Rate
  • Nper
  • Pv
  • Fv
Unit 5 Statistical Functions
  • Median, Mode, Standard deviation
  • Min, Max, Large, Small
  • Math & trig functions
  • Round, Roundup, Rounddown
Unit 6 If Function
  • If Function
  • AND and OR Function
Unit 7 Conditional Formatting
  • Highlight Cells Rules
  • Clear Rules
  • Top/Bottom Rules
Unit 8 Text Functions
  • Join Strings
  • Left
  • Right
  • Mid
  • Len
  • Find
  • Substitute
Unit 9 Data Validation
  • Create Validation Rule
  • Input Message
  • Error Alert
  • Data Validation Result
  • Reject Invalid Dates
  • Budget Limit
  • Prevent Duplicate Entries
  • Drop-down List
Unit 10 Creating A Worksheet Template Unit 11 Pivot Tables
  • Insert A Pivot Table
  • Two-dimensional Pivot Table
  • Multi-level Pivot Table
  • Multiple Report Filter Fields
UNIT 12 Tables
  • Insert a table
  • Format a table
  • Working with tables
  • Convert to a range
Unit 13 What If Analysis
  • Create a Different Scenarios
  • Goal Seek
  • Solver
  • Load the Solver Add-in
Unit 14 Group And Consolidate Worksheets
  • Group Worksheets
  • Consolidate
  • View Multiple Worksheets
Unit 15 Web Integration
  • How to run a Web Query
Unit 16 How To Insert Hyperlink In Excel

Unit 17 Sparklines
  • Insert Sparklines
  • Customize Sparklines

For further enquiries, please call us at +6 (06) 8500888.

SIGN-UP EARLY TO AVOID DISAPPOINTMENT!
Register NOW!


Registration can be made by filling and submitting the online form below or email us at hello@lccm.asia

Payment shall be made payable to LOGICA CENTRE OF COMPUTER & MANAGEMENT SDN BHD (AmBank Account Number: 212-201-200360-6)

Type of Course Registration
IndividualCorporate

PART A: For ALL Types of Course Registration:

Your Choice of Program (required)

I / We would like to register for the above choice of program for:
Public CourseIn-house CourseOne-to-one Intensive Program

Your Name (required)

Your Company/Organization

Address

Tel. No. (required)

Email (required)

PART B: For Corporate Registration ONLY:
Please fill in Approving Manager details for attendee(s) below.

Authorised By

No. of Delegates you want to register?

*Note: Payment can be made before or on the commencement date.

Terms & Conditions

Registration & Fees Policy:
Registration is confirmed once registration form is received via online form/email/mail. Letter of Approval (For Corporate Registration ONLY) must be made available and presented prior to the course.

Cancellation Policy:
Any cancellation must be received in writing within 5 working days prior to the event else full payment will be imposed. Any no-show by registered delegates will be liable for full payment of the program fees.