- Introduction
- SUM & AVERAGE
- SUMIF & SUMIFS
- COUNT & COUNTIF & COUNTIFS
- COUNTIF APPLICATION
- VLOOKUP & IFERROR
- COLUMN & ROW & INT
- IF
- INDEX
- MIN & MAX & SMALL & LARGE
- MATCH
- OFFSET
- SUBTOTAL
- TRANSPOSE
- CONVERT
- CEILING & FLOOR
- CELL
- FIND & SEARCH & LEN
- LEFT & RIGHT & MID
- SUBSTITUTE
- TRIM & LOWER & UPPER
- TEXT
- DATE & TIME FUNCTIONS
What you'll learn
- Excel Functions Seeking
- Excel Automating Formulas
- Excel tips
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.
Other Courses
ChatGPT Content Writing for Freelance Copywriting (Ethical)
Ethical Artificial intelligence Freelancing Fusion: Master Copywriting Ethically with ChatGPT, Quillbot, and Grammarly
English Made Simple: Vocabulary To Describe Personality
Learn the common adjectives used to describe people and improve your English conversational skills
Graphic Design Theory for beginners
Learn Graphic Design Theory like color, composition, typography to design professional designs based on science!
About the instructors
- 4.55 Calificación
- 9441 Estudiantes
- 1 Cursos
Bishoy Samir William
Electrical Enginner
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.
Student feedback
Course Rating
Reviews
Captions can be edited to keep up to the understanding
Lots of basic functions for beginners which are very helpful. Thanks