Udemy Mastering Excel Data Analysis Dashboard Reporting

Files Included :

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
4 Commencing the Journey.mp4 (10.54 MB)
MP4
1 Important Section Instructions.mp4 (16.21 MB)
MP4
2 Working On Text Visuals Through Proper() Function.mp4 (92.55 MB)
MP4
3 Establish Uniformity Using Excel's UPPER() Function.mp4 (60.91 MB)
MP4
4 Harnessing MS Excel's Paste Special Feature.mp4 (60.86 MB)
MP4
5 Substituting Nonsensical Data with the CHOOSE() Function.mp4 (143.47 MB)
MP4
6 Utilizing the TEXT() Function for Date Value Extraction.mp4 (85.76 MB)
MP4
1 Customer Information Lookup.mp4 (17.54 MB)
MP4
2 Data Preparation Formatting as a Table.mp4 (81.88 MB)
MP4
3 Generating a Dropdown Menu using Data Validation.mp4 (34.41 MB)
MP4
4 Data Retrieval using Excel's VLOOKUP() Function.mp4 (93.27 MB)
MP4
5 Data Cleansing using Excel's IF() Function.mp4 (61.63 MB)
MP4
6 Exploring INDEX() and MATCH() VLOOKUP() Alternative.mp4 (220.83 MB)
MP4
1 Incorporating the Order History Table.mp4 (88.96 MB)
MP4
2 Converting Orders into a Table Format.mp4 (56.36 MB)
MP4
3 Exploring Excel's Advanced Filter Functionality.mp4 (95.68 MB)
MP4
4 Creating a Macro for Advanced Filtering.mp4 (96.33 MB)
MP4
5 Implementing Customer-Triggered Order Record Filtering (VBA).mp4 (45.6 MB)
MP4
6 Adjusting the VBA Filter Code.mp4 (103.44 MB)
MP4
1 The Benefits of Utilizing Excel's SUBTOTAL() Function.mp4 (80.18 MB)
MP4
2 Applying the SUBTOTAL() Function in Practice.mp4 (96.71 MB)
MP4
1 The Advantages of Using PivotTables.mp4 (93.39 MB)
MP4
2 Condensing Order Information using PivotTables.mp4 (74.07 MB)
MP4
3 Setting Up PivotTable for Customer Filtering.mp4 (49.88 MB)
MP4
4 Crafting the VBA Process.mp4 (47.14 MB)
MP4
5 Defining Variables in VBA.mp4 (20.03 MB)
MP4
6 Setting Values for VBA Variables.mp4 (67.24 MB)
MP4
7 Linking the Filter with the PivotTable.mp4 (47.68 MB)
MP4
8 Updating Pivot Chart with Customer Selection (VBA).mp4 (47.5 MB)
MP4
9 Handling Errors for Customers with No Orders.mp4 (56.89 MB)
MP4
1 Generating Dynamic Charts using Slicers.mp4 (56.09 MB)
MP4
2 Customizing the Chart Slicer.mp4 (22.58 MB)
MP4
1 Concealing Redundant Worksheets and Columns.mp4 (72.48 MB)
MP4
2 Optimizing Excel's Default Configuration.mp4 (23.57 MB)
MP4
3 Concealing Chart and Slicer Reset (VBA).mp4 (91.05 MB)
MP4
4 Securing the Dashboard Content.mp4 (59.32 MB)
MP4
1 Achievement Unlocked Congratulations!.mp4 (10.29 MB)
MP4