Udemy - Microsoft Excel: Functions, Formulas, Analysis, & Dashboards

seeders: 38
leechers: 24
updated:
Download torrent
Added by tutsnode in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 353
  • Language: English

Files

Microsoft Excel Functions, Formulas, Analysis, & Dashboards [TutsNode.com] - Microsoft Excel Functions, Formulas, Analysis, & Dashboards 4. Level 4 Compiling data
  • 1. Vlookup.mp4 (129.8 MB)
  • 1. Vlookup.srt (20.7 KB)
  • 1.1 Vlookup.xlsx (16.4 MB)
  • 2. Hlookup.mp4 (39.0 MB)
  • 2. Hlookup.srt (8.5 KB)
  • 2.1 Hlookup.xlsx (183.0 KB)
  • 3. Consolidate.mp4 (31.7 MB)
  • 3. Consolidate.srt (6.8 KB)
  • 3.1 Consolidate.xlsx (10.0 KB)
  • 4. Append data with Power Query.mp4 (54.4 MB)
  • 4. Append data with Power Query.srt (7.8 KB)
  • 4.1 MonthlySalesFiles.zip (2.4 MB)
1. Level 1 Getting to know Excel
  • 1. Introduction to Spreadsheet, Cell, Column and Row.mp4 (52.5 MB)
  • 1. Introduction to Spreadsheet, Cell, Column and Row.srt (12.3 KB)
  • 2. Learning keyboard shortcuts to navigatge in a sheet, to add columns and rows.mp4 (44.7 MB)
  • 2. Learning keyboard shortcuts to navigatge in a sheet, to add columns and rows.srt (8.7 KB)
  • 3. Understanding cell format.mp4 (20.8 MB)
  • 3. Understanding cell format.srt (5.0 KB)
  • 4. Autofill.mp4 (10.1 MB)
  • 4. Autofill.srt (2.3 KB)
  • 5. Basic Mathamatical functions.mp4 (46.5 MB)
  • 5. Basic Mathamatical functions.srt (9.1 KB)
  • 6. Practice on real data.mp4 (93.6 MB)
  • 6. Practice on real data.srt (14.8 KB)
  • 6.1 Practice sheet.xlsx (8.9 KB)
2. Level 2 Cleaning data
  • 1. Remove duplicates.mp4 (34.3 MB)
  • 1. Remove duplicates.srt (7.0 KB)
  • 1.1 Product-Lookup - removing duplicates.xlsx (191.3 KB)
  • 2. Removing spaces.mp4 (65.0 MB)
  • 2. Removing spaces.srt (10.2 KB)
  • 2.1 Product-Lookup - removing spaces.xlsx (98.0 KB)
  • 3. Spell check.mp4 (48.4 MB)
  • 3. Spell check.srt (5.8 KB)
  • 3.1 Product-Lookup - spell check.xlsx (107.2 KB)
  • 4. Find Find & Replace.mp4 (78.3 MB)
  • 4. Find Find & Replace.srt (10.1 KB)
  • 4.1 Product-Lookup - find find and replace.xlsx (117.2 KB)
  • 5. Replacing blank cells.mp4 (26.2 MB)
  • 5. Replacing blank cells.srt (3.2 KB)
  • 5.1 Product-Lookup - blanks.xlsx (110.9 KB)
  • 6. Using proper fonts.mp4 (30.5 MB)
  • 6. Using proper fonts.srt (4.9 KB)
  • 6.1 Product-Lookup - Proper case.xlsx (36.0 KB)
3. Level 3 Transforming Data
  • 1. Merging data in cells.mp4 (36.2 MB)
  • 1. Merging data in cells.srt (7.2 KB)
  • 1.1 Product-Lookup - merging data in columns.xlsx (44.2 KB)
  • 2. Text to Columns.mp4 (52.2 MB)
  • 2. Text to Columns.srt (9.7 KB)
  • 2.1 Product-Lookup - unmerge or delimate.xlsx (59.5 KB)
  • 3. Data Sorting.mp4 (51.9 MB)
  • 3. Data Sorting.srt (8.3 KB)
  • 3.1 Product-Lookup - sorting.xlsx (190.2 KB)
  • 4. Transpose Data.mp4 (30.3 MB)
  • 4. Transpose Data.srt (5.0 KB)
  • 4.1 Transpose.xlsx (9.6 KB)
  • 5. Flash Fill.mp4 (27.2 MB)
  • 5. Flash Fill.srt (3.9 KB)
  • 5.1 Flash fill.xlsx (189.3 KB)
