|
Learn Basic to Advance Excel from Scratch - Master Course
https://DevCourseWeb.com
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 34 lectures (4h 23m) | Size: 2.18 GB
Mastering the art of MS Excel from Basics to Advance Level
What you'll learn:
Hands on all Basic to Advance shortcuts required in Ms Excel
All Advance Functions like Lookup Functions, If related all functions, Time Value of Money Functions, Data Analysis Functions etc.
All kind of Charts like Tree Chart, Columunar Chart, Sparkling Charts, Bar Chart, Bridge Chart etc.
All functionalities related to Goal Seek, Ranking Sensitivity Analysis, Pivot Tables, Loan Schedule etc.
All functionalities related to Errors, Text, Basic & Advance Formatting, Filtering, Sorting etc.
Requirements
You need a Laptop with MS Excel, PDF Viewer and a Good Internet Connection
Second and the foremost thing you need is : "YOUR WILL to practice along side the class"
Description
This is a 100 % practical course specially designed for Finance Professionals, Beginners, School Students, MBA Professionals, Graduate Students to master the art of MS Excel. In this course, almost all necessary tools, functions, commands are included which will make you a real professional. After learning this course students shall be able to work in excel at a lighting speed. This course will enhance your speed, office productivity and will add skill to your professional life.
This course includes the following functions: 1) Basics of Excel 2) Home Tab Function 3) Mathematical operators 4) Lookup Functions 5) Time Value of Money Functions 6) Date Functions 7) Text Functions 8) Logical Functions 9) Error Functions 10) Basic Formatting 11) Advance level formatting 12) Goal Seek Function 13) Ranking & Sensitivity Analysis etc. |
[ DevCourseWeb.com ] Udemy - Learn Basic to Advance Excel from Scratch - Master Course
-
Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here !
1. Introduction to Ms Excel
-
1. Introduction.mp4 (42.7 MB)
-
1. Introduction.srt (6.2 KB)
-
2. How to Open a New File.mp4 (31.2 MB)
-
2. How to Open a New File.srt (4.1 KB)
-
2.1 Student's Excel File for Practice.xlsx (867.5 KB)
10. Lookup Functions
-
1. Vlookup.mp4 (10.8 MB)
-
1. Vlookup.srt (6.2 KB)
-
1.1 EXCEL CLASS-32.xlsx (11.0 KB)
-
2. Hlookup.mp4 (11.7 MB)
-
2. Hlookup.srt (2.9 KB)
11. Ranking & Sensitivity Analysis
-
1. Ranking & Sensitivity Analysis.mp4 (29.2 MB)
-
1. Ranking & Sensitivity Analysis.srt (6.2 KB)
-
1.1 EXCEL CLASS-33-RANK FUNCTION.xlsx (9.7 KB)
-
1.2 EXCEL CLASS-33-SENSITIVITY ANALYSIS.xlsx (9.0 KB)
-
2. Final Class.mp4 (76.7 MB)
-
2. Final Class.srt (13.6 KB)
2. Introduction to Basic Functions of Ms Excel and Regular Shortcuts
-
1. Auto Fill Series.mp4 (43.9 MB)
-
1. Auto Fill Series.srt (5.2 KB)
-
2. Cut Copy Paste Function.mp4 (51.6 MB)
-
2. Cut Copy Paste Function.srt (5.9 KB)
3. Basics of Formatting in Excel
-
1. Font Style and Font Size.mp4 (12.8 MB)
-
1. Font Style and Font Size.srt (5.2 KB)
-
2. Font Color, Bold, Italics and Underline Function.mp4 (81.5 MB)
-
2. Font Color, Bold, Italics and Underline Function.srt (8.2 KB)
4. Introduction to Formulas in Excel
-
1. Mathematical Operators.mp4 (174.4 MB)
-
1. Mathematical Operators.srt (18.0 KB)
-
2. Conditional Formatting.mp4 (139.8 MB)
-
2. Conditional Formatting.srt (12.1 KB)
-
3. Basic Statistical Functions.mp4 (144.7 MB)
-
3. Basic Statistical Functions.srt (13.3 KB)
-
4. Number Formatting.mp4 (71.8 MB)
-
4. Number Formatting.srt (7.0 KB)
-
5. Filtering & Freeze Panes.mp4 (72.0 MB)
-
5. Filtering & Freeze Panes.srt (5.9 KB)
5. Introduction to Advance Functions
-
1. IF Function.mp4 (104.1 MB)
-
1. IF Function.srt (11.2 KB)
-
2. Referencing and IF OR function.mp4 (193.8 MB)
-
2. Referencing and IF OR function.srt (19.5 KB)
-
3. Count and Sum IF Functions.mp4 (156.3 MB)
-
3. Count and Sum IF Functions.srt (17.9 KB)
-
4. Sum Product & Text Functions.mp4 (63.0 MB)
-
4. Sum Product & Text Functions.srt (7.4 KB)
-
5. Time Value of Money Function.mp4 (144.4 MB)
-
5. Time Value of Money Function.srt (16.9 KB)
-
6. If error & IRR function.mp4 (63.1 MB)
-
6. If error & IRR function.srt (7.4 KB)
-
7. Loan Schedule.mp4 (112.1 MB)
-
7. Loan Schedule.srt (11.1 KB)
6. Date Functions
-
1. Date Functions - Part 1.mp4 (13.2 MB)
-
1. Date Functions - Part 1.srt (6.7 KB)
-
2. Date Functions - Part 2.mp4 (32.5 MB)
-
2. Date Functions - Part 2.srt (3.8 KB)
7. Pivot Tables
-
1. Pivot Tables.mp4 (133.3 MB)
-
1. Pivot Tables.srt (12.1 KB)
8. Introduction to Charts
-
1. Introduction to Charts.mp4 (47.6 MB)
-
1. Introduction to Charts.srt (5.8 KB)
-
2. Charts Formatting.mp4 (67.3 MB)
-
2. Charts Formatting.srt (6.3 KB)
-
3. Bridge Chart.mp4 (36.6 MB)
-
3. Bridge Chart.srt (4.9 KB)
-
3.1 EXCEL CLASS-24.xlsx (8.7 KB)
-
4. Tree Map Chart.mp4 (37.1 MB)
-
4. Tree Map Chart.srt (4.2 KB)
-
4.1 EXCEL CLASS-25.xlsx (8.4 KB)
-
5. Sparkline Charts.mp4 (34.3 MB)
-
5. Sparkline Charts.srt (5.5 KB)
-
5.1 EXCEL CLASS-26-SPARK LINES CHART.xlsx (8.7 KB)
9. Other Advanced Functions
-
1. Average If, Ifs.mp4 (59.9 MB)
-
1. Average If, Ifs.srt (7.6 KB)
-
1.1 EXCEL CLASS-27.xlsx (8.9 KB)
-
2. Round Function.mp4 (8.6 MB)
-
2. Round Function.srt (2.4 KB)
-
2.1 EXCEL CLASS-28.xlsx (8.6 KB)
-
3. Choose and Goal Seek.mp4 (48.3 MB)
-
3. Choose and Goal Seek.srt (6.9 KB)
-
3.1 EXCEL CLASS-29.xlsx (13.3 KB)
-
3.2 EXCEL CLASS-29(1).xlsx (9.3 KB)
-
4. If with IF Error.mp4 (24.0 MB)
-
4. If with IF Error.srt (2.7 KB)
-
4.1 EXCEL CLASS-30.xlsx (13.3 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 |
