Excel Magic Trick 1489

DESCRIPTION In this video learn how to create a single Excel formula that will lookup a product price and lookup the volume / quantity discount and deliver the correct discounted Product Price. See how to [Read More >>>]

Excel Magic Trick 1462

DESCRIPTION Learn about how to create a single cell Array Formula to calculate Total Sales from a Column of Units Sold and a column of Prices (5,000 transactions). See how to use SUMPRODUCT function to [Read More >>>]

Office 2016 28

DESCRIPTION Topics in this video: (00:01) Introduction (01:24) Example 1: Mixed Cell References in Multiplication Table (04:24) Song and Excel Example in High Speed (05:20) How Cell References Move Throughout Copy Action (07:06) Two Questions [Read More >>>]

Office 2016 24

DESCRIPTION Topics in this video: (00:01) Introduction (00:30) Different Types of Formulas (02:07) Formula Elements – what you can out into a formula. (04:55) Formula 01: Goal: Add calls made a service centre last week.: [Read More >>>]

Office 2016 21

DESCRIPTION Topics in this video: (00:01) Introduction (02:10) What does Number Formatting do? (03:20) Formulas do NOT see Number Formatting (04:20) Number Formatting can save a lot of time for Data Entry (07:03) Compare General, [Read More >>>]

Excel Magic Trick 1432

DESCRIPTION See how to create nine DAX Formulas that build a Confidence Interval: (00:13) Introduction to the Confidence Interval example, reference video about Statistics, and introduction to Data Model used in this video (03:34) Formula [Read More >>>]

Highline Excel 2016 Class 25

DESCRIPTION In this video learn about: (00:09) ROUND function so Invoices and Payroll spreadsheets are accurate (03:49) ROUND to the penny, dollar or thousands position (04:28) ROUND, ROUNDUP, ROUNDDOWN functions round to a digit or [Read More >>>]

Highline Excel 2016 Class 22

DESCRIPTION In this video learn about: (00:16) Introduction to Entire Project, including what type of start files we have and what the final report looks like. (03:36) What is Data Modelling? Steps to creating a [Read More >>>]

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

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