Mastering in Advanced Excel Reporting and VBA Macro

Start Download


Files Included :

1 - Trainer Introduction.mp4 (18.53 MB)
MP4
2 - Course Overview.mp4 (62.18 MB)
MP4
3 - Excel Overview.mp4 (139.02 MB)
MP4
4 - Limitation of Excel.mp4 (23.36 MB)
MP4
5 - What is Advanced Excel.mp4 (199.48 MB)
MP4
6 - Cell Referencing.mp4 (90.89 MB)
MP4
66 - Introduction of PIVOT TABLE.mp4 (101.4 MB)
MP4
67 - Basic Feature of PIVOT TABLE.mp4 (113.13 MB)
MP4
68 - More Features of PIVOT TABLE.mp4 (117.41 MB)
MP4
69 - SLICER to Filter Data in PIVOT TABLE and PIVOT CHART.mp4 (198.87 MB)
MP4
70 - Group and Ungroup in PIVOT TABLE.mp4 (58.3 MB)
MP4
71 - Represent Data in Different Calculation.mp4 (224.98 MB)
MP4
72 - CALCULATED FIELD with Live Scenario.mp4 (92.43 MB)
MP4
73 - Filter with Text Value.mp4 (131.89 MB)
MP4
74 - Filter with Number Value.mp4 (82.1 MB)
MP4
75 - Custom Filter.mp4 (22.4 MB)
MP4
76 - Advance Filter.mp4 (268.91 MB)
MP4
77 - Introduction to Chart.mp4 (99.42 MB)
MP4
78 - Dynamic Chart.mp4 (59.92 MB)
MP4
79 - Speedometer Chart.mp4 (62.74 MB)
MP4
80 - Adjust Value Using GOAL SEEK.mp4 (100.13 MB)
MP4
81 - Predict Output Using DATA TABLE.mp4 (99.09 MB)
MP4
82 - Create Scenario Manager.mp4 (30.71 MB)
MP4
83 - Predict Value to Achieve Target.mp4 (105.1 MB)
MP4
84 - Create Dynamic Sales Report.mp4 (903.94 MB)
MP4
85 - Create Performance Report.mp4 (818.1 MB)
MP4
86 - Create a Dashboard on Orders Data.mp4 (992.1 MB)
MP4
87 - Basic Macros Development.mp4 (1.17 GB)
MP4
88 - Advanced Macros Development.mp4 (1.72 GB)
MP4
89 - Form Design.mp4 (2.4 GB)
MP4
10 - Extract Multiple Columns Data Using VLOOKUP and MATCH.mp4 (440.54 MB)
MP4
11 - Extract Data from Multiple Datasets Using VLOOKUP.mp4 (689.12 MB)
MP4
12 - HLOOKUP Overview.mp4 (66.96 MB)
MP4
13 - Extract Data from Multiple Rows and Columns Using HLOOKUP and MATCH.mp4 (100.19 MB)
MP4
14 - Extract Data from Various Datasets Using HLOOKUP and MATCH.mp4 (70.67 MB)
MP4
15 - INDEX Overview.mp4 (62.23 MB)
MP4
16 - Extract Data for Single Column Using INDEX and Single MATCH.mp4 (93.98 MB)
MP4
17 - Extract Data for Multiple Columns Using INDEX and Multiple MATCH.mp4 (145.93 MB)
MP4
18 - Extensive Use of INDEX Function with Various Functions.mp4 (170.41 MB)
MP4
7 - VLOOKUP Overview.mp4 (230.29 MB)
MP4
8 - Extract Product Name of Highest Shipping Cost and Highest Loss with VLOOKUP.mp4 (247.89 MB)
MP4
9 - Basic of MATCH Function.mp4 (55.7 MB)
MP4
19 - Basic of SUMPRODUCT Function.mp4 (45.5 MB)
MP4
20 - Count Data on Single Condition Using COUNTIF and SUMPRODUCT.mp4 (364.6 MB)
MP4
21 - Count Data on Multiple Conditions Using COUNTIFS and SUMPRODUCT.mp4 (760.48 MB)
MP4
22 - Aggregate Data on Single Condition Using SUMIF and SUMPRODUCT.mp4 (186.45 MB)
MP4
23 - Aggregate Data on Multiple Conditions Using SUMIFS and SUMPRODUCT.mp4 (575.56 MB)
MP4
24 - Average on Single and Multiple Conditions with AVERAGEIF and AVERAGEIFS.mp4 (188.32 MB)
MP4
25 - Advance use of Countifs Averageifs and Sumifs with IF Functions.mp4 (150.16 MB)
MP4
26 - Advance Use of SUMPRODUCT Function.mp4 (126.65 MB)
MP4
27 - Returns Grade and Tax Using IF.mp4 (126.45 MB)
MP4
28 - AND to Check Conditions.mp4 (19.97 MB)
MP4
29 - OR to Check Conditions.mp4 (181.83 MB)
MP4
30 - NOT to Reverse Condition.mp4 (67.03 MB)
MP4
31 - Introduction and Importance of Data Cleaning and Transformation.mp4 (11.36 MB)
MP4
32 - Number of Character Count in any Text with LEN Function.mp4 (34.4 MB)
MP4
33 - Find Position of Character with Find and Search Functions.mp4 (36.84 MB)
MP4
34 - Extract Data From Left Side Using LEFT.mp4 (83.54 MB)
MP4
35 - Extract Data From Right Side Using RIGHT.mp4 (50.89 MB)
MP4
36 - Extract Middle Value From Data Using MID.mp4 (145.81 MB)
MP4
37 - Replace Single Character Using SUBSTITUTE Function.mp4 (30.5 MB)
MP4
38 - Replace Complete Word Using SUBSTITUTE Function.mp4 (91.6 MB)
MP4
39 - Specific Character Count Using SUBSTITUTE.mp4 (33.8 MB)
MP4
40 - Dynamic SUBSTITUTE Function with Live Scenario.mp4 (91.96 MB)
MP4
41 - Replace Existing Text with New Text Using REPLACE Function.mp4 (81.31 MB)
MP4
42 - Extract Invoice Number From Data Using REPLACE.mp4 (122.44 MB)
MP4
43 - Extract Last Word From Data.mp4 (73.22 MB)
MP4
44 - Basics of Date Functions.mp4 (125.02 MB)
MP4
45 - Advance Date Function to Calculate Difference in Days.mp4 (258.75 MB)
MP4
46 - Calculate Age and Birthday.mp4 (68.52 MB)
MP4
47 - Date Functions with Live Scenario.mp4 (275.49 MB)
MP4
48 - Calculate Aging of Invoice Payment.mp4 (144.24 MB)
MP4
49 - Basic of OFFSET Function.mp4 (70.47 MB)
MP4
50 - Make a Dynamic Range with OFFSET Function.mp4 (181.54 MB)
MP4
51 - Create a Dynamic Chart with OFFSET Function.mp4 (127.38 MB)
MP4
52 - Use of Dynamic Range in Any Function.mp4 (150.37 MB)
MP4
53 - Create a Dynamic Pivot Table.mp4 (223.7 MB)
MP4
54 - Connect and Import Data from Ms Access Data.mp4 (127.41 MB)
MP4
55 - Connect Transform and Extract Data from Ms Access to Excel.mp4 (61.52 MB)
MP4
56 - Connect and Transform Text Data.mp4 (25.11 MB)
MP4
57 - Introduction to Conditional Formatting.mp4 (60.72 MB)
MP4
58 - Highlight Number on Condition.mp4 (209.54 MB)
MP4
59 - Highlight Text on Condition.mp4 (77.9 MB)
MP4
60 - Highlight TopN Values.mp4 (128.74 MB)
MP4
61 - Highlight with Data Bars Color Scale Icon Set.mp4 (115.11 MB)
MP4
62 - Highlight Duplicates with Single or Multiple Conditions.mp4 (236.31 MB)
MP4
63 - Highlight values on Drop Downlist.mp4 (70.45 MB)
MP4
64 - Highlight Specific Date Month Year.mp4 (87.09 MB)
MP4
65 - Highlight Minimum and Maximum Value.mp4 (39.71 MB)
MP4