4.5  41 reviews on Udemy

The ultimate guide for Excel Formulas and Functions.

Master Excel Formulas and Functions from basic to advanced-additional lectures on office 365 and Excel 2019
Course from Udemy
 928 students enrolled
 en
Excel Functions and Formulas-from basic Excel functions to advanced
Bonus lectures on Excel functions Excel 2019 and Office 365
Calculations with excel-searching for data-logical functions-date & time function

In this course, we will learn the most important and useful Excel functions and Formulas in an easy, efficient, and practical way.

Here is a general overview of the course:

1-We will start with an introduction about functions in excel. I will share with you the essential knowledge that you will need before we start to tackle the formulas. In other words,  you will learn:

1.1-Different ways to insert a function in Excel

1.2-The absolute and relative references in Excel.

1.3-How to name a cell and range of cells in Excel.

1.4-How to build a list of items using data validation.

1.5- The most common types of errors in Excel.

2- Later you will understand the logic behind the most important and commonly used Excel functions among professionals:

2.1-Excel Logical Functions: IF-NOT-AND-OR-Nested IF statement- SWITCH-IFEEROR.

2.2-Excel Mathematical and statistical Functions: AVERAGE-MIN-MAX-SUMIF-SUMIFS-COUNTIF-COUNTIFS- SMALL-LARGE-RAND-POWER-SUMPRODUCT-RAND-RANK-RANDBETWEEN-AVERAGEIF-AVERAGEIFS

2.3-Excel Lookup Functions: VLOOKUP( exact and approximate match)-HLOOKUP-INDEX-MATCH-INDIRECT-OFFSET-CHOOSE-ROW(S)-COLUMN(S)

2.4-Excel Text Functions: LOWER-UPPER-PROPER-TRIM-LEN-RIGHT-LEFT-MID-SEARCH-FIND-SUBSTITUTE-CONCATENATE

2.5-Excel Date & Time Functions: YEARFRAC-WEEKNUM-EOMONTH-WEEKDAY-NETWORKDAYS-TODAY-NOW-DATE-YEAR-...

3- Most importantly, you will learn how to master excel functions and formulas by nesting and integrating them. Also, You will be able to tailor and adjust their functionalities to serve your purpose.

4- Finally, at the end of each section, you will have hands-on practice that summarizes everything you’ve learned.

In addition to all that, I provide in this course some bonus lectures on the coolest functions in office 365 such as XLOOKUP- TEXTJOIN-MINIFS-MAXIFS-IFS.

The ultimate guide for Excel Formulas and Functions.
$ 44.99
per course
Also check at

FAQs About "The ultimate guide for Excel Formulas and Functions."

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.

SOCIAL NETWORK