Udemy - Microsoft Excel For All - Students + Professionals

seeders: 18
leechers: 11
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

[ TutPig.com ] Udemy - Microsoft Excel For All - Students + Professionals
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Basics of Excel
    • 1. Introduction to Excel.mp4 (55.4 MB)
    • 2. Learn various methods of opening a new or an existing Excel file..mp4 (10.4 MB)
    • 3. Learn how Excel recognises different data, i.e date, time, text, digits..mp4 (16.9 MB)
    • 4. Difference between Function & Formula.mp4 (6.7 MB)
    • 5. Learn the application of BODMAS in Excel..mp4 (21.3 MB)
    • 6. Learn to customise Tabs, adddelete new tabs, hideunhide tabs.mp4 (16.9 MB)
    • 7. Learn various uses of Paste Special, Transpose etc..mp4 (25.7 MB)
    10. MOD QUOTIENT
    • 1. Learn the use of MOD & QUOTIENT functions in Excel with an amazing example..mp4 (9.5 MB)
    11. ERRORS
    • 1. Learn the list of 8 different types of common errors we get in Excel..mp4 (33.7 MB)
    • 2. IFERROR, Difference between System Generate Errors & Manual Errors..mp4 (12.3 MB)
    12. LOOKUPS
    • 1. Learn to use LOOKUP function in vertical and horizontal tables.mp4 (31.7 MB)
    • 2. Learnt the use of LOOKUP with Absolute Reference (locking the cell).mp4 (7.5 MB)
    • 3. HLOOKUP on a horizontal table.mp4 (11.3 MB)
    • 4. VLOOKUP on a vertical table.mp4 (11.0 MB)
    • 5. Learn the difference between TRUE & FALSE, Exact & Approximate Match..mp4 (12.5 MB)
    • 6. Advance V-Lookup with Mixed Reference.mp4 (22.7 MB)
    • 7. Multi-Dimensional V-Lookup with CONCATENATE Function.mp4 (37.8 MB)
    13. Time Calculation in Excel
    • 1. Time Calculation in Excel.mp4 (11.8 MB)
    14. Financial Functions
    • 1. Learn to calculate depreciation by different methods.mp4 (25.3 MB)
    • 2. Learn to calculate EMI & the portion of principal & interest in EMI.mp4 (45.1 MB)
    • 3. Learn to calculate future value in Excel.mp4 (11.0 MB)
    • 4. Learn to calculate Net Present Value & Internal Rate of Return of any investment.mp4 (16.2 MB)
    • 5. Calculation of NPV IRR for cash inflows on different date in Excel.mp4 (7.2 MB)
    15. Freeze Panes
    • 1. Freeze Panes.mp4 (81.4 MB)
    16. IF Function
    • 1. Learn the use of logical test & parameters in IF function.mp4 (29.1 MB)
    • 2. IF AND Learn to use more than one logical test in IF function.mp4 (36.1 MB)
    • 3. IF OR Learn to use of OR function in IF function to provide options in logical.mp4 (7.8 MB)
    • 4. IF NOT Learn to use of NOT function in logical test to get false or blank..mp4 (5.5 MB)
    • 5. NESTED IF Learn how to use multiple IFs to get answer to multiple parameters..mp4 (22.6 MB)
    • 6. Make Profit & Loss Account with the help of IF, SUM functions & Name Manager.mp4 (35.1 MB)
    • 7. Learn to prepare Income Tax Slabs for various % or Tax Rates..mp4 (22.6 MB)
    17. WhatifAnalysis
    • 1. Goal Seek.mp4 (32.3 MB)
    • 2. Learn advance use of Goal Seek.mp4 (20.2 MB)
    • 3. Learn Data Table to calculate various interest rates.mp4 (18.2 MB)
    • 4. Learn advance use of Data Table with both row and column input cells..mp4 (14.9 MB)
    • 5. Scenario Manager in different scenarios, create & compare Best & Worst Scenarios.mp4 (17.5 MB)
    18. An example of the manner & method with which I have taught in the course
    • 1. A Demo Lecture..mp4 (13.9 MB)
    19. INDEX & MATCH FUNCTIONS
    • 1. Learn the basic use of INDEX & MATCH Functions in Excel..mp4 (14.2 MB)
    • 2. Learn advance use of INDEX & MATCH with IFERROR Function..mp4 (17.3 MB)
    2. Fill Series
    • 1. Fill Series.mp4 (8.2 MB)
    • 2. Flash Fill.mp4 (23.3 MB)
    20. Macros & Relative Reference
    • 1. Basics of Macro.mp4 (25.9 MB)
    • 2. What is VBA Editor.mp4 (6.6 MB)
    • 3. How to Save a Macro File.mp4 (6.3 MB)
    • 4. The Fantastic use of Relative Reference in Macro.mp4 (37.3 MB)
    21. Protect Sheet
    • 1. How to lock cells to protect sheet.mp4 (32.5 MB)
    22. Formula Auditing
    • 1. What is Formula Auditing.mp4 (34.8 MB)
    23. Some Good to Know Features
    • 1. Good to Know Features.mp4 (18.7 MB)
    24. Charts
    • 1. Pie Chart Learn to how to add & customise 2D, 3D Pie Charts..mp4 (22.9 MB)
    • 2. Column Chart Learn to fix the default problem with the column chart X-axis..mp4 (13.3 MB)
    • 3. Learn different Sparkline Charts.mp4 (19.3 MB)
    25. Pivot Table & Charts
    • 1. Pivot Table.mp4 (34.1 MB)
    • 2. Pivot Chart.mp4 (15.0 MB)
    26. Simple & Dependent Drop-Down List
    • 1. Learn to createremove Simple Drop-Down List in Excel..mp4 (10.3 MB)
    • 2. Learn the advance Drop-Down List.mp4 (32.0 MB)
    27. Short Cuts in Excel
    • 1. Ctrl-A to Z Short Cuts.mp4 (26.0 MB)
    • 2. F1 to F12 Short Cuts.mp4 (8.2 MB)
    • 3. Ctrl 1 to 0 Short Cuts.mp4 (11.8 MB)
    28. Introduction
    • 1. Introduction to the Course.mp4 (18.5 MB)
    3. References
    • 1. Relative Reference.mp4 (14.3 MB)
    • 2. Absolute Reference.mp4 (19.1 MB)
    • 3. Mixed Reference.mp4 (19.9 MB)
    4. Conditional Formatting
    • 1. Basics of Conditional Formatting.mp4 (41.7 MB)
    • 2. New Rule in Conditional Formatting.mp4 (21.6 MB)
    • 3. Advance Conditional Formatting.mp4 (22.2 MB)
    5. 3D SUM
    • 1. 3D SUM.mp4 (21.1 MB)
    6. Hyperlink
    • 1. Hyperlink.mp4 (18.4 MB)
    7. Drop-Down List
    • 1. Simple Drop-Down List.mp4 (10.3 MB)
    • 2. Dependent Drop-Down List.mp4 (32.0 MB)
    8. Date Functions
    • 1. Default Date.mp4 (13.0 MB)
    • 2. Learn to add date, months & years in a particular date with the help of e-date..mp4 (17.4 MB)
    • 3. Le

