Excel Is Fun

Highline Excel 2016 Class 14

DESCRIPTION In this video learn about how to create a Regional Sales Report with: (00:13) Discussion about VLOOKUP or PowerPivot Data Model Relationships. (01:57) Copy Sheets with Keyboard and Mouse. (02:43) VLOOKUP Example to create [Read More >>>]

Excel Is Fun

Excel Magic Trick 1363

DESCRIPTION See how to use images in Power View Report: 1. Create Column with web address to pictures using a Text Formula 2. Add Table to Power Pivot Data Model: From Power Pivot Ribbon Tab, [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 >>>]

GETTING STARTED IN EXCEL

Excel 2013 Layout

For those of you who have worked with Microsoft Excel 2003, the first thing you will notice when using Microsoft Excel 2013 is that Microsoft has changed the standard toolbar into a ribbon interface. You [Read More >>>]

Excel Is Fun

Excel 2013 Power Query 13

DESCRIPTION See how to improve spreadsheet performance (calculation speed) by replace a workbook with array formulas to do 3 way lookup for big data by using Power Query and PowerPivot: 1. Using Power Query import [Read More >>>]

Excel Is Fun

Excel 2013 Power Query 05

DESCRIPTION See how to Create Dimension Table From Fact Table for PowerPivot During CSV File Import: (00:08) Problem Setup (01:33) Create Dimension Table or Lookup Table from File Name in Fact Table. Use Power Query [Read More >>>]

Excel Is Fun

Excel 2013 Power Query 01

DESCRIPTION See how to import three tables from three different source files (Access database, Excel File, Text File) and merge them into one table using Power Query. Merge tables into the PowerPivot Data Model or [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 13

DESCRIPTION See how to improve spreadsheet performance (calculation speed) by replace a workbook with array formulas to do 3 way lookup for big data by using PowerQuery and PowerPivot: 1. Using PowerQuery import three data [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 12

DESCRIPTION See how to create Student GPA Grade by Class for each High School, with each report on a new sheet, automatically using a PivotTable and Show Report Filter Pages. This feature is NOT available [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 11

DESCRIPTION See how to: (00:47) Group By Date: Excel PivotTable: 1) Drag Date to Rows, Right-click Group, Years and Months (02:04) Group By Date: PowerPivot PivotTable: (02:07) Add Revenue Table to PowerPivot Data Model (02:46) [Read More >>>]