5. Level 5 Getting ready for Data Analysis
  • 1. Manipulating dates - Date Month Year.mp4 (26.2 MB)
  • 1. Manipulating dates - Date Month Year.srt (6.6 KB)
  • 1.1 Getting ready for data analysis - lectures.xlsx (135.0 KB)
  • 2. Manipulate dates - Name of the Day Name of the Month.mp4 (26.3 MB)
  • 2. Manipulate dates - Name of the Day Name of the Month.srt (5.3 KB)
  • 3. Manipulating dates - Day of the week Week of the year.mp4 (39.1 MB)
  • 3. Manipulating dates - Day of the week Week of the year.srt (6.4 KB)
  • 4. Day of the Year.mp4 (58.1 MB)
  • 4. Day of the Year.srt (11.2 KB)
  • 5. Quarter of the Year.mp4 (43.0 MB)
  • 5. Quarter of the Year.srt (8.4 KB)
  • 6. Dynamic TODAY Tomorrow Yesterday.mp4 (9.6 MB)
  • 6. Dynamic TODAY Tomorrow Yesterday.srt (2.4 KB)
  • 7. Calculating Age.mp4 (22.2 MB)
  • 7. Calculating Age.srt (4.6 KB)
  • 8. Adding conditional columns based on IF.mp4 (12.7 MB)
  • 8. Adding conditional columns based on IF.srt (2.9 KB)
  • 9. NESTED IF.mp4 (19.5 MB)
  • 9. NESTED IF.srt (3.9 KB)
  • 10. IF OR.mp4 (28.1 MB)
  • 10. IF OR.srt (5.4 KB)
  • 11. IF OR Multiple Column.mp4 (19.8 MB)
  • 11. IF OR Multiple Column.srt (4.0 KB)
  • 12. IF OR OR OR Practice.mp4 (27.8 MB)
  • 12. IF OR OR OR Practice.srt (5.3 KB)
  • 13. IF AND.mp4 (20.5 MB)
  • 13. IF AND.srt (4.5 KB)
  • 14. IF AND AND AND Practice.mp4 (27.1 MB)
  • 14. IF AND AND AND Practice.srt (3.5 KB)
6. Level 6 Basic Data Analysis (Ad hoc Data Analysis)
  • 1. Freeze Panes.mp4 (43.1 MB)
  • 1. Freeze Panes.srt (5.1 KB)
  • 1.1 Analysis sheet.xlsx (11.8 MB)
  • 2. Filters and advance filters.mp4 (77.2 MB)
  • 2. Filters and advance filters.srt (9.6 KB)
  • 3. Conditional Formatting.mp4 (121.6 MB)
  • 3. Conditional Formatting.srt (11.8 KB)
  • 4. Subtotals.mp4 (30.3 MB)
  • 4. Subtotals.srt (3.7 KB)
  • 5. COUNTIF.mp4 (43.7 MB)
  • 5. COUNTIF.srt (5.0 KB)
  • 6. COUNTIFS.mp4 (29.3 MB)
  • 6. COUNTIFS.srt (3.8 KB)
  • 7. SUMIF.mp4 (45.2 MB)
  • 7. SUMIF.srt (5.6 KB)
  • 8. SUMIFS.mp4 (40.8 MB)
  • 8. SUMIFS.srt (4.6 KB)
7. Level 7 Data Analysis
  • 1. Introduction to Data Analaysis and Data.mp4 (56.4 MB)
  • 1. Introduction to Data Analaysis and Data.srt (6.8 KB)
  • 1.1 Analysis - lectures.xlsx (11.8 MB)
  • 2. Summay by a parameter.mp4 (41.3 MB)
  • 2. Summay by a parameter.srt (8.6 KB)
  • 3. Adding parameters with drill down and drill up.mp4 (17.8 MB)
  • 3. Adding parameters with drill down and drill up.srt (4.4 KB)
  • 4. Breaking down information by Column.mp4 (18.9 MB)
  • <

Description


Description

If your work requires working with numbers or large amounts of data, Microsoft Excel is your software.

Microsoft Excel is one of the most powerful data management and data analysis tool.

This course enables students to start using Excel in an effective manner. It starts from the very basics and within a few minutes, you will be having a good command over basic excel functions and even some advanced and frequently used features.

About this course:

Designed to teach Microsoft Excel to absolute beginners, this course will take you from scratch to a level where you can effectively store, manage, clean, transform, consolidate, analyze, and visualize data.

Prerequisites:

There is absolutely no prerequisite to start this course. Even 8 years old can take this course to learn Excel.

Who should take this course:

First-time learners, who have no idea about Excel and want to start the right way. This includes:

Students
Professionals, especially those who have to work with numbers.
Daydreamers who wish to bring financial sense to their dreams.
Anyone who wants to learn a better way to manage the numbers and calculations.

Software Requirement:

You should have Microsoft Excel installed on your computer. Any version above Excel 2010 will be okay. I will be using Excel 2016 in this course. If you do not have Excel currently, please download Office 365 free trial from the Microsoft website. Just google Office 365 free trial and it will take you to the page.

Money-Back Guarantee:

Nothing to lose! If you won’t be satisfied with the course, Udemy offers 30 days money-back guarantee!

Introduction to the teacher:

Chartered Accountant | 12 years of work experience | 12 years of teaching experience as visiting faculty | 4000+ in-class students | 100,000+ Udemy students | In love with Excel for 15 years
Who this course is for:

Beginner level users of Excel who are looking for a solid foundation
Students, business owners, entrepreneurs and professionals
Students with Zero knowledge of Excel

Requirements

Microsoft Excel 2016, or any other version

Last Updated 9/2020



Download torrent
2.5 GB
seeders:38
leechers:24
Udemy - Microsoft Excel: Functions, Formulas, Analysis, & Dashboards

Trackers

tracker name
udp://inferno.demonoid.pw:3391/announce
udp://tracker.openbittorrent.com:80/announce
udp://tracker.opentrackr.org:1337/announce
udp://torrent.gresille.org:80/announce
udp://glotorrents.pw:6969/announce
udp://tracker.leechers-paradise.org:6969/announce
udp://tracker.pirateparty.gr:6969/announce
udp://tracker.coppersurfer.tk:6969/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://9.rarbg.to:2710/announce
udp://shadowshq.yi.org:6969/announce
udp://tracker.zer0day.to:1337/announce
µTorrent compatible trackers list

Download torrent
2.5 GB
seeders:38
leechers:24
Udemy - Microsoft Excel: Functions, Formulas, Analysis, & Dashboards

Torrent hash: C98A6DDC61AFD5904A94A5A3D0AEF7930AC2FDB9