Advanced Microsoft Excel

Online Short Course

R8,223.00

Course Fees
8
Modules
8 weeks
Duration
Registration

WHY AN ADVANCED MICROSOFT EXCEL COURSE?


Excel is a major player in virtually every business worldwide and is considered a universal business requirement. The skills required to reap the full benefits of mastering Excel are important for entrepreneurs, as well as for senior, middle and junior management.

Microsoft Excel is a powerful business tool when it comes to processing and analysing data. Having the ability to process, access and interpret data about your business’s operations is empowering, as it allows you to make informed decisions about your business. As an employee, these are essential skills in any position, and having the competency to use this business tool will give you increased confidence and the ability to take on more complex data processing and analysis tasks.

Summary

This course steps up a level from beginner and intermediate courses and is predominantly aimed at business analysts as well as the Excel power-user. It will provide you with an overview of Excel’s programming model and provide solid grounding in many of the day-to-day solutions afforded to Excel power-users. Skills that you will gain include, filtering and presenting management data from a variety of sources, reading and analysing data, and using reporting tools and functions, including Pivot Tables.

Subject Expert

Fred Benbow-Hebbert is an independent contractor with 23 years’ experience in the Microsoft client/server environment using Visual Basic, VBA programming of Excel, Access and [JB1] Outlook, and ASP/JavaScript/HTML/XML for web applications.

He specialises in reading databases with either VB6, Access or Excel front ends, depending on the amount of data-set manipulation required (Excel for the most complex).

Fred worked in London from 2001 to 2004, contracted to a newly established subsidiary of the personnel recruitment giant Pertemps. He continued to work for the company from Cape Town, until 2014.

Tutor Support

Each course is assigned its own Online Academic Tutor, who is ready and waiting to guide and assist their learners throughout their learning experience.

The Online Academic Tutor who is assigned to your course, is trained to build each student up to reach their fullest potential. Students can expect their Online Academic Tutor to answer questions, offering advice and provide further clarification on any academic aspects.

Course and Technical Requirements

BASIC REQUIREMENTS
To successfully access and complete this course, you will be required to have a registered email account, access to a computer/laptop/tablet and stable internet connection. You will be required to be familiar with using a computer as you may need to be able to read and download documents in Adobe PDF Reader, view Microsoft PowerPoint presentations, and read and create documents in Microsoft Word.

ADDITIONAL REQUIREMENTS
Our online short learning programmes may require additional software applications. These additional software applications requirements will be communicated to you in this information pack and/or on the website course page. Damelin Online does not provide any additional software applications required for online short learning programmes.

Please note: Google, YouTube and Vimeo may be used in our online course delivery. If any of these services are blocked in your jurisdiction, you may have difficult in accessing our course content.

How You Will Learn

Our online short learning programmes are broken into self-paced manageable modules, designed to assist you throughout your learning process through diverse learning activities:

  • Learn through all your interactive course notes
  • Review case studies and supplementary resources
  • Apply and evaluate what you have learned in each module with the self-grading quizzes and assignment submissions.
  • View a range of course video lectures presented our Subject Matter Experts
  • Network, collaborate and interact with your fellow participants and Online Course Facilitator via the discussion forum and Zoom webinars.

Certification

Upon successful completion of this online short learning programme, you will receive the recognition of your knowledge and skills with a Damelin Certificate of Competence. Your certificate of competence will be issued in your registered name and will be couriered at no additional cost.

You will be required to complete a series of assessments that will be facilitated through our virtual learning environment. Your course handbook will be made available to you once you have commenced with your short learning programme.

MODULE OUTLINE

  • MODULE 0
    Orientation Module
  • MODULE 1
    Cleaning up Data
  • MODULE 2
    Data Sources
  • MODULE 3
    Reporting
  • MODULE 4
    Advanced Functions
  • MODULE 5
    Basic Macros
  • MODULE 6
    Databases
  • MODULE 7
    Wrap up

NEED MORE INFORMATION ABOUT THIS COURSE?

Complete the fields below to receive the course information pack.
*Required fields
By providing us with your contact details, you agree to the use of your data as described in our terms and conditions to receive communications. You may opt out of receiving communications at any time.