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 1366

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

Excel Is Fun

Excel Magic Trick 1333

DESCRIPTION Learn about Banker’s Rounding or Gaussian Rounding: (00:15) What is Banker’s Rounding? (02:30) Normal Excel ROUND Function (Arithmetic Rounding, NOT Banker’s Rounding) (03:18) Excel formula to do Banker’s Round using IF, MOD, MROUND and [Read More >>>]

Excel Is Fun

Excel Magic Trick 1269

DESCRIPTION Without Power Pivot: DAX Measures, Relationships & Data Model Using Excel 2016, learn how to access the Data Model, build Relationships between tables and create DAX Measures (Formulas in Pivot Tables) without having PowerPivot [Read More >>>]

Excel Is Fun

Excel Magic Trick 1249

DESCRIPTION Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail **Note; The word “Database” is used loosely in this video. We use it just to mean we have a dynamic table [Read More >>>]

Dueling Excel

Dueling Excel 110

3 VLOOKUPS Calculate Cost Based on Product, Packaging, Discount DESCRIPTION See Mr Excel and excelisfun use two methods to calculate the total costs when there are three factors that go into calculating costs: Product Name, [Read More >>>]

Dueling Excel

Dueling Excel 92

Round Invoice: ROUND or SUMPRODUCT – ROUND DESCRIPTION See Mr Excel and excelisfun use two methods to round the amounts on an Invoice so the SUM total is correct. WORKBOOKS

Dueling Excel

Dueling Excel 71

ROUND to 4 or 2 Formula or Conditional Formatting? DESCRIPTION See Mr Excel and excelisfun round numbers to 2 if the column says “DOLLAR” and 4 if the column says “CRUDE” using the functions ROUND, [Read More >>>]

Excel Is Fun

Excel Magic Trick 1145

Create Random Data Set with Formulas: 4 Unusual Formulas DESCRIPTION See how to: (00:08) Overview of Different data Types (01:02) FORMULA 1: Create Random Serial Number Dates with RANDBETWEEN and actual Serial Numbers (02:10) Keyboards [Read More >>>]