Learn More

Free Tutorials

Explore my free Excel tutorials for easy tips on dashboards, charts, advanced formulas,
and quick productivity hacks.
This course has enabled me to finish jobs in
5-10% of the time due to my ability to process
Excel so far. It has also given me the confidence
Free Tutorials to better get around Excel.
- Mitchell Ryan

Courses Designed for Your Success

Discover the structured path to mastering Excel at your own pace with our bestselling
courses. Explore them now:
I'm using Excel often at work as a business architect. I was able to achieve
what I wanted a lot of the time but sometimes, I wasn't using the most
Get a Course efficient way. Hence, I subscribed to the Black Belt package. There were a lot
of AH-HA moments! I'm now able to use Power Query and build good
looking dashboards more easily but it's only the first course out of a series
I'm taking with you.
I'm very excited about it!
- Christian Fiset
(Excel Black Belt Bundle)
Raw Data for Pivot Table

Company Company Name Region Sales Document Document Date Customer Code
1010US Urban Right America 66030 6/1/2020 8010
1010US Urban Right America 66030 6/2/2020 8010
1010US Urban Right America 66032 6/1/2020 8010
1010US Urban Right America 66032 6/2/2020 8010
1010US Urban Right America 66031 6/1/2020 8020
1010US Urban Right America 66031 6/2/2020 8020
1010US Urban Right America 66031 6/7/2020 8020
1010US Urban Right America 68112 6/8/2020 8010
1010US Urban Right America 68112 6/9/2020 8010
1010US Urban Right America 68116 6/10/2020 8020
1010US Urban Right America 68116 6/11/2020 8020
1010US Urban Right America 68116 6/12/2020 8020
1010US Urban Right America 68116 6/13/2020 8010
1010US Urban Right America 68116 6/14/2020 8010
1010US Urban Right America 65662 6/15/2020 8020
1010US Urban Right America 65662 6/16/2020 8020
1010US Urban Right America 65666 6/2/2020 8010
1010US Urban Right America 65666 6/3/2020 8010
1010US Urban Right America 65666 6/4/2020 8010
1010US Urban Right America 65666 6/5/2020 8020
1010US Urban Right America 65666 6/6/2020 8020
1010US Urban Right America 66015 6/10/2020 8010
1010US Urban Right America 66015 6/11/2020 8010
1010US Urban Right America 66017 6/12/2020 8010
1010US Urban Right America 66017 6/13/2020 8010
1010US Urban Right America 66016 6/14/2020 8020
1010US Urban Right America 66016 6/15/2020 8020
1010US Urban Right America 66016 6/16/2020 8020
1010US Urban Right America 68097 6/17/2020 8010
1010US Urban Right America 68097 6/18/2020 8010
1010US Urban Right America 68099 6/19/2020 8020
1010US Urban Right America 68099 6/20/2020 8020
1010US Urban Right America 68099 6/21/2020 8020
1010US Urban Right America 68101 6/15/2020 8010
1010US Urban Right America 68101 6/16/2020 8010
1010US Urban Right America 65627 6/17/2020 8020
1010US Urban Right America 65627 6/18/2020 8020
1010US Urban Right America 65629 6/19/2020 8010
1010US Urban Right America 65629 6/20/2020 8010
1010US Urban Right America 65629 6/21/2020 8010
1010US Urban Right America 65631 6/22/2020 8020
1010US Urban Right America 65631 6/23/2020 8020
1020US Meta Creations America 24030 6/1/2020 8020
1020US Meta Creations America 24030 6/2/2020 8020
1020US Meta Creations America 24030 6/3/2020 8020
1020US Meta Creations America 24030 6/4/2020 8020
1020US Meta Creations America 24031 6/5/2020 8020
1020US Meta Creations America 24031 6/6/2020 8020
1020US Meta Creations America 24031 6/7/2020 8020
1020US Meta Creations America 28112 6/8/2020 8020
1020US Meta Creations America 28112 6/9/2020 8020
1020US Meta Creations America 28112 6/10/2020 8020
1020US Meta Creations America 28112 6/11/2020 8020
1020US Meta Creations America 28112 6/12/2020 8020
1020US Meta Creations America 28112 6/13/2020 8020
1020US Meta Creations America 28112 6/14/2020 8020
1020US Meta Creations America 25442 6/15/2020 8010
1020US Meta Creations America 25442 6/16/2020 8010
1020US Meta Creations America 25442 6/17/2020 8010
1020US Meta Creations America 25442 6/18/2020 8010
1020US Meta Creations America 25442 6/19/2020 8010
1020US Meta Creations America 25442 6/20/2020 8010
1020US Meta Creations America 25442 6/21/2020 8010
1040DE Lucas Basics Europe 44030 6/1/2020 8060
1040DE Lucas Basics Europe 44030 6/2/2020 8060
1040DE Lucas Basics Europe 44032 6/1/2020 8060
1040DE Lucas Basics Europe 44032 6/2/2020 8060
1040DE Lucas Basics Europe 44031 6/1/2020 8050
1040DE Lucas Basics Europe 44031 6/2/2020 8050
1040DE Lucas Basics Europe 44031 6/7/2020 8050
1040DE Lucas Basics Europe 48112 6/8/2020 8060
1040DE Lucas Basics Europe 48112 6/9/2020 8060
1040DE Lucas Basics Europe 48114 6/8/2020 8050
1040DE Lucas Basics Europe 48114 6/9/2020 8050
1040DE Lucas Basics Europe 48114 6/12/2020 8050
1040DE Lucas Basics Europe 48116 6/8/2020 8060
1040DE Lucas Basics Europe 48116 6/9/2020 8060
1040DE Lucas Basics Europe 45442 6/15/2020 8050
1040DE Lucas Basics Europe 45442 6/16/2020 8050
1040DE Lucas Basics Europe 45444 6/15/2020 8060
1040DE Lucas Basics Europe 45444 6/16/2020 8060
1040DE Lucas Basics Europe 45444 6/19/2020 8060
1040DE Lucas Basics Europe 45446 6/15/2020 8050
1040DE Lucas Basics Europe 45446 6/16/2020 8050
1040DE Lucas Basics Europe 44015 6/18/2020 8060
1040DE Lucas Basics Europe 44015 6/23/2020 8060
1040DE Lucas Basics Europe 44017 6/16/2020 8060
1040DE Lucas Basics Europe 44017 6/25/2020 8060
1040DE Lucas Basics Europe 44016 6/16/2020 8050
1040DE Lucas Basics Europe 44016 6/18/2020 8050
1040DE Lucas Basics Europe 44016 6/23/2020 8050
1040DE Lucas Basics Europe 48097 6/29/2020 8060
1040DE Lucas Basics Europe 48097 6/30/2020 8060
1040DE Lucas Basics Europe 48099 6/15/2020 8050
1040DE Lucas Basics Europe 48099 6/16/2020 8050
1040DE Lucas Basics Europe 48099 6/17/2020 8050
1040DE Lucas Basics Europe 48101 6/18/2020 8060
1040DE Lucas Basics Europe 48101 6/19/2020 8060
1040DE Lucas Basics Europe 45427 6/20/2020 8050
1040DE Lucas Basics Europe 45427 6/21/2020 8050
1040DE Lucas Basics Europe 45429 6/22/2020 8060
1040DE Lucas Basics Europe 45429 6/23/2020 8060
1040DE Lucas Basics Europe 45429 6/24/2020 8060
1040DE Lucas Basics Europe 45431 6/25/2020 8050
1040DE Lucas Basics Europe 45431 6/26/2020 8050
Customer Name Product Code Product Description Quantity Sales USD
Dellicia 103 Women type T simple white 120 1440
Dellicia 104 Women type T simple black 150 1800
Dellicia 103 Women type T simple white 170 2040
Dellicia 104 Women type T simple black 140 1680
Erma 103 Women type T simple white 140 1680
Erma 104 Women type T simple black 150 1800
Erma 105 Women crop top black 100 1000
Dellicia 104 Women type T simple black 180 2160
Dellicia 105 Women crop top black 120 1200
Erma 104 Women type T simple black 150 1800
Erma 105 Women crop top black 190 1900
Erma 107 Women basics 160 800
Dellicia 104 Women type T simple black 160 1920
Dellicia 105 Women crop top black 190 1900
Erma 103 Women type T simple white 120 1440
Erma 104 Women type T simple black 110 1320
Dellicia 103 Women type T simple white 120 1440
Dellicia 104 Women type T simple black 140 1680
Dellicia 105 Women crop top black 160 1600
Erma 107 Women basics 120 600
Erma 103 Women type T simple white 200 2400
Dellicia 103 Women type T simple white 140 1680
Dellicia 104 Women type T simple black 140 1680
Dellicia 103 Women type T simple white 140 1680
Dellicia 104 Women type T simple black 140 1680
Erma 103 Women type T simple white 120 1440
Erma 104 Women type T simple black 130 1560
Erma 105 Women crop top black 120 1200
Dellicia 104 Women type T simple black 140 1680
Dellicia 105 Women crop top black 130 1300
Erma 104 Women type T simple black 120 1440
Erma 105 Women crop top black 140 1400
Erma 107 Women basics 170 850
Dellicia 104 Women type T simple black 190 2280
Dellicia 105 Women crop top black 140 1400
Erma 103 Women type T simple white 140 1680
Erma 104 Women type T simple black 160 1920
Dellicia 103 Women type T simple white 190 2280
Dellicia 104 Women type T simple black 130 1560
Dellicia 105 Women crop top black 140 1400
Erma 107 Women basics 190 950
Erma 103 Women type T simple white 120 1440
Erma 101 Men type T simple white 130 1560
Erma 102 Men type T simple black 30 360
Erma 106 Men basics 60 300
Erma 108 Laptop bag black 80 2240
Erma 101 Men type T simple white 100 1200
Erma 108 Laptop bag black 20 560
Erma 113 Men dress shirt black 100 2500
Erma 114 Men dress shirt grey 50 1250
Erma 101 Men type T simple white 40 480
Erma 102 Men type T simple black 70 840
Erma 106 Men basics 70 350
Erma 108 Laptop bag black 10 280
Erma 117 Men shorts grey 80 1440
Erma 118 Men shorts black 70 1260
Dellicia 118 Men shorts black 70 1260
Dellicia 117 Men shorts grey 80 1440
Dellicia 118 Men shorts black 70 1260
Dellicia 116 Unisex tank top white 60 360
Dellicia 106 Men basics 20 100
Dellicia 101 Men type T simple white 40 480
Dellicia 102 Men type T simple black 10 120
Liebher 108 Laptop bag black 60 1970
Liebher 109 Laptop bag red 60 1970
Liebher 108 Laptop bag black 60 1970
Liebher 109 Laptop bag red 70 2300
Aida GmbH 108 Laptop bag black 60 1970
Aida GmbH 109 Laptop bag red 50 1640
Aida GmbH 110 Smartphone case diamond 60 4230
Liebher 109 Laptop bag red 60 1970
Liebher 110 Smartphone case diamond 50 3520
Aida GmbH 109 Laptop bag red 60 1970
Aida GmbH 110 Smartphone case diamond 60 4230
Aida GmbH 111 Smartphone case simple 80 1880
Liebher 109 Laptop bag red 60 1970
Liebher 110 Smartphone case diamond 60 4230
Aida GmbH 108 Laptop bag black 50 1640
Aida GmbH 109 Laptop bag red 60 1970
Liebher 108 Laptop bag black 60 1970
Liebher 109 Laptop bag red 70 2300
Liebher 110 Smartphone case diamond 60 4230
Aida GmbH 111 Smartphone case simple 80 1880
Aida GmbH 108 Laptop bag black 50 1640
Liebher 108 Laptop bag black 60 1970
Liebher 109 Laptop bag red 70 2300
Liebher 108 Laptop bag black 70 2300
Liebher 109 Laptop bag red 70 2300
Aida GmbH 108 Laptop bag black 70 2300
Aida GmbH 109 Laptop bag red 60 1970
Aida GmbH 110 Smartphone case diamond 50 3520
Liebher 109 Laptop bag red 60 1970
Liebher 110 Smartphone case diamond 70 4930
Aida GmbH 109 Laptop bag red 60 1970
Aida GmbH 110 Smartphone case diamond 60 4230
Aida GmbH 111 Smartphone case simple 60 1410
Liebher 109 Laptop bag red 60 1970
Liebher 110 Smartphone case diamond 50 3520
Aida GmbH 108 Laptop bag black 70 2300
Aida GmbH 109 Laptop bag red 60 1970
Liebher 108 Laptop bag black 80 2630
Liebher 109 Laptop bag red 80 2630
Liebher 110 Smartphone case diamond 50 3520
Aida GmbH 111 Smartphone case simple 60 1410
Aida GmbH 108 Laptop bag black 60 1970
 Data Product Description Sales This shape repre
Customer Name Sales Sales % Smartphone case diamond 40160 slicer. Slicers are
Liebher 58440 30.71% Laptop bag red 33170 in Excel 2010 or
Aida GmbH 46100 24.23% Women type T simple black 27960
Erma 43240 22.72% Laptop bag black 27710 If the shape was
an earlier version
Dellicia 42500 22.34% Women type T simple white 20640 or if the workboo
Total Result 190280 100.00% Women crop top black 14300 in Excel 2003 or
Smartphone case simple 6580 slicer cannot be
Men shorts black 3780
Men type T simple white 3720
Women basics 3200
Men shorts grey 2880
Men dress shirt black 2500
Men type T simple black 1320
Men dress shirt grey 1250
Men basics 750
Unisex tank top white 360
Total Result 190280
This shape represents a
slicer. Slicers are supported
in Excel 2010 or later.

If the shape was modified in

an earlier version of Excel,
or if the workbook was saved
in Excel 2003 or earlier, the
slicer cannot be used.

#VALUE!
Join Leila's Course: Excel Pivot Tables Essentials
Unlock Excel's true power with Pivot Tables—fast!

This course breaks it down step by step, so you can analyze data like a
pro.

No more guessing, no more struggling.

Get access now and see the difference Pivot Tables can make!