17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Microsoft Excel Data Analysis - Pivot Tables And Formulas
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
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
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
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
