Average Last 3 Customer Sales: Power Query, DAX Measure or Worksheet Formula: Excel Magic Trick 1552

About this tutorial: Video duration: 22:45 Download Excel Finished Files: Entire page with all Excel Files for All Videos: In this video learn how to Average a customers last three sales (last three dates) using Excel Worksheet Formulas, Power Query M Code and a Power Pivot & Power BI DAX Measure. Learn about the Table.Sort […]

Introduction to Excel PowerPivot

What is Excel PowerPivot? It’s a free add-on in Excel 2010 designed by Microsoft that’s still useful in 2015. It adds a lot of power to Excel by extending the capabilities of PivotTable and data summarization. Having the ability to import data from multiple sources has never been easier. Designed to add and integrate large […]

Usar Power Pivot en Excel para hacer una Tabla dinámica con información de Microsoft Access

About this tutorial: Video duration: 11:43 #Excel, #PowerPivot, #EXCELeINFO ✅ Descarga el archivo de ejemplo | ? Suscríbete a este canal | El tema de Inteligencia de negocios nos está abordando por todos lados, y Microsoft Excel ya está listo para la batalla. En este tutorial seguiremos probando la maravillosa herramienta Power Pivot. Nos conectaremos […]

Excel Magic Trick 1336: Power Query: Import Big Data Text Files: Connection Only or Data Model?

About this tutorial: Video duration: 11:35 Download File: See how to use Import 10 Text Files and Append (combine) then into a single Proper Data Set before making a PivotTable Report. Compare and Contrast whether we should use Connection Only or Data Model to store the data. 1. (00:18) Introduction & Look at Text Files […]

How to Create an Excel Dashboard Using Slicers and Timeline

About this tutorial: Video duration: 5:26 $10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: ************************************************************** How to Create an Excel Dashboard Using Slicers and Timeline Website: Udemy page: Facebook: Twitter: Linkedin: gr.linkedin.com/in/andreasexadaktylos Youtube channel: ****************************************************************** Amazing discount for my…

An Introduction of Microsoft Excel 2016 Absolutely For Beginners in Hindi Language

About this tutorial: Video duration: 4:59 यह Microsoft Excel का परिचय है यह सिर्फ शुरुआत है यहां श्री बालाग कंप्यूटर में हम एक बुनियादी कंप्यूटर कोर्स शुरू करने जा रहे हैं जहां हम यह पढ़ाते हैं कि जो लोग कम्प्यूटर के बारे में नहीं जानते हैं हम उन्हें कम्प्यूटर के बुनियादी कार्यों…

www.officekurs.se – en oslagbar Excelutbildning

About this tutorial: Video duration: 1:3 Vill du ha en effektiv, prisvärd Excelutbildning som innehåller alla de viktiga beståndsdelarna i Excel och som du kan avnjuta precis NÄR du själv vill, VAR du själv vill och på VILKEN plattform du själv vill? Då ska du välja www.officekurs.se.

Power Pivot: obsługa dużych zestawów danych w Excel 2010/2013 (tutorial)

About this tutorial: Video duration: 55:1 Tutorial przedstawiający działanie funkcji PowerPivot w MS Excel 2010 i 2013. Szkolenie prowadzi Piotr Piątek, trener rozwiązań BI, Altkom Akademia. • Wymagania sprzętowe i programowe • Przygotowanie środowiska • Import i łączenie danych • Tworzenie relacji • Tworzenie tabel i wykresów przestawnych • Fragmentatory • Hierarchie Sprawdź szkolenia z […]

Excel 2016 Dashboard Linking with Power Query – Pivot Table Dashboard Part 1

About this tutorial: Video duration: 4:49 Full 2.5hr Course with downloadable files In this video we will setup the first pivot table for our dashboard by connecting to our data via power query / get and transform. This will enable us to easily refresh all of our work with a click of a refresh button. […]

Excel 2016 Dashboard Multi Charts and Number Ranges – Pivot Table Dashboard Part 3

