Udemy - Microsoft Excel Data Analysis: Pivot Tables and Formulas ...
- Category Other
- Type Tutorials
- Language English
- Total size 1.4 GB
- Uploaded By coursedrive
- Downloads 950
- Last checked 1 week ago
- Date uploaded 5 years ago
- Seeders 12
- Leechers 1
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)
- 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)
- 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)
- 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)
- 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)
- 028 Project 1 - Answers and Walk Through-en.srt (5.2 KB)
- 028 Project 1 - Answers and Walk Through.mp4 (51.7 MB)
- 044 Pivot Tables 101 Creating our first Pivot Table-en.srt (2.9 KB)
- 044 Pivot Tables 101 Creating our first Pivot Table.mp4 (18.1 MB)
- 044 Pivot-Tables.xlsx (69.8 KB)
- 045 Pivot Tables 101 Rows-en.srt (2.2 KB)
- 045 Pivot Tables 101 Rows.mp4 (15.4 MB)
- 046 Pivot Tables 101 Columns-en.srt (2.9 KB)
- 046 Pivot Tables 101 Columns.mp4 (18.9 MB)
- 047 Pivot Tables 101 Values - Part 1-en.srt (1.9 KB)
- 047 Pivot Tables 101 Values - Part 1.mp4 (13.2 MB)
- 048 Pivot Tables 101 Values - Part 2-en.srt (2.0 KB)
- 048 Pivot Tables 101 Values - Part 2.mp4 (13.5 MB)
- 049 Pivot Tables 101 Filters-en.srt (2.9 KB)
- 049 Pivot Tables 101 Filters.mp4 (17.7 MB)
- 050 Pivot Tables 101 Refreshing Pivot Tables-en.srt (3.8 KB)
- 050 Pivot Tables 101 Refreshing Pivot Tables.mp4 (37.5 MB)
- 051 Pivot Tables 101 Using Tables to Refresh Pivot Tables-en.srt (2.0 KB)
- 051 Pivot Tables 101 Using Tables to Refresh Pivot Tables.mp4 (22.8 MB)
- 052 Pivot Tables E Calculated Fields-en.srt (3.2 KB)
- 052 Pivot Tables E Calculated Fields.mp4 (24.9 MB)
- 052 Pivot-Tables-part-2.xlsx (129.1 KB)
- 053 Pivot Tables E Calculated Items-en.srt (4.1 KB)
- 053 Pivot Tables E Calculated Items.mp4 (35.9 MB)
- 054 Pivot Tables E Working with Dates-en.srt (5.6 KB)
- 054 Pivot Tables E Working with Dates.mp4 (46.8 MB)
- 055 Pivot Tables E Clean up and Organization-en.srt (3.3 KB)
- 055 Pivot Tables E Clean up and Organization.mp4 (31.1 MB)
- 056 Pivot-Tables-Project.xlsx (77.2 KB)
- 056 Project 3 - Introduction and Project Files-en.srt (2.3 KB)
- 056 Project 3 - Introduction and Project Files.mp4 (17.7 MB)
- 057 Project 3 - Answers and Walk Through-en.srt (4.7 KB)
- 057 Project 3 - Answers and Walk Through.mp4 (51.7 MB)
- Visit Coursedrive.org.url (0.1 KB)
- ReadMe.txt (0.2 KB)
There are currently no comments. Feel free to leave one :)
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