Back to Top
Close Menu
 
Centre for Professional Development and Lifelong Learning
CAVE HILL HOME > Lifelong Learning > Courses > Short Courses > Business and Data Analytics > Data Analytics using Microsoft Excel (Intermediate)

Short Courses


Business and Data Analytics

Data Analytics using Microsoft Excel (Intermediate)

Overview

Microsoft Excel is used by many businesses, but few are maximizing its analytical capabilities to support business decision-making. This course develops an intermediate level of competence in the advanced features of Microsoft Excel.  On completion, you will be able to use Microsoft Excel to produce information that can support the decision-making process, as well as to automate necessary but tedious tasks required in an organizational setting, resulting in time and cost efficiencies. Topics such as the application of statistics in business and how to present data in both graphical and tabular format for immediate transfer of information to support the decision-making process will be addressed.

Mode of Delivery: Face-to-Face ONLINE

What will I Learn?

On successful completion of the course, delegates will be able to:

  • Skillfully navigate the Excel interface
  • Convert  data from many sources into the Excel Application and process such data
  • Analyze and present information for decision making using the statistical methodology
  • Write short descriptive and comparative reports on your observations

Who Should do this Course

Support, supervisory and managerial personnel in administration, accounting, marketing, sales, purchasing, distribution, retail, economics and finance.  The course will benefit anyone who has a basic knowledge of Excel and wants to improve knowledge and skills. 

Important Information

This course has been offered at a special rate, CLICK HERE to view Terms and Conditions
 

At a Glance

  • Admissions Term: 2019/2020 Summer
  • Date: August 17th- 21st, 2020
  • Time: Monday to Friday, 5pm-8pm
  • Duration: 5 days (15 hours)
  • Certificate Awarded: Certificate of Completion
  • CRN: 30109
  • Course Code: PDLL121
  • Capacity: 20
  • Cost: BDS $1,250 (US $625) BDS $500.00 (US$250.00)

The following topics will be addressed:
  • The Excel interface
  • Where to find good data
  • Understanding data types and variables
  • Cleaning and verifying data
  • The role of Statistics in Characterizing data
  • Using Excel functions to organize and present data for flexible reporting layout
  • Create pivot tables to organize and present data
  • Create graphs for easy visual representation and interpretation of  data
  • Ethical guidelines in statistical practice
  •  

Basic knowledge of Microsoft Excel would be an asset

This course is formulated to be hands-on and extremely practical and will therefore be taught in a computer lab using examples, in-class exercises and practice cases that can be instructor created or suggested by delegates to coincide with their particular needs.

TBA

Annette Greene


Annette Greene came to Economics from a background in business administration.  She earned her first degree in Economics in 2004 and her Master’s degree in Financial and Business Economics in 2006 – both from UWI Cave Hill Campus and is now pursuing a doctorate in the area of transport.  She has been part of the Economics Department as a part-time tutor and lecturer since 2004.  She has also acted in the capacity of facilitator and E-tutor with the Open Campus and the Cave Hill School of Business and  as a Research Assistant at the Sir Arthur Lewis Institute (SALISES) and now with the Department of Economics.  At present, she is lecturing in the MSc. Logistics and Supply Chain programme offered in the Department of Economics.


Related Courses

Data Analytics using Microsoft Excel (Advanced)