Excel Is Fun

Highline Excel 2016 Class 20

DESCRIPTION In this video learn about: (00:15) Overview: Clean & Transform & Import Multiple Excel Files with 1 Sheet Each & Create PivotTable Report (03:00) Step 1: Import Multiple Excel Files, 1 Sheet Each, including [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 1394

DESCRIPTION See how to use formulas to calculate “PivotTable Show Values As: Calculations: (00:14) Introduction to unusual formulas for standard PivotTable Show Values As Calculations (01:29) Total Revenue Formula for either Product or Manufacturer in [Read More >>>]

Excel Is Fun

Excel Magic Trick 1393

DESCRIPTION See how to use the Show Values As Calculation in a PivotTable: (00:14) Introduction (00:46) Build Pivot Table for Total Revenue for Manufacturer and Product (02:13) Explain Parent Child Relationship (03:22) % Column Total [Read More >>>]

Excel Is Fun

Excel Magic Trick 1392

DESCRIPTION See how to perform Case Sensitive Unique Count with Power Query: (00:15) Introduction and examples of Remove Duplicates ans Data Model PivotTable Disnict Count Function will not perform Case Sensitive Unique Count. (01:34) Case [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 15

DESCRIPTION In this video learn about: (00:28) Define Charts. What do Charts do? (01:12) Effective Charts: No Chart Junk. Example of Chart Junk. (02:54) Types of Charts: 11 different chart types. (06:55) Terminology for Chart [Read More >>>]

Excel Is Fun

Excel Magic Trick 1380

DESCRIPTION See how to extract the incomplete student assignments from a cross tabulated table using Power Query (Get & Transform), a PivotTable and Slicers. WORKBOOKS

Excel Is Fun

Highline Excel 2016 Class 09

DESCRIPTION In this video learn about: (00:12) Introduction (00:22) Reminder of Date Math and Serial Number Dates and Number Formatting (02:14) TODAY and NOW functions to show the current date and time (03:13) EOMONTH function [Read More >>>]