|
Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
| 0. Apply Conditional Formatting.mp4 |
28.96MB |
| 0. Apply Conditional Formatting.srt |
9.72KB |
| 0. Create a Simple Macro.mp4 |
19.16MB |
| 0. Create a Simple Macro.srt |
8.92KB |
| 0. Create Custom Number Formats.mp4 |
12.61MB |
| 0. Create Custom Number Formats.srt |
8.48KB |
| 0. Create Pivot Tables.mp4 |
29.63MB |
| 0. Create Pivot Tables.srt |
9.74KB |
| 0. Display Formulas.mp4 |
9.68MB |
| 0. Display Formulas.srt |
2.85KB |
| 0. Display Hidden Ribbon Tabs.mp4 |
18.02MB |
| 0. Display Hidden Ribbon Tabs.srt |
8.16KB |
| 0. Format Text by Using RIGHT, LEFT, and MID Functions.mp4 |
15.26MB |
| 0. Format Text by Using RIGHT, LEFT, and MID Functions.srt |
4.56KB |
| 0. Import, Transform, and Connect to Data.mp4 |
29.30MB |
| 0. Import, Transform, and Connect to Data.srt |
14.14KB |
| 0. Insert and Configure Form Controls.mp4 |
15.35MB |
| 0. Insert and Configure Form Controls.srt |
9.92KB |
| 0. Insert Sparklines.mp4 |
31.29MB |
| 0. Insert Sparklines.srt |
7.22KB |
| 0. Inspect a Workbook for Hidden Properties or Personal Information.mp4 |
13.08MB |
| 0. Inspect a Workbook for Hidden Properties or Personal Information.srt |
6.47KB |
| 0. Outline Data.mp4 |
37.46MB |
| 0. Outline Data.srt |
5.84KB |
| 0. Perform Logical Operations by Using the IF Function.mp4 |
7.76MB |
| 0. Perform Logical Operations by Using the IF Function.srt |
3.34KB |
| 0. Reference the Date and Time by Using the NOW and TODAY Functions.mp4 |
15.91MB |
| 0. Reference the Date and Time by Using the NOW and TODAY Functions.srt |
9.53KB |
| 1. Apply International Currency Formats.mp4 |
8.47MB |
| 1. Apply International Currency Formats.srt |
3.95KB |
| 1. Combine and Display Data.mp4 |
20.50MB |
| 1. Combine and Display Data.srt |
9.97KB |
| 1. Configure Formula Calculation Options.mp4 |
13.00MB |
| 1. Configure Formula Calculation Options.srt |
6.34KB |
| 1. Create a New Chart.mp4 |
11.59MB |
| 1. Create a New Chart.srt |
5.51KB |
| 1. Create Custom Conditional Formatting Rules.mp4 |
20.74MB |
| 1. Create Custom Conditional Formatting Rules.srt |
7.05KB |
| 1. Format Text by Using UPPER, LOWER, and PROPER Functions.mp4 |
13.31MB |
| 1. Format Text by Using UPPER, LOWER, and PROPER Functions.srt |
3.61KB |
| 1. Insert Subtotals.mp4 |
21.99MB |
| 1. Insert Subtotals.srt |
4.40KB |
| 1. Inspect a Workbook for Accessibility Issues.mp4 |
13.52MB |
| 1. Inspect a Workbook for Accessibility Issues.srt |
5.00KB |
| 1. Modify a Simple Macro.mp4 |
8.87MB |
| 1. Modify a Simple Macro.srt |
3.44KB |
| 1. Modify Field Selections and Options.mp4 |
16.97MB |
| 1. Modify Field Selections and Options.srt |
7.57KB |
| 1. Perform Logical Operations by Using the SUMIF Function.mp4 |
18.30MB |
| 1. Perform Logical Operations by Using the SUMIF Function.srt |
6.49KB |
| 1. Serialize Numbers by Using DATE and TIME Functions.mp4 |
18.92MB |
| 1. Serialize Numbers by Using DATE and TIME Functions.srt |
8.52KB |
| 1. Trace Precedence and Dependence.mp4 |
16.13MB |
| 1. Trace Precedence and Dependence.srt |
6.70KB |
| 10. Add Trendlines to Charts.mp4 |
12.52MB |
| 10. Add Trendlines to Charts.srt |
7.25KB |
| 10. Manipulate Options in Existing Pivot Charts.mp4 |
10.22MB |
| 10. Manipulate Options in Existing Pivot Charts.srt |
5.23KB |
| 11. Apply Styles to Pivot Charts.mp4 |
7.28MB |
| 11. Apply Styles to Pivot Charts.srt |
3.31KB |
| 11. Create Dual-axis Charts.mp4 |
10.40MB |
| 11. Create Dual-axis Charts.srt |
6.15KB |
| 12. Drill down into Pivot Chart Details.mp4 |
8.36MB |
| 12. Drill down into Pivot Chart Details.srt |
4.17KB |
| 12. Save a Chart as a Template.mp4 |
8.52MB |
| 12. Save a Chart as a Template.srt |
4.00KB |
| 2. Add Additional Data Series.mp4 |
16.97MB |
| 2. Add Additional Data Series.srt |
6.50KB |
| 2. Create Conditional Formatting Rules That Use Formulas.mp4 |
28.34MB |
| 2. Create Conditional Formatting Rules That Use Formulas.srt |
7.48KB |
| 2. Create Slicers.mp4 |
9.38MB |
| 2. Create Slicers.srt |
5.87KB |
| 2. Display Data in Multiple International Formats.mp4 |
7.60MB |
| 2. Display Data in Multiple International Formats.srt |
4.39KB |
| 2. Evaluate Formulas.mp4 |
7.69MB |
| 2. Evaluate Formulas.srt |
3.37KB |
| 2. Format Text by Using the CONCAT Function.mp4 |
11.84MB |
| 2. Format Text by Using the CONCAT Function.srt |
3.39KB |
| 2. Insert References.mp4 |
11.50MB |
| 2. Insert References.srt |
5.74KB |
| 2. Inspect a Workbook for Compatibility Issues.mp4 |
12.74MB |
| 2. Inspect a Workbook for Compatibility Issues.srt |
5.14KB |
| 2. Perform Logical Operations by Using the AVERAGEIF Function.mp4 |
17.06MB |
| 2. Perform Logical Operations by Using the AVERAGEIF Function.srt |
5.73KB |
| 2. Perform What-if Analysis by Using Goal Seek.mp4 |
9.00MB |
| 2. Perform What-if Analysis by Using Goal Seek.srt |
5.90KB |
| 2. Save and Enable Macros in a Workbook.mp4 |
7.40MB |
| 2. Save and Enable Macros in a Workbook.srt |
3.38KB |
| 3. Copy Macros Between Workbooks.mp4 |
11.28MB |
| 3. Copy Macros Between Workbooks.srt |
4.01KB |
| 3. Group Pivot Table Data.mp4 |
11.72MB |
| 3. Group Pivot Table Data.srt |
5.18KB |
| 3. Manage Conditional Formatting Rules.mp4 |
18.17MB |
| 3. Manage Conditional Formatting Rules.srt |
5.70KB |
| 3. Perform Statistical Operations by Using the COUNTIF Function.mp4 |
5.12MB |
| 3. Perform Statistical Operations by Using the COUNTIF Function.srt |
2.01KB |
| 3. Perform What-if Analysis by Using Scenario Manager.mp4 |
21.67MB |
| 3. Perform What-if Analysis by Using Scenario Manager.srt |
11.00KB |
| 3. Reference Data in Another Workbook.mp4 |
9.01MB |
| 3. Reference Data in Another Workbook.srt |
4.44KB |
| 3. Restrict Editing.mp4 |
17.28MB |
| 3. Restrict Editing.srt |
6.95KB |
| 3. Switch Between Rows and Columns in Source Data.mp4 |
4.82MB |
| 3. Switch Between Rows and Columns in Source Data.srt |
2.09KB |
| 3. Validate Formulas by Using Error Checking Rules.mp4 |
24.87MB |
| 3. Validate Formulas by Using Error Checking Rules.srt |
6.93KB |
| 4. Analyze Data by Using Quick Analysis.mp4 |
10.52MB |
| 4. Analyze Data by Using Quick Analysis.srt |
5.33KB |
| 4. Calculate Data by Using Financial Functions- PMT.mp4 |
8.51MB |
| 4. Calculate Data by Using Financial Functions- PMT.srt |
5.25KB |
| 4. Create a Macro Button.mp4 |
6.47MB |
| 4. Create a Macro Button.srt |
1.79KB |
| 4. Format Pivot Table Data.mp4 |
10.88MB |
| 4. Format Pivot Table Data.srt |
5.23KB |
| 4. Monitor Cells and Formulas by Using the Watch Window.mp4 |
12.78MB |
| 4. Monitor Cells and Formulas by Using the Watch Window.srt |
5.33KB |
| 4. Perform Statistical Operations by Using the SUMIFS Function.mp4 |
17.54MB |
| 4. Perform Statistical Operations by Using the SUMIFS Function.srt |
6.24KB |
| 4. Protect Workbook Structure.mp4 |
9.03MB |
| 4. Protect Workbook Structure.srt |
3.59KB |
| 4. Reference Data by Using Structured References.mp4 |
8.34MB |
| 4. Reference Data by Using Structured References.srt |
4.92KB |
| 5. Add Additional Fields.mp4 |
13.26MB |
| 5. Add Additional Fields.srt |
6.00KB |
| 5. Calculate Data by Using Financial Functions- PPMT & IPMT.mp4 |
22.24MB |
| 5. Calculate Data by Using Financial Functions- PPMT & IPMT.srt |
12.54KB |
| 5. Consolidate Data.mp4 |
14.90MB |
| 5. Consolidate Data.srt |
5.86KB |
| 5. Encrypt a Workbook with a Password.mp4 |
5.54MB |
| 5. Encrypt a Workbook with a Password.srt |
2.76KB |
| 5. Perform Statistical Operations by Using the AVERAGEIFS Function.mp4 |
14.36MB |
| 5. Perform Statistical Operations by Using the AVERAGEIFS Function.srt |
4.48KB |
| 5. Resize Charts.mp4 |
7.14MB |
| 5. Resize Charts.srt |
2.86KB |
| 6. Add Calculated Fields.mp4 |
16.60MB |
| 6. Add Calculated Fields.srt |
7.14KB |
| 6. Calculate Data by Using Financial Functions- FV.mp4 |
11.28MB |
| 6. Calculate Data by Using Financial Functions- FV.srt |
6.02KB |
| 6. Configure Data Validation.mp4 |
14.08MB |
| 6. Configure Data Validation.srt |
8.39KB |
| 6. Manage Workbook Versions.mp4 |
8.73MB |
| 6. Manage Workbook Versions.srt |
4.52KB |
| 6. Move Charts to a Chart Sheet.mp4 |
9.63MB |
| 6. Move Charts to a Chart Sheet.srt |
3.84KB |
| 6. Perform Statistical Operations by Using the COUNTIFS Function.mp4 |
12.23MB |
| 6. Perform Statistical Operations by Using the COUNTIFS Function.srt |
3.16KB |
| 7. Add and Modify Chart Elements.mp4 |
18.53MB |
| 7. Add and Modify Chart Elements.srt |
7.76KB |
| 7. Drill down into PivotTable Details.mp4 |
8.87MB |
| 7. Drill down into PivotTable Details.srt |
3.62KB |
| 7. Perform Logical Operations by Using AND, OR, and NOT Functions.mp4 |
13.49MB |
| 7. Perform Logical Operations by Using AND, OR, and NOT Functions.srt |
4.91KB |
| 8. Apply Chart Layouts.mp4 |
8.17MB |
| 8. Apply Chart Layouts.srt |
3.96KB |
| 8. Perform Logical Operations by Using Nested Functions.mp4 |
18.50MB |
| 8. Perform Logical Operations by Using Nested Functions.srt |
9.81KB |
| 8. Use Cube Functions to Get Data out of the Excel Data Model.mp4 |
17.94MB |
| 8. Use Cube Functions to Get Data out of the Excel Data Model.srt |
10.25KB |
| 9. Apply Chart Styles.mp4 |
12.51MB |
| 9. Apply Chart Styles.srt |
5.42KB |
| 9. Create Pivot Charts.mp4 |
12.63MB |
| 9. Create Pivot Charts.srt |
5.64KB |
| content.txt |
4.24KB |