Excel Is Fun

Highline Excel 2016 Class 26

DESCRIPTION In this video use Macro Recorder to record six Macros: (00:12) Basics for Recorded Macros (VBA) (05:55) Absolute Reference Macro: Format report that always has the same number of columns and rows. This Macro [Read More >>>]

Excel Is Fun

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

Excel Is Fun

Highline Excel 2016 Class 24

DESCRIPTION In this video learn about: (00:01) Introduction (02:22) PMT function from Borrower point of view, End Payment (07:10) PMT with Begin Payment (08:19) PMT function from Lender point of view (09:25) PMT function with [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 23

DESCRIPTION In this video learn about a free download called Power BI Desktop that is a single program that does all that Excel’s Power Query & Power Pivot can do, and more. Comprehensive example of [Read More >>>]

Excel Is Fun

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

Excel Is Fun

Highline Excel 2016 Class 21

DESCRIPTION In this video learn about how to import multiple Excel files using Power Query (Get & Transform): (00:15) Introduction (01:32) Files used for Import (02:46) Multiple Excel Workbooks with Multiple Sheets (03:50) Get “City” [Read More >>>]

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

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 18

DESCRIPTION In this video learn about: (00:13) Introduction (01:08) Find & Replace feature (Clean Data) (03:49) Flash Fill: Clean Data (10 Examples) (11:14) Text To Columns (TTC) (12:16) Text To Columns (TTC) to split data [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 >>>]