Microsoft Excel Data Analysis Pivot Tables and Formulas | A874E583CB7DBED74649CB4523D11E22F2FAEE40

Microsoft Excel Data Analysis Pivot Tables and Formulas

Name	Microsoft Excel Data Analysis - Pivot Tables and Formulas	DOWNLOAD Copy Link
Total Size	1.5 GB
Total Files	133
Hash	A874E583CB7DBED74649CB4523D11E22F2FAEE40

/.../06 Functions and Formulas Part 3/
043 Project 2 - Answers and Walk Through Video.mp4	67.8 MB
029 Lookup Functions VLOOKUP - Part 1-en.srt	2.8 KB
029 Lookup Functions VLOOKUP - Part 1.mp4	30.8 MB
029 LOOKUP-Functions-VLOOKUP.xlsx	29.1 KB
030 Lookup Functions VLOOKUP - Part 2-en.srt	2.5 KB
030 Lookup Functions VLOOKUP - Part 2.mp4	29.9 MB
031 Lookup Functions VLOOKUP - Part 3-en.srt	3.2 KB
031 Lookup Functions VLOOKUP - Part 3.mp4	38.5 MB
032 INDEX-MATCH.xlsx	30.0 KB
032 Lookup Functions INDEX-en.srt	2.7 KB
032 Lookup Functions INDEX.mp4	25.3 MB
033 Lookup Functions MATCH-en.srt	1.9 KB
033 Lookup Functions MATCH.mp4	19.8 MB
034 Lookup Functions INDEX MATCH - Part 1-en.srt	2.3 KB
034 Lookup Functions INDEX MATCH - Part 1.mp4	24.7 MB
035 Lookup Functions INDEX MATCH - Part 2-en.srt	3.8 KB
035 Lookup Functions INDEX MATCH - Part 2.mp4	39.0 MB
036 Logical Functions Part 1-en.srt	2.4 KB
036 Logical Functions Part 1.mp4	16.1 MB
036 LOGICAL-Functions.xlsx	12.2 KB
037 Logical Functions Part 2-en.srt	4.2 KB
037 Logical Functions Part 2.mp4	45.1 MB
038 Logical Functions Part 3-en.srt	4.6 KB
038 Logical Functions Part 3.mp4	51.2 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	20.0 MB
039 ERRORS-in-Excel.xlsx	26.6 KB
040 Errors in Excel Part 2 - NAME and VALUE-en.srt	1.9 KB
040 Errors in Excel Part 2 - NAME and VALUE.mp4	17.2 MB
041 Errors in Excel Part 3 - REF Errors-en.srt	2.9 KB
041 Errors in Excel Part 3 - REF Errors.mp4	25.2 MB
042 Formulas-Project-2.xlsx	64.0 KB
042 Project 2 - Intro and Project Files-en.srt	2.0 KB
042 Project 2 - Intro and Project Files.mp4	12.4 MB
043 Project 2 - Answers and Walk Through Video-en.srt	6.3 KB
/
Visit Coursedrive.org.url	0.1 KB
ReadMe.txt	0.2 KB
/Microsoft Excel Data Analysis - Pivot Tables and Formulas/
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.4 MB
/.../02 The Data Set for this Course/
002 Data-Analysis-for-Excel.pdf	1.7 MB
002 Download the Powerpoint file for this Course (Optional).html	1.1 KB
003 Raw-Data.xlsx	216.2 KB
003 Understanding our Data Set - Part 1-en.srt	1.0 KB
003 Understanding our Data Set - Part 1.mp4	5.7 MB
004 Metrics and Dimensions-en.srt	3.7 KB
004 Metrics and Dimensions.mp4	16.7 MB
005 Understanding our Data Set - Part 2-en.srt	3.7 KB
005 Understanding our Data Set - Part 2.mp4	28.1 MB
/.../03 Foundational Principles/
006 Foundations Lesson 1 - Sorting Data-en.srt	8.5 KB
006 Foundations Lesson 1 - Sorting Data.mp4	58.7 MB
006 Foundations-Workbook.xlsx	72.4 KB
007 Foundations Lesson 2 - Filtering Data-en.srt	5.5 KB
007 Foundations Lesson 2 - Filtering Data.mp4	38.5 MB
008 Foundations Lesson 3 - Autofilling Patterns and Formulas-en.srt	3.2 KB
008 Foundations Lesson 3 - Autofilling Patterns and Formulas.mp4	15.7 MB
009 Foundations Lesson 4 - Named Ranges-en.srt	3.2 KB
009 Foundations Lesson 4 - Named Ranges.mp4	28.7 MB
010 Keyboard Shortcuts Lesson 1 Moving around your workbook-en.srt	3.2 KB
010 Keyboard Shortcuts Lesson 1 Moving around your workbook.mp4	28.3 MB
010 Keyboard-Shortcuts-Raw-Data.xlsx	67.2 KB
011 Keyboard Shortcuts Lesson 2 CTRL 1-en.srt	2.2 KB
011 Keyboard Shortcuts Lesson 2 CTRL 1.mp4	13.6 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	18.7 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	16.4 MB
014 Introduction to Formulas Part 2-en.srt	2.1 KB
014 Introduction to Formulas Part 2.mp4	8.2 MB
015 Date-Functions.xlsx	13.3 KB
015 Dates Part 1 - Introduction-en.srt	1.5 KB
015 Dates Part 1 - Introduction.mp4	6.5 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.3 MB
017 Dates Part 3 - DATEDIF-en.srt	1.7 KB
017 Dates Part 3 - DATEDIF.mp4	7.0 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	27.0 MB
019 Dates Part 5 - Using the TEXT function to ReFormat Cells-en.srt	3.0 KB
019 Dates Part 5 - Using the TEXT function to ReFormat Cells.mp4	25.5 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	18.5 MB
020 MATH.xlsx	194.8 KB
021 Math Functions Part 2 - SUMIF-en.srt	3.9 KB
021 Math Functions Part 2 - SUMIF.mp4	42.5 MB
022 Math Functions Part 3 - SUMIFS-en.srt	5.6 KB
022 Math Functions Part 3 - SUMIFS.mp4	62.8 MB
023 Statistical Functions Part 1 - COUNT and AVERAGE-en.srt	3.2 KB
023 Statistical Functions Part 1 - COUNT and AVERAGE.mp4	24.1 MB
023 STATS-Functions.xlsx	15.9 KB
024 Statistical Functions Part 2 - COUNTIF-en.srt	2.5 KB
024 Statistical Functions Part 2 - COUNTIF.mp4	25.9 MB
025 Statistical Functions Part 3 - COUNTIFS-en.srt	3.9 KB
025 Statistical Functions Part 3 - COUNTIFS.mp4	40.4 MB
026 Statistical Functions Part 4 - AVERAGEIFS-en.srt	2.7 KB
026 Statistical Functions Part 4 - AVERAGEIFS.mp4	28.4 MB
027 Formulas-Project.xlsx	69.5 KB
027 Project 1 - Intro and Project Files-en.srt	1.6 KB
027 Project 1 - Intro and Project Files.mp4	6.6 MB
028 Project 1 - Answers and Walk Through-en.srt	5.3 KB
028 Project 1 - Answers and Walk Through.mp4	54.2 MB
/.../07 Pivot Tables Part 1/
044 Pivot Tables 101 Creating our first Pivot Table-en.srt	2.9 KB
044 Pivot Tables 101 Creating our first Pivot Table.mp4	19.0 MB
044 Pivot-Tables.xlsx	71.5 KB
045 Pivot Tables 101 Rows-en.srt	2.3 KB
045 Pivot Tables 101 Rows.mp4	16.2 MB
046 Pivot Tables 101 Columns-en.srt	3.0 KB
046 Pivot Tables 101 Columns.mp4	19.9 MB
047 Pivot Tables 101 Values - Part 1-en.srt	2.0 KB
047 Pivot Tables 101 Values - Part 1.mp4	13.8 MB
048 Pivot Tables 101 Values - Part 2-en.srt	2.0 KB
048 Pivot Tables 101 Values - Part 2.mp4	14.2 MB
049 Pivot Tables 101 Filters-en.srt	2.9 KB
049 Pivot Tables 101 Filters.mp4	18.6 MB
050 Pivot Tables 101 Refreshing Pivot Tables-en.srt	3.9 KB
050 Pivot Tables 101 Refreshing Pivot Tables.mp4	39.3 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	23.9 MB
/.../08 Pivot Tables Part 2/
052 Pivot Tables E Calculated Fields-en.srt	3.2 KB
052 Pivot Tables E Calculated Fields.mp4	26.1 MB
052 Pivot-Tables-part-2.xlsx	132.2 KB
053 Pivot Tables E Calculated Items-en.srt	4.2 KB
053 Pivot Tables E Calculated Items.mp4	37.6 MB
054 Pivot Tables E Working with Dates-en.srt	5.7 KB
054 Pivot Tables E Working with Dates.mp4	49.1 MB
055 Pivot Tables E Clean up and Organization-en.srt	3.4 KB
055 Pivot Tables E Clean up and Organization.mp4	32.6 MB
056 Pivot-Tables-Project.xlsx	79.0 KB
056 Project 3 - Introduction and Project Files-en.srt	2.4 KB
056 Project 3 - Introduction and Project Files.mp4	18.6 MB
057 Project 3 - Answers and Walk Through-en.srt	4.8 KB
057 Project 3 - Answers and Walk Through.mp4	54.2 MB
Total files 133