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

[LeeAndro]

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 66 lectures (3 hour, 18 mins) | Size: 2.55 GB

be familiar with Excel interface and the basic commands.

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 & function

Requirements

Excel basics

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 & 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, Eeers, university students,MBA students, Finance people, consultant, assistants, managers



DOWNLOAD
uploadgig

https://uploadgig.com/file/download/29e304740666055a/rsxP1rv5_.Excel_Func.part1.rar
https://uploadgig.com/file/download/155e395edb1d6bbe/rsxP1rv5_.Excel_Func.part2.rar
https://uploadgig.com/file/download/80844Dbb8651c378/rsxP1rv5_.Excel_Func.part3.rar

rapidgator

https://rapidgator.net/file/f47edf88a1640da5f207f39f0aa76d20/rsxP1rv5_.Excel_Func.part1.rar
https://rapidgator.net/file/6fc3785bebda455f66e76a61800a8e09/rsxP1rv5_.Excel_Func.part2.rar
https://rapidgator.net/file/74341d86382554f7101f855f033d9c98/rsxP1rv5_.Excel_Func.part3.rar

nitroflare

http://nitroflare.com/view/8E34A8AFF5E9703/rsxP1rv5_.Excel_Func.part1.rar
http://nitroflare.com/view/0E33CD497E2C851/rsxP1rv5_.Excel_Func.part2.rar
http://nitroflare.com/view/F3CE1527CB584C0/rsxP1rv5_.Excel_Func.part3.rar