|
/0. Formatting/
|
|
0. Create Custom Number Formats.mp4
|
13.2 MB
|
|
0. Create Custom Number Formats.srt
|
8.7 KB
|
|
1. Apply International Currency Formats.mp4
|
8.9 MB
|
|
1. Apply International Currency Formats.srt
|
4.0 KB
|
|
2. Display Data in Multiple International Formats.mp4
|
8.0 MB
|
|
2. Display Data in Multiple International Formats.srt
|
4.5 KB
|
|
/1. Working with Data/
|
|
0. Outline Data.mp4
|
39.3 MB
|
|
0. Outline Data.srt
|
6.0 KB
|
|
1. Insert Subtotals.mp4
|
23.1 MB
|
|
1. Insert Subtotals.srt
|
4.5 KB
|
|
2. Insert References.mp4
|
12.1 MB
|
|
2. Insert References.srt
|
5.9 KB
|
|
3. Reference Data in Another Workbook.mp4
|
9.4 MB
|
|
3. Reference Data in Another Workbook.srt
|
4.5 KB
|
|
4. Reference Data by Using Structured References.mp4
|
8.7 MB
|
|
4. Reference Data by Using Structured References.srt
|
5.0 KB
|
|
5. Consolidate Data.mp4
|
15.6 MB
|
|
5. Consolidate Data.srt
|
6.0 KB
|
|
6. Configure Data Validation.mp4
|
14.8 MB
|
|
6. Configure Data Validation.srt
|
8.6 KB
|
|
/10. Advanced Options/
|
|
0. Display Hidden Ribbon Tabs.mp4
|
18.9 MB
|
|
0. Display Hidden Ribbon Tabs.srt
|
8.4 KB
|
|
1. Configure Formula Calculation Options.mp4
|
13.6 MB
|
|
1. Configure Formula Calculation Options.srt
|
6.5 KB
|
|
/11. Finalizing a Workbook/
|
|
0. Inspect a Workbook for Hidden Properties or Personal Information.mp4
|
13.7 MB
|
|
0. Inspect a Workbook for Hidden Properties or Personal Information.srt
|
6.6 KB
|
|
1. Inspect a Workbook for Accessibility Issues.mp4
|
14.2 MB
|
|
1. Inspect a Workbook for Accessibility Issues.srt
|
5.1 KB
|
|
2. Inspect a Workbook for Compatibility Issues.mp4
|
13.4 MB
|
|
2. Inspect a Workbook for Compatibility Issues.srt
|
5.3 KB
|
|
3. Restrict Editing.mp4
|
18.1 MB
|
|
3. Restrict Editing.srt
|
7.1 KB
|
|
4. Protect Workbook Structure.mp4
|
9.5 MB
|
|
4. Protect Workbook Structure.srt
|
3.7 KB
|
|
5. Encrypt a Workbook with a Password.mp4
|
5.8 MB
|
|
5. Encrypt a Workbook with a Password.srt
|
2.8 KB
|
|
6. Manage Workbook Versions.mp4
|
9.2 MB
|
|
6. Manage Workbook Versions.srt
|
4.6 KB
|
|
/12. Macros/
|
|
0. Create a Simple Macro.mp4
|
20.1 MB
|
|
0. Create a Simple Macro.srt
|
9.1 KB
|
|
1. Modify a Simple Macro.mp4
|
9.3 MB
|
|
1. Modify a Simple Macro.srt
|
3.5 KB
|
|
2. Save and Enable Macros in a Workbook.mp4
|
7.8 MB
|
|
2. Save and Enable Macros in a Workbook.srt
|
3.5 KB
|
|
3. Copy Macros Between Workbooks.mp4
|
11.8 MB
|
|
3. Copy Macros Between Workbooks.srt
|
4.1 KB
|
|
4. Create a Macro Button.mp4
|
6.8 MB
|
|
4. Create a Macro Button.srt
|
1.8 KB
|
|
/13. Form Controls/
|
|
0. Insert and Configure Form Controls.mp4
|
16.1 MB
|
|
0. Insert and Configure Form Controls.srt
|
10.2 KB
|
|
/2. Power Query/
|
|
0. Import, Transform, and Connect to Data.mp4
|
30.7 MB
|
|
0. Import, Transform, and Connect to Data.srt
|
14.5 KB
|
|
1. Combine and Display Data.mp4
|
21.5 MB
|
|
1. Combine and Display Data.srt
|
10.2 KB
|
|
/3. Text Functions/
|
|
0. Format Text by Using RIGHT, LEFT, and MID Functions.mp4
|
16.0 MB
|
|
0. Format Text by Using RIGHT, LEFT, and MID Functions.srt
|
4.7 KB
|
|
1. Format Text by Using UPPER, LOWER, and PROPER Functions.mp4
|
14.0 MB
|
|
1. Format Text by Using UPPER, LOWER, and PROPER Functions.srt
|
3.7 KB
|
|
2. Format Text by Using the CONCAT Function.mp4
|
12.4 MB
|
|
2. Format Text by Using the CONCAT Function.srt
|
3.5 KB
|
|
/4. Logical and Statistical Functions/
|
|
0. Perform Logical Operations by Using the IF Function.mp4
|
8.1 MB
|
|
0. Perform Logical Operations by Using the IF Function.srt
|
3.4 KB
|
|
1. Perform Logical Operations by Using the SUMIF Function.mp4
|
19.2 MB
|
|
1. Perform Logical Operations by Using the SUMIF Function.srt
|
6.6 KB
|
|
2. Perform Logical Operations by Using the AVERAGEIF Function.mp4
|
17.9 MB
|
|
2. Perform Logical Operations by Using the AVERAGEIF Function.srt
|
5.9 KB
|
|
3. Perform Statistical Operations by Using the COUNTIF Function.mp4
|
5.4 MB
|
|
3. Perform Statistical Operations by Using the COUNTIF Function.srt
|
2.1 KB
|
|
4. Perform Statistical Operations by Using the SUMIFS Function.mp4
|
18.4 MB
|
|
4. Perform Statistical Operations by Using the SUMIFS Function.srt
|
6.4 KB
|
|
5. Perform Statistical Operations by Using the AVERAGEIFS Function.mp4
|
15.1 MB
|
|
5. Perform Statistical Operations by Using the AVERAGEIFS Function.srt
|
4.6 KB
|
|
6. Perform Statistical Operations by Using the COUNTIFS Function.mp4
|
12.8 MB
|
|
6. Perform Statistical Operations by Using the COUNTIFS Function.srt
|
3.2 KB
|
|
7. Perform Logical Operations by Using AND, OR, and NOT Functions.mp4
|
14.1 MB
|
|
7. Perform Logical Operations by Using AND, OR, and NOT Functions.srt
|
5.0 KB
|
|
8. Perform Logical Operations by Using Nested Functions.mp4
|
19.4 MB
|
|
8. Perform Logical Operations by Using Nested Functions.srt
|
10.0 KB
|
|
/5. Expanded Functions/
|
|
0. Reference the Date and Time by Using the NOW and TODAY Functions.mp4
|
16.7 MB
|
|
0. Reference the Date and Time by Using the NOW and TODAY Functions.srt
|
9.8 KB
|
|
1. Serialize Numbers by Using DATE and TIME Functions.mp4
|
19.8 MB
|
|
1. Serialize Numbers by Using DATE and TIME Functions.srt
|
8.7 KB
|
|
2. Perform What-if Analysis by Using Goal Seek.mp4
|
9.4 MB
|
|
2. Perform What-if Analysis by Using Goal Seek.srt
|
6.0 KB
|
|
3. Perform What-if Analysis by Using Scenario Manager.mp4
|
22.7 MB
|
|
3. Perform What-if Analysis by Using Scenario Manager.srt
|
11.3 KB
|
|
4. Calculate Data by Using Financial Functions- PMT.mp4
|
8.9 MB
|
|
4. Calculate Data by Using Financial Functions- PMT.srt
|
5.4 KB
|
|
5. Calculate Data by Using Financial Functions- PPMT & IPMT.mp4
|
23.3 MB
|
|
5. Calculate Data by Using Financial Functions- PPMT & IPMT.srt
|
12.8 KB
|
|
6. Calculate Data by Using Financial Functions- FV.mp4
|
11.8 MB
|
|
6. Calculate Data by Using Financial Functions- FV.srt
|
6.2 KB
|
|
/6. Error Checking/
|
|
0. Display Formulas.mp4
|
10.2 MB
|
|
0. Display Formulas.srt
|
2.9 KB
|
|
1. Trace Precedence and Dependence.mp4
|
16.9 MB
|
|
1. Trace Precedence and Dependence.srt
|
6.9 KB
|
|
2. Evaluate Formulas.mp4
|
8.1 MB
|
|
2. Evaluate Formulas.srt
|
3.5 KB
|
|
3. Validate Formulas by Using Error Checking Rules.mp4
|
26.1 MB
|
|
3. Validate Formulas by Using Error Checking Rules.srt
|
7.1 KB
|
|
4. Monitor Cells and Formulas by Using the Watch Window.mp4
|
13.4 MB
|
|
4. Monitor Cells and Formulas by Using the Watch Window.srt
|
5.5 KB
|
|
/7. Conditional Formatting/
|
|
0. Apply Conditional Formatting.mp4
|
30.4 MB
|
|
0. Apply Conditional Formatting.srt
|
10.0 KB
|
|
1. Create Custom Conditional Formatting Rules.mp4
|
21.7 MB
|
|
1. Create Custom Conditional Formatting Rules.srt
|
7.2 KB
|
|
2. Create Conditional Formatting Rules That Use Formulas.mp4
|
29.7 MB
|
|
2. Create Conditional Formatting Rules That Use Formulas.srt
|
7.7 KB
|
|
3. Manage Conditional Formatting Rules.mp4
|
19.1 MB
|
|
3. Manage Conditional Formatting Rules.srt
|
5.8 KB
|
|
/8. Charts/
|
|
0. Insert Sparklines.mp4
|
32.8 MB
|
|
0. Insert Sparklines.srt
|
7.4 KB
|
|
1. Create a New Chart.mp4
|
12.1 MB
|
|
1. Create a New Chart.srt
|
5.6 KB
|
|
10. Add Trendlines to Charts.mp4
|
13.1 MB
|
|
10. Add Trendlines to Charts.srt
|
7.4 KB
|
|
11. Create Dual-axis Charts.mp4
|
10.9 MB
|
|
11. Create Dual-axis Charts.srt
|
6.3 KB
|
|
12. Save a Chart as a Template.mp4
|
8.9 MB
|
|
12. Save a Chart as a Template.srt
|
4.1 KB
|
|
2. Add Additional Data Series.mp4
|
17.8 MB
|
|
2. Add Additional Data Series.srt
|
6.7 KB
|
|
3. Switch Between Rows and Columns in Source Data.mp4
|
5.1 MB
|
|
3. Switch Between Rows and Columns in Source Data.srt
|
2.1 KB
|
|
4. Analyze Data by Using Quick Analysis.mp4
|
11.0 MB
|
|
4. Analyze Data by Using Quick Analysis.srt
|
5.5 KB
|
|
5. Resize Charts.mp4
|
7.5 MB
|
|
5. Resize Charts.srt
|
2.9 KB
|
|
6. Move Charts to a Chart Sheet.mp4
|
10.1 MB
|
|
6. Move Charts to a Chart Sheet.srt
|
3.9 KB
|
|
7. Add and Modify Chart Elements.mp4
|
19.4 MB
|
|
7. Add and Modify Chart Elements.srt
|
7.9 KB
|
|
8. Apply Chart Layouts.mp4
|
8.6 MB
|
|
8. Apply Chart Layouts.srt
|
4.1 KB
|
|
9. Apply Chart Styles.mp4
|
13.1 MB
|
|
9. Apply Chart Styles.srt
|
5.6 KB
|
|
/9. Pivot Tables/
|
|
0. Create Pivot Tables.mp4
|
31.1 MB
|
|
0. Create Pivot Tables.srt
|
10.0 KB
|
|
1. Modify Field Selections and Options.mp4
|
17.8 MB
|
|
1. Modify Field Selections and Options.srt
|
7.7 KB
|
|
10. Manipulate Options in Existing Pivot Charts.mp4
|
10.7 MB
|
|
10. Manipulate Options in Existing Pivot Charts.srt
|
5.4 KB
|
|
11. Apply Styles to Pivot Charts.mp4
|
7.6 MB
|
|
11. Apply Styles to Pivot Charts.srt
|
3.4 KB
|
|
12. Drill down into Pivot Chart Details.mp4
|
8.8 MB
|
|
12. Drill down into Pivot Chart Details.srt
|
4.3 KB
|
|
2. Create Slicers.mp4
|
9.8 MB
|
|
2. Create Slicers.srt
|
6.0 KB
|
|
3. Group Pivot Table Data.mp4
|
12.3 MB
|
|
3. Group Pivot Table Data.srt
|
5.3 KB
|
|
4. Format Pivot Table Data.mp4
|
11.4 MB
|
|
4. Format Pivot Table Data.srt
|
5.4 KB
|
|
5. Add Additional Fields.mp4
|
13.9 MB
|
|
5. Add Additional Fields.srt
|
6.1 KB
|
|
6. Add Calculated Fields.mp4
|
17.4 MB
|
|
6. Add Calculated Fields.srt
|
7.3 KB
|
|
7. Drill down into PivotTable Details.mp4
|
9.3 MB
|
|
7. Drill down into PivotTable Details.srt
|
3.7 KB
|
|
8. Use Cube Functions to Get Data out of the Excel Data Model.mp4
|
18.8 MB
|
|
8. Use Cube Functions to Get Data out of the Excel Data Model.srt
|
10.5 KB
|
|
9. Create Pivot Charts.mp4
|
13.2 MB
|
|
9. Create Pivot Charts.srt
|
5.8 KB
|
|
/
|
|
content.txt
|
4.3 KB
|
|
Total files 163
|
