|
|
001 Welcome to this Data Analysis Course-en.srt
|
SRT
|
1.5 KB
|
|
|
001 Welcome to this Data Analysis Course.mp4
|
MP4
|
4.2 MB
|
|
|
002 Data-Analysis-for-Excel.pdf
|
PDF
|
1.6 MB
|
|
|
002 Download the Powerpoint file for this Course (Optional).html
|
HTML
|
1.1 KB
|
|
|
003 Raw-Data.xlsx
|
XLSX
|
211.2 KB
|
|
|
003 Understanding our Data Set - Part 1-en.srt
|
SRT
|
1 KB
|
|
|
003 Understanding our Data Set - Part 1.mp4
|
MP4
|
5.5 MB
|
|
|
004 Metrics and Dimensions-en.srt
|
SRT
|
3.6 KB
|
|
|
004 Metrics and Dimensions.mp4
|
MP4
|
15.9 MB
|
|
|
005 Understanding our Data Set - Part 2-en.srt
|
SRT
|
3.6 KB
|
|
|
005 Understanding our Data Set - Part 2.mp4
|
MP4
|
26.8 MB
|
|
|
006 Foundations Lesson 1 - Sorting Data-en.srt
|
SRT
|
8.3 KB
|
|
|
006 Foundations Lesson 1 - Sorting Data.mp4
|
MP4
|
55.9 MB
|
|
|
006 Foundations-Workbook.xlsx
|
XLSX
|
70.7 KB
|
|
|
007 Foundations Lesson 2 - Filtering Data-en.srt
|
SRT
|
5.4 KB
|
|
|
007 Foundations Lesson 2 - Filtering Data.mp4
|
MP4
|
36.7 MB
|
|
|
008 Foundations Lesson 3 - Autofilling Patterns and Formulas-en.srt
|
SRT
|
3.1 KB
|
|
|
008 Foundations Lesson 3 - Autofilling Patterns and Formulas.mp4
|
MP4
|
14.9 MB
|
|
|
009 Foundations Lesson 4 - Named Ranges-en.srt
|
SRT
|
3.1 KB
|
|
|
009 Foundations Lesson 4 - Named Ranges.mp4
|
MP4
|
27.4 MB
|
|
|
010 Keyboard Shortcuts Lesson 1 Moving around your workbook-en.srt
|
SRT
|
3.1 KB
|
|
|
010 Keyboard Shortcuts Lesson 1 Moving around your workbook.mp4
|
MP4
|
27 MB
|
|
|
010 Keyboard-Shortcuts-Raw-Data.xlsx
|
XLSX
|
65.6 KB
|
|
|
011 Keyboard Shortcuts Lesson 2 CTRL 1-en.srt
|
SRT
|
2.2 KB
|
|
|
011 Keyboard Shortcuts Lesson 2 CTRL 1.mp4
|
MP4
|
13 MB
|
|
|
012 Keyboard Shortcuts Lesson 3 Cut Copy Paste Undo Find-en.srt
|
SRT
|
2.1 KB
|
|
|
012 Keyboard Shortcuts Lesson 3 Cut Copy Paste Undo Find.mp4
|
MP4
|
17.8 MB
|
|
|
013 Introduction to Formulas Part 1-en.srt
|
SRT
|
3.1 KB
|
|
|
013 Introduction to Formulas Part 1.mp4
|
MP4
|
15.6 MB
|
|
|
014 Introduction to Formulas Part 2-en.srt
|
SRT
|
2.1 KB
|
|
|
014 Introduction to Formulas Part 2.mp4
|
MP4
|
7.8 MB
|
|
|
015 Date-Functions.xlsx
|
XLSX
|
13 KB
|
|
|
015 Dates Part 1 - Introduction-en.srt
|
SRT
|
1.5 KB
|
|
|
015 Dates Part 1 - Introduction.mp4
|
MP4
|
6.2 MB
|
|
|
016 Dates Part 2 - Finding the difference between days-en.srt
|
SRT
|
1.4 KB
|
|
|
016 Dates Part 2 - Finding the difference between days.mp4
|
MP4
|
5.1 MB
|
|
|
017 Dates Part 3 - DATEDIF-en.srt
|
SRT
|
1.6 KB
|
|
|
017 Dates Part 3 - DATEDIF.mp4
|
MP4
|
6.7 MB
|
|
|
018 Dates Part 4 - DAY MONTH YEAR and WEEKDAY-en.srt
|
SRT
|
2.7 KB
|
|
|
018 Dates Part 4 - DAY MONTH YEAR and WEEKDAY.mp4
|
MP4
|
25.8 MB
|
|
|
019 Dates Part 5 - Using the TEXT function to ReFormat Cells-en.srt
|
SRT
|
2.9 KB
|
|
|
019 Dates Part 5 - Using the TEXT function to ReFormat Cells.mp4
|
MP4
|
24.3 MB
|
|
|
020 MATH.xlsx
|
XLSX
|
190.3 KB
|
|
|
020 Math Functions Part 1 - SUM-en.srt
|
SRT
|
2.7 KB
|
|
|
020 Math Functions Part 1 - SUM.mp4
|
MP4
|
17.7 MB
|
|
|
021 Math Functions Part 2 - SUMIF-en.srt
|
SRT
|
3.8 KB
|
|
|
021 Math Functions Part 2 - SUMIF.mp4
|
MP4
|
40.6 MB
|
|
|
022 Math Functions Part 3 - SUMIFS-en.srt
|
SRT
|
5.4 KB
|
|
|
022 Math Functions Part 3 - SUMIFS.mp4
|
MP4
|
59.9 MB
|
|
|
023 STATS-Functions.xlsx
|
XLSX
|
15.5 KB
|
|
|
023 Statistical Functions Part 1 - COUNT and AVERAGE-en.srt
|
SRT
|
3.2 KB
|
|
|
023 Statistical Functions Part 1 - COUNT and AVERAGE.mp4
|
MP4
|
23 MB
|
|
|
024 Statistical Functions Part 2 - COUNTIF-en.srt
|
SRT
|
2.4 KB
|
|
|
024 Statistical Functions Part 2 - COUNTIF.mp4
|
MP4
|
24.7 MB
|
|
|
025 Statistical Functions Part 3 - COUNTIFS-en.srt
|
SRT
|
3.8 KB
|
|
|
025 Statistical Functions Part 3 - COUNTIFS.mp4
|
MP4
|
38.5 MB
|
|
|
026 Statistical Functions Part 4 - AVERAGEIFS-en.srt
|
SRT
|
2.6 KB
|
|
|
026 Statistical Functions Part 4 - AVERAGEIFS.mp4
|
MP4
|
27.1 MB
|
|
|
027 Formulas-Project.xlsx
|
XLSX
|
67.9 KB
|
|
|
027 Project 1 - Intro and Project Files-en.srt
|
SRT
|
1.6 KB
|
|
|
027 Project 1 - Intro and Project Files.mp4
|
MP4
|
6.3 MB
|
|
|
028 Project 1 - Answers and Walk Through-en.srt
|
SRT
|
5.2 KB
|
|
|
028 Project 1 - Answers and Walk Through.mp4
|
MP4
|
51.7 MB
|
|
|
029 LOOKUP-Functions-VLOOKUP.xlsx
|
XLSX
|
28.5 KB
|
|
|
029 Lookup Functions VLOOKUP - Part 1-en.srt
|
SRT
|
2.8 KB
|
|
|
029 Lookup Functions VLOOKUP - Part 1.mp4
|
MP4
|
29.4 MB
|
|
|
030 Lookup Functions VLOOKUP - Part 2-en.srt
|
SRT
|
2.5 KB
|
|
|
030 Lookup Functions VLOOKUP - Part 2.mp4
|
MP4
|
28.6 MB
|
|
|
031 Lookup Functions VLOOKUP - Part 3-en.srt
|
SRT
|
3.1 KB
|
|
|
031 Lookup Functions VLOOKUP - Part 3.mp4
|
MP4
|
36.7 MB
|
|
|
032 INDEX-MATCH.xlsx
|
XLSX
|
29.3 KB
|
|
|
032 Lookup Functions INDEX-en.srt
|
SRT
|
2.6 KB
|
|
|
032 Lookup Functions INDEX.mp4
|
MP4
|
24.2 MB
|
|
|
033 Lookup Functions MATCH-en.srt
|
SRT
|
1.8 KB
|
|
|
033 Lookup Functions MATCH.mp4
|
MP4
|
18.9 MB
|
|
|
034 Lookup Functions INDEX MATCH - Part 1-en.srt
|
SRT
|
2.2 KB
|
|
|
034 Lookup Functions INDEX MATCH - Part 1.mp4
|
MP4
|
23.5 MB
|
|
|
035 Lookup Functions INDEX MATCH - Part 2-en.srt
|
SRT
|
3.8 KB
|
|
|
035 Lookup Functions INDEX MATCH - Part 2.mp4
|
MP4
|
37.2 MB
|
|
|
036 LOGICAL-Functions.xlsx
|
XLSX
|
12 KB
|
|
|
036 Logical Functions Part 1-en.srt
|
SRT
|
2.3 KB
|
|
|
036 Logical Functions Part 1.mp4
|
MP4
|
15.4 MB
|
|
|
037 Logical Functions Part 2-en.srt
|
SRT
|
4.1 KB
|
|
|
037 Logical Functions Part 2.mp4
|
MP4
|
43.1 MB
|
|
|
038 Logical Functions Part 3-en.srt
|
SRT
|
4.5 KB
|
|
|
038 Logical Functions Part 3.mp4
|
MP4
|
48.8 MB
|
|
|
039 ERRORS-in-Excel.xlsx
|
XLSX
|
25.9 KB
|
|
|
039 Errors in Excel Part 1 - NA and the IFERROR Functiton-en.srt
|
SRT
|
1.8 KB
|
|
|
039 Errors in Excel Part 1 - NA and the IFERROR Functiton.mp4
|
MP4
|
19 MB
|
|
|
040 Errors in Excel Part 2 - NAME and VALUE-en.srt
|
SRT
|
1.8 KB
|
|
|
040 Errors in Excel Part 2 - NAME and VALUE.mp4
|
MP4
|
16.4 MB
|
|
|
041 Errors in Excel Part 3 - REF Errors-en.srt
|
SRT
|
2.8 KB
|
|
|
041 Errors in Excel Part 3 - REF Errors.mp4
|
MP4
|
24.1 MB
|
|
|
042 Formulas-Project-2.xlsx
|
XLSX
|
62.5 KB
|
|
|
042 Project 2 - Intro and Project Files-en.srt
|
SRT
|
2 KB
|
|
|
042 Project 2 - Intro and Project Files.mp4
|
MP4
|
11.9 MB
|
|
|
043 Project 2 - Answers and Walk Through Video-en.srt
|
SRT
|
6.1 KB
|
|
|
043 Project 2 - Answers and Walk Through Video.mp4
|
MP4
|
64.6 MB
|
|
|
044 Pivot Tables 101 Creating our first Pivot Table-en.srt
|
SRT
|
2.9 KB
|
|
|
044 Pivot Tables 101 Creating our first Pivot Table.mp4
|
MP4
|
18.1 MB
|
|
|
044 Pivot-Tables.xlsx
|
XLSX
|
69.8 KB
|
|
|
045 Pivot Tables 101 Rows-en.srt
|
SRT
|
2.2 KB
|
|
|
045 Pivot Tables 101 Rows.mp4
|
MP4
|
15.4 MB
|
|
|
046 Pivot Tables 101 Columns-en.srt
|
SRT
|
2.9 KB
|
|
|
046 Pivot Tables 101 Columns.mp4
|
MP4
|
18.9 MB
|
|
|
047 Pivot Tables 101 Values - Part 1-en.srt
|
SRT
|
1.9 KB
|
|
|
047 Pivot Tables 101 Values - Part 1.mp4
|
MP4
|
13.2 MB
|
|
|
048 Pivot Tables 101 Values - Part 2-en.srt
|
SRT
|
2 KB
|
|
|
048 Pivot Tables 101 Values - Part 2.mp4
|
MP4
|
13.5 MB
|
|
|
049 Pivot Tables 101 Filters-en.srt
|
SRT
|
2.9 KB
|
|
|
049 Pivot Tables 101 Filters.mp4
|
MP4
|
17.7 MB
|
|
|
050 Pivot Tables 101 Refreshing Pivot Tables-en.srt
|
SRT
|
3.8 KB
|
|
|
050 Pivot Tables 101 Refreshing Pivot Tables.mp4
|
MP4
|
37.5 MB
|
|
|
051 Pivot Tables 101 Using Tables to Refresh Pivot Tables-en.srt
|
SRT
|
2 KB
|
|
|
051 Pivot Tables 101 Using Tables to Refresh Pivot Tables.mp4
|
MP4
|
22.8 MB
|
|
|
052 Pivot Tables E Calculated Fields-en.srt
|
SRT
|
3.2 KB
|
|
|
052 Pivot Tables E Calculated Fields.mp4
|
MP4
|
24.9 MB
|
|
|
052 Pivot-Tables-part-2.xlsx
|
XLSX
|
129.1 KB
|
|
|
053 Pivot Tables E Calculated Items-en.srt
|
SRT
|
4.1 KB
|
|
|
053 Pivot Tables E Calculated Items.mp4
|
MP4
|
35.9 MB
|
|
|
054 Pivot Tables E Working with Dates-en.srt
|
SRT
|
5.6 KB
|
|
|
054 Pivot Tables E Working with Dates.mp4
|
MP4
|
46.8 MB
|
|
|
055 Pivot Tables E Clean up and Organization-en.srt
|
SRT
|
3.3 KB
|
|
|
055 Pivot Tables E Clean up and Organization.mp4
|
MP4
|
31.1 MB
|
|
|
056 Pivot-Tables-Project.xlsx
|
XLSX
|
77.2 KB
|
|
|
056 Project 3 - Introduction and Project Files-en.srt
|
SRT
|
2.3 KB
|
|
|
056 Project 3 - Introduction and Project Files.mp4
|
MP4
|
17.7 MB
|
|
|
057 Project 3 - Answers and Walk Through-en.srt
|
SRT
|
4.7 KB
|
|
|
057 Project 3 - Answers and Walk Through.mp4
|
MP4
|
51.7 MB
|
|
|
ReadMe.txt
|
TXT
|
204.8 B
|
|
|
Visit Coursedrive.org.url
|
URL
|
102.4 B
|
![Udemy - Microsoft Excel Data Analysis: Pivot Tables and Formulas [Course Drive]](/static/img/no-torrent-image.png "Udemy - Microsoft Excel Data Analysis: Pivot Tables and Formulas [Course Drive]")
