download скачать Free download скачать : Reporting and Analytics With Excel+ Excel Macro+SQL+Power BI
mp4 | Video: h264,1280X720 | Audio: AAC, 44.1 KHz
Genre:eLearning | Language: English | Size:17.87 GB

Files Included :

1  Course Introduction.mp4 (79.26 MB)
MP4
2  Excel and Advanced Excel Introduction.mp4 (38.99 MB)
MP4
3  Excel Macro Introduction and Basic Macro writing.mp4 (117.82 MB)
MP4
4  SQL Introduction and SQL Query writing.mp4 (60.89 MB)
MP4
5  Power BI Introduction, Import Data and Visualization.mp4 (231.37 MB)
MP4
1  Introduction of PIVOT TABLE.mp4 (111.43 MB)
MP4
2  Basic Feature of PIVOT TABLE.mp4 (90.69 MB)
MP4
3  More Features of  PIVOT TABLE.mp4 (68.31 MB)
MP4
4  SLICER to Filter Data in PIVOT TABLE and PIVOT CHART.mp4 (113.72 MB)
MP4
5  Group and Ungroup in PIVOT TABLE.mp4 (33.15 MB)
MP4
6  Represent Data in Different % Calculation.mp4 (130.16 MB)
MP4
7  CALCULATED FIELD with Live Scenario.mp4 (58.82 MB)
MP4
1  Filter with Text Value.mp4 (107.13 MB)
MP4
2  Filter with Number Value.mp4 (67.61 MB)
MP4
3  Custom Filter.mp4 (17.9 MB)
MP4
4  Advance Filter.mp4 (151.59 MB)
MP4
1  Introduction to Chart.mp4 (122.52 MB)
MP4
2  Dynamic Chart.mp4 (65.91 MB)
MP4
3  Speedometer Chart.mp4 (67.53 MB)
MP4
1  Create Dynamic Sales Report.mp4 (510.15 MB)
MP4
2  Create Performance Report.mp4 (465.73 MB)
MP4
1  Create a Dashboard on Orders Data.mp4 (567.43 MB)
MP4
1  Introduction of Excel Macro.mp4 (117.83 MB)
MP4
2  Cell Object.mp4 (114.14 MB)
MP4
3  Range Object.mp4 (337.23 MB)
MP4
4  Worksheet Object.mp4 (186.44 MB)
MP4
5  Workbook Object.mp4 (165.95 MB)
MP4
1  Advanced Macro Development with Multiple Live Scenario.mp4 (2.45 GB)
MP4
1  Import Data from Access Database.mp4 (211.99 MB)
MP4
2  Export Data in Access Database.mp4 (117.12 MB)
MP4
3  Import Data from SQL Database.mp4 (137.92 MB)
MP4
4  Export Data in SQL Database.mp4 (249.13 MB)
MP4
1  Connect and Open Power Point.mp4 (91.78 MB)
MP4
2  Export Data into Power Point Using VBA.mp4 (50.41 MB)
MP4
3  Create Chart and Export in Power Point Slide.mp4 (122.53 MB)
MP4
1  Scrap Data from Website.mp4 (143.12 MB)
MP4
1  Excel Cell Reference.mp4 (102.81 MB)
MP4
2  Excel Shortcuts.mp4 (132.25 MB)
MP4
3  Format Painter.mp4 (11.75 MB)
MP4
4  Advanced Paste Special.mp4 (97.07 MB)
MP4
1  Data Entry and Search Form Design.mp4 (1.35 GB)
MP4
1  Introduction of SQL Server.mp4 (19.63 MB)
MP4
2  SQL Server Interface.mp4 (45.5 MB)
MP4
3  Server and Database.mp4 (57.98 MB)
MP4
4  SQL Table, Record, Field.mp4 (56.24 MB)
MP4
1  Create Table.mp4 (30.41 MB)
MP4
2  Create Table without Create Statement.mp4 (82.57 MB)
MP4
3  Delete Table.mp4 (8.05 MB)
MP4
4  Alter Table.mp4 (64.06 MB)
MP4
1  Insert Data with Graphical User Interface.mp4 (52.56 MB)
MP4
2  Insert Data into Table.mp4 (83.32 MB)
MP4
3  Bulk Insert Data into Table.mp4 (79.46 MB)
MP4
4  Import Data into Table.mp4 (38.36 MB)
MP4
5  Export Data from Table.mp4 (30.19 MB)
MP4
1  Delete Data on Condition.mp4 (50.89 MB)
MP4
2  Delete Entire Data from Table.mp4 (100.11 MB)
MP4
1  Update Entire Field Data in Table.mp4 (63.61 MB)
MP4
2  Update Data on Condition.mp4 (50.94 MB)
MP4
1  View Data.mp4 (52.64 MB)
MP4
2  View Distinct Data.mp4 (40.77 MB)
MP4
3  View Filtered Data.mp4 (32.29 MB)
MP4
1  View Filtered Data with AND Operator.mp4 (59.8 MB)
MP4
2  View Filtered Data with OR Operator.mp4 (64.01 MB)
MP4
3  View Filtered Data with IN Operator.mp4 (78.19 MB)
MP4
4  View Filtered Data with BETWEEN Operator.mp4 (85.88 MB)
MP4
5  View Filtered Data with LIKE Operator.mp4 (117.07 MB)
MP4
6  View Top and Bottom Records with TOP Clause.mp4 (73.51 MB)
MP4
1  Sort Data in Ascending or Descending Orders.mp4 (62.1 MB)
MP4
2  Sort Data In Ascending Orders.mp4 (36.84 MB)
MP4
3  Sort Data in Descending Orders.mp4 (35.27 MB)
MP4
1  Extract Distinct Data.mp4 (21.28 MB)
MP4
2  Aggregate Data with Group By.mp4 (40.77 MB)
MP4
3  Apply Condition with Having Clause.mp4 (121.59 MB)
MP4
1  VLOOKUP Overview.mp4 (132.17 MB)
MP4
10  Extract Data for Single Column Using INDEX and Single MATCH.mp4 (54.46 MB)
MP4
11  Extract Data for Multiple Columns Using INDEX and Multiple MATCH.mp4 (84.66 MB)
MP4
12  Extensive Use of INDEX Function with Various Functions.mp4 (97.34 MB)
MP4
2  Extract Product Name of Highest Shipping Cost and Highest Loss with VLOOKUP.mp4 (145.3 MB)
MP4
3  Basic of MATCH Function.mp4 (82.27 MB)
MP4
4  Extract Multiple Columns Data Using VLOOKUP and MATCH.mp4 (285.28 MB)
MP4
5  Extract Data from Multiple Datasets Using VLOOKUP.mp4 (393.58 MB)
MP4
6  HLOOKUP Overview.mp4 (55.75 MB)
MP4
7  Extract Data from Multiple Rows and Columns Using HLOOKUP and MATCH.mp4 (56.48 MB)
MP4
8  Extract Data from Various Datasets Using HLOOKUP and MATCH.mp4 (49.09 MB)
MP4
9  INDEX Overview.mp4 (35.98 MB)
MP4
1  Extract Data of Max Value.mp4 (35.39 MB)
MP4
2  Extract Data of Min Value.mp4 (16.23 MB)
MP4
3  Extract Data more than Average Value.mp4 (12.72 MB)
MP4
4  Extract 3rd Highest Sales.mp4 (51.22 MB)
MP4
1  Introduction of Join.mp4 (11.79 MB)
MP4
2  Inner Join.mp4 (61.65 MB)
MP4
3  Left Join.mp4 (43.69 MB)
MP4
4  Right Join.mp4 (41.42 MB)
MP4
5  Full Join.mp4 (30.68 MB)
MP4
6  Cross Join.mp4 (32.02 MB)
MP4
7  Self Join.mp4 (124.35 MB)
MP4
1  Union.mp4 (54.7 MB)
MP4
2  Union ALL.mp4 (31.08 MB)
MP4
3  Intersect.mp4 (26.57 MB)
MP4
4  Except.mp4 (23.07 MB)
MP4
1  Create a Conditional Field.mp4 (125.16 MB)
MP4
1  Row Number.mp4 (45.73 MB)
MP4
2  Rank Function.mp4 (65.51 MB)
MP4
3  Dense Rank Function.mp4 (81.45 MB)
MP4
4  Extract Product Name of 3rd Largest Sales.mp4 (51.18 MB)
MP4
5  Extract Each Category 2Max Value Data.mp4 (74.69 MB)
MP4
1  Introduction of Power BI.mp4 (231.33 MB)
MP4
1  Introduction and Importance of Data Cleaning and Transformation.mp4 (17.15 MB)
MP4
10  Dynamic SUBSTITUTE Function with Live Scenario.mp4 (54.5 MB)
MP4
11  Replace Existing Text with New Text Using REPLACE Function.mp4 (59.63 MB)
MP4
12  Extract Invoice Number From Data Using REPLACE.mp4 (89.33 MB)
MP4
13  Extract Last Word From Data.mp4 (53.06 MB)
MP4
2  Number of Character Count in any Text with LEN Function.mp4 (20.78 MB)
MP4
3  Find Position of Character with Find and Search Functions.mp4 (26.65 MB)
MP4
4  Extract Data From Left Side Using LEFT.mp4 (63.46 MB)
MP4
5  Extract Data From Right Side Using RIGHT.mp4 (32.35 MB)
MP4
6  Extract Middle Value From Data Using MID.mp4 (109.46 MB)
MP4
7  Replace Single Character Using SUBSTITUTE Function.mp4 (31.27 MB)
MP4
8  Replace Complete Word Using SUBSTITUTE Function.mp4 (57.22 MB)
MP4
9  Specific Character Count Using SUBSTITUTE.mp4 (42.94 MB)
MP4
1  Basic of OFFSET Function.mp4 (53.77 MB)
MP4
2  Make a Dynamic Range with OFFSET Function.mp4 (136.19 MB)
MP4
3  Create a Dynamic Chart with OFFSET Function.mp4 (92.25 MB)
MP4
4  Use of Dynamic Range in Any Function.mp4 (85.57 MB)
MP4
5  Create a Dynamic Pivot Table.mp4 (127.4 MB)
MP4
1  Basic of SUMPRODUCT Function.mp4 (26.61 MB)
MP4
2  Count Data on Single Condition Using COUNTIF and SUMPRODUCT.mp4 (214.27 MB)
MP4
3  Count Data on Multiple Conditions Using COUNTIFS and SUMPRODUCT.mp4 (436.14 MB)
MP4
4  Aggregate Data on Single Condition Using SUMIF and SUMPRODUCT.mp4 (107.62 MB)
MP4
5  Aggregate Data on Multiple Conditions Using SUMIFS and SUMPRODUCT.mp4 (329.86 MB)
MP4
6  Average on Single and Multiple Conditions with AVERAGEIF and AVERAGEIFS.mp4 (148.65 MB)
MP4
7  Advance use of Countifs, Averageifs and Sumifs with IF Functions.mp4 (108.65 MB)
MP4
8  Advance Use of SUMPRODUCT Function.mp4 (81.85 MB)
MP4
1  Basics of Date Functions.mp4 (72.15 MB)
MP4
2  Advance Date Function to Calculate Difference in Days.mp4 (200.69 MB)
MP4
3  Calculate Age and Birthday.mp4 (66.38 MB)
MP4
4  Date Functions with Live Scenario.mp4 (155.45 MB)
MP4
5  Calculate Aging of Invoice Payment.mp4 (127.11 MB)
MP4
1  Returns Grade and Tax Using IF.mp4 (98.59 MB)
MP4
2  AND to Check Conditions.mp4 (33.16 MB)
MP4
3  OR to Check Conditions.mp4 (104.98 MB)
MP4
4  NOT to Reverse Condition.mp4 (38.36 MB)
MP4
1  Introduction to Conditional Formatting.mp4 (54.73 MB)
MP4
2  Highlight Number on Condition.mp4 (118.25 MB)
MP4
3  Highlight Text on Condition.mp4 (43.29 MB)
MP4
4  Highlight TopN Values.mp4 (73.2 MB)
MP4
5  Highlight with Data Bars, Color Scale, Icon Set.mp4 (65.03 MB)
MP4
6  Highlight Duplicates with Single or Multiple Conditions.mp4 (132.03 MB)
MP4
7  Highlight values on Drop Downlist.mp4 (62.46 MB)
MP4
8  Highlight Specific Date, Month, Year.mp4 (73.45 MB)
MP4
9  Highlight Minimum and Maximum Value.mp4 (35.66 MB)
MP4

 https://rapidgator.net/file/b742a9b4d0d3a53c8491f55e7f9c74a3/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z01
