Excel Functions

Microsoft Excel Functions Courses in Kenya

This 2KO Microsoft Excel Functions course provides students with the knowledge and skills that are needed to use Microsoft Excel proficiently. 2KO Africa offers IT consulting, technical IT services and top-of-the-range IT training on multiple platforms. Our best-of-breed computer courses are presented as instructor led classes or as online internet-based elearning. 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.

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

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

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)