Udemy - Excel formulas and data operations

seeders: 13
leechers: 14
updated:

Download Fast Safe Anonymous
movies, software, shows...

Files

[ DevCourseWeb.com ] Udemy - Excel formulas and data operations
  • Get Bonus Downloads Here.url (0.2 KB)
  • ~Get Your Files Here ! 01 - How to learn Excel
    • 001 The New Excel Learning Curve.mp4 (57.4 MB)
    • 001 The New Excel Learning Curve_en.srt (3.6 KB)
    02 - Lesson 1. Introduction to Excel formulas
    • 001 1.1 Basic math formulas.mp4 (72.4 MB)
    • 001 1.1 Basic math formulas_en.srt (8.9 KB)
    • 001 1.1-solution.xlsx (19.4 KB)
    • 001 1.1.xlsx (18.8 KB)
    • 002 1.2 Formulas in the entire column.mp4 (65.3 MB)
    • 002 1.2 Formulas in the entire column_en.srt (6.7 KB)
    • 002 1.2-solution.xlsx (40.6 KB)
    • 002 1.2.xlsx (24.1 KB)
    • 003 1.3 Blocking formula address.mp4 (59.3 MB)
    • 003 1.3 Blocking formula address_en.srt (9.8 KB)
    • 003 1.3-solution.xlsx (15.4 KB)
    • 003 1.3.xlsx (13.3 KB)
    • 004 1.4 Formulas in tables.mp4 (66.6 MB)
    • 004 1.4 Formulas in tables_en.srt (9.4 KB)
    • 004 1.4-solution.xlsx (13.2 KB)
    • 004 1.4.xlsx (10.6 KB)
    • 005 1.5-solution.xlsx (12.5 KB)
    • 005 1.5. Defined names.mp4 (34.2 MB)
    • 005 1.5. Defined names_en.srt (4.9 KB)
    • 005 1.5.xlsx (10.8 KB)
    • 006 1.6 Shortcuts useful in working with cells and formulas.mp4 (103.8 MB)
    • 006 1.6 Shortcuts useful in working with cells and formulas_en.srt (12.3 KB)
    • 006 1.6.xlsx (12.0 KB)
    • 007 1.7 Errors and problems with formulas.mp4 (41.8 MB)
    • 007 1.7 Errors and problems with formulas_en.srt (7.7 KB)
    • 007 1.7-solution.xlsx (11.9 KB)
    • 007 1.7.xlsx (11.7 KB)
    • 008 1.8 DIY Introduction to Excel formulas.mp4 (46.0 MB)
    • 008 1.8 DIY Introduction to Excel formulas_en.srt (9.4 KB)
    • 008 1.8-solution.xlsx (15.8 KB)
    • 008 1.8.xlsx (15.0 KB)
    03 - Lesson 2. Excel functions overview
    • 001 2.1 Logical functions.mp4 (38.5 MB)
    • 001 2.1 Logical functions_en.srt (6.6 KB)
    • 002 2.1-2-solution.xlsx (12.5 KB)
    • 002 2.1-2.xlsx (11.0 KB)
    • 002 2.2 IF, IFS, SWITCH (Excel 365).mp4 (65.9 MB)
    • 002 2.2 IF, IFS, SWITCH (Excel 365)_en.srt (9.0 KB)
    • 003 2.3 Date & time functions.mp4 (91.8 MB)
    • 003 2.3 Date & time functions_en.srt (12.3 KB)
    • 003 2.3-solution.xlsx (13.4 KB)
    • 003 2.3.xlsx (12.8 KB)
    • 003 form11.mp4 (45.4 MB)
    • 004 2.4 Text functions (Excel 365).mp4 (127.0 MB)
    • 004 2.4 Text functions (Excel 365)_en.srt (16.1 KB)
    • 004 2.4-solution.xlsx (13.3 KB)
    • 004 2.4.xlsx (11.9 KB)
    • 005 2.5 DIY Excel functions overview.mp4 (100.3 MB)
    • 005 2.5 DIY Excel functions overview_en.srt (19.7 KB)
    • 005 2.5-solution.xlsx (21.3 KB)
    • 005 2.5.xlsx (18.0 KB)
    04 - Lesson 3. VLOOKUP
    • 001 3.1 Your first VLOOKUP.mp4 (64.6 MB)
    • 001 3.1 Your first VLOOKUP_en.srt (7.8 KB)
    • 002 3.2 Common problems with VLOOKUP.mp4 (57.2 MB)
    • 002 3.2 Common problems with VLOOKUP_en.srt (7.9 KB)
    • 003 3.3 Dealing with VLOOKUP errors with IFERROR.mp4 (16.5 MB)
    • 003 3.3 Dealing with VLOOKUP errors with IFERROR_en.srt (1.9 KB)
    • 004 3.4 VLOOKUP to the left.mp4 (18.0 MB)
    • 004 3.4 VLOOKUP to the left_en.srt (2.3 KB)
    • 005 3.5 VLOOKUP on more than 1 column.mp4 (11.5 MB)
    • 005 3.5 VLOOKUP on more than 1 column_en.srt (1.6 KB)
    • 006 3.6 VLOOKUP with TRUE.mp4 (14.5 MB)
    • 006 3.6 VLOOKUP with TRUE_en.srt (2.7 KB)
    • 007 3.7 VLOOKUP and many columns.mp4 (15.7 MB)
    • 007 3.7 VLOOKUP and many columns_en.srt (2.2 KB)
    • 008 3.1-8-solution.xlsx (65.4 KB)
    • 008 3.1-8.xlsx (62.5 KB)
    • 008 3.8 HLOOKUP.mp4 (20.7 MB)
    • 008 3.8 HLOOKUP_en.srt (2.4 KB)
    • 009 3.9 XLOOKUP and XMATCH (Excel 365).mp4 (10.2 MB)
    • 009 3.9 XLOOKUP and XMATCH (Excel 365)_en.srt (1.8 KB)
    • 009 3.9-solution.xlsx (60.3 KB)
    • 009 3.9.xlsx (57.7 KB)
    • 010 3.10 DIY VLOOKUP.mp4 (77.9 MB)
    • 010 3.10 DIY VLOOKUP_en.srt (12.7 KB)
    • 010 3.10-solution.xlsx (80.8 KB)
    • 010 3.10.xlsx (70.4 KB)
    05 - Lesson 4. Key reporting formulas
    • 001 4.1 COUNTIF and SUMIF.mp4 (70.8 MB)
    • 001 4.1 COUNTIF and SUMIF_en.srt (9.1 KB)
    • 002 4.2 COUNTIFS and SUMIFS.mp4 (86.0 MB)
    • 002 4.2 COUNTIFS and SUMIFS_en.srt (9.0 KB)
    • 003 4.3 AVERAGEIF and MINIFS.mp4 (16.2 MB)
    • 003 4.3 AVERAGEIF and MINIFS_en.srt (1.9 KB)
    • 004 4.4 SUMPRODUCT.mp4 (13.2 MB)
    • 004 4.4 SUMPRODUCT_en.srt (1.2 KB)
    • 005 4.5 Pivot table.mp4 (8.0 MB)
    • 005 4.5 Pivot table_en.srt (1.6 KB)
    • 006 4.6 Array formulas (Excel 365).mp4 (8.9 MB)
    • 006 4.6 Array formulas (Excel 365)_en.srt (1.3 KB)
    • 007 4.1-7-solution.xlsx (33.0 KB)
    • 007 4.1-7.xlsx (24.2 KB)
    • 007 4.7 Reference formulas.mp4 (32.1 MB)
    • 007 4.7 Reference formulas_en.srt (5.4 KB)
    • 008 4.8 DYI Key reporting formulas.mp4 (8.8 MB)
    • 008 4.8 DYI Key reporting formulas_en.srt (1.9 KB)
    • 008 4.8-solution.xlsx (40.2 KB)
    • 008 4.8.xlsx (33.1 KB)
    06 - Lesson 5. Data operations
    • 001 5.1 Basic filtering.mp4 (207.0 MB)
    • 001 5.1 Basic filtering_en.srt (36.0 KB)
    • 001 5.1-solution.xlsx (2.4 MB)
    • 001 5.1.xlsx (2.3 MB)
    • 002 5.2 Advanced filtering.mp4 (55.4 MB)
    • 002 5.2 Advanced filtering_en.srt (4.8 KB)
    • 002 5.2-solution.xlsx (3.2 MB)
    • 002 5.2.xlsx (3.1 MB)
    • 003 5.3 Sorting.mp4 (78.2 MB)
    • 003 5.3 Sorting_en.srt (7.5 KB)
    • 003 5.3-solution.xlsx (52.5 KB)
    • 003 5.3.xlsx (51.9 KB)
    • 004 5.4 Removing duplicates.mp4 (22.9 MB)
    • 004 5.4 Removing duplicates_en.srt (3.2 KB)
    • 004 5.4-solution.xlsx (787.1 KB)
    • 004 5.4.xlsx (766.8 KB)
    • 005 5.5 Conditional formatt

Description

Excel formulas and data operations



https://DevCourseWeb.com

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 41 lectures (4h 27m) | Size: 1.97 GB

The most important elements of Excel

What you'll learn
I recorded the course in such a way that each user could face all the tasks on their own, even without watching the video, and then check the results.
But if you're new to Excel, there are full-length videos of how formulas work and tasks step by step.
The course is also a great preparation for further deepening the knowledge of creating reports in Excel - with the use of Power Query, Power Pivot, dashboards a
I recorded the course in the form of challenges. Thanks to it, everyone will find something for themselves.

Requirements
I recorded the course in 2020 in Office 365, but the formulas have been working the same for years. You can easily follow the course in Excel 2007, 2010, 2013, 2016, 2019 and 365.
In older versions, you may not come across a few of the formulas discussed.



Download torrent
2.2 GB
seeders:13
leechers:14
Udemy - Excel formulas and data operations


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
2.2 GB
seeders:13
leechers:14
Udemy - Excel formulas and data operations


Torrent hash: 609D9BDC8C6E95574D06807E5BD1C9A91E270644