Udemy - Microsoft Excel Data Analysis: Pivot Tables and Formulas [Course Drive]

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size1.4 GB
  • Uploaded Bycoursedrive
  • Downloads641
  • Last checkedApr. 29th '20
  • Date uploadedApr. 27th '20
  • Seeders 18
  • Leechers11
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : A874E583CB7DBED74649CB4523D11E22F2FAEE40

⚡️⚡️For More Udemy Courses Visit ?? Course Drive



Microsoft Excel Data Analysis: Pivot Tables and Formulas

Learn Data Analysis, Formulas, and Pivot Tables. Data Analysis in Microsoft Excel for Beginners and Intermediate users






What you'll learn

• How to create Pivot Tables to quickly summarize data
• How to use VLOOKUP and INDEX/MATCH to pull out specific info from large data sets
• How to use basic math/statistical functions like SUM, AVERAGE, COUNTIFS, and more...
• How to build conditional statements using the IF() function
• How to organize data to be scalable and easily used other data analysts
• How to move around Excel quickly and efficiently
• How to sort and filter data based on specific criteria
• How to streamline your data analysis workflow in Excel

Requirements

• Microsoft Excel for PC (2013 or later recommended. Some features may not be available in earlier versions)
• Some prior knowledge of Excel will be helpful.

Description

This course will teach you to go from level up from beginner to intermediate in Excel in around 2 hours. You'll learn a wide variety of important Excel features, including Pivot Tables, sorting and filtering, keyboard shortcuts, as well as intermediate functions like VLOOKUP, INDEX & MATCH, IF statements, and many more (2016 PC Version used in course).
Sample data sets provided for you to follow along and learn as you watch!

Who this course is for:

• Job seekers who want to add "Microsoft Excel" as a skill on their resume or Linkedin Profile
• Aspiring Data Analysts, Managers, or employees that anticipate using MORE data in the future
• Anyone already in a job/career that involves data who wants to level up their skills in Excel
• Anyone who wants to learn how to cut hours off of their weekly reporting tasks
• Anyone who wants to learn how to learn excel for budgeting, side projects, or as an additional skill

Files:

