Master Microsoft Excel Functions and Formulas
Duration: 2h 36m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 878 MB
Genre: eLearning | Language: English
Duration: 2h 36m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 878 MB
Genre: eLearning | Language: English
Excel Functions
What you'll learn:
Master Microsoft Excel Functions and Formulas
Master Counts Functions
Master Logical Functions
Master Statistical Functions
Master Forecast Functions
Master date and Time functions
Requirements:
No Requirements needed this course for absolute beginners
Description:
Microsoft Excel is most used software tool in the world. It has a lot features that make this program valuable. One of the most strong feature that Microsoft Excel has is the functions and formulas. There are hundreds of builtin function in Microsoft Excel such as logical , statistical , Financial , logical, Text , date $ time, lookup math and much more. Also, you can build your own formula. This course, designed for functions and formulas so you will learn about each one of them and how to use them in details. examples of functions that you will learn in this course
1- count and counts if functions
2- sum and sum ifs functions
3- if functions
4- AND & OR function
5-ifs functions
6- date and time functions
7- text functions like joint, right, left ,upper, lower, trim , search, proper functions
8- forecast function
9-workday and network day function
10-standard deviation function
11- average and average if function
12-mode functions
13-Text Functions
15-statitical functions
16- Auto function
17- Much more functions
Also, you learn how create formula in Excel and how to copy formula in Excel.
At the end of this course you master the most used functions and formulas and then you will be in advanced level of using Microsoft excel. In addition, you will master how to build your own formulas and functions and master auto functions in Microsoft Exce
Who this course is for:
Anyone wants to master Excel Functions and Formulas
More Info