Existing User Login

New User? Create An Account

Request new password

We are iCollege

Established in 2003 under the parent company XpertSkills, iCollege is one of the most trusted marketplaces in E-Learning. Our dedication transcends mere content – we source learning products from only the best suppliers and vendors across the globe so you have the widest selection of educational courses designed to equip you for success.

Headquartered in stunning South Africa, our distributed company spans 3 continents with employees in the U.S., India, and of course, South Africa. Our customers call more than 120 countries home. We're proud to say iCollege is trusted by leading organizations in major tech hubs, including Silicon Valley, to train and equip employees to be the very best that they can be.

Whether partnering with Fortune 500 companies or being part of an individual's journey toward career growth, we are committed to the success of all who trust us as their source for education and training.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

Excel Functions

EDUTAINMENT COURSE

Excel Functions

Interactive and entertaining talk-show style format presented by industry leading experts.
Overview

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.

Objectives
  • Perform calculations in an Excel worksheet.
  • Modify an Excel worksheet.
  • Modify the appearance of data within a worksheet.
  • Manage Excel workbooks.
  • Print the content of an Excel worksheet.
Prerequisites
  • Excel Crash Course 
  • Building a 3  Statematent Financial Model 
  • Scenario  & Sensitivity Analysis
Target Audience

If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.

Instructor: ITProTV

ITProTV delivers the IT instruction that you need to advance or launch your IT career in a fun and creative way. With attractive studios and an interactive, talk-show style format, you'll watch more and learn more. From CompTIA, Cisco, and Microsoft to Security and Cloud Fundamentals, you can learn it all. Dive deep into one or master many with the friendly faces of IT training.

  1. ESSENTIALS
1
Start
Introduction To Excel Function
2
Start
Basic Formulas
3
Start
Basic Functions
4
Start
Basic Functions Part 2
5
Start
Functions In Mac
6
Start
Keyboard Shortcuts For Functions
  1. ADVANCED
7
Start
Named Ranges
8
Start
3D Cell Reference
9
Start
Formula Auditing
  1. FUNCTION LIBRARY
10
Start
SUM
11
Start
SUMIF
12
Start
SUMIFS
13
Start
COUNT, COUNTA, COUNTBLANK
14
Start
COUNTIF, COUNTIFS
15
Start
AVERAGE, AVERAGEA
16
Start
AVERAGEIF, AVERAGEIFS
17
Start
MIN, MAX, SMALL, LARGE
18
Start
MINIFS, MAXIFS
19
Start
RAND, RANDBETWEEN
20
Start
TODAY, NOW
21
Start
MONTH, DAY, YEAR, TEXT
22
Start
CONCAT, TEXTJOIN
23
Start
LEFT, RIGHT, MID
24
Start
UPPER, LOWER, PROPER
25
Start
TRIM, CLEAN
26
Start
CHAR, CODE, UNICHAR, UNICODE
27
Start
REPLACE, SUBSTITUTE
28
Start
FIND, SEARCH
29
Start
LEN
30
Start
IF
31
Start
AND, OR
32
Start
NOT
33
Start
MATCH
34
Start
INDEX
35
Start
VLOOKUP
36
Start
HLOOKUP
37
Start
LOOKUP
38
Start
CHOOSE
EDUTAINMENT COURSE
?Interactive and entertaining talk-show style format presented by industry leading experts.
USD 59 USD 19 68% OFF
  • 15:54:00
    Hours of learning
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months Access (Unless indicated otherwise)
  • 10-Day money-back guarantee
Back to Top