Pivot Table Training Giveaway Winners

Thanks to everyone who entered the Pivot Table Training giveaway, for a chance to win an amazing online course from John Michaloudis, at My Excel Online Training.

You shared your biggest pivot table fears, and you can see the voting result below. In the upcoming weeks, I’ll cover some of these topics, and all of them are covered in comprehensive John’s online pivot table course.

The winners are listed below, and each person has been sent an email, with instructions for claiming their prize. Winners will have 24 hours to respond, by adding a comment in this blog post, and if they don’t claim the prize, another random name will be selected.

Xtreme Pivot Table Discount

There is good news, even if you didn’t win – John will give you a 25% discount on his Xtreme Pivot Tables course, if you use the coupon code CONTEXTURES, until Friday, November 21, 2014.

The Giveaway Winners – Online Course

John had a random draw, from all the valid entries, and congratulations to the following 3 people, who each win one of the Xtreme Pivot Table Courses ($199 value). Please reply in the comments below, to confirm that you’re a winner, and John will be in touch.

  1. lloyd dsouza (confirmed)
  2. dgrous06 (confirmed)
  3. UPDATED Nov. 13, 2014 11:15 AM — shabbahm (confirmed)

The Giveaway Runners-Up – Contextures Product

John had another random draw, from all the valid entries, and congratulations to the following 2 people, who each win any one of my Contextures products, such as my PivotPower Premium add-in. (up to $30 value). Please reply in the comments below, and let me know which product you would like

  1. UPDATED Nov. 13, 2014 11:15 AM — fbanabi (confirmed)
  2. julia gibson (confirmed)

Pivot Table Fears Voting Results

Here are the voting results, from all the valid entries. Of course, I summarized the votes into a pivot table, and you can see the top responses in the pivot chart below.

Surprisingly, the top response was, “Everything scares me!”, with almost twice as many votes as the next response (“How do you insert a Calculated Field?”).

I’ll be covering these topics in upcoming weeks, to help you get over some of those pivot table fears.

xtremeptresults01

Pivot Table Intro

In the meantime, here is John’s video that shows how to insert a pivot table – it’s from one of the first lessons in the Xtreme Pivot Tables course.

And remember, you can get a 25% discount on John’s My Excel Online Training course, if you use the coupon code CONTEXTURES, until Friday, November 21, 2014.

__________________

___________________________

This entry was posted in Excel Pivot Table. Bookmark the permalink.

14 Responses to Pivot Table Training Giveaway Winners

  1. Dave Rousseau says:

    It appears my user name is listed as one of the three winners of the Pivot Table Training Giveaway. Usually don’t win anything, so a little stocked if it is so. Just wanting to confirm if I was lucky this time around. Thanks very much.

  2. Lloyd D'Souza says:

    Thank you very much for selecting me as a winner for the Xtreme Pivot Table Course!
    I use excel on a daily basis as a Business Analyst and participation in this course will be invaluable to me. I am looking forward to this.

  3. julia gibson says:

    thanks, I never win either and am not sure what I won 🙂

  4. Leslie says:

    hope I win!!! need to add power to my pivot tables

  5. Farzaneh says:

    Do you know Debra, I can’t believe if I have won anything after loosing everything in my life!
    After loosing both my mobility and self-assurance due to MS, surely and highly I gratitude Scary Pivot Tables Giveaway gift.
    I use it as the most efficient anti-depressant pill ever prescribed or taken by me.
    What can I say more than “Thank You Debra”

  6. Shab says:

    I just open my mail and found out I have been selected. Can’t believe it, I have won something.

    I use excel everyday in my job to evaluate staff performance. Currently there are big changes happening in our organisation and I have been asked to produce a lots of analysis. Very excited! I am sure this course will take my Pivot table knowledge to next level.

  7. matt roeming says:

    sure hope to win

  8. Jan Halliday says:

    You are fabulous – Creating “hyperlinks” in Pivot tables was refreshingly brilliant! Thank you ever-so-much!

    I’ve got it working perfectly but was attempting to make it ACT that way on 2 fields, but can’t seem to modify the code precisely enough – thoughts?

    Option Explicit

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim selPF As PivotField
    Dim strField As String

    strField = “LDBContractIDlink”
    strField = “SFDCContractIDlink”

    On Error Resume Next
    Set selPF = Target.PivotField
    If Not selPF Is Nothing Then
    If selPF.Name = strField Then
    ThisWorkbook.FollowHyperlink _
    Address:=Target.Value, NewWindow:=True
    End If
    End If

Leave a Reply

Your email address will not be published. Required fields are marked *