IT & Software

Microsoft Excel Level 2

Course Fee R799.00

RELATED COURSES:

If you liked this course, we think you will also like:

  • MS Word 2016 for Beginners
  • MS Powerpoint
  • Office Administration

 

What this course is about?

 

Course 2 of the Excel series is designed for people who need to master the basic and foundational functionalities of Excel. The course firstly navigates the student through the interface and basic syntax. Secondly, it will teach students to do the basics of data handling and manipulation, while educating students on how to present data and structure worksheets. Students who master the contents can be considered strong beginners in Excel.

Who should be doing this course?

The course is therefore aimed at people who will classify themselves as beginnera, and will give them a basis to implement basic commands and structures The course aims to assist anyone who intends on using Excel for personal or business use, and students need a computer to practice on. Apart from the basics, students who do not know how to chart, work with logical functions, or with text functions will find this course suitable for them.

Learning outcomes

Participants will be taken through the following:

  • The user interfaces sections of Excel
  • How to use shortcut menus and keyboard shortcuts
  • How to use formulas
  • Cell referencing methods
  • How to lock a reference
  • Address function and Freeze panes
  • Rename or colour worksheet tabs and working with hyperlinks
  • Formulas and how to copy them
  • Named cells, ranges, name manager and paste special options
  • Basic mathematical functions
  • Basic Statistical functions
  • Logical functions – Working with IF, <, >, <>, => and <=
  • Logical functions – Working with NOT, AND, OR
  • Nested IF functions
  • Logical Commands meets basic functions: SUMIF(S), AVERAGEIF(S), COUNTIF(S)
  • Text functions – An Introduction – Text delimiters and Concatenate function
  • Various text functions
  • How to use text functions in formulas and create unique codes
  • Comparing data in columns: Rank and If functions
  • Logical Exercise – Moving average and testing
  • Basic Charting – How to set up a chart (using existing data or manual setup from toolbar)
  • Basic Charting (continued) – types (Line/Pie/Bar) and areas of charts

 

How your final mark is calculated?

 

Your course is mark is calculated using the average mark obtained in each of the Chapter tests. In order to pass this course, you must obtain a final course mark of at least 50%. This means that even if you fail a few of the chapter tests, if your test marks in the other chapter tests are high enough you will still be able to pass the course. Good Luck!

HOW YOUR COURSE MARK IS CALCULATED?

Your course is mark is calculated using the average mark obtained in each of the Chapter tests. In order to pass this course, you must obtain a final course mark of at least 50%. This means that even if you fail a few of the chapter tests, if your test marks in the other chapter tests are high enough you will still be able to pass the course. Good Luck!

Study at your own pace!

We’ve created our courses to suit your busy life! The duration of this course is based on a student guide where one 300 – 500 word article is read per day, and the assessment is done on a separate day after the relevant articles have been reviewed. But you can do the course in your own time and at your own pace. If you choose to do two readings per day, it will take you half of the estimated time, four readings per day means doing the course in a quarter of the time etc. We leave that decision up to you!

In the 5 chapters of this course you'll be covering the following areas:

CHAPTER 1 Excel basics
CHAPTER 2 Formulas and worksheets
CHAPTER 3 Logical functions
CHAPTER 4 Text functions and functionalities
CHAPTER 5 Applied logic and charting
Thumbnail_dr_rousseau_lötter

Dr Rousseau Lötter

Educator

Dr Lötter is a senior lecturer in Investment Management at a leading South African University. He worked as a portfolio manager at a large asset-manager before joining the University, and has held the CFP® designation since 2008. He has helped many individuals set up and plan their budgets, and has often presented financial talks in public forums. He has published financial papers in accredited journals locally and internationally, and has received numerous teaching awards in South Africa and abroad. He is married and has one daughter. Qualifications: Doctorate in Investment Management, Postgraduate Diploma in Financial Management, Certified Financial Planner
Thumbnail_f4d6e862-219c-4246-9440-6acb7a7e2998

Professor Elsamari Botha

Educator

Not sure if this is the right course for you?

Let one of your career counselors help you make the right choice.

Related Courses

Marketing Management Level 1

Convener: Ras Smit

Have you ever wondered how our groceries, clothing, cell phones, computers, cars (and just about every other other product in the world) is made available - so we can...
read more

Office Management

Convener: TSIBA Business School

As customer needs evolve, so too do business needs. The one thing that a business must rely on in this dynamic environment, is a strong support structure, one of which is...
read more

Microsoft PowerPoint For Beginners

Convener: Luigi McLeod

RELATED COURSES: If you liked this course, we think you will also like: Microsoft Excel Level 1 A Guide To Windows 7, 8 And 10 Microsoft Word 2016 For Beginners WhatsApp...
read more

Microsoft Excel Level 1

Convener: Dr Rousseau Lötter

What this course is about Course 1 of the Excel series is designed for people who have never worked in Excel or have only the most basic of experience, and want to get...
read more

Aquaponics - Content created by Stellenbosch University

Convener: Henk Stander Dept of Animal Sciences, Division of Aquaculture, University of Stellenbosch

This Aquaponics courseis an introductory course into the field of Aquaponics. Aquaponics is an ancient food growing technology that has been around since the earth has...
read more

Business Basics for Entrepreneurs

Convener: Over The Rainbow

This course was designed to help ambitious South Africans who would like to learn how to design their own lives and have a better chance of building a bright future. This course...
read more