Excel Functions and Formulas from basic to advanced (Updated 6/2020)

Microsoft Excel-Excel functions and formulas from basic to advanced- Bonus lectures on Excel Functions in Office 365.

What you'll learn

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

Requirements

Excel basics
be familiar with Excel interface and the basic commands.

Description

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.

Who this course is for:

People with basic knowledge in Excel and who are looking to learn functions
Example:Business owners, teachers, accountants, Engineers, university students,MBA students, Finance people, consultant, assistants, managers