Excel: Learn basic and advanced formulas quick and easy
4.7 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
848 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel: Learn basic and advanced formulas quick and easy to your Wishlist.

Add to Wishlist

Excel: Learn basic and advanced formulas quick and easy

Basic and advanced functions and formulas explained quickly and simply
4.7 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
848 students enrolled
Created by Adam Holczer
Last updated 9/2016
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • learn basic and advanced excel functions in couple of minutes
  • learn advanced formulas for making your work quicker
  • get to know how to use combination of functions in Excel
  • be more efficient by using quick solutions
View Curriculum
Requirements
  • You need a computer with possibly Microsoft Excel 2013 and you are free to go. The tutorial covers topics from the beginning till advanced level.
Description

We are living in a running and crazy world, where everybody wants to grasp the most information with the least time spending on it. This is true for all of us, especially the ones would like to study and know more. 

Therefore I decided to show you Excel formulas & function in 2-3 minute-long videos; lots of info compressed in short series of videos. 

The aim of this course is to show you basic and advanced functions, their use, and some real-life example how to use it in your daily work/life. 

When I started learning Excel, I realized that it is very important to know Excel functions, but knowing them is not enough. You have to build it into your daily work and start thinking the way Excel "thinks". With this course I will focus on some real-life examples I had to face during my work and try to shed light on what Excel is capable of. The structure of the course includes some basics as well, so that if you do not have a strong basis, it still gives you guidance and a firm fund to continues and handle more complex problems.

My aim is to show you how the functions work and then give you some tips how to use them. Moreover the videos are approaching from a point of view that can be useful at your workplace, e.g. automatization in handling structures, giving solutions for report generations. If you would like to save some time and spend less on sitting in front of a computer and handling data in Excel, then I recommend this course for you.

Have fun with the course and let me know if you have any question.

Adam

Who is the target audience?
  • This excel course is for newbies and for guys with advanced level in the same time.
  • For those who would like to save time by applying automatization
  • For those who would like to learn formulas & functions in minutes
Compare to Other Excel Courses
Curriculum For This Course
102 Lectures
05:37:15
+
Date & Time Functions
15 Lectures 43:32

DAY formula
02:53

DAYS formula
02:17

TIME formula
02:52

TIMEVALUE formula
02:20

MINUTE formula
01:15

HOUR formula
01:32

SECOND formula
01:20

TODAY formula
02:46

NOW formula
01:48

YEAR forumula
01:59

MONTH formula
02:05

DATEVALUE formula
04:19

WORKDAY formula
07:10

WEEKNUM formula
06:21
+
Text Manipulation Functions
13 Lectures 34:12
CONCATENATE formula
03:46

& formula
02:01

LEN formula
02:58

LEFT formula
02:39

RIGHT formula
02:13

MID formula
02:59

EXACT formula
02:27

FIND formula
03:45

DOLLAR formula
02:24

LOWER formula
01:20

UPPER formula
01:08

SUBSTITUTE formula
03:34

REPLACE formula
02:58
+
Mathematical Functions
16 Lectures 36:56

AVERAGE formula
02:06

MIN formula
02:19

MAX formula
01:51

MEDIAN formula
03:00

ROUND formula
03:22

PRODUCT formula
01:41

SUMPRODUCT formula
04:31

RAND formula
02:32

RANDBETWEEN formula
02:07

ABS formula
01:07

CEILING formula
03:49

POWER formula
01:07

PI formula
00:36

LARGE formula
02:28

SIGN formula
01:38
+
Statistical Functions
9 Lectures 36:08
AVERAGEIF formula
05:12

AVERAGEIFS formula
03:08

SUMIF formula
04:18

SUMIFS formula
05:48

COUNT formula
02:50

COUNTA formula
01:56

COUNTIF formula
05:30

COUNTIFS formula
04:07

COUNTBLANK formula
03:19
+
Lookup Functions
13 Lectures 48:57

HLOOKUP formula
04:52

MATCH formula
04:09

LOOKUP formula
03:55

ADDRESS formula
04:39

COLUMN formula
02:09

COLUMNS formula
01:48

ROW formula
01:35

ROWS formula
01:12

HYPERLINK formula
03:32

INDEX formula
05:52

INDIRECT formula
03:43

TRANSPOSE formula
04:27
+
Logical Functions
15 Lectures 39:33
IF formula
07:30

NOT formula
02:09

OR formula
02:07

AND formula
03:30

ISBLANK formula
03:18

ISERROR formula
03:23

TRUE & FALSE formula
00:55

IFNA formula
02:11

ISLOGICAL formula
02:58

ISTEXT formula
01:40

ISNUMBER formula
01:41

#N/A formula
02:10

SHEET formula
02:08

SHEETS formula
01:39

VALUE formula
02:14
+
Other Functions
4 Lectures 08:57
CELL formula
02:45

CHAR formula
02:49

ARABIC formula
01:20

FORMULATEXT formula
02:03
+
Common Function Combination
14 Lectures 01:21:17
Using data validaton with LOOKUP formulas (e.g. VLOOKUP)
09:38

Hiding error messages
09:41

LEFT & UPPER: Text manipulation formula combo with capital letters
05:15

LEFT & UPPER & IF: Text manipulation formula combo with capital letters and IF
03:10

LEFT & UPPER and &: Text manipulation formula combo with capital letters and &
03:16

Correcting blank cells: IF combination with ISBLANK
03:59

Correcting blank cells: IF combination with ISBLANK and OR
04:55

Lookup-type combo: INDEX and MATCH formula combination
07:35

Lookup-type combo: HLOOKUP and MATCH formula combination
06:51

Lookup-type combo: VLOOKUP & UPPER & LEFT
05:27

Embedding logical functions: IF in IF
04:26

Embedding logical functions with lookup: IF in IF with VLOOKUP
04:25

RIGHT & LEN: Text manipulation formula combination
05:40

Automatic countdown combo: NOW & HOUR & MINUTE
06:59
About the Instructor
Adam Holczer
4.2 Average rating
30 Reviews
2,288 Students
6 Courses
Senior Optimization Analyst

I'm Adam, working for an oil company in sales optimization, aiming the potential sales volumes and allocation throughout the company's market. I have a strong interest in the Oil Industry, therefore I always wanted to work in the industry. after finishing Business Administration (BSc) I studied International Economics and Business in Budapest and in the Netherlands. My interest drove me back to University to study Optimization in Oil Industry in the framework of a post-graduate course. Now I am working for the biggest Oil & Gas Corporation in Central Eastern Europe as an optimization expert, supporting decision-making and analyzing the regional markets.