PivotTables in Excel Course for Beginners

Files Included :

1 Course Introduction.mp4 (62.56 MB)
MP4
2 WATCH ME Essential Information for a Successful Training Experience.mp4 (37.99 MB)
MP4
5 What are Pivot Tables and Why are They Useful.mp4 (67.87 MB)
MP4
1 Selecting the Right Chart Type.mp4 (69.72 MB)
MP4
2 Clustered Column and Bar Charts.mp4 (86.21 MB)
MP4
3 Line Charts.mp4 (65.59 MB)
MP4
4 Pie and Donut Charts.mp4 (71.63 MB)
MP4
5 Map Charts.mp4 (78.52 MB)
MP4
6 Applying Chart Layouts.mp4 (20.29 MB)
MP4
7 Exercise 09.mp4 (32.56 MB)
MP4
1 Adding a Slicer.mp4 (48.55 MB)
MP4
2 Formatting a Slicer.mp4 (41.62 MB)
MP4
3 Adding a Timeline.mp4 (50.22 MB)
MP4
4 Connecting Slicers and Timelines.mp4 (36.73 MB)
MP4
5 Exercise 10.mp4 (24.37 MB)
MP4
1 Highlight Cell Rules.mp4 (36.31 MB)
MP4
2 Data Bars.mp4 (35.93 MB)
MP4
3 Color Scales.mp4 (30.32 MB)
MP4
4 Icon Sets.mp4 (39.74 MB)
MP4
5 Exercise 11.mp4 (14.33 MB)
MP4
1 Adding Data to the Dataset.mp4 (39.38 MB)
MP4
2 Updating Pivot Tables and Pivot Charts.mp4 (16.25 MB)
MP4
3 Exercise 12.mp4 (25.46 MB)
MP4
1 Course Close and Next Steps.mp4 (20.17 MB)
MP4
2 Ten Excel Tips and Tricks - Part 1.mp4 (336.74 MB)
MP4
3 Ten Excel Tips and Tricks - Part 2.mp4 (293.66 MB)
MP4
4 Ten Excel Tips and Tricks - Part 3.mp4 (317.65 MB)
MP4
1 The Importance of Cleaning Data.mp4 (35.76 MB)
MP4
10 Finding and Replacing Text.mp4 (81.38 MB)
MP4
11 Spell Check.mp4 (51.55 MB)
MP4
12 Exercise 01.mp4 (56.5 MB)
MP4
2 Removing Blank Rows.mp4 (62.49 MB)
MP4
3 Removing Duplicate Rows.mp4 (34.79 MB)
MP4
4 Clearing Formatting.mp4 (58.78 MB)
MP4
5 Applying Number Formatting.mp4 (121.26 MB)
MP4
6 Changing the Case.mp4 (113.26 MB)
MP4
7 Removing Spaces and Non-printing Characters.mp4 (129.28 MB)
MP4
8 Merging and Splitting Columns.mp4 (101.26 MB)
MP4
9 Convert Numbers Stored as Text.mp4 (31.39 MB)
MP4
1 Excel Tables vs Pivot Tables.mp4 (73.8 MB)
MP4
2 Format Data as a Table.mp4 (134.46 MB)
MP4
3 Exercise 02.mp4 (29.28 MB)
MP4
1 Using Recommended Pivot Tables.mp4 (68.13 MB)
MP4
2 Creating a Pivot Table from Scratch.mp4 (63.33 MB)
MP4
3 Pivot Table Ribbons and Fields.mp4 (37.43 MB)
MP4
4 Pivoting the Fields.mp4 (36.85 MB)
MP4
5 Adding Multiple Dimensions.mp4 (29.98 MB)
MP4
6 Deleting Fields and Locking the Report Layout.mp4 (38.19 MB)
MP4
7 Exercise 03.mp4 (20.77 MB)
MP4
1 Methods of Aggregation.mp4 (38.07 MB)
MP4
2 Combining Methods of Aggregation.mp4 (48.59 MB)
MP4
3 Grouping and Ungrouping Data.mp4 (88.77 MB)
MP4
4 Exercise 04.mp4 (33.6 MB)
MP4
1 Applying Number Formatting.mp4 (46.53 MB)
MP4
2 Handling Cells with No Data.mp4 (36.29 MB)
MP4
3 Exercise 05.mp4 (24.48 MB)
MP4
1 Subtotals and Grand Totals.mp4 (45.08 MB)
MP4
2 Choosing a Report Layout.mp4 (47.64 MB)
MP4
3 Inserting Blank Rows.mp4 (23.43 MB)
MP4
4 Exercise 06.mp4 (15.7 MB)
MP4
1 Applying Pivot Table Styles.mp4 (47.38 MB)
MP4
2 Modifying Pivot Table Styles.mp4 (48.46 MB)
MP4
3 Creating a Custom Pivot Table Style.mp4 (64.55 MB)
MP4
4 Exercise 07.mp4 (36.36 MB)
MP4
1 Sorting Pivot Table Data.mp4 (86.72 MB)
MP4
2 Filtering Pivot Table Data.mp4 (73.02 MB)
MP4
3 Top 10 Filter.mp4 (30.37 MB)
MP4
4 Exercise 08.mp4 (18.62 MB)
MP4