1 Course Introduction.mp4 (18.59 MB)
MP4
2 Managing Unprocessed Data.mp4 (64.11 MB)
MP4
3 Comprehensive Guide to Excel Dashboards.mp4 (62.63 MB)
MP4
10 Utilizing the TEXT() Function for Date Value Extraction.mp4 (85.75 MB)
MP4
4 Commencing the Journey.mp4 (10.54 MB)
MP4
5 Important Section Instructions.mp4 (16.21 MB)
MP4
6 Working On Text Visuals Through Proper() Function.mp4 (92.54 MB)
MP4
7 Establish Uniformity Using Excel's UPPER() Function.mp4 (60.91 MB)
MP4
8 Harnessing MS Excel's Paste Special Feature.mp4 (79.34 MB)
MP4
9 Optimizing Data Representation using the CHOOSE() Function.mp4 (143.47 MB)
MP4
11 Customer Information Lookup.mp4 (17.54 MB)
MP4
12 Data Preparation Formatting as a Table.mp4 (81.88 MB)
MP4
13 Generating a Dropdown Menu using Data Validation.mp4 (34.4 MB)
MP4
14 Data Retrieval using Excel's VLOOKUP() Function.mp4 (93.27 MB)
MP4
15 Data Cleansing using Excel's IF() Function.mp4 (61.63 MB)
MP4
16 Exploring INDEX() and MATCH() VLOOKUP() Alternative.mp4 (220.82 MB)
MP4
17 Incorporating the Order History Table.mp4 (88.96 MB)
MP4
18 Converting Orders into a Table Format.mp4 (56.36 MB)
MP4
19 Exploring Excel's Advanced Filter Functionality.mp4 (95.67 MB)
MP4
20 Creating a Macro for Advanced Filtering.mp4 (96.33 MB)
MP4
21 Implementing Customer-Triggered Order Record Filtering (VBA).mp4 (45.59 MB)
MP4
22 Adjusting the VBA Filter Code.mp4 (103.43 MB)
MP4
23 The Benefits of Utilizing Excel's SUBTOTAL() Function.mp4 (80.18 MB)
MP4
24 Applying the SUBTOTAL() Function in Practice.mp4 (96.71 MB)
MP4
25 The Advantages of Using PivotTables.mp4 (93.39 MB)
MP4
26 Condensing Order Information using PivotTables.mp4 (74.07 MB)
MP4
27 Setting Up PivotTable for Customer Filtering.mp4 (49.88 MB)
MP4
28 Crafting the VBA Process.mp4 (47.13 MB)
MP4
29 Defining Variables in VBA.mp4 (20.02 MB)
MP4
30 Setting Values for VBA Variables.mp4 (67.24 MB)
MP4
31 Linking the Filter with the PivotTable.mp4 (47.68 MB)
MP4
32 Updating Pivot Chart with Customer Selection (VBA).mp4 (47.49 MB)
MP4
33 Handling Errors for Customers with No Orders.mp4 (56.89 MB)
MP4
34 Generating Dynamic Charts using Slicers.mp4 (56.09 MB)
MP4
35 Customizing the Chart Slicer.mp4 (22.58 MB)
MP4
36 Concealing Redundant Worksheets and Columns.mp4 (72.48 MB)
MP4
37 Optimizing Excel's Default Configuration.mp4 (23.57 MB)
MP4
38 Concealing Chart and Slicer Reset (VBA).mp4 (91.05 MB)
MP4
39 Securing the Dashboard Content.mp4 (59.32 MB)
MP4
40 Achievement Unlocked Congratulations!.mp4 (10.29 MB)
MP4