|
|
1. Create a Pivot Chart.mp4
|
MP4
|
31.4 MB
|
|
|
1. Create a Pivot Chart.srt
|
SRT
|
4.7 KB
|
|
|
1. Data entry, Editing and AutoFill.mp4
|
MP4
|
34.7 MB
|
|
|
1. Data entry, Editing and AutoFill.srt
|
SRT
|
6.2 KB
|
|
|
1. Display and highlight formulas.mp4
|
MP4
|
38.3 MB
|
|
|
1. Display and highlight formulas.srt
|
SRT
|
6.5 KB
|
|
|
1. Font styles and effects.mp4
|
MP4
|
75.6 MB
|
|
|
1. Font styles and effects.srt
|
SRT
|
9.8 KB
|
|
|
1. Highlighting cells by applying a rule.mp4
|
MP4
|
54.5 MB
|
|
|
1. Highlighting cells by applying a rule.srt
|
SRT
|
11.2 KB
|
|
|
1. How to Create Charts in Excel.mp4
|
MP4
|
69.1 MB
|
|
|
1. How to Create Charts in Excel.srt
|
SRT
|
11.9 KB
|
|
|
1. Introduction.mp4
|
MP4
|
6.2 MB
|
|
|
1. Introduction.srt
|
SRT
|
1 KB
|
|
|
1. Subtotals and Grand Totals.mp4
|
MP4
|
33.7 MB
|
|
|
1. Subtotals and Grand Totals.srt
|
SRT
|
5.3 KB
|
|
|
1. What is Excel used for.mp4
|
MP4
|
31.4 MB
|
|
|
1. What is Excel used for.srt
|
SRT
|
5.5 KB
|
|
|
1. Working with Simple formulas.mp4
|
MP4
|
58.8 MB
|
|
|
1. Working with Simple formulas.srt
|
SRT
|
11.1 KB
|
|
|
1.1 Data source_Pivot.xlsx
|
XLSX
|
31.2 KB
|
|
|
10. Filtering with search.mp4
|
MP4
|
13.4 MB
|
|
|
10. Filtering with search.srt
|
SRT
|
2.3 KB
|
|
|
10. Use IFS for multiple conditions.mp4
|
MP4
|
87.2 MB
|
|
|
10. Use IFS for multiple conditions.srt
|
SRT
|
21.8 KB
|
|
|
11. COUNTIF, AVERAGEIF, SUMIF.mp4
|
MP4
|
64.7 MB
|
|
|
11. COUNTIF, AVERAGEIF, SUMIF.srt
|
SRT
|
14 KB
|
|
|
11. Filtering using Slicers.mp4
|
MP4
|
36.1 MB
|
|
|
11. Filtering using Slicers.srt
|
SRT
|
6.8 KB
|
|
|
12. Formatting the slicers.mp4
|
MP4
|
28.5 MB
|
|
|
12. Formatting the slicers.srt
|
SRT
|
5.5 KB
|
|
|
13. More on filtering your data.mp4
|
MP4
|
43.7 MB
|
|
|
13. More on filtering your data.srt
|
SRT
|
8.2 KB
|
|
|
14. Clearing and re-applying filters.mp4
|
MP4
|
43.7 MB
|
|
|
14. Clearing and re-applying filters.srt
|
SRT
|
8.2 KB
|
|
|
15. Filtering the PivotTable with a Timeline.mp4
|
MP4
|
28.9 MB
|
|
|
15. Filtering the PivotTable with a Timeline.srt
|
SRT
|
5 KB
|
|
|
16. Changing the style of the PivotTable.mp4
|
MP4
|
39.3 MB
|
|
|
16. Changing the style of the PivotTable.srt
|
SRT
|
6.3 KB
|
|
|
17. Changing the Layout of the PivotTable.mp4
|
MP4
|
38.4 MB
|
|
|
17. Changing the Layout of the PivotTable.srt
|
SRT
|
6.8 KB
|
|
|
18. Formatting the numbers in the PivotTable.mp4
|
MP4
|
32.7 MB
|
|
|
18. Formatting the numbers in the PivotTable.srt
|
SRT
|
5.3 KB
|
|
|
2. Auditing tools.mp4
|
MP4
|
76.9 MB
|
|
|
2. Auditing tools.srt
|
SRT
|
13.6 KB
|
|
|
2. Borders and color background.mp4
|
MP4
|
51.2 MB
|
|
|
2. Borders and color background.srt
|
SRT
|
7.6 KB
|
|
|
2. Chart Types.mp4
|
MP4
|
113.8 MB
|
|
|
2. Chart Types.srt
|
SRT
|
17.6 KB
|
|
|
2. Create your first PivotTable.mp4
|
MP4
|
109.1 MB
|
|
|
2. Create your first PivotTable.srt
|
SRT
|
15.3 KB
|
|
|
2. Entering Dates and Time.mp4
|
MP4
|
33.9 MB
|
|
|
2. Entering Dates and Time.srt
|
SRT
|
7.7 KB
|
|
|
2. Excel Toolbars and shortcut menues.mp4
|
MP4
|
41 MB
|
|
|
2. Excel Toolbars and shortcut menues.srt
|
SRT
|
8.3 KB
|
|
|
2. Highlight the top values in a PivotTable.mp4
|
MP4
|
43.3 MB
|
|
|
2. Highlight the top values in a PivotTable.srt
|
SRT
|
7.1 KB
|
|
|
2. Operations of the Data field summary.mp4
|
MP4
|
30.2 MB
|
|
|
2. Operations of the Data field summary.srt
|
SRT
|
4.8 KB
|
|
|
2. Pivot a PivotChart.mp4
|
MP4
|
41.9 MB
|
|
|
2. Pivot a PivotChart.srt
|
SRT
|
7.1 KB
|
|
|
2. Using the SUM() function.mp4
|
MP4
|
46.3 MB
|
|
|
2. Using the SUM() function.srt
|
SRT
|
8 KB
|
|
|
3. Adding more than one data field.mp4
|
MP4
|
24.9 MB
|
|
|
3. Adding more than one data field.srt
|
SRT
|
4.2 KB
|
|
|
3. Adjusting row height and column width.mp4
|
MP4
|
42.3 MB
|
|
|
3. Adjusting row height and column width.srt
|
SRT
|
9.2 KB
|
|
|
3. Configure your PivotTable.mp4
|
MP4
|
51.1 MB
|
|
|
3. Configure your PivotTable.srt
|
SRT
|
9.5 KB
|
|
|
3. Exploring Excel Ideas.mp4
|
MP4
|
33.6 MB
|
|
|
3. Exploring Excel Ideas.srt
|
SRT
|
4.8 KB
|
|
|
3. Filter a PivotChart.mp4
|
MP4
|
27.2 MB
|
|
|
3. Filter a PivotChart.srt
|
SRT
|
5.4 KB
|
|
|
3. Formatting cells using data bars.mp4
|
MP4
|
36.5 MB
|
|
|
3. Formatting cells using data bars.srt
|
SRT
|
8.2 KB
|
|
|
3. Use entire rowcolumn reference.mp4
|
MP4
|
57.3 MB
|
|
|
3. Use entire rowcolumn reference.srt
|
SRT
|
12.1 KB
|
|
|
3. Using MIN() and MAX() Functions.mp4
|
MP4
|
24 MB
|
|
|
3. Using MIN() and MAX() Functions.srt
|
SRT
|
3.6 KB
|
|
|
3. Workbooks and Worksheets.mp4
|
MP4
|
29.7 MB
|
|
|
3. Workbooks and Worksheets.srt
|
SRT
|
6.7 KB
|
|
|
4. Change formulas to values and update values with formulas.mp4
|
MP4
|
80.1 MB
|
|
|
4. Change formulas to values and update values with formulas.srt
|
SRT
|
14.9 KB
|
|
|
4. Create a PivotTable from external data source.mp4
|
MP4
|
14.7 MB
|
|
|
4. Create a PivotTable from external data source.srt
|
SRT
|
2.9 KB
|
|
|
4. Format a PivotChart.mp4
|
MP4
|
23.5 MB
|
|
|
4. Format a PivotChart.srt
|
SRT
|
4.1 KB
|
|
|
4. Formatting cells using colour scale.mp4
|
MP4
|
42.2 MB
|
|
|
4. Formatting cells using colour scale.srt
|
SRT
|
10.5 KB
|
|
|
4. How to look for Help on Excel - Using Excel Help.mp4
|
MP4
|
21.7 MB
|
|
|
4. How to look for Help on Excel - Using Excel Help.srt
|
SRT
|
4.3 KB
|
|
|
4. Insert, Hide, Delete a column or a row.mp4
|
MP4
|
57.9 MB
|
|
|
4. Insert, Hide, Delete a column or a row.srt
|
SRT
|
8 KB
|
|
|
4. Managing Dates in PivotTables.mp4
|
MP4
|
29.8 MB
|
|
|
4. Managing Dates in PivotTables.srt
|
SRT
|
4.5 KB
|
|
|
4. Using the AVERAGE() function.mp4
|
MP4
|
40.4 MB
|
|
|
4. Using the AVERAGE() function.srt
|
SRT
|
5.9 KB
|
|
|
5. Change a PivotChart typelayout.mp4
|
MP4
|
22.2 MB
|
|
|
5. Change a PivotChart typelayout.srt
|
SRT
|
4.5 KB
|
|
|
5. Creating Calculated Fields.mp4
|
MP4
|
29.4 MB
|
|
|
5. Creating Calculated Fields.srt
|
SRT
|
5.3 KB
|
|
|
5. Debugging formulas with the F9 key.mp4
|
MP4
|
28.2 MB
|
|
|
5. Debugging formulas with the F9 key.srt
|
SRT
|
6.5 KB
|
|
|
5. Formatting cells using icon sets.mp4
|
MP4
|
43.9 MB
|
|
|
5. Formatting cells using icon sets.srt
|
SRT
|
9.1 KB
|
|
|
5. Manage PivotTables.mp4
|
MP4
|
46.2 MB
|
|
|
5. Manage PivotTables.srt
|
SRT
|
7.4 KB
|
|
|
5. Move, Copy and Insert Data.mp4
|
MP4
|
66.4 MB
|
|
|
5. Move, Copy and Insert Data.srt
|
SRT
|
10.2 KB
|
|
|
6. Add a trendline to a PivotChart.mp4
|
MP4
|
23.2 MB
|
|
|
6. Add a trendline to a PivotChart.srt
|
SRT
|
4.8 KB
|
|
|
6. Drilling down the data.mp4
|
MP4
|
43.6 MB
|
|
|
6. Drilling down the data.srt
|
SRT
|
5.6 KB
|
|
|
6. Edit a conditional formatting rule.mp4
|
MP4
|
20.2 MB
|
|
|
6. Edit a conditional formatting rule.srt
|
SRT
|
3.9 KB
|
|
|
6. Find and Replace.mp4
|
MP4
|
60.5 MB
|
|
|
6. Find and Replace.srt
|
SRT
|
8.9 KB
|
|
|
6. Improve readability with cells and range names.mp4
|
MP4
|
36.9 MB
|
|
|
6. Improve readability with cells and range names.srt
|
SRT
|
6.8 KB
|
|
|
7. IF logical test and the use of relational operators.mp4
|
MP4
|
60.5 MB
|
|
|
7. IF logical test and the use of relational operators.srt
|
SRT
|
13.6 KB
|
|
|
7. Multiple formatting.mp4
|
MP4
|
51.9 MB
|
|
|
7. Multiple formatting.srt
|
SRT
|
11.1 KB
|
|
|
7. Sorting the data.mp4
|
MP4
|
16.9 MB
|
|
|
7. Sorting the data.srt
|
SRT
|
3.4 KB
|
|
|
8. Filtering the data.mp4
|
MP4
|
20.9 MB
|
|
|
8. Filtering the data.srt
|
SRT
|
3.8 KB
|
|
|
8. Nested IF statement.mp4
|
MP4
|
45.5 MB
|
|
|
8. Nested IF statement.srt
|
SRT
|
12.8 KB
|
|
|
9. Compound logical tests with AND, OR.mp4
|
MP4
|
64.7 MB
|
|
|
9. Compound logical tests with AND, OR.srt
|
SRT
|
16.4 KB
|
|
|
9. Filter by rules.mp4
|
MP4
|
30.3 MB
|
|
|
9. Filter by rules.srt
|
SRT
|
4.7 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
