Excel Functions

Microsoft Excel Functions Courses in Malawi

 

This 2KO Microsoft Excel Functions course provides students with the knowledge and skills that are needed to use Microsoft Excel proficiently. 2KO Africa is a professional training company, delivering cutting edge programs in the IT space and in selected business applications. Our training is offered online, live online and also by instructor led classes. 2KO Africa's business courses are available world-wide, many of them leading to European Certification. 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.


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)