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!