Webinars On-Demand

Back

---

MS Excel Series

---

Overview: 

When the word spreadsheet is mentioned, the name that comes to mind for the majority of people is - MS Excel. Created in the mid-1980's, this program has come a long way to become the most widely used spreadsheet software program in the world today. It is also arguably the best in terms of user-friendliness and functionality.  

MS Excel is used by people for many different reasons and this 3-webinar series takes a look at it with a bias towards the accounting and bookkeeping end-user. The series discusses how these professionals can use MS Excel more extensively in their work.   

---

Topics: 

Module 1: MS Excel  - An Introduction 

Module 1 is purely an introductory webinar with some background information on how the program came about. The presenter also looks at the basic structure of the spreadsheet's user interface, highlighting its different parts and how the user can manipulate them.  

---

Content: 

• The origins. 

• 3 fun facts.  

• MS Excel today.  

• What is a spreadsheet?  

Module 2: MS Excel  - Worksheets, Formulas & Functions 

Having established the background to MS Excel as a software program as well as its basic structure and user interface, we now move on to the practical side of this webinar series. How do you create, modify, save and print an MS Excel worksheet? How do you use the myriad of formulas and apply that to your everyday tasks? Join this webinar and learn how to perform basic operations on MS Excel including the use of common formulas.  

Content: 

• Working with worksheets. 

  • Creating and saving a worksheet. 

  • Navigating within, and modifying a worksheet. 

  • Worksheet appearance and printing.  

• Formulas and functions.  

  • Page layout tab. 

  • Formulas tab. 

  • View tab. 

  

Module 3: MS Excel  - Charts & Basic Visualisations 

Tables full of rows and rows, and columns, of data can be overwhelming and painful to the reader's eyes!  It is good then that information processed on MS Excel worksheets can be presented to users in many different ways in order to enhance its appearance. 

Join us for the last instalment of the series where we take a look at charts and other basic visualisations that make data more visually appealing on MS Excel.   

Content: 

• Running a macro with conditional formatting. 

• Inserting illustrations. 

• Using sparklines. 

• Basic visualisations using charts. 

---

Obtaining your CPD certificate 

This full series of webinars qualifies for 5 CPD hours with your professional body including: ACCA, SAICA, AAT, SAIPA, SAIBA, IAC, CIS, ICBA, LSSA, FPI, and the IBA. The SAAA CPD policy is compliant with IFAC IES7 and is recognized by all relevant professional bodies. 

All attendees are issued with a CPD certificate available in an online profile. 

---

About the presenter 

 

 

Innocent Shongedza CTFAIcba(SA) 

Innocent Shongedza is a qualified accountant with more than 11 years experience in the corporate world. He entered the skills development field more than 12 years ago where he is a facilitator, registered assessor, and registered moderator for various training programmes.  

Innocent is a registered member of the ICBA and currently coaches Sage Pastel Accounting, QuickBooks Online, and other accounting-related training material.   

---

Price: 

Normal price for full course - R950