Power Query - Creating a Flat File (plus, 14 Pivot Table Styling Tips)

01:10 File download instructions
01:42 Obtaining data from a SQL server
02:58 Database authentication options
03:33 Previewing and selecting database tables
04:05 Selecting only needed fields (i.e., columns)
05:23 Extracting data from a record
05:52 Extracting data from a table
06:28 Creating extended calculations
06:55 Code-level column rennames
07:43 Removing "new" unneeded columns
07:56 Finding and replacing nulls
08:42 Row reduction
09:49 Filtering out the "non-sale" rows
10:04 Setting data types and rounding values
10:41 Loading the results to Excel
10:51 Stylizing the "Sales" column
11:21 Creating the Pivot Table report
12:47 Pivot Table Styling Tips
13:12 Hiding Gridlines and Headings
13:25 Hiding "Expand/Collapse" buttons
13:39 Applying a Currency Style to the values
13:53 Displaying Subtotals at the bottom of their groups
14:14 Adding blank lines between groups
14:27 Customizing Indentations
15:26 Sorting columns
16:05 Sorting Rows (multi-level sorting)
17:06 Zero-fill the empty cells
17:33 Changing the color of zero-filled cells
19:00 Creating custom headings
19:52 Centering the headings
20:24 Hiding the Filter controls
21:38 Standardizing column widths
23:20 Conclusion
#PowerQuery #tutorial