Building a Pivot Table in Excel 2010 -- Part 1

Watch the full course at http://SimonSezIT.com. In this 4-part series on Microsoft Excel 2010 Pivot Tables, we start with Part 1 -- the basics of creating to use Pivot Tables.
Website: http://SimonsezIT.com
Facebook: http://www.facebook.com/SimonSezIT
Twitter: http://twitter.com/SimonsezIT

Category:

Science & Technology

Tags:

• Pivot
• table
• Excel
• Microsoft
• MS
• Tutorial
• Education
• SimonSezIT
• excel
• charts
• spreadsheet
• analysis
• pivottable
• graphs
• 2010
• training
• tuts
• office
• guide
• help
• beginners
• basics
• computers

[laufel]

Extremely helpful tutorial!! Thank you very much!

[bonniej2009]

@riggins2308 Yes. Click anywhere in your Pivot table to reveal "tools" and in far left hand corner of ribbon, click on "options" to reveal piovot table options dialog box. Under "display" subtab, check the box for "Classic Pivot Table Layout" (allows you to drag and drop data into the table)

[MrMikelee77]

I liked this guy. He has a very relaxed, straight forward and methodical style. More important, he does not come over condescending like some do at 100 miles an hour!

[hangc10]

how can you stop the pivot table to calculate the year. Cause I have a table Year and it freakin calculate all the year... I have it as 2010, 2011, and 2012.

[andyxlcn]

THANKS!

[seanchristie02]

Very informative, covering detailed practical application and use. Great service.

[888sugar888]

thank you so much, you made it easy to understand for beginners like me :)

[PaulCutcliffe]

Excellent.

[myforexdna]

great video....great stuff, nicely explained very useful.!!

[riggins2308]

Is there a reason why I can not drag and drop into my pivot table? Is there feature that I need to select?