Using Excel Formulas and Functions in Business Analysis 2017-09-15T14:04:43+00:00

Project Description

Loading...
Welkin Course Code: XL0F

Course Features

This course will expand your understanding and use of Excel by focusing on the techniques that help you build useful worksheet formulas and enhance spreadsheet functionality with the right functions.

  • Filtering Table Data

  • Excel’s Table Functions

  • Building PivotTables

  • Creating Custom PivotTable Calculations

  • Using What-If Analysis

  • Working with Goal Seek

  • Using Multiple Regression Analysis

  • Using Solver

Learn from the Experts

Get Professional Recognition

mos-certificate

Certify your Excel skills with Microsoft Office Specialist Excel certification. The certification is not a requirement for course completion but we highly recommend you to get your skills professionally recognized.

Remark: The course fee does not include the certification exam.

Further Study

After completing this course you may further develop your knowledge and skills with the CEF reimbursable course Financial Modeling with Excel VBA.

Course Fee

$960

Course Duration

6 Hours

Course Prerequisites

Course participants are expected to have a basic knowledge of Microsoft Excel.

Title of Award

Upon successful completion of the course, students will receive a Certificate of Achievement for the course.

Schedule & Online Enrolment
Enquiry/Booking
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
XL0F-12C20C
 Central
 Cantonese / PC
27/11~28/11
1900-22006 hrs/
2 sessions
MON, TUE960.00
XL0F-45C21K
 Mongkok
 Cantonese / PC
21/12~28/12
1900-22006 hrs/
2 sessions
THU960.00
XL0F-6A6C
 Central
 Cantonese / PC
6/1~13/1
1000-13006 hrs/
2 sessions
SAT960.00
XL0F-6A3K
 Mongkok
 Cantonese / PC
3/2~10/2
1000-13006 hrs/
2 sessions
SAT960.00
XL0F-24C20C
 Central
 Cantonese / PC
20/2~22/2
1900-22006 hrs/
2 sessions
TUE, THU960.00
XL0F-12C19K
 Mongkok
 Cantonese / PC
19/3~20/3
1900-22006 hrs/
2 sessions
MON, TUE960.00
XL0F-35C11C
 Central
 Cantonese / PC
11/4~13/4
1900-22006 hrs/
2 sessions
WED, FRI960.00
XL0F-6A5K
 Mongkok
 Cantonese / PC
5/5~12/5
1000-13006 hrs/
2 sessions
SAT960.00
XL0F-6A26C
 Central
 Cantonese / PC
26/5~2/6
1000-13006 hrs/
2 sessions
SAT960.00
XL0F-45C32K
 Mongkok
 Cantonese / PC
21/6~22/6
1900-22006 hrs/
2 sessions
THU, FRI960.00
XL0F-35C32C
 Central
 Cantonese / PC
11/7~13/7
1900-22006 hrs/
2 sessions
WED, FRI960.00
XL0F-6A34C
 Central
 Cantonese / PC
25/8~1/9
1000-13006 hrs/
2 sessions
SAT960.00
Using Excel 2010 Formulas and Functions in Business Analysis
Complete your Enrol
How to enrol/pay online

Most Microsoft Excel users know they will get their work more effectively done if they grasp the use of formulas and functions, but in fact many of them have not been able to do so. This short but practical course is designed to overcome this problem and aims at Excel users in the business environment. It will expand your understanding and use of Excel by focusing on the techniques that help you build useful worksheet formulas and enhance spreadsheet functionality with the right functions.

  1. Analyzing Data with Tables
    • Converting a Range to a Table
    • Basic Table Operations
    • Sorting a Table
    • Filtering Table Data
    • Referencing Tables in Formulas
    • Excel’s Table Functions
  2. Analyzing Data with PivotTables
    • What Are PivotTables?
    • Building PivotTables
    • Working with PivotTable Subtotals
    • Changing the Data Field Summary Calculation
    • Creating Custom PivotTable Calculations
    • Using PivotTable Results in a Worksheet Formula
  3. Using Excel’s Business-Modeling Tools
    • Using What-If Analysis
    • Working with Goal Seek
    • Working with Scenarios
  1. Using Regression to Track Trends and Make Forecasts
    • Choosing a Regression Method
    • Using Simple Regression on Linear Data
    • Using Simple Regression on Nonlinear Data
    • Using Multiple Regression Analysis
  2. Solving Complex Problems with Solver
    • Some Background on Solver
    • Loading Solver
    • Using Solver
    • Adding Constraints
    • Saving a Solution as a Scenario
    • Setting Other Solver Options
    • Making Sense of Solver’s Messages
    • Displaying Solver’s Reports
  1. Proceed with on-line registration or send the completed enrolment form (download) to us together with a cheque (made payable to Welkin Compuer Training) for the program fee.
  2. CEF applicants have to complete the CEF Application Form (download) and send it to us for certification. They will then send the form to the Office of the Continuing Education Fund, Room 916, 9/F, Kwai Hing Government Offices, 166-174 Hing Fong Road, Kwai Chung, New Territories, together with a photocopy of their HKID Card before course commencement.
  3. Applicants will receive application results from the Office of the CEF within 14 working days.

 

You may also be interested in