Don't like banners? Log in and we will make sure you see no banners. For free.
Microsoft Excel Data Analysis - Pivot Tables and Formulas

Microsoft Excel Data Analysis - Pivot Tables and Formulas

Other
Size
1.4 GB
Seeders
0
Leechers
1
Files
97
Category
Other
Added
at 12:35pm GMT+1
Infohash
a874e583cb7dbed74649cb4523d11e22f2faee40
Direct linkTorrent fileDownload now
Don't like banners? Log in and we will make sure you see no banners. For free.

Description
⚡️⚡️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

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

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
1.8 GB00