| 0 | 102.4 B | ||
| 1. Intro to Section 3.mp4 | 2.4 MB | ||
| 1. Section Overview.mp4 | 2.9 MB | ||
| 1 | 0 B | ||
| 1. Intro to Section 2.mp4 | 3.8 MB | ||
| 1. Introduction - Course Overview.mp4 | 10.5 MB | ||
| 2 | 6.2 KB | ||
| 3 | 395.2 KB | ||
| 4 | 74.1 KB | ||
| 5 | 203.7 KB | ||
| 6 | 487.4 KB | ||
| 7 | 318.2 KB | ||
| 8 | 313.9 KB | ||
| 9 | 36.8 KB | ||
| 10. Q Paste Special.html | 204.8 B | ||
| 10. Ratio Analysis.mp4 | 53.3 MB | ||
| 10. Vlookup, Hlookup.mp4 | 48.2 MB | ||
| 10.1 3.6 Vlookup, HLookup.xlsx | 21.1 KB | ||
| 10.1 4.7 Ratio analysis.xlsx | 20.9 KB | ||
| 11. Keyboard shortcuts - moving faster in a spreadsheet.mp4 | 25.2 MB | ||
| 11. Q Lookup functions.html | 204.8 B | ||
| 11. Ratio Analysis part 2.mp4 | 18 MB | ||
| 11.1 2.7 Moving faster, shortcuts.xlsx | 14.2 KB | ||
| 11.1 4.8 ratio analysis part 2.xlsx | 13.3 KB | ||
| 11.2 Excel Shortcuts.pdf | 98.7 KB | ||
| 11.3 Find more shortcuts at Microsoft Support page.html | 204.8 B | ||
| 12. Index & Match.mp4 | 59.9 MB | ||
| 12. Macros.mp4 | 23.6 MB | ||
| 12. Regression Analysis.mp4 | 31.6 MB | ||
| 12.1 2.8 macros.xlsx | 11.5 KB | ||
| 12.1 3.7 index, match.xlsx | 29 KB | ||
| 12.1 4.9 Regression Analysis.xlsx | 13.4 KB | ||
| 13. Q IndexMatch.html | 204.8 B | ||
| 13. Q Macros.html | 204.8 B | ||
| 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. Goal Seek.mp4 | 15.6 MB | ||
| 14. Text to column, transpose function.mp4 | 14.8 MB | ||
| 14.1 2.9 text to column.xlsx | 10.8 KB | ||
| 14.1 3.8 goal seek.xlsx | 24.5 KB | ||
| 14.1 4.11 Correlation.xlsx | 18.2 KB | ||
| 15. Creating lists and dropdown menu.mp4 | 17.4 MB | ||
| 15. Pivot Table.mp4 | 47.2 MB | ||
| 15. Stock pick - Analysis.mp4 | 28.5 MB | ||
| 15.1 2.10 creating lists, dropdown menu.xlsx | 15.4 KB | ||
| 15.1 3.9 pivot table.xlsx | 24.7 KB | ||
| 15.1 4.13 Fundamental analysis - Stock picking.xlsx | 10.5 KB | ||
| 16. Q Pivot.html | 204.8 B | ||
| 16. Text wrap and Line break.mp4 | 15.7 MB | ||
| 16.1 2.11 wrap text.xlsx | 14.2 KB | ||
| 17. Choose Function helps you navigate between different scenarios.mp4 | 14.2 MB | ||
| 17. Q Line break.html | 204.8 B | ||
| 17.1 3.10 choose.xlsx | 12.5 KB | ||
| 18. Hyperlinks.mp4 | 11.4 MB | ||
| 18. Min, Max.mp4 | 5.8 MB | ||
| 18.1 2.12 hyperlinks.xlsx | 27.3 KB | ||
| 18.1 3.11 Min, Max.xlsx | 11.9 KB | ||
| 19. Conditional Formatting.mp4 | 59.5 MB | ||
| 19. Starting each formula with equal or plus sign.mp4 | 5.6 MB | ||
| 19.1 2.13 equals or plus.xlsx | 10.3 KB | ||
| 19.1 3.12 conditional formatting.xlsx | 47 KB | ||
| 2. Course Resources - How to Use it.mp4 | 7 MB | ||
| 2. Discounted Cash Flow - NPV.mp4 | 28.2 MB | ||
| 2. Inserting, deleting, modifying rows and columns.mp4 | 16.4 MB | ||
| 2. Sum, SumIF, SumIFS.mp4 | 39.1 MB | ||
| 2.1 2.2 inserting, deleting, modifying rows and columns.xlsx | 11.6 KB | ||
| 2.1 3.1. sum, sumif, sumifs.xlsx | 19.7 KB | ||
| 2.1 4.01 DCF analysis.xlsx | 12.3 KB | ||
| 20. Freeze panes.mp4 | 23.5 MB | ||
| 20. Q Cond. Formatting.html | 204.8 B | ||
| 20.1 2.14 freeze panes.xlsx | 23.4 KB | ||
| 21. Absolute & Relative References.mp4 | 17.6 MB | ||
| 21. Q Freeze panes.html | 204.8 B | ||
| 21.1 3.13 absolute and relative reference.xlsx | 14.9 KB | ||
| 22. How to print Set print area.mp4 | 14.4 MB | ||
| 22. Working with Charts.mp4 | 46.5 MB | ||
| 22.1 2.15 print area.xlsx | 33.6 KB | ||
| 22.1 3.14 working with charts.xlsx | 30.9 KB | ||
| 23. Finding templates in Excel.mp4 | 6.3 MB | ||
| 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. Excel Basics Quiz.html | 204.8 B | ||
| 24. Find and Replace.mp4 | 11.9 MB | ||
| 24.1 3.15 find and replace.xlsx | 12.7 KB | ||
| 25. Date Function.mp4 | 30 MB | ||
| 25.1 3.16 date function.xlsx | 24.1 KB | ||
| 26. Section Quiz.html | 204.8 B | ||
| 3. Formatting cells.mp4 | 19.1 MB | ||
| 3. MS Excel Basics.mp4 | 22 MB | ||
| 3. Q NPV.html | 204.8 B | ||
| 3. Q Sum.html | 204.8 B | ||
| 3.1 2.3 formatting cells.xlsx | 11.4 KB | ||
| 3.1 Spreasheet basics.pdf | 97 KB | ||
| 4. Basic Excel Formulas.mp4 | 20.2 MB | ||
| 4. Count, CountIF, CountIFS, CountA.mp4 | 36.4 MB | ||
| 4. Dividend Discount Model.mp4 | 44.2 MB | ||
| 4. Q formatting.html | 204.8 B | ||
| 4.1 1.5 Basic formulas in excel.xlsx | 12.1 KB | ||
| 4.1 3.2 count, count if, countifs.xlsx | 13.3 KB | ||
| 4.1 4.2 stock valuation - dividend discount model.xlsx | 11.3 KB | ||
| 5. Formatting Spreadsheets.mp4 | 49 MB | ||
| 5. Internal Rate of Return - IRR.mp4 | 16.4 MB | ||
| 5. Intro to Excel Functions.mp4 | 11.9 MB | ||
| 5. Q Count.html | 204.8 B | ||
| 5.1 1.6 intro to functions.xlsx | 11.3 KB | ||
| 5.1 2.4 formatting spreadsheet.xlsx | 20.9 KB | ||
| 5.1 4.4 IRR.xlsx | 12.8 KB | ||
| 6. Average, AverageIF, AverageIFS.mp4 | 25.3 MB | ||
| 6. Q IRR.html | 204.8 B | ||
| 6. Q2 formatting.html | 204.8 B | ||
| 6. Section 1 Quiz.html | 204.8 B | ||
| 6.1 3.3 average.xlsx | 20.4 KB | ||
| 7. Cut, copy, paste.mp4 | 12.2 MB | ||
| 7. Left, Right, Mid, Upper, Lower, Proper, Concatenate.mp4 | 31 MB | ||
| 7. PMT Function - Loan Schedule.mp4 | 30.8 MB | ||
| 7.1 2.5 cut, copy, paste.xlsx | 11.1 KB | ||
| 7.1 3.4 left, right, mid, upper, lower.xlsx | 19.1 KB | ||
| 7.1 4.5 PMT function, Loan Schedule.xlsx | 31.1 KB | ||
| 8. Q CopyPaste.html | 204.8 B | ||
| 8. Q LeftRightMidUpper.html | 204.8 B | ||
| 8. Q PMT.html | 204.8 B | ||
| 9. IF Function.mp4 | 59 MB | ||
| 9. Paste Special, copying formulas.mp4 | 26.4 MB | ||
| 9. Scenario and Sensitivity Analysis - Data Table.mp4 | 81.2 MB | ||
| 9.1 2.6 Paste special.xlsx | 14.7 KB | ||
| 9.1 3.5 IF Function.xlsx | 15.6 KB | ||
| 9.1 4.6 Data Table, Sensitivity, Scenario Analysis.xlsx | 23.7 KB | ||
| TutsNode.com.txt | 102.4 B | ||
| [TGx]Downloaded from torrentgalaxy.to .txt | 614.4 B | ||
| 10 | 327.2 KB | ||
| 11 | 150.8 KB | ||
| 12 | 396 KB | ||
| 13 | 149.3 KB | ||
| 14 | 456 KB | ||
| 15 | 500.1 KB | ||
| 16 | 184.3 KB | ||
| 17 | 7.5 KB | ||
| 18 | 483.3 KB | ||
| 19 | 321.4 KB | ||
| 20 | 120.7 KB | ||
| 21 | 204.8 KB | ||
| 22 | 277 KB | ||
| 23 | 156.6 KB | ||
| 24 | 424 KB | ||
| 25 | 489.1 KB | ||
| 26 | 466.8 KB | ||
| 27 | 291.9 KB | ||
| 28 | 404.8 KB | ||
| 29 | 33 KB | ||
| 30 | 405.1 KB | ||
| 31 | 89 KB | ||
| 32 | 67.3 KB | ||
| 33 | 142.7 KB | ||
| 34 | 350.3 KB | ||
| 35 | 452.7 KB | ||
| 36 | 203.6 KB | ||
| 37 | 51.4 KB | ||
| 38 | 346.5 KB | ||
| 39 | 313.4 KB | ||
| 40 | 68.8 KB | ||
| 41 | 77.6 KB | ||
| 42 | 86.7 KB | ||
| 43 | 499.3 KB | ||
| 44 | 465.9 KB | ||
| 45 | 244.5 KB | ||
| 46 | 240.3 KB | ||
| 47 | 449.5 KB | ||
| 48 | 197.2 KB | ||
| 49 | 143.2 KB | ||
| ▲ 170 total files | |||
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.
***Extensive Experience as an eLearning video creator, course creator, for Udemy with over 8000 students.***
By the time you finish this course, you will have a deep understanding of the advanced tools that are built into Excel – and you’ll be able to apply your newfound knowledge in your job, schoolwork, or home life.
You will be able to analyze the company’s balance sheet and P&L in a short period of time.
Are you interested in using Microsoft Excel to analyze your data, but don’t know where to start? Listen to this course and you’ll learn how to use some of the most powerful functions, like VLOOKUP, INDEX/MATCH, and CHOOSE, as well as some of the lesser-known tricks like combining IF statements with array formulas.
This course is created for one simple purpose:
to show people that is possible to master Excel with a few simple techniques.
If you are:
a complete newbie when it comes to Excel and business modeling
an experienced user who wants to learn more about excel, advanced functions, and how to apply these functions for personal finances.
I will also show you how to convert Excel from a basic spreadsheet into an analytics tool by explaining some of the most powerful tools that Excel has been hiding from you.
Learn how to calculate your mortgage, solve for unknowns in equations, build a stocks portfolio that grows over time. Gain the excel skills to achieve your financial goals.
Once you understand some of the basics about how Excel functions, you will find it to be a powerful tool for organizing and analyzing data, so you can make informed decisions about everything from your home mortgage payments to your stocks or bond portfolio.
This is the course I wish I had when I just started using Excel in college for building a stocks portfolio. It covers everything from the basics to investment banking formulas and ratios.
If you are ready to master Excel and start crushing your spreadsheets, this is the course for you.
Easy to follow, with practical examples that show exactly how Excel can help you achieve your goals faster.
Start today!
Who this course is for:
Beginner MS Excel users and those who would like to use excel for data analysis and portfolio creation
Everyone who wants to accelerate their careers
Business professionals who want to expand their Excel knowledge
Students taking Finance classes and who want to master Excel
Financial analysts looking to jumpstart their careers
Requirements
No previous Excel knowledge required. You will learn everything from the start
Last Updated 2/2022
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1.2 GB | freecoursewb | 2 years | 2 | 0 | |
| 1 MB | freecoursewb | 3 years | 0 | 0 | |
|
Udemy - SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL [FCS] Posted by
fcs0310 in Other
|
3.6 GB | fcs0310 | 3 years | 1 | 1 |
| 1.3 GB | freecoursewb | 4 years | 0 | 0 | |
| 731.8 MB | freecoursewb | 4 years | 0 | 0 |
All Comments