Other
Learn Excel 2021 Beyond the Basics - An Intermediate Course
Torrent info
Torrent Files List
[TutsNode.com] - Learn Excel 2021 Beyond the Basics - An Intermediate Course (Size: 4.76 GB) (Files: 276)
[TutsNode.com] - Learn Excel 2021 Beyond the Basics - An Intermediate Course
7. Preparing Data for Analysis
3. Changing Case and Removing Spaces.mp4
1. Importing Data into Excel.srt
8. Formatting Data as a Table.srt
3. Changing Case and Removing Spaces.srt
5. Splitting Data using Text Functions.srt
7. Joining Data using CONCAT.srt
10. Section Quiz.html
4. Splitting Data using Text to Columns.srt
6. Splitting or Combining Cell Data Using Flash fill.srt
9. Exercise 05.srt
2. Removing Blank Rows, Cells and Duplicates.srt
1. Importing Data into Excel.mp4
8. Formatting Data as a Table.mp4
4. Splitting Data using Text to Columns.mp4
9. Exercise 05.mp4
2. Removing Blank Rows, Cells and Duplicates.mp4
7. Joining Data using CONCAT.mp4
5. Splitting Data using Text Functions.mp4
6. Splitting or Combining Cell Data Using Flash fill.mp4
2. Designing Better Spreadsheets
1. The Golden Rules of Spreadsheet Design.srt
5. Section Quiz.html
4. Adding Navigation Buttons.srt
3. Controlling Data Input.srt
1. The Golden Rules of Spreadsheet Design.mp4
2. Improving Readability with Cell Styles.srt
4. Adding Navigation Buttons.mp4
3. Controlling Data Input.mp4
2. Improving Readability with Cell Styles.mp4
3. Making Decisions with Logical Functions
1. Logical Functions (AND, OR, IF).srt
3. Nested IFs.srt
9. Section Quiz.html
8. Exercise 01.srt
6. Multiple Criteria (SUMIFS, COUNTIFS, AVERAGEIFS).srt
5. Conditional IFs (SUMIF, COUNTIF, AVERAGEIF).srt
4. The IFS Function.srt
7. Error Handling with IFERROR and IFNA.srt
2. The IF Function.srt
1. Logical Functions (AND, OR, IF).mp4
3. Nested IFs.mp4
8. Exercise 01.mp4
6. Multiple Criteria (SUMIFS, COUNTIFS, AVERAGEIFS).mp4
7. Error Handling with IFERROR and IFNA.mp4
5. Conditional IFs (SUMIF, COUNTIF, AVERAGEIF).mp4
2. The IF Function.mp4
4. The IFS Function.mp4
11. Interactive Dashboards
2. Assembling a Dashboard - Part 1.srt
3. Assembling a Dashboard - Part 2.srt
4. Assembling a Dashboard - Part 3.srt
1. What is a Dashboard.srt
5. Exercise 09.srt
6. Section Quiz.html
2. Assembling a Dashboard - Part 1.mp4
3. Assembling a Dashboard - Part 2.mp4
4. Assembling a Dashboard - Part 3.mp4
1. What is a Dashboard.mp4
5. Exercise 09.mp4
1. Introduction
2. WATCH ME Essential Information for a Successful Training Experience.srt
3. DOWNLOAD ME Course Exercise Files.html
4. DOWNLOAD ME Course Instructor Files.html
5. Section Quiz.html
1. Course Introduction.srt
1. Course Introduction.mp4
4.1 Excel 2021 Intermediate Course Files.zip
2. WATCH ME Essential Information for a Successful Training Experience.mp4
3.1 Excel 2021 Intermediate Exercise Files.zip
4. Looking Up Information
4. Performing Flexible Lookups With INDEX And MATCH.srt
1. Looking Up Information using VLOOKUP (Exact Match).srt
5. Using XLOOKUP and XMATCH.srt
6. The OFFSET Function.srt
7. The INDIRECT Function.srt
9. Section Quiz.html
3. Looking Up Information Horizontally Using HLOOKUP.srt
8. Exercise 02.srt
2. Looking Up Information using VLOOKUP (Approx Match).srt
1. Looking Up Information using VLOOKUP (Exact Match).mp4
4. Performing Flexible Lookups With INDEX And MATCH.mp4
5. Using XLOOKUP and XMATCH.mp4
7. The INDIRECT Function.mp4
6. The OFFSET Function.mp4
8. Exercise 02.mp4
3. Looking Up Information Horizontally Using HLOOKUP.mp4
2. Looking Up Information using VLOOKUP (Approx Match).mp4
5. Advanced Sorting and Filtering
3. The SORT and SORTBY Functions.srt
6. The FILTER Function.srt
1. Performing Sorts on Multiple Columns.srt
8. Section Quiz.html
4. Using the Advanced Filter.srt
7. Exercise 03.srt
5. Extracting Unique Values - The UNIQUE Function.srt
2. Sorting Using a Custom List.srt
3. The SORT and SORTBY Functions.mp4
6. The FILTER Function.mp4
1. Performing Sorts on Multiple Columns.mp4
4. Using the Advanced Filter.mp4
7. Exercise 03.mp4
5. Extracting Unique Values - The UNIQUE Function.mp4
2. Sorting Using a Custom List.mp4
13. Data Validation
3. Custom Data Validation.srt
1. Creating Dynamic Drop-down Lists.srt
2. Other Types of Data Validation.srt
4. Exercise 11.srt
5. Section Quiz.html
1. Creating Dynamic Drop-down Lists.mp4
3. Custom Data Validation.mp4
2. Other Types of Data Validation.mp4
4. Exercise 11.mp4
9. Pivot Charts
3. Formatting a Pivot Chart - Part 2.srt
2. Formatting a Pivot Chart - Part 1.srt
6. Section Quiz.html
4. Using Map Charts.srt
1. Creating a Pivot Chart.srt
5. Exercise 07.srt
3. Formatting a Pivot Chart - Part 2.mp4
2. Formatting a Pivot Chart - Part 1.mp4
1. Creating a Pivot Chart.mp4
4. Using Map Charts.mp4
5. Exercise 07.mp4
12. Formula Auditing
1. Troubleshooting Common Errors.srt
2. Tracing Precedents and Formula Auditing.srt
3. Exercise 10.srt
4. Section Quiz.html
2. Tracing Precedents and Formula Auditing.mp4
3. Exercise 10.mp4
1. Troubleshooting Common Errors.mp4
6. Working with Date and Time
3. Using Date and Time Functions.srt
7. Calculate Dates with EDATE and EOMONTH.srt
2. Applying Custom Date Formats.srt
9. Section Quiz.html
6. Tabulate Date Differences with the DATEDIF Function.srt
1. Understanding How Dates are Stored in Excel.srt
8. Exercise 04.srt
4. Using the WORKDAY and WORKDAY.INT Functions.srt
5. Using the NETWORKDAYS and NETWORKDAYS.INT Function.srt
3. Using Date and Time Functions.mp4
2. Applying Custom Date Formats.mp4
7. Calculate Dates with EDATE and EOMONTH.mp4
6. Tabulate Date Differences with the DATEDIF Function.mp4
4. Using the WORKDAY and WORKDAY.INT Functions.mp4
1. Understanding How Dates are Stored in Excel.mp4
8. Exercise 04.mp4
5. Using the NETWORKDAYS and NETWORKDAYS.INT Function.mp4
14. WhatIf Analysis Tools
5. Exercise 12.srt
2. Using Scenario Manager.srt
1. Goal Seek and the PMT Function.srt
3. Data Tables One Variable.srt
4. Data Tables Two Variables.srt
6. Section Quiz.html
5. Exercise 12.mp4
2. Using Scenario Manager.mp4
1. Goal Seek and the PMT Function.mp4
4. Data Tables Two Variables.mp4
3. Data Tables One Variable.mp4
10. Adding Interaction to PivotTables and Charts
1. Inserting and Formatting Slicers.srt
5. Exercise 08.srt
2. Inserting Timeline Slicers.srt
3. Connecting Slicers to Pivot Charts.srt
4. Updating PivotTable Data.srt
6. Section Quiz.html
5. Exercise 08.mp4
4. Updating PivotTable Data.mp4
1. Inserting and Formatting Slicers.mp4
3. Connecting Slicers to Pivot Charts.mp4
2. Inserting Timeline Slicers.mp4
8. PivotTables
12. Section Quiz.html
6. Show Values As and Summarize Values By.srt
3. Pivoting the PivotTable Fields.srt
7. Grouping PivotTable Data.srt
8. Formatting Error Values and Empty Cells.srt
2. Creating a PivotTable from Scratch.srt
10. Applying PivotTable Styles.srt
9. Choosing a Report Layout.srt
11. Exercise 06.srt
4. Applying Subtotals and Grand Totals.srt
5. Applying Number Formatting to PivotTable Data.srt
1. PivotTables Explained.srt
2. Creating a PivotTable from Scratch.mp4
7. Grouping PivotTable Data.mp4
8. Formatting Error Values and Empty Cells.mp4
10. Applying PivotTable Styles.mp4
11. Exercise 06.mp4
6. Show Values As and Summarize Values By.mp4
9. Choosing a Report Layout.mp4
3. Pivoting the PivotTable Fields.mp4
4. Applying Subtotals and Grand Totals.mp4
5. Applying Number Formatting to PivotTable Data.mp4
1. PivotTables Explained.mp4
15. Course Close
1. Course Close.srt
1. Course Close.mp4
TutsNode.com.txt
[TGx]Downloaded from torrentgalaxy.to .txt
.pad
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch Learn Excel 2021 Beyond the Basics - An Intermediate Course Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
