DESCRIPTION See how to Get the Total for each employee when the Employee Name column has many empty cells and the “TOTAL” is in a row without an employee name. See five methods: (00:13) Introduction [Read More >>>]
DESCRIPTION In this video learn about the fundamentals of Data Analysis and Business Intelligence in Excel 2016: Sort, Filter, PivotTables, Power Query, Power Pivot Data Model: (00:00:05) Introduction (00:01:39) Sort (00:03:02) Sorting one column (00:03:23) [Read More >>>]
DESCRIPTION In this video learn about these Excel Fundamentals for Excel Highline Excel 2016 Class: (00:33) Prerequisites for class (01:04) Excel Professional 2016 (01:50) Install Com Add-in Power Pivot (02:54) Examples of Effective and Efficient [Read More >>>]
DESCRIPTION Full Lesson on Power BI Desktop to build Product Analysis for Gross Profit with Average, Standard Deviation, Coefficient of Variation and Histogram Calculations and Visualizations: (00:04) Files to download (00:12) Introduction (04:42) Import Related [Read More >>>]
DESCRIPTION See how to use Power BI Desktop to import, clean and transform Sales Tables from Multiple Excel Files and consolidate into a Single Proper Data Set that can be linked in a Relationship to [Read More >>>]
DESCRIPTION See an example of how to invoke Query Dependencies View in Power Query (Get & Transform) WORKBOOKS
DESCRIPTION Goal: Unpivot and Clean Cross Tabulated Tables in multiple Excel Workbook Files and Create a Single Proper Data Set. Create a Power Query Function to repeatedly perform the Clean & Transform Task across many [Read More >>>]
DESCRIPTION See how to lookup 3 Items & Return to Single Cell with a Cell Helper Column or Power Query: (00:15) Introduction (01:19) Cell Helper Column in Lookup Table solution. Trick thanks to Ian Putt [Read More >>>]
DESCRIPTION See how to use the Power Query (Get & Transform) Inner Join Merge Feature to Extract Records (Data) from an Excel Table based on Criteria from cells in an Excel sheet (Criteria in a [Read More >>>]
DESCRIPTION Using Power Query (Get & Transform), see how to Import & Merge Text & Excel Files, Clean Data, Add Helper Columns for Company Name and Revenue, and add a Total Row & Slicer for [Read More >>>]
Master Excel