Excel Functions

Learn 40 Microsoft Excel Functions Step by Step
Rating: 4.3 out of 5 (549 ratings)
7,279 students
Excel Functions
Rating: 4.3 out of 5 (549 ratings)
7,281 students
Excel Functions Seeking
Excel Automating Formulas
Excel tips

Requirements

  • Familiar with some Excel interface
Description

This course is all about excel functions, if you are looking for automating your job and make it easier this is the right course for you, so excel functions are so important for 2 main reasons, the first one is time saving and the second one is eliminating human errors.

In this course you will learn over 40 most important excel functions, for each function i will explain it in details and show you its syntax then will show you how to do it in excel sheets step by step.

Who this course is for:
  • Students searching for Excel Functions
Course content
1 section • 23 lectures • 1h 29m total length
  • Introduction
    03:09
  • SUM & AVERAGE
    01:58
  • SUMIF & SUMIFS
    08:20
  • COUNT & COUNTIF & COUNTIFS
    07:42
  • COUNTIF APPLICATION
    02:59
  • VLOOKUP & IFERROR
    05:48
  • COLUMN & ROW & INT
    03:51
  • IF
    03:42
  • INDEX
    03:00
  • MIN & MAX & SMALL & LARGE
    04:40
  • MATCH
    05:58
  • OFFSET
    04:16
  • SUBTOTAL
    02:32
  • TRANSPOSE
    02:47
  • CONVERT
    02:49
  • CEILING & FLOOR
    02:53
  • CELL
    01:23
  • FIND & SEARCH & LEN
    08:04
  • LEFT & RIGHT & MID
    03:50
  • SUBSTITUTE
    02:14
  • TRIM & LOWER & UPPER
    02:46
  • TEXT
    01:31
  • DATE & TIME FUNCTIONS
    02:56

Instructor
Electrical Enginner
Bishoy Samir William
  • 4.3 Instructor Rating
  • 549 Reviews
  • 7,281 Students
  • 1 Course

My name is Bishoy Samir, I am from EGYPT I studied at faculty of engineering Ain-shams university class 2013 electrical department, started working at ORASCOM Constructions from Feb. 2014 till present.

I love working with Excel Functions and VBA Programming algorithms in Excel and I used my skills in my work alot then I have invented a program from fully automated excel sheets connected together and this program won the first place in a competition alog the whole company in EGYPT this competition called OC Innovation 2018.