Excel Is Fun

Excel Magic Trick 1269

February 9, 2017 0

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

GETTING STARTED IN EXCEL

Excel 2013 Layout

July 23, 2016 0

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

Excel Is Fun

Excel 2013 Power Query 01

May 13, 2015 0

Merge 3 Tables Into One in PowerPivot or Excel Table 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 […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 13

April 13, 2015 0

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

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 12

April 12, 2015 0

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

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 11

April 11, 2015 0

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) […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 10

April 10, 2015 0

DESCRIPTION Topics in this video: (00:34) Essence of PivotTable (01:08) Overview of Filter Context and CALCULATE (02:30) Look at how Filter Context works on a Calculated Field (03:53) COUNTROWS function to see “Filtered Table” Example […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 09

April 9, 2015 0

DESCRIPTION See how to create 9 different DAX functions or Calculated Fields (00:08) Overview of Reports we need to create (01:05) Calculated Fields Overview (01:58) Calculated Column For Net Revenue using ROUND and RELATED function […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 08

April 8, 2015 0

DESCRIPTION See how to: (00:08) Overview (01:45) Update Calendar Table in Excel file when we anticipate new transactional data with new dates. (03:35) Update Existing Connections to Source Data Files when File Name or File […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 07

April 7, 2015 0

DESCRIPTION See how to: (00:17) Calendar Table in Diagram View with no Calculated Fields (00:58) Format Date Column (01:08) Create Calculated Column #01: Month Number using MONTH function. (01:53) Create Calculated Column #02: Month Name […]