Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

Categories

Archives

Learn how to create Excel dashboards.

Follow the List

Yesterday I compiled the Excel newsgroup statistics for September, a monthly task that entertains me, even if no one else reads them. Actually, the page gets a few hundred hits every month, so I guess a few other people find the numbers interesting too. Or maybe it's one other person, with OCD.
Pulling the report together [...]

Hey Kids -- Create a 3D Pie Chart

Children around the world can learn how to make shiny 3D pie charts, thanks to the Create a Graph page on the National Center for Education Statistics (NCES) web site. The NCES is part of the U.S. Department of Education and the Institute of Education Sciences, and collects and analyzes data related to education.
The Create [...]

What Business Can Learn From Baseball

In Moneyball: The Art of Winning an Unfair Game, author Michael Lewis details how Oakland A's general manager, Billy Beane, used statistical data to create a winning team on a small payroll.
In 2007, NetSuite invited Billy Beane onto their board of directors, and have improved their sales process by using his data analysis techniques. In [...]