Excel Is Fun

Excel Magic Trick 1498

DESCRIPTION In this video learn how to Transform Two Fact Tables (Header Invoice and Invoice Line Item Tables) with Dimension Tables into a Proper Star Schema using Power Query inside Power BI Desktop. The Power [Read More >>>]

Excel Is Fun

Power BI for Accountants

DESCRIPTION Topics in Video: 01. Download Files 02. Video Introduction and review of Topics covered in video 03. Introduction to Power BI Desktop 04. Overview of process of using Power BI Desktop to build our [Read More >>>]

Excel Is Fun

Excel Magic Trick 1456

DESCRIPTION In this video see how to create an 8 Year Span Monthly Revenue Report for a selected Product. WORKBOOKS

Excel Is Fun

Office 2016 32

DESCRIPTION Topics in this video: (00:01) Introduction (01:51) Review of PivotTables we have already completed in this class. (03:15) What is Data Analysis in one sentence (03:34) What’s is Proper Data Set in Excel? (03:50) [Read More >>>]

Excel Is Fun

Excel Magic Trick 1450

DESCRIPTION Learn how to use Relationships in Excel 2016 (or later versions) rather than the VLOOKUP Function when you are making PivotTable Reports from multiple tables. See how to create a Product / Region Yearly [Read More >>>]

Excel Is Fun

Office 2016 17

DESCRIPTION Topics in this video: (00:01) Introduction (01:46) Keyboard for PivotTable (04:00) Why a PivotTable is called a PivotTable (04:25) Cross Tabulated Report (Adding with 2 Criteria) (05:15) Calculations with Conditions or Criteria (07:40) Change [Read More >>>]

Excel Is Fun

Excel Magic Trick 1395

DESCRIPTION See how to simulate the Standard PivotTable Show Values As calculations of % of Grand Total, % of Column Total and % of Parent Total. See the DAX Functions: CALCULATE, ALL, ALLSELECTED, VALUES, DIVIDE, [Read More >>>]

Excel Is Fun

Excel Magic Trick 1387

DESCRIPTION See how to Create a Data Model with DAX Formula to build PivotTable Frequency Distribution with Conditional Formatting. Also learn how the Data Model and DAX Formulas work on Big Data: (00:13) Introduction (03:42) [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 17

DESCRIPTION In this video learn about how to build Excel Dashboard based on Data Model and see first DAX Measure (Formula): (00:22) Introduction (02:43) Power Query to Clean, Transform & Import Text Files (From Folder [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 03

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 >>>]