Description

Microsoft Excel For All – Students + Professionals



MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 76 lectures (4h 6m) | Size: 1.47 GB
Excel in Excel
What you'll learn:
Learn functions & formulas with the easiest & the most comprehensible examples.
Learn to prepare for the most Excel practical examinations.
Learn to master usage of Excel in an office environment.
Learn various charts & Pivot Table with the easiest examples.
Learn practically MS Excel from basic to advance.
Learn unique & difficult combination of different functions in Excel.
Students who want to learn Excel. Professionals who want to improve in Excel & bring more clarity to various options.

Requirements
Need to have a Notebook, Laptop, Mac Book or a Personal Computer.
Need to have MS Office installed with any of the versions 2003, 2007, 2010, 2013, 2016, 2019.
It is preferable to have the recent versions of MS Office for the optimum tasks.
You will learn the basic & some advance uses of Excel after the end of this course.

Description
This course contains the basics to advance the learning of Excel. The quick explanation technique in video saves a lot of time, it has various functions & formulas explained in the easiest, accurate & most comprehensible examples for all. This course explains what are rows & columns how to hide/unhide & delete them, cell & range of cells & how to drag cells, who many spreadsheets in one Excel workbook, different Tabs & Ribbons, what is the Quick Access Toolbar, Name Box & Formula Bar, how to navigate Excel & how to save & save As. The application of BODMAS in Excel, learn when it will be applicable & when not.

In this course, you will get to learn the basics & advance usage of functions like LEFT, RIGHT, MID, CONCATENATE, NOW, TODAY, EOMONTH, NETWORKDAYS, NETWORKDAYSINTL, WORKDAY, SUBTOTAL, MOD & QUOTIENT, IFERROR, LOOKUP, HLOOKUP, HLOOKUP



Download torrent
1.6 GB
seeders:18
leechers:11
Udemy - Microsoft Excel For All - Students + Professionals

Trackers

tracker name
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
µTorrent compatible trackers list

Download torrent
1.6 GB
seeders:18
leechers:11
Udemy - Microsoft Excel For All - Students + Professionals

Torrent hash: CC2122BED241DB65CB8F95B6EE4B6324D0E2E95D