|
Most Essential & Popular Excel Formulas And Functions - 2021
https://CourseWikia.com
Last Update: 10/2021
Duration: 3h 21m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 44.1 kHz, 2ch | Size: 1.83 GB
Genre: eLearning | Language: English
Vlookup,Excel Formulas and Functions ,Excel, advanced excel ,excel ,Basic Excel, Essential Excel, Excel Beginners,
What you'll learn:
How to write basics formulas and perform calculations from scratch
Learn the most popular Microsoft Excel functions for beginners
Identify formulas and functions and know the difference between the two.
How To Use The Popular Mathematical Function In Excel With Real Practical Excel Sheets Such As SUM, AVERAGE, MAX, MIN, ROUND, SUMIF, COUNT, COUNTA, COUNTIF Functions
How To Use The Essential Text Function In Excel With Real Practical Excel Sheets Which Are LEFT, RIGHT, CONCATENATE, UPPER, LOWER, MID, PROPER, TRIM, REPT, TYPE, EXACT, HYPERLINK Functions
How To Use The Essential & Popular Date & Time Functions In Excel With Real Practical Excel Sheets Which Are NOW, TODAY, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, TIME, EDATE
How To Use The Lookup Function In Excel Which Are IF, VLOOKUP, AND, OR, Functions With Real Practical Excel Sheets
How To Use The DATA VALIDATION, FILTER Function In Excel With Real Practical Excel Sheets
Requirements:
A computer or laptop
No prior Excel knowledge is needed.
Microsoft Excel 2007 ,2010,2013,2016,2019 or Office 365 (Some features may not be available in earlier versions)
Description:
Recent Student's Reviews |
[ CourseWikia.com ] Udemy - Most Essential & Popular Excel Formulas And Functions - 2021
-
Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here !
1. INTRODUCTION THE COURSE
-
1. INTRODUCTION THE COURSE.mp4 (36.8 MB)
2. CHAPTER -01 - INTRODUCTION TO EXCEL
-
1. Introduction To Excel - Part 1.mp4 (109.0 MB)
-
1.1 INTRODUCTION TO EXCEL - PART1.xlsx (11.2 KB)
-
2. Introduction To Excel - Part-2.mp4 (102.2 MB)
-
2.1 INTRODUCTION TO EXCEL - PART 2.xlsx (11.7 KB)
3. CHAPTER-02 - MATHEMATICAL FUNCTIONS
-
1. SUM,AVERAGE AND MAX FUNCTIONS.mp4 (65.5 MB)
-
1.1 CHAPTER-02 - AVERAGE FUNCTION.xlsx (11.8 KB)
-
1.2 CHAPTER-02 - MAX FUNCTION.xlsx (11.7 KB)
-
1.3 CHAPTER-02 - SUM FUNCTION.xlsx (12.0 KB)
-
2. MIN, ROUND AND SUMIF FUNCTION.mp4 (67.1 MB)
-
2.1 CHAPTER-02 - MIN FUNCTION.xlsx (11.6 KB)
-
2.2 CHAPTER-02 - ROUND FUNCTION.xlsx (11.7 KB)
-
2.3 CHAPTER-02 - SUMIF.xlsx (11.8 KB)
-
3. COUNT,COUNTA AND COUNTIF FUNCTION.mp4 (53.3 MB)
-
3.1 CHAPTER-02 - COUNT.xlsx (11.6 KB)
-
3.2 CHAPTER-02 - COUNTA.xlsx (11.6 KB)
-
3.3 CHAPTER-02 - COUNTIF.xlsx (11.7 KB)
-
4. MATHEMATICAL FUNCTION - OVERALL EXERCISES.mp4 (150.5 MB)
-
4.1 CHAPTER -02 OVERALL EXCERCIES FILE-MATHERMATICAL FORMULAS.xlsx (11.7 KB)
4. CHAPTER -03 - TEXT FUNCTIONS
-
1. LEFT,RIGHT,CONCATENATE FUNCTIONS.mp4 (83.7 MB)
-
1.1 CHAPTER-03- CONCATENATE FUNCTION.xlsx (10.0 KB)
-
1.2 CHAPTER-03- LEFT.xlsx (20.0 KB)
-
1.3 CHAPTER-03- RIGHT.xlsx (10.0 KB)
-
2. UPPER, LOWER,MID FUNCTIONS.mp4 (47.8 MB)
-
2.1 CHAPTER-03- LOWER FUNCTION.xlsx (10.0 KB)
-
2.2 CHAPTER-03- MID FUNCTION.xlsx (10.0 KB)
-
2.3 CHAPTER-03- UPPER FUNCTION.xlsx (10.0 KB)
-
3. PROPER,TRIM,REPT FUNCTIONS.mp4 (43.1 MB)
-
3.1 CHAPTER-03- PROPER FUNCTION.xlsx (20.0 KB)
-
3.2 CHAPTER-03- REPT FUNCTION.xlsx (9.9 KB)
-
3.3 CHAPTER-03- TRIM FUNCTION.xlsx (9.9 KB)
-
4. TYPE, EXACT,HYPERLINK FUNCTIONS.mp4 (71.0 MB)
-
4.1 CHAPTER-03- HYPERLINK.xlsx (9.6 KB)
-
4.2 CHAPTER-03- TYPE FUNCTION.xlsx (20.0 KB)
-
4.3 CHAPTER-03-EXACT FUNCTION.xlsx (20.2 KB)
-
5. TEXT FUNCTION - OVERALL EXERCISES.mp4 (167.0 MB)
-
5.1 CHAPTER-03 OVERALL EXCERCISE FILE -TEXT FORMULAS.xlsx (11.8 KB)
5. CHAPTER -04- DATE & TIME FUNCTIONS
-
1. NOW AND TODAY FUNCTIONS.mp4 (66.8 MB)
-
1.1 CHAPTER-04-NOW FUNCTION.xlsx (10.1 KB)
-
1.2 CHAPTER-04-TODAY FUNCTION.xlsx (10.0 KB)
-
2. YEAR,MONTH,DAY FUNCTIONS.mp4 (56.9 MB)
-
2.1 CHAPTER-04- DAY FUNCTION.xlsx (9.9 KB)
-
2.2 CHAPTER-04- MONTH FUNCTION.xlsx (9.9 KB)
-
2.3 CHAPTER-04-YEAR FUNCTION.xlsx (19.1 KB)
-
3. HOUR,MINUTE,SECOND,TIME,EDATE FUNCTIONS.mp4 (82.2 MB)
-
3.1 CHAPTER -04 -EDATE.xlsx (19.5 KB)
-
3.2 CHAPTER-04- HOUR FUNCTION.xlsx (10.2 KB)
-
3.3 CHAPTER-04- MINUTE FUNCTION.xlsx (10.1 KB)
-
3.4 CHAPTER-04- SECOUND FUNCTION.xlsx (20.1 KB)
-
3.5 CHAPTER-04- TIME FUNCTION.xlsx (10.1 KB)
-
4. DATE & TIME FUNCTION - OVERALL EXERCISES.mp4 (77.1 MB)
-
4.1 CHAPTER-04 OVERALL EXCERCIES TIME & DATE FORMULA FUNCTION.xlsx (11.8 KB)
6. CHAPTER -05- LOGICAL FUNCTIONS
-
1. IF AND VLOOKUP FUNCTIONS.mp4 (115.0 MB)
-
1.1 CHAPTER-05 - IF.xlsx (12.6 KB)
-
1.2 CHAPTER-05 - VLOOKUP.xlsx (12.8 KB)
-
2. AND ,OR FUNCTIONS.mp4 (77.9 MB)
-
2.1 CHAPTER-05 - AND.xlsx (12.0 KB)
-
2.2 CHAPTER-05 - OR.xlsx (12.0 KB)
-
3. LOGICAL FUNCTION - OVERALL EXERCISES.mp4 (147.2 MB)
-
3.1 CHAPTER-05 OVERALL LOGICAL FORMULAS - EXCERCIES FILE.xlsx (11.8 KB)
7. CHAPTER - 06 DATAVALIDATION & FILTER
-
1. DATA VALIDATION & FILTER.mp4 (115.8 MB)
-
1.1 CHAPTER -06 DATA VALIDATION.xlsx (11.1 KB)
-
1.2 CHAPTER -06 FILTER.xlsx (12.1 KB)
-
2. DATA VALIDATION AND FILTER - OVERALL EXERCISES.mp4 (146.4 MB)
-
2.1 CHAPTER -06 OVERALL EXCERCIES - FILTER & DATA VALIDATION.xlsx (25.1 KB)
8. BONUS SECTION
-
1. BONUS LECTURE.html (1.8 KB)
-
Bonus Resources.txt (0.3 KB)
files
|
|
udp://tracker.torrent.eu.org:451/announce udp://tracker.tiny-vps.com:6969/announce http://tracker.foreverpirates.co:80/announce udp://tracker.cyberia.is:6969/announce udp://exodus.desync.com:6969/announce udp://explodie.org:6969/announce udp://tracker.opentrackr.org:1337/announce udp://9.rarbg.to:2780/announce udp://tracker.internetwarriors.net:1337/announce udp://ipv4.tracker.harry.lu:80/announce udp://open.stealth.si:80/announce udp://9.rarbg.to:2900/announce udp://9.rarbg.me:2720/announce udp://opentor.org:2710/announce |
