herwigs's channel

Always love this time of year - when Microsoft is hosting the MVP Summit - because it means that Bill "MrExcel" Jelen gets to go out to Seattle, Wa...

See how to calculate columns in the PowerPivot grid using DAX.

This video is designed to accompany the book, PowerPivot for the Data Analyst: Micr...

If you have data in Excel and want to get that data into PowerPivot, you could copy and paste, or you can use the method in this video; declare the...

In Chapter 2 of PowerPivot for the Excel Data Analyst, you will see how to import a 1.8 million row text file into the PowerPivot window.

This vid...

Rather than turn off the evil GetPivotData like we did yesterday, how about trying to understand what GetPivotData actually does? Episode 1127 show...

FULL TUTORIAL OF MS EXCEL 2010 BY LYNDA.COM

Neville from Germany sends in a good suggestion for overcoming pivot formatting problems from Episode 865. By using conditional formatting on the u...

Match two worksheets using a pivot table. We continue on this week with Jim's question about matching two worksheets with a common column. Rather t...

How to create calculated items in Pivot tables in Excel 2007 and Excel 2010

Calculate items allow to make new categories from existing ones. Effec...

Prompted by a question in the PowerDirector Forum here http://forum.cyberlink.com/...

A how-to tutorial about controlling r...

Download this song on iTunes: http://itunes.apple.com/us/...

Your Love by Nicki Minaj. Inspired by a...

Download this song on iTunes: http://itunes.apple.com/us/...

Musical inspiration from "A Milli" - "Loll...

Here's the official debut... It's called "The Answer" and was recorded and mixed this past week (April 25-29, 2011). Music & Lyrics by Rob Gonzalez...

Litla stelpan okkar að hjóla

Litli karlinn að koma sér fyrir