Excel Is Fun

Office 2016 05

DESCRIPTION Topics in this video: (00:01) Introduction (03:21) Formatting Keyboards: (07:40) Insert Clip Art or Pictures (11:05) Highlighting and Fill to add background colour (14:39) Highlight to end of document = Ctrl + Shift + [Read More >>>]

Excel Is Fun

Office 2016 01

DESCRIPTION Topics in this video: (00:01) Introduction (00:28) Programs/Apps (application software) (02:32) Task Bar (02:56) Operating Systems (03:11) Start Button (05:23) USB Flash Drive (05:58) Introduction to Windows Explorer (09:34) Deleting a File or Folder [Read More >>>]

Excel Is Fun

Excel Magic Trick 1408

DESCRIPTION See how to create a DAX Measures for Moving 12 Month Average on Daily Sales: (00:15) Introduction and comparison to formulas created in Excel Magic Trick 1406. (01:07) Discussion of Filter Context and how [Read More >>>]

Excel Is Fun

Excel Magic Trick 1400

DESCRIPTION See how to Conditionally Format the row in an Enrollment Table when the following conditions are met: 1. Enrollment less than or equal to 15, then format row 2. Name Column can NOT contain: [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 19

DESCRIPTION In this video learn about: (00:14) Introduction to Advanced Filter (02:50) Extract Records based on AND Logical Test (AND Criteria). Comprehensive Example including Defined Names that are created and how to run the Advanced [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 16

DESCRIPTION In this video learn about Conditional Formatting Topics : (00:16) Introduction (00:43) Built-in Feature: Cell Contains (03:28) Logical Formula: Highlight Row (Record) where cell contains a value. (10:00) Built-in Feature: Below Average (10:55) Logical [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

Excel Magic Trick 1368

DESCRIPTION See how to use the SUMIFS and SUMPRODUCT functions to Calculate Sum Of Amazon And Google Under Each Region. Properly you will learn about OR Logical Tests and AND Logical Tests so that we [Read More >>>]