Corporate HomeCorporate ProfileWorldwide OfficesSolutions At WorkEmployment  
LRS Education Services
LEARN  >  Find a Class  >  Class Summary

APPIVOT - Data Analysis using Excel PivotTables

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com
Students will learn how to create and modify PivotTables to summarize and analyze large amounts of data.
Click here for a printer-friendly version of this page
 
Upcoming classes
Number Class Date Location Length Cost Sign up
APPIVOT Jun 08, 2012 - Jun 08, 2012 Springfield 0.5 days $95.00 Register


Prerequisites

Excel Level 1 or equivalent knowledge
 
Detailed Class Syllabus


Make it easy to read
  • Begin with your raw data

  • Create a PivotTable

  • Group some data

  • Apply some formatting


    • See sales trends
  • What were sales by category by month?

  • What were the trends?

  • What products are doing well?

  • How did each sales rep do?


    • Spot market patterns
  • What did customers buy?

  • Who were our biggest customers?

  • What products do best in each region?


    • Analyze product surveys
  • Are customers satisfied?

  • What's the most important feature?
    •
     
    Microsoft Partner Gold LearningPrometricEC-Council
    Microsoft Certified ProgramsAdditional Certification Courses