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

Excel Is Fun

Highline Excel 2016 Class 06

DESCRIPTION In this video learn about All the ways to make conditional Calculations with Formulas in Excel: Built-in Functions like SUMIFS, AND function, OR Function, IS Functions, Array Formulas, D Functions and more: (00:23) Introduction [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 >>>]

Excel Is Fun

Highline Excel 2016 Class 02

DESCRIPTION In this video learn about: (00:13) Introduction (01:09) Excel’s Golden Rule (04:31) Look at list of Formula Types and Formula Elements (06:29) Number Formula Examples (08:24) Text and Number Formulas for counting numbers above [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 01

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

Excel Is Fun

Excel Magic Trick 1350

DESCRIPTION Learn how to create formulas to make calculations in a Standard PivotTable. See how to Create a PivotTable Report with PivotTable Formulas for Year, Product & Region with Total Cost Of Goods Sold, Total [Read More >>>]

Excel Is Fun

Excel Magic Trick 1341

DESCRIPTION See how to use Power Query, a PivotTable and an Excel Formulas to calculate to calculating Average and Standard Deviation with Criteria: (00:14) Introduction & Setup (01:28) Array Formula for calculating Average and Standard [Read More >>>]

Excel Is Fun

Excel Magic Trick 1337

DESCRIPTION If you try to make X-Y Scatter Chart from PivotTable is will NOT work!!!!! See how to use Power Query to create the same output as a PivotTable in order to make an X-Y [Read More >>>]