Lynda - Excel Business Intelligence Part 1 - Power Query

386.49 MB | 00:10:17 | mp4 | 1280X720 | 16:9
Genre:eLearning |Language:English

Files Included :
01 Welcome (16.27 MB)
02 Important - Versions and compatibility (11.4 MB)
03 Download the course exercise files (3.74 MB)
04 Set expectations (4.97 MB)
05 The power Excel workflow (10.02 MB)
06 The best thing to happen to Excel in 20 years (23.35 MB)
07 When to use Power Query and Power Pivot in Excel (2.34 MB)
08 Power Query introduction (2.54 MB)
09 Meet Power Query aka Get & Transform (7.27 MB)
10 The Query Editor (8.86 MB)
11 Options for loading data in Excel (4.34 MB)
12 Basic Power Query table transformations (24.95 MB)
13 Text-specific query editing tools (32.02 MB)
14 Number-specific query editing tools (23.2 MB)
15 Date-specific query editing tools (22.5 MB)
16 Create a rolling calendar with Power Query (13.71 MB)
17 Add index and conditional columns with Power Query (21.61 MB)
18 Group and aggregate data with Power Query (18.94 MB)
19 Modify Excel workbook queries (12.38 MB)
20 Merge queries (22.56 MB)
21 Append queries (16.84 MB)
22 Connect Excel to a folder of files (27.7 MB)
23 Excel Power Query best practices (7.5 MB)
24 Pivot and unpivot data with Power Query (23.73 MB)
25 Next steps (2.01 MB)
Ex Files Excel Business Intelligence Part 1 Power Query (21.55 MB)]
Screenshot

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm