Torrent Downloads » Other » [ TutPig com ] Udemy - Microsoft Excel For All - Students + Professionals
Other
[ TutPig com ] Udemy - Microsoft Excel For All - Students + Professionals
Torrent info
Torrent Files List
Get Bonus Downloads Here.url (Size: 1.58 GB) (Files: 78)
Get Bonus Downloads Here.url
~Get Your Files Here !
1. Basics of Excel
1. Introduction to Excel.mp4
2. Learn various methods of opening a new or an existing Excel file..mp4
3. Learn how Excel recognises different data, i.e date, time, text, digits..mp4
4. Difference between Function & Formula.mp4
5. Learn the application of BODMAS in Excel..mp4
6. Learn to customise Tabs, adddelete new tabs, hideunhide tabs.mp4
7. Learn various uses of Paste Special, Transpose etc..mp4
10. MOD QUOTIENT
1. Learn the use of MOD & QUOTIENT functions in Excel with an amazing example..mp4
11. ERRORS
1. Learn the list of 8 different types of common errors we get in Excel..mp4
2. IFERROR, Difference between System Generate Errors & Manual Errors..mp4
12. LOOKUPS
1. Learn to use LOOKUP function in vertical and horizontal tables.mp4
2. Learnt the use of LOOKUP with Absolute Reference (locking the cell).mp4
3. HLOOKUP on a horizontal table.mp4
4. VLOOKUP on a vertical table.mp4
5. Learn the difference between TRUE & FALSE, Exact & Approximate Match..mp4
6. Advance V-Lookup with Mixed Reference.mp4
7. Multi-Dimensional V-Lookup with CONCATENATE Function.mp4
13. Time Calculation in Excel
1. Time Calculation in Excel.mp4
14. Financial Functions
1. Learn to calculate depreciation by different methods.mp4
2. Learn to calculate EMI & the portion of principal & interest in EMI.mp4
3. Learn to calculate future value in Excel.mp4
4. Learn to calculate Net Present Value & Internal Rate of Return of any investment.mp4
5. Calculation of NPV IRR for cash inflows on different date in Excel.mp4
15. Freeze Panes
1. Freeze Panes.mp4
16. IF Function
1. Learn the use of logical test & parameters in IF function.mp4
2. IF AND Learn to use more than one logical test in IF function.mp4
3. IF OR Learn to use of OR function in IF function to provide options in logical.mp4
4. IF NOT Learn to use of NOT function in logical test to get false or blank..mp4
5. NESTED IF Learn how to use multiple IFs to get answer to multiple parameters..mp4
6. Make Profit & Loss Account with the help of IF, SUM functions & Name Manager.mp4
7. Learn to prepare Income Tax Slabs for various % or Tax Rates..mp4
17. WhatifAnalysis
1. Goal Seek.mp4
2. Learn advance use of Goal Seek.mp4
3. Learn Data Table to calculate various interest rates.mp4
4. Learn advance use of Data Table with both row and column input cells..mp4
5. Scenario Manager in different scenarios, create & compare Best & Worst Scenarios.mp4
18. An example of the manner & method with which I have taught in the course
1. A Demo Lecture..mp4
19. INDEX & MATCH FUNCTIONS
1. Learn the basic use of INDEX & MATCH Functions in Excel..mp4
2. Learn advance use of INDEX & MATCH with IFERROR Function..mp4
2. Fill Series
1. Fill Series.mp4
2. Flash Fill.mp4
20. Macros & Relative Reference
1. Basics of Macro.mp4
2. What is VBA Editor.mp4
3. How to Save a Macro File.mp4
4. The Fantastic use of Relative Reference in Macro.mp4
21. Protect Sheet
1. How to lock cells to protect sheet.mp4
22. Formula Auditing
1. What is Formula Auditing.mp4
23. Some Good to Know Features
1. Good to Know Features.mp4
24. Charts
1. Pie Chart Learn to how to add & customise 2D, 3D Pie Charts..mp4
2. Column Chart Learn to fix the default problem with the column chart X-axis..mp4
3. Learn different Sparkline Charts.mp4
25. Pivot Table & Charts
1. Pivot Table.mp4
2. Pivot Chart.mp4
26. Simple & Dependent Drop-Down List
1. Learn to createremove Simple Drop-Down List in Excel..mp4
2. Learn the advance Drop-Down List.mp4
27. Short Cuts in Excel
1. Ctrl-A to Z Short Cuts.mp4
2. F1 to F12 Short Cuts.mp4
3. Ctrl 1 to 0 Short Cuts.mp4
28. Introduction
1. Introduction to the Course.mp4
3. References
1. Relative Reference.mp4
2. Absolute Reference.mp4
3. Mixed Reference.mp4
4. Conditional Formatting
1. Basics of Conditional Formatting.mp4
2. New Rule in Conditional Formatting.mp4
3. Advance Conditional Formatting.mp4
5. 3D SUM
1. 3D SUM.mp4
6. Hyperlink
1. Hyperlink.mp4
7. Drop-Down List
1. Simple Drop-Down List.mp4
2. Dependent Drop-Down List.mp4
8. Date Functions
1. Default Date.mp4
2. Learn to add date, months & years in a particular date with the help of e-date..mp4
3. Learn to know the last date of next month, or the following month..mp4
4. Learn how to compute working days considering different weekends..mp4
5. Learn to calculate exact number of years, months & days from a historic date..mp4
9. Subtotal
1. Learn the use of SUBTOTAL function in Excel, learn how to use SubTotal under Dat.mp4
2. Learn the amazing use of adding filter & slicer in a given data..mp4
Bonus Resources.txt
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [ TutPig com ] Udemy - Microsoft Excel For All - Students + Professionals Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