Microsoft Excel Data Analysis - Pivot Tables and Formulas Microsoft Excel Data Analysis - Pivot Tables and Formulas 06 Functions and Formulas Part 3
  • 043 Project 2 - Answers and Walk Through Video.mp4 (64.6 MB)
  • 029 Lookup Functions VLOOKUP - Part 1-en.srt (2.8 KB)
  • 029 Lookup Functions VLOOKUP - Part 1.mp4 (29.4 MB)
  • 029 LOOKUP-Functions-VLOOKUP.xlsx (28.5 KB)
  • 030 Lookup Functions VLOOKUP - Part 2-en.srt (2.5 KB)
  • 030 Lookup Functions VLOOKUP - Part 2.mp4 (28.6 MB)
  • 031 Lookup Functions VLOOKUP - Part 3-en.srt (3.1 KB)
  • 031 Lookup Functions VLOOKUP - Part 3.mp4 (36.7 MB)
  • 032 INDEX-MATCH.xlsx (29.3 KB)
  • 032 Lookup Functions INDEX-en.srt (2.6 KB)
  • 032 Lookup Functions INDEX.mp4 (24.2 MB)
  • 033 Lookup Functions MATCH-en.srt (1.8 KB)
  • 033 Lookup Functions MATCH.mp4 (18.9 MB)
  • 034 Lookup Functions INDEX MATCH - Part 1-en.srt (2.2 KB)
  • 034 Lookup Functions INDEX MATCH - Part 1.mp4 (23.5 MB)
  • 035 Lookup Functions INDEX MATCH - Part 2-en.srt (3.8 KB)
  • 035 Lookup Functions INDEX MATCH - Part 2.mp4 (37.2 MB)
  • 036 Logical Functions Part 1-en.srt (2.3 KB)
  • 036 Logical Functions Part 1.mp4 (15.4 MB)
  • 036 LOGICAL-Functions.xlsx (12.0 KB)
  • 037 Logical Functions Part 2-en.srt (4.1 KB)
  • 037 Logical Functions Part 2.mp4 (43.1 MB)
  • 038 Logical Functions Part 3-en.srt (4.5 KB)
  • 038 Logical Functions Part 3.mp4 (48.8 MB)
  • 039 Errors in Excel Part 1 - NA and the IFERROR Functiton-en.srt (1.8 KB)
  • 039 Errors in Excel Part 1 - NA and the IFERROR Functiton.mp4 (19.0 MB)
  • 039 ERRORS-in-Excel.xlsx (25.9 KB)
  • 040 Errors in Excel Part 2 - NAME and VALUE-en.srt (1.8 KB)
  • 040 Errors in Excel Part 2 - NAME and VALUE.mp4 (16.4 MB)
  • 041 Errors in Excel Part 3 - REF Errors-en.srt (2.8 KB)
  • 041 Errors in Excel Part 3 - REF Errors.mp4 (24.1 MB)
  • 042 Formulas-Project-2.xlsx (62.5 KB)
  • 042 Project 2 - Intro and Project Files-en.srt (2.0 KB)
  • 042 Project 2 - Intro and Project Files.mp4 (11.9 MB)
  • 043 Project 2 - Answers and Walk Through Video-en.srt (6.1 KB)
  • ReadMe.txt (0.2 KB)
  • Visit Coursedrive.org.url (0.1 KB)
    • 01 Welcome
    • 001 Welcome to this Data Analysis Course-en.srt (1.5 KB)
    • 001 Welcome to this Data Analysis Course.mp4 (4.2 MB)
    02 The Data Set for this Course
    • 002 Data-Analysis-for-Excel.pdf (1.6 MB)
    • 002 Download the Powerpoint file for this Course (Optional).html (1.1 KB)
    • 003 Raw-Data.xlsx (211.2 KB)
    • 003 Understanding our Data Set - Part 1-en.srt (1.0 KB)
    • 003 Understanding our Data Set - Part 1.mp4 (5.5 MB)
    • 004 Metrics and Dimensions-en.srt (3.6 KB)
    • 004 Metrics and Dimensions.mp4 (15.9 MB)
    • 005 Understanding our Data Set - Part 2-en.srt (3.6 KB)
    • 005 Understanding our Data Set - Part 2.mp4 (26.8 MB)
    03 Foundational Principles
    • 006 Foundations Lesson 1 - Sorting Data-en.srt (8.3 KB)
    • 006 Foundations Lesson 1 - Sorting Data.mp4 (55.9 MB)
    • 006 Foundations-Workbook.xlsx (70.7 KB)
    • 007 Foundations Lesson 2 - Filtering Data-en.srt (5.4 KB)
    • 007 Foundations Lesson 2 - Filtering Data.mp4 (36.7 MB)
    • 008 Foundations Lesson 3 - Autofilling Patterns and Formulas-en.srt (3.1 KB)
    • 008 Foundations Lesson 3 - Autofilling Patterns and Formulas.mp4 (14.9 MB)
    • 009 Foundations Lesson 4 - Named Ranges-en.srt (3.1 KB)
    • 009 Foundations Lesson 4 - Named Ranges.mp4 (27.4 MB)
    • 010 Keyboard Shortcuts Lesson 1 Moving around your workbook-en.srt (3.1 KB)
    • 010 Keyboard Shortcuts Lesson 1 Moving around your workbook.mp4 (27.0 MB)
    • 010 Keyboard-Shortcuts-Raw-Data.xlsx (65.6 KB)
    • 011 Keyboard Shortcuts Lesson 2 CTRL 1-en.srt (2.2 KB)
    • 011 Keyboard Shortcuts Lesson 2 CTRL 1.mp4 (13.0 MB)
    • 012 Keyboard Shortcuts Lesson 3 Cut Copy Paste Undo Find-en.srt (2.1 KB)
    • 012 Keyboard Shortcuts Lesson 3 Cut Copy Paste Undo Find.mp4 (17.8 MB)
    04 Functions and Formulas Part 1
    • 013 Introduction to Formulas Part 1-en.srt (3.1 KB)
    • 013 Introduction to Formulas Part 1.mp4 (15.6 MB)
    • 014 Introduction to Formulas Part 2-en.srt (2.1 KB)
    • 014 Introduction to Formulas Part 2.mp4 (7.8 MB)
    • 015 Date-Functions.xlsx (13.0 KB)
    • 015 Dates Part 1 - Introduction-en.srt (1.5 KB)
    • 015 Dates Part 1 - Introduction.mp4 (6.2 MB)
    • 016 Dates Part 2 - Finding the difference between days-en.srt (1.4 KB)
    • 016 Dates Part 2 - Finding the difference between days.mp4 (5.1 MB)
    • 017 Dates Part 3 - DATEDIF-en.srt (1.6 KB)
    • 017 Dates Part 3 - DATEDIF.mp4 (6.7 MB)
    • 018 Dates Part 4 - DAY MONTH YEAR and WEEKDAY-en.srt (2.7 KB)
    • 018 Dates Part 4 - DAY MONTH YEAR and WEEKDAY.mp4 (25.8 MB)
    • 019 Dates Part 5 - Using the TEXT function to ReFormat Cells-en.srt (2.9 KB)
    • 019 Dates Part 5 - Using the TEXT function to ReFormat Cells.mp4 (24.3 MB)
    05 Functions and Formulas Part 2
    • 020 Math Functions Part 1 - SUM-en.srt (2.7 KB)
    • 020 Math Functions Part 1 - SUM.mp4 (17.7 MB)
    • 020 MATH.xlsx (190.3 KB)
    • 021 Math Functions Part 2 - SUMIF-en.srt (3.8 KB)
    • 021 Math Functions Part 2 - SUMIF.mp4 (40.6 MB)
    • 022 Math Functions Part 3 - SUMIFS-en.srt (5.4 KB)
    • 022 Math Functions Part 3 - SUMIFS.mp4 (59.9 MB)
    • 023 Statistical Functions Part 1 - COUNT and AVERAGE-en.srt (3.2 KB)
    • 023 Statistical Functions Part 1 - COUNT and AVERAGE.mp4 (23.0 MB)
    • 023 STATS-Functions.xlsx (15.5 KB)
    • 024 Statistical Functions Part 2 - COUNTIF-en.srt (2.4 KB)
    • 024 Statistical Functions Part 2 - COUNTIF.mp4 (24.7 MB)
    • 025 Statistical Functions Part 3 - COUNTIFS-en.srt (3.8 KB)
    • 025 Statistical Functions Part 3 - COUNTIFS.mp4 (38.5 MB)
    • 026 Statistical Functions Part 4 - AVERAGEIFS-en.srt (2.6 KB)
    • 026 Statistical Functions Part 4 - AVERAGEIFS.mp4 (27.1 MB)
    • 027 Formulas-Project.xlsx (67.9 KB)
    • 027 Project 1 - Intro and Project Files-en.srt (1.6 KB)
    • 027 Project 1 - Intro and Project Files.mp4 (6.3 MB)
    • 02

Code:

  • udp://tracker.opentrackr.org:1337/announce
  • udp://tracker.leechers-paradise.org:6969/announce
  • http://p4p.arenabg.com:1337/announce
  • udp://9.rarbg.to:2710/announce
  • udp://9.rarbg.me:2710/announce
  • udp://exodus.desync.com:6969/announce
  • udp://open.stealth.si:80/announce
  • udp://tracker.cyberia.is:6969/announce
  • udp://tracker.tiny-vps.com:6969/announce
  • udp://tracker.sbsub.com:2710/announce
  • udp://retracker.lanta-net.ru:2710/announce
  • udp://tracker.torrent.eu.org:451/announce
  • udp://tracker.moeking.me:6969/announce
  • http://tracker3.itzmx.com:6961/announce
  • http://tracker1.itzmx.com:8080/announce