About this tutorial: Video duration: 5:52 In this Microsoft Excel tutorial I’m going to show you how to setup this chart from a pivot table that groups employees into pay range buckets. We will combine multiple chart types, and apply linear and moving average trend lines. In the previous video we looked at how to […]

Excel 2016 Dashboard Custom Grouping and Doughnut Charts – Pivot Table Dashboard Part 2

About this tutorial: Video duration: 7:24 In this video I’m going to show you how to setup this doughnut chart from a custom grouped pivot table. From here we can see the relative proportions of employee headcount vs pay, per department grouping. In the previous video we pulled in our data via power query also […]

Learn Excel with MrExcel – “Chandoo Explains Structured Table Reference”: Podcast #1708

About this tutorial: Video duration: 5:52 On Friday May 10, 2013, Chandoo ( and Rob Collie ( – PowerPivotPro – stopped by MrExcel’s place for an evening of Microsoft Excel. So, what is on the agenda For Today’s Podcast? Chandoo doing his First Guest Appearance on the Learn Excel Podcast and his topic: “The Benefits […]

Publish Power BI Report to Power Point

About this tutorial: Video duration: 1:41 How to publish Power BI report to Power Point quickly and efficiently. Created by Excelando. Excelando is a privately-held smart data analysis company specializing in business intelligence, data analytics and data modelling. By utilizing Power BI and Azure data platforms and applying effective cutting-edge technologies, we help organizations understand […]

Power Map for Excel / Office 365 / Power BI

About this tutorial: Video duration: 13:39 http://blogs.msdn.com/b/ajmee Here’s a quick video of some of the changes with the latest version of the Power Map add-in (September 2013). I’m using some US Census data and including both Power Query and Power Pivot into the mix.

Excel PowerPivot Tutorial Dashboards with Power Query, Power View and Power Map BI

About this tutorial: Video duration: 14:16 Learn to extract data with Power Query in Excel 2013. Then create visualizations from your data with Power Map, Power Pivot, and Power View. This video will teach you the end-to-end process of building a business intelligence dashboard with Power BI.

Excel 2013 PowerPivot Basics #11: Group By Date: Excel PivotTable vs. PowerPivot PivotTable

About this tutorial: Video duration: 10:52 Download file: http://people.highline.edu/mgirvin/excelisfun.htm Scroll to down to PowerPivot Section. See how to: 1. (00:47 minute mark) Group By Date: Excel PivotTable: 1) Drag Date to Rows, Right-click Group, Years and Months 2. (02:04 minute mark) Group By Date: PowerPivot PivotTable: 3. (02:07 minute mark) Add Revenue Table to PowerPivot […]

Roundup #34 (Compression, RLS and updates)

About this tutorial: Video duration: 4: Adam Saxton is a Microsoft Employee working with Business Intelligence products. We start with a new content pack for Power BI for Insightly CRM. We got a new preview of the Mobile Report Publisher for Reporting Services. Matt Allington talks about a compression tip for Power Pivot. Patrick LeBlanc […]

Excel 2013 Power Query #01: Merge 3 Tables Into One in PowerPivot or Excel Table

About this tutorial: Video duration: 5:31 Download file: http://people.highline.edu/mgirvin/excelisfun.htm Scroll to down to PowerPivot Section. 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 an Excel Table 1. (01:38 minute […]

Excel 2013 Power Query #01: Merge 3 Tables Into One in PowerPivot or Excel Table

About this tutorial: Video duration: 5:31 Download file: http://people.highline.edu/mgirvin/excelisfun.htm Scroll to down to PowerPivot Section. 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 an Excel Table 1. (01:38 minute […]

Excel 2013 PowerPivot Basics #01: Introduction To PowerPivot for Excel 2013

About this tutorial: Video duration: 38:33 Download file: http://people.highline.edu/mgirvin/excelisfun.htm Scroll to down to PowerPivot Section. Basics of PowerPivot: Why PowerPivot?, Add to Data Model, Relationships, Calculated Column, Calculated Field, Build report with PivotTable based on Data Model: 1. (00:22 min mark) Smartest People with PowerPivot 2. (01:31 min mark) Which Versions of Excel 2013 contain […]