Business Analysis with Microsoft Excel (CEF Approved) 2017-09-15T14:07:26+00:00

Project Description

Loading...
cef CEF Course Code: 23C03603-5
CEF Institution Code: 548
Welkin Course Code: CBA

Course Features

In this course, you will learn a wide range of advanced Excel skills that help you organize, analyze, forecast and present business data in an effective and professional manner. It is specially designed for those who want to gain more expertise in using and manipulating business data from within Excel.

  • Step-by-step structured delivery for an in-depth understanding of Excel functions
  • Valuable and practical tips and tricks

By the end of the course, you should have a good understanding of advanced Excel features and be able to use Excel to analyze business data and present your results more effectively.

  • Qualified and experienced instructors
  • Daytime, evening and weekend classes with Cantonese and English tuition options

Learn from the Experts

Get Professional Recognition

mos-certificate

Certify your Excel skills with Microsoft Office Specialist Excel Expert 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 in Excel data analysis with the course Financial Modeling with Excel VBA.

Course Fee

$1170*

*after maximum 80% fee reimbursement from CEF. Full course fee is $5850, payable by monthly instalments.

Am I qualified for CEF?

Course Duration

30 Hours

Course Prerequisites

Course participants should be at least 18 years old, have an education level of Form 5 or above, and possess basic business concepts and knowledge of Microsoft Excel.

Title of Award & Assessment Methods

Students will receive the course certificate after achieving 80% attendance and passing in 2 course assignments.

Schedule & Online Enrolment
Enquiry/Booking

Evening classes, 6 hours per week, course fee in 2 instalments

COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
CBAB-6D14E
 Central
 English / PC
14/10~25/11
1000-1300
1400-1700
30 hrs/
10 sessions
SAT2,925.00
CBAB-13C16E
 Central
 English / PC
16/10~15/11
1900-220030 hrs/
10 sessions
MON, WED2,925.00
CBAB-13C23C
 Central
 Cantonese / PC
23/10~22/11
1900-220030 hrs/
10 sessions
MON, WED2,925.00
CBAB-42C26K
 Mongkok
 Cantonese / PC
26/10~28/11
1900-220030 hrs/
10 sessions
TUE, THU2,925.00
CBAB-6D32K
 Mongkok
 Cantonese / PC
4/11~2/12
1000-1300
1400-1700
30 hrs/
10 sessions
SAT2,925.00
CBAB-24C33E
 Central
 English / PC
5/12~9/1
1900-220030 hrs/
10 sessions
TUE, THU2,925.00
CBAB-25C5K
 Mongkok
 Cantonese / PC
5/12~12/1
1900-220030 hrs/
10 sessions
TUE, FRI2,925.00
CBAB-6D9E
 Central
 English / PC
9/12~13/1
1000-1300
1400-1700
30 hrs/
10 sessions
SAT2,925.00
CBAB-14C11C
 Central
 Cantonese / PC
11/12~18/1
1900-220030 hrs/
10 sessions
MON, THU2,925.00
CBAB-6D33K
 Mongkok
 Cantonese / PC
6/1~3/2
1000-1300
1400-1700
30 hrs/
10 sessions
SAT2,925.00
CBAB-14C32K
 Mongkok
 Cantonese / PC
22/1~1/3
1900-220030 hrs/
10 sessions
MON, THU2,925.00
CBAB-25C6C
 Central
 Cantonese / PC
6/2~13/3
1900-220030 hrs/
10 sessions
TUE, FRI2,925.00
CBAB-6D10E
 Central
 English / PC
10/2~17/3
1000-1300
1400-1700
30 hrs/
10 sessions
SAT2,925.00
CBAB-52C9K
 Mongkok
 Cantonese / PC
9/3~13/4
1900-220030 hrs/
10 sessions
TUE, FRI2,925.00
CBAB-6D10K
 Mongkok
 Cantonese / PC
10/3~14/4
1000-1300
1400-1700
30 hrs/
10 sessions
SAT2,925.00
Business Analysis with Microsoft Excel (CEF Approved)
Complete your Enrol
How to enrol/pay online

Evening classes, 6 hours per week, course fee in 3 instalments

COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
THERE IS NO AVAILABLE COURSE AT THE MOMENT!
Business Analysis with Microsoft Excel (CEF Approved)
Complete your Enrol
How to enrol/pay online

As the industry standard spreadsheet software for business data analysis and presentation, Microsoft Excel is indispensable for every office professional. This course is specially designed to help you master Microsoft Excel as a business tool to organize, analyze and present business data in an effective and professional manner. Also included in the course are valuable advice and guidance from experienced instructors that course participants can apply to real life situations.

Module 1: Microsoft Excel for Business Data Analysis

Organizing growing data systematically and enabling automatic updating of reports and charts:

  • Automatic updating of reports and charts with live data
  • Handling growing data in formulas using Offset, Indirect and Array
  • Using VLookup to retrieve specific data from a database
  • Handling #N/A and different types of formula errors

Summarizing data for an overview:

  • Summarizing data using SUMIFS and DSUM based on dates and complex criteria
  • Managing the time value of money using Excel financial functions, e.g., IRR, XIRR, MIRR, NPV, etc
  • Reconciliation of data from multiple workbooks

Evaluating business performance with data analysis:

  • Analyzing and reporting data using PivotTables

Creating professional reports in Excel:

  • Building advanced Excel charts, e.g., overlay multiple charts
  • Professional Dashboards using conditional formatting and Sparklines

Module 2: Microsoft Excel for Financial Planning and Control

Data modeling by scenario:

  • Budgeting
  • Forecasting
  • Using Net Present Value(NPV) for project selection
  • Pricing & costing

Module 3: Microsoft Excel for Business Decision Making

Leveraging Excel features to facilitate decision making and the use of resources:

  • Forecasting by regression analysis
  • What-if analysis: Goal Seek, Data Table and Scenario Manager
  • Using Solver to optimize resources

Module 4: Microsoft Excel for Sales and Marketing

Using Excel in sales analysis and formulating marketing strategies:

  • Spreadsheet modeling for sales and marketing
  • Setting up relationships to link up multiple worksheets in creating PivotTable reports
  • Linking live data between Excel and PowerPoint
  • Integrating an Access database with Excel
  • Advanced data analysis techniques using SQL and PivotTables
  • Using Macros to automate Excel processes
  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