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.