589689.xyz

[ ] Udemy - Microsoft Excel For All - Students + Professionals

  • 收录时间:2021-10-11 06:07:44
  • 文件大小:2GB
  • 下载次数:1
  • 最近下载:2021-10-11 06:07:44
  • 磁力链接:
立即下载 复制链接

文件列表

  1. ~Get Your Files Here !/15. Freeze Panes/1. Freeze Panes.mp4 81MB
  2. ~Get Your Files Here !/1. Basics of Excel/1. Introduction to Excel.mp4 55MB
  3. ~Get Your Files Here !/9. Subtotal/1. Learn the use of SUBTOTAL function in Excel, learn how to use SubTotal under Dat.mp4 55MB
  4. ~Get Your Files Here !/14. Financial Functions/2. Learn to calculate EMI & the portion of principal & interest in EMI.mp4 45MB
  5. ~Get Your Files Here !/4. Conditional Formatting/1. Basics of Conditional Formatting.mp4 42MB
  6. ~Get Your Files Here !/12. LOOKUPS/7. Multi-Dimensional V-Lookup with CONCATENATE Function.mp4 38MB
  7. ~Get Your Files Here !/20. Macros & Relative Reference/4. The Fantastic use of Relative Reference in Macro.mp4 37MB
  8. ~Get Your Files Here !/16. IF Function/2. IF AND Learn to use more than one logical test in IF function.mp4 36MB
  9. ~Get Your Files Here !/16. IF Function/6. Make Profit & Loss Account with the help of IF, SUM functions & Name Manager.mp4 35MB
  10. ~Get Your Files Here !/22. Formula Auditing/1. What is Formula Auditing.mp4 35MB
  11. ~Get Your Files Here !/25. Pivot Table & Charts/1. Pivot Table.mp4 34MB
  12. ~Get Your Files Here !/11. ERRORS/1. Learn the list of 8 different types of common errors we get in Excel..mp4 34MB
  13. ~Get Your Files Here !/21. Protect Sheet/1. How to lock cells to protect sheet.mp4 32MB
  14. ~Get Your Files Here !/17. WhatifAnalysis/1. Goal Seek.mp4 32MB
  15. ~Get Your Files Here !/26. Simple & Dependent Drop-Down List/2. Learn the advance Drop-Down List.mp4 32MB
  16. ~Get Your Files Here !/7. Drop-Down List/2. Dependent Drop-Down List.mp4 32MB
  17. ~Get Your Files Here !/12. LOOKUPS/1. Learn to use LOOKUP function in vertical and horizontal tables.mp4 32MB
  18. ~Get Your Files Here !/16. IF Function/1. Learn the use of logical test & parameters in IF function.mp4 29MB
  19. ~Get Your Files Here !/27. Short Cuts in Excel/1. Ctrl-A to Z Short Cuts.mp4 26MB
  20. ~Get Your Files Here !/20. Macros & Relative Reference/1. Basics of Macro.mp4 26MB
  21. ~Get Your Files Here !/1. Basics of Excel/7. Learn various uses of Paste Special, Transpose etc..mp4 26MB
  22. ~Get Your Files Here !/14. Financial Functions/1. Learn to calculate depreciation by different methods.mp4 25MB
  23. ~Get Your Files Here !/2. Fill Series/2. Flash Fill.mp4 23MB
  24. ~Get Your Files Here !/24. Charts/1. Pie Chart Learn to how to add & customise 2D, 3D Pie Charts..mp4 23MB
  25. ~Get Your Files Here !/12. LOOKUPS/6. Advance V-Lookup with Mixed Reference.mp4 23MB
  26. ~Get Your Files Here !/16. IF Function/7. Learn to prepare Income Tax Slabs for various % or Tax Rates..mp4 23MB
  27. ~Get Your Files Here !/16. IF Function/5. NESTED IF Learn how to use multiple IFs to get answer to multiple parameters..mp4 23MB
  28. ~Get Your Files Here !/4. Conditional Formatting/3. Advance Conditional Formatting.mp4 22MB
  29. ~Get Your Files Here !/4. Conditional Formatting/2. New Rule in Conditional Formatting.mp4 22MB
  30. ~Get Your Files Here !/9. Subtotal/2. Learn the amazing use of adding filter & slicer in a given data..mp4 21MB
  31. ~Get Your Files Here !/1. Basics of Excel/5. Learn the application of BODMAS in Excel..mp4 21MB
  32. ~Get Your Files Here !/5. 3D SUM/1. 3D SUM.mp4 21MB
  33. ~Get Your Files Here !/17. WhatifAnalysis/2. Learn advance use of Goal Seek.mp4 20MB
  34. ~Get Your Files Here !/3. References/3. Mixed Reference.mp4 20MB
  35. ~Get Your Files Here !/24. Charts/3. Learn different Sparkline Charts.mp4 19MB
  36. ~Get Your Files Here !/3. References/2. Absolute Reference.mp4 19MB
  37. ~Get Your Files Here !/23. Some Good to Know Features/1. Good to Know Features.mp4 19MB
  38. ~Get Your Files Here !/28. Introduction/1. Introduction to the Course.mp4 18MB
  39. ~Get Your Files Here !/6. Hyperlink/1. Hyperlink.mp4 18MB
  40. ~Get Your Files Here !/17. WhatifAnalysis/3. Learn Data Table to calculate various interest rates.mp4 18MB
  41. ~Get Your Files Here !/17. WhatifAnalysis/5. Scenario Manager in different scenarios, create & compare Best & Worst Scenarios.mp4 18MB
  42. ~Get Your Files Here !/8. Date Functions/2. Learn to add date, months & years in a particular date with the help of e-date..mp4 17MB
  43. ~Get Your Files Here !/19. INDEX & MATCH FUNCTIONS/2. Learn advance use of INDEX & MATCH with IFERROR Function..mp4 17MB
  44. ~Get Your Files Here !/1. Basics of Excel/6. Learn to customise Tabs, adddelete new tabs, hideunhide tabs.mp4 17MB
  45. ~Get Your Files Here !/1. Basics of Excel/3. Learn how Excel recognises different data, i.e date, time, text, digits..mp4 17MB
  46. ~Get Your Files Here !/14. Financial Functions/4. Learn to calculate Net Present Value & Internal Rate of Return of any investment.mp4 16MB
  47. ~Get Your Files Here !/25. Pivot Table & Charts/2. Pivot Chart.mp4 15MB
  48. ~Get Your Files Here !/8. Date Functions/4. Learn how to compute working days considering different weekends..mp4 15MB
  49. ~Get Your Files Here !/17. WhatifAnalysis/4. Learn advance use of Data Table with both row and column input cells..mp4 15MB
  50. ~Get Your Files Here !/3. References/1. Relative Reference.mp4 14MB
  51. ~Get Your Files Here !/19. INDEX & MATCH FUNCTIONS/1. Learn the basic use of INDEX & MATCH Functions in Excel..mp4 14MB
  52. ~Get Your Files Here !/8. Date Functions/5. Learn to calculate exact number of years, months & days from a historic date..mp4 14MB
  53. ~Get Your Files Here !/18. An example of the manner & method with which I have taught in the course/1. A Demo Lecture..mp4 14MB
  54. ~Get Your Files Here !/24. Charts/2. Column Chart Learn to fix the default problem with the column chart X-axis..mp4 13MB
  55. ~Get Your Files Here !/8. Date Functions/1. Default Date.mp4 13MB
  56. ~Get Your Files Here !/12. LOOKUPS/5. Learn the difference between TRUE & FALSE, Exact & Approximate Match..mp4 13MB
  57. ~Get Your Files Here !/11. ERRORS/2. IFERROR, Difference between System Generate Errors & Manual Errors..mp4 12MB
  58. ~Get Your Files Here !/13. Time Calculation in Excel/1. Time Calculation in Excel.mp4 12MB
  59. ~Get Your Files Here !/27. Short Cuts in Excel/3. Ctrl 1 to 0 Short Cuts.mp4 12MB
  60. ~Get Your Files Here !/12. LOOKUPS/3. HLOOKUP on a horizontal table.mp4 11MB
  61. ~Get Your Files Here !/12. LOOKUPS/4. VLOOKUP on a vertical table.mp4 11MB
  62. ~Get Your Files Here !/14. Financial Functions/3. Learn to calculate future value in Excel.mp4 11MB
  63. ~Get Your Files Here !/1. Basics of Excel/2. Learn various methods of opening a new or an existing Excel file..mp4 10MB
  64. ~Get Your Files Here !/7. Drop-Down List/1. Simple Drop-Down List.mp4 10MB
  65. ~Get Your Files Here !/26. Simple & Dependent Drop-Down List/1. Learn to createremove Simple Drop-Down List in Excel..mp4 10MB
  66. ~Get Your Files Here !/10. MOD QUOTIENT/1. Learn the use of MOD & QUOTIENT functions in Excel with an amazing example..mp4 9MB
  67. ~Get Your Files Here !/2. Fill Series/1. Fill Series.mp4 8MB
  68. ~Get Your Files Here !/27. Short Cuts in Excel/2. F1 to F12 Short Cuts.mp4 8MB
  69. ~Get Your Files Here !/16. IF Function/3. IF OR Learn to use of OR function in IF function to provide options in logical.mp4 8MB
  70. ~Get Your Files Here !/12. LOOKUPS/2. Learnt the use of LOOKUP with Absolute Reference (locking the cell).mp4 8MB
  71. ~Get Your Files Here !/14. Financial Functions/5. Calculation of NPV IRR for cash inflows on different date in Excel.mp4 7MB
  72. ~Get Your Files Here !/8. Date Functions/3. Learn to know the last date of next month, or the following month..mp4 7MB
  73. ~Get Your Files Here !/1. Basics of Excel/4. Difference between Function & Formula.mp4 7MB
  74. ~Get Your Files Here !/20. Macros & Relative Reference/2. What is VBA Editor.mp4 7MB
  75. ~Get Your Files Here !/20. Macros & Relative Reference/3. How to Save a Macro File.mp4 6MB
  76. ~Get Your Files Here !/16. IF Function/4. IF NOT Learn to use of NOT function in logical test to get false or blank..mp4 6MB
  77. ~Get Your Files Here !/Bonus Resources.txt 357B
  78. Get Bonus Downloads Here.url 176B