https://rapidgator.net/file/9a29938b18b8151c7d401d7a94f24596/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z02
https://rapidgator.net/file/eff149a971ad44914bd87c60015681fc/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z03
https://rapidgator.net/file/059eadadfac227fed92d17927c2df9b2/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z04
https://rapidgator.net/file/ce277bb62075dbbce964ebe5a5e11b18/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z05
https://rapidgator.net/file/35634098e9fcb0e873191edf033bff4d/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z06
https://rapidgator.net/file/9a25289a8248eba12637fedad5226f26/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z07
https://rapidgator.net/file/3c155389f2ab571c85f8339ce49da212/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z08
https://rapidgator.net/file/f9d9122e531c0396baaea1e97dc7a089/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z09
https://rapidgator.net/file/caf939c7339affe507f2f9b17940fa32/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z10
https://rapidgator.net/file/ca57feac4bf378fa102fe3efac13b6db/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z11
https://rapidgator.net/file/a75c871c3aa73909130dc8030ef62c15/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z12
https://rapidgator.net/file/ef3f69e6d96a0d5ca5ab33e7bed54016/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z13
https://rapidgator.net/file/86006a6fa54071933158baa293e2dbac/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z14
https://rapidgator.net/file/bba1f3f994bd228095e77e94b0a8e0d8/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z15
https://rapidgator.net/file/9505554719006acc20c258ca0266ddf6/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z16
https://rapidgator.net/file/38807dcc007f419b29ede41ce20cf3fe/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z17
https://rapidgator.net/file/f79373f84984970fa349a839977a5905/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.z18
https://rapidgator.net/file/8a9215ced4a2f9c78c171e9b4fffbf00/Reporting_and_Analytics_With_Excel__Excel_Macro_SQL_Power_BI.zip

 https://nitroflare.com/view/C4BD47ABED1B8A4/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z01
