Excel Functions

Microsoft Excel Functions Courses in South Africa

This 2KO Microsoft Excel Functions course provides students with the knowledge and skills that are needed to use Microsoft Excel proficiently. 2KO is an IT consulting and training company, offering both business services and multi-platform training. 2KO Africa's wide range of computer courses are available as full time classes, or as online learning. from the comfort of home or work. Learn all there is to know about Excel 2016 functions for Windows machines. Watch videos ranging from the basics to more advanced data analysis. In this Daniel and Vonne start the Excel Functions series by laying down some foundational knowledge and terminology. Specific concepts/definitions discussed here include: formulas, functions, relative reference, absolute reference, and named ranges.

 

Register for an Online MS Office Course Here

 

Curriculum

Essentials
Introduction To Excel Function
Basic Formulas
Basic Functions
Basic Functions Part 2
Functions In Mac
Introduction To Excel Function
Basic Formulas
Basic Functions
Basic Functions Part 2
Functions In Mac
Keyboard Shortcuts For Functions

Advanced
Named Ranges
3d Cell Reference
Formula Auditing

Function Library
Sum
Sumif
Sumifs
Count, Counta, Countblank
Countif, Countifs
Average, Averagea
Averageif, Averageifs
Min, Max, Small, Large
Minifs, Maxifs
Rand, Randbetween
Today, Now
Month, Day, Year, Text
Concat, Textjoin
Left, Right, Mid
Upper, Lower, Proper
Trim, Clean
Char, Code, Unichar, Unicode
Replace, Substitute
Find, Search
Len
If
And, Or
Not
Match
Index
Vlookup
Hlookup
Lookup
Choose

 

To buy a course now using Credit Card, click the icon below

 

Details about this course
Almost 16 hours of learning
Includes video, presentations, workbooks, quizzes, flashcards & games
Receive a Certificate of Excellence on successful completion
Presented by highly qualified, industry leading experts
12 Months access (Unless indicated otherwise)