Udemy - Microsoft Excel _ MS Excel Basics & Excel PivotTables (2021)

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1. Getting Started with Excel
• 1. What is Excel used for.mp4 (31.4 MB)
• 1. What is Excel used for.srt (5.5 KB)
• 2. Excel Toolbars and shortcut menues.mp4 (41.0 MB)
• 2. Excel Toolbars and shortcut menues.srt (8.3 KB)
• 3. Workbooks and Worksheets.mp4 (29.7 MB)
• 3. Workbooks and Worksheets.srt (6.7 KB)
• 4. How to look for Help on Excel - Using Excel Help.mp4 (21.7 MB)
• 4. How to look for Help on Excel - Using Excel Help.srt (4.3 KB)
2. Data entry, Editing and AutoFill
• 1. Data entry, Editing and AutoFill.mp4 (34.7 MB)
• 1. Data entry, Editing and AutoFill.srt (6.2 KB)
• 2. Entering Dates and Time.mp4 (33.9 MB)
• 2. Entering Dates and Time.srt (7.7 KB)
3. Formulas and Functions
• 1. Working with Simple formulas.mp4 (58.8 MB)
• 1. Working with Simple formulas.srt (11.1 KB)
• 2. Using the SUM() function.mp4 (46.3 MB)
• 2. Using the SUM() function.srt (8.0 KB)
• 3. Using MIN() and MAX() Functions.mp4 (24.0 MB)
• 3. Using MIN() and MAX() Functions.srt (3.6 KB)
• 4. Using the AVERAGE() function.mp4 (40.4 MB)
• 4. Using the AVERAGE() function.srt (5.9 KB)
4. Charts
• 1. How to Create Charts in Excel.mp4 (69.1 MB)
• 1. How to Create Charts in Excel.srt (11.9 KB)
• 2. Chart Types.mp4 (113.8 MB)
• 2. Chart Types.srt (17.6 KB)
• 3. Exploring Excel Ideas.mp4 (33.6 MB)
• 3. Exploring Excel Ideas.srt (4.8 KB)
5. PivotTables in Excel
• 1. Introduction.mp4 (6.2 MB)
• 1. Introduction.srt (1.0 KB)
• 2. Create your first PivotTable.mp4 (109.1 MB)
• 2. Create your first PivotTable.srt (15.3 KB)
• 3. Configure your PivotTable.mp4 (51.1 MB)
• 3. Configure your PivotTable.srt (9.5 KB)
• 4. Create a PivotTable from external data source.mp4 (14.7 MB)
• 4. Create a PivotTable from external data source.srt (2.9 KB)
• 5. Manage PivotTables.mp4 (46.2 MB)
• 5. Manage PivotTables.srt (7.4 KB)
6. Summarizing PivotTable Data
• 1. Subtotals and Grand Totals.mp4 (33.7 MB)
• 1. Subtotals and Grand Totals.srt (5.3 KB)
• 10. Filtering with search.mp4 (13.3 MB)
• 10. Filtering with search.srt (2.3 KB)
• 11. Filtering using Slicers.mp4 (36.1 MB)
• 11. Filtering using Slicers.srt (6.8 KB)
• 12. Formatting the slicers.mp4 (28.4 MB)
• 12. Formatting the slicers.srt (5.5 KB)
• 13. More on filtering your data.mp4 (43.7 MB)
• 13. More on filtering your data.srt (8.2 KB)
• 14. Clearing and re-applying filters.mp4 (43.7 MB)
• 14. Clearing and re-applying filters.srt (8.2 KB)
• 15. Filtering the PivotTable with a Timeline.mp4 (28.9 MB)
• 15. Filtering the PivotTable with a Timeline.srt (5.0 KB)
• 16. Changing the style of the PivotTable.mp4 (39.3 MB)
• 16. Changing the style of the PivotTable.srt (6.3 KB)
• 17. Changing the Layout of the PivotTable.mp4 (38.4 MB)
• 17. Changing the Layout of the PivotTable.srt (6.8 KB)
• 18. Formatting the numbers in the PivotTable.mp4 (32.7 MB)
• 18. Formatting the numbers in the PivotTable.srt (5.3 KB)
• 2. Operations of the Data field summary.mp4 (30.2 MB)
• 2. Operations of the Data field summary.srt (4.8 KB)
• 3. Adding more than one data field.mp4 (24.9 MB)
• 3. Adding more than one data field.srt (4.2 KB)
• 4. Managing Dates in PivotTables.mp4 (29.8 MB)
• 4. Managing Dates in PivotTables.srt (4.5 KB)
• 5. Creating Calculated Fields.mp4 (29.4 MB)
• 5. Creating Calculated Fields.srt (5.3 KB)
• 6. Drilling down the data.mp4 (43.6 MB)
• 6. Drilling down the data.srt (5.6 KB)
• 7. Sorting the data.mp4 (16.9 MB)
• 7. Sorting the data.srt (3.4 KB)
• 8. Filtering the data.mp4 (20.9 MB)
• 8. Filtering the data.srt (3.8 KB)
• 9. Filter by rules.mp4 (30.3 MB)
• 9. Filter by rules.srt (4.7 KB)
7. Conditional formatting for PivotTables
• 1. Highlighting cells by applying a rule.mp4 (54.5 MB)
• 1. Highlighting cells by applying a rule.srt (11.2 KB)
• 2. Highlight the top values in a PivotTable.mp4 (43.3 MB)
• 2. Highlight the top values in a PivotTable.srt (7.1 KB)
• 3. Formatting cells using data bars.mp4 (36.5 MB)
• 3. Formatting cells using data bars.srt (8.2 KB)
• 4. Formatting cells using colour scale.mp4 (42.2 MB)
• 4. Formatting cells using colour scale.srt (10.5 KB)
• 5. Formatting cells using icon sets.mp4 (43.9 MB)
• 5. Formatting cells using icon sets.srt (9.1 KB)
• 6. Edit a conditional formatting rule.mp4 (20.2 MB)
• 6. Edit a conditional formatting rule.srt (3.9 KB)
• 7. Multiple formatting.mp4 (51.9 MB)
• 7. Multiple formatting.srt (11.1 KB)
• Bonus Resources.txt (0.3 KB)