https://nitroflare.com/view/E4DF832444663B4/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z02
https://nitroflare.com/view/657AFCFD551BAD4/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z03
https://nitroflare.com/view/C2500EC3E8D9FC2/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z04
https://nitroflare.com/view/E417AD9E5892361/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z05
https://nitroflare.com/view/DDCF8F726B6DF73/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z06
https://nitroflare.com/view/6E03F6F65462A6E/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z07
https://nitroflare.com/view/43D529FEC978AE4/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z08
https://nitroflare.com/view/56682860A6EE07A/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z09
https://nitroflare.com/view/33FC1B0A9598DC4/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z10
https://nitroflare.com/view/CD64FC796A34D6B/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z11
https://nitroflare.com/view/8D0051A42C7A9E1/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z12
https://nitroflare.com/view/29E6C24F1FAD315/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z13
https://nitroflare.com/view/CBFA1B36D132995/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z14
https://nitroflare.com/view/5151AC2CF1ADDD9/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z15
https://nitroflare.com/view/B5E79F9A9497CE5/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z16
https://nitroflare.com/view/A8EC7BFFA944090/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z17
https://nitroflare.com/view/2E6D9A4B9FA0316/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.z18
https://nitroflare.com/view/62ECC327EE8AFD1/Reporting_and_Analytics_With_Excel%2B_Excel_Macro%2BSQL%2BPower_BI.zip