Udemy - Learn MS Excel and Data Analysis
Udemy - Learn MS Excel and Data Analysis
Learn MS Excel and Data Analysis https://DevCourseWeb.com Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz Language: English | Size: 1.33 GB | Duration: 3h 1m Master Essential Excel Formulas and Analyze Financials Like a Pro What you'll learn Use Excel for Personal Finances Use Excel for Stock Analysis Calculate and Use Basic Excel Functions Calculate and Use Advanced Excel Functions Analyze Data in Excel Create Pivot Tables Excel Features Lifetime Access to Excel Course + Quizzes & Worksheets Analyze Financial Statements Perform Business Analysis Description This course is designed with the Excel power user in mind. No prior knowledge of VLOOKUP, IF statements, PivotTables, Sensitivity Analysis, or other such formulas is required -- my goal is to teach you how to solve business problems in Excel.
83
Other /Tutorials
1.3 GB
[ DevCourseWeb.com ] Udemy - Learn MS Excel and Data Analysis
Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here !
1. Introduction
1. Introduction - Course Overview.mp4 (10.5 MB)
2. Course Resources - How to Use it.mp4 (7.0 MB)
3. MS Excel Basics.mp4 (22.0 MB)
3.1 Spreasheet basics.pdf (97.0 KB)
4. Basic Excel Formulas.mp4 (20.2 MB)
4.1 1.5 Basic formulas in excel.xlsx (12.1 KB)
5. Intro to Excel Functions.mp4 (11.9 MB)
5.1 1.6 intro to functions.xlsx (11.3 KB)
6. Section 1 Quiz.html (0.2 KB)
2. MS Excel Basics
1. Intro to Section 2.mp4 (3.8 MB)
10. Q Paste Special.html (0.2 KB)
11. Keyboard shortcuts - moving faster in a spreadsheet.mp4 (25.2 MB)
11.1 2.7 Moving faster, shortcuts.xlsx (14.2 KB)
11.2 Excel Shortcuts.pdf (98.7 KB)
11.3 Find more shortcuts at Microsoft Support page.html (0.2 KB)
12. Macros.mp4 (23.6 MB)
12.1 2.8 macros.xlsx (11.5 KB)
13. Q Macros.html (0.2 KB)
14. Text to column, transpose function.mp4 (14.8 MB)
14.1 2.9 text to column.xlsx (10.8 KB)
15. Creating lists and dropdown menu.mp4 (17.4 MB)
15.1 2.10 creating lists, dropdown menu.xlsx (15.4 KB)
16. Text wrap and Line break.mp4 (15.7 MB)
16.1 2.11 wrap text.xlsx (14.2 KB)
17. Q Line break.html (0.2 KB)
18. Hyperlinks.mp4 (11.4 MB)
18.1 2.12 hyperlinks.xlsx (27.3 KB)
19. Starting each formula with equal or plus sign.mp4 (5.6 MB)
19.1 2.13 equals or plus.xlsx (10.3 KB)
2. Inserting, deleting, modifying rows and columns.mp4 (16.4 MB)
2.1 2.2 inserting, deleting, modifying rows and columns.xlsx (11.6 KB)
20. Freeze panes.mp4 (23.5 MB)
20.1 2.14 freeze panes.xlsx (23.4 KB)
21. Q Freeze panes.html (0.2 KB)
22. How to print Set print area.mp4 (14.4 MB)
22.1 2.15 print area.xlsx (33.6 KB)
23. Finding templates in Excel.mp4 (6.3 MB)
24. Excel Basics Quiz.html (0.2 KB)
3. Formatting cells.mp4 (19.1 MB)
3.1 2.3 formatting cells.xlsx (11.4 KB)
4. Q formatting.html (0.2 KB)
5. Formatting Spreadsheets.mp4 (49.0 MB)
5.1 2.4 formatting spreadsheet.xlsx (20.9 KB)
6. Q2 formatting.html (0.2 KB)
7. Cut, copy, paste.mp4 (12.2 MB)
7.1 2.5 cut, copy, paste.xlsx (11.1 KB)
8. Q CopyPaste.html (0.2 KB)
9. Paste Special, copying formulas.mp4 (26.4 MB)
9.1 2.6 Paste special.xlsx (14.7 KB)
3. Functions and Formulas
1. Intro to Section 3.mp4 (2.4 MB)
10. Vlookup, Hlookup.mp4 (48.2 MB)
10.1 3.6 Vlookup, HLookup.xlsx (21.1 KB)
11. Q Lookup functions.html (0.2 KB)
12. Index & Match.mp4 (59.9 MB)
12.1 3.7 index, match.xlsx (29.0 KB)
13. Q IndexMatch.html (0.2 KB)
14. Goal Seek.mp4 (15.6 MB)
14.1 3.8 goal seek.xlsx (24.5 KB)
15. Pivot Table.mp4 (47.2 MB)
15.1 3.9 pivot table.xlsx (24.7 KB)
16. Q Pivot.html (0.2 KB)
17. Choose Function helps you navigate between different scenarios.mp4 (14.2 MB)
17.1 3.10 choose.xlsx (12.5 KB)
18. Min, Max.mp4 (5.8 MB)
18.1 3.11 Min, Max.xlsx (11.9 KB)
19. Conditional Formatting.mp4 (59.5 MB)
19.1 3.12 conditional formatting.xlsx (47.0 KB)
2. Sum, SumIF, SumIFS.mp4 (39.1 MB)
2.1 3.1. sum, sumif, sumifs.xlsx (19.7 KB)
20. Q Cond. Formatting.html (0.2 KB)
21. Absolute & Relative References.mp4 (17.6 MB)
21.1 3.13 absolute and relative reference.xlsx (14.9 KB)
22. Working with Charts.mp4 (46.5 MB)
22.1 3.14 working with charts.xlsx (30.9 KB)
23. Working with Charts Secondary Axis, Sparklines, WaterfallBridge Charts.mp4 (56.9 MB)
23.1 3.14 working with charts part 2.xlsx (43.7 KB)
24. Find and Replace.mp4 (11.9 MB)
24.1 3.15 find and replace.xlsx (12.7 KB)
25. Date Function.mp4 (30.0 MB)
25.1 3.16 date function.xlsx (24.1 KB)
26. Section Quiz.html (0.2 KB)
3. Q Sum.html (0.2 KB)
4. Count, CountIF, CountIFS, CountA.mp4 (36.4 MB)
4.1 3.2 count, count if, countifs.xlsx (13.3 KB)
5. Q Count.html (0.2 KB)
6. Average, AverageIF, AverageIFS.mp4 (25.3 MB)
6.1 3.3 average.xlsx (20.4 KB)
7. Left, Right, Mid, Upper, Lower, Proper, Concatenate.mp4 (31.0 MB)
7.1 3.4 left, right, mid, upper, lower.xlsx (19.1 KB)
8. Q LeftRightMidUpper.html (0.2 KB)
9. IF Function.mp4 (59.0 MB)
9.1 3.5 IF Function.xlsx (15.6 KB)
4. Finance and Financial Analysis in Excel
1. Section Overview.mp4 (2.9 MB)
10. Ratio Analysis.mp4 (53.3 MB)
10.1 4.7 Ratio analysis.xlsx (20.9 KB)
11. Ratio Analysis part 2.mp4 (18.0 MB)
11.1 4.8 ratio analysis part 2.xlsx (13.3 KB)
12. Regression Analysis.mp4 (31.6 MB)
12.1 4.9 Regression Analysis.xlsx (13.4 KB)
13. Regression Analysis Part 2.mp4 (39.4 MB)
13.1 4.10 Regression Analysis part 2.xlsx (16.1 KB)
14. Correlation.mp4 (24.3 MB)
14.1 4.11 Correlation.xlsx (18.2 KB)
15. Stock pick - Analysis.mp4 (28.5 MB)
15.1 4.13 Fundamental analysis - Stock picking.xlsx (10.5 KB)
2. Discounted Cash Flow - NPV.mp4 (28.2 MB)
2.1 4.01 DCF analysis.xlsx (12.3 KB)
3. Q NPV.html (0.2 KB)
4. Dividend Discount Model.mp4 (44.2 MB)
4.1 4.2 stock valuation - dividend discount model.xlsx (11.3 KB)
5. Internal Rate of Return - IRR.mp4 (16.4 MB)
5.1 4.4 IRR.xlsx (12.8 KB)
6. Q IRR.html (0.2 KB)
7. PMT Function - Loan Schedule.mp4 (30.8 MB)
7.1 4.5 PMT function, Loan Schedule.xlsx (31.1 KB)
8. Q PMT.ht
files
2022-03-04 10:03:34
English
Seeders : 10 , Leechers : 2
Microsoft Excel Udemy
Udemy - Learn MS Excel and Data Analysis
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
Back