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

Learn how to combine data from separate sources to create a simple "flat table" (i.e., flat file) when you don't need the complexity of a proper data model. Also, see 14 Pivot Table styling tips for turning "ugly" Pivot Tables into eye-catching, easier-to-read Pivot Tables. File Download Link: https://www.bcti.com//wp-content/YT_D... Power Query - Rounds Differently than Excel (video link)    • Power Query - Rounds Differently than Exce...   Microsoft Excel - Hide Pivot Table Filters Without Hiding Headings (video link)    • Microsoft Excel - Hide Pivot Table Filters...   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