67 Excel Tutorials on Charting, Pivot Tables, Add-ins

Here is a comprehensive linked list of 67 Excel articles, tutorials, and tips covering Excel Add-ins, Excel Charting and Graphing, and Pivot Tables. These learning materials are hosted by three excellent Excel tutorial sites: MrExcel, Chip Pearson, and John Walkenbach, all together containing over 500 Excel Articles and Tutorials.

These Excel articles and tutorials are presented in this post within these categories:

Add-Ins for Excel – Find out where to get Excel add-ins and how to use them.

Charts and Graphing in Excel – Learn how to Chart and Graph in Excel, from beginning to end.

Pivot Tables – Learn this important Excel data analysis feature.

9 Add-Ins for Excel

• Add-Ins - Free, Third-Party Add-Ins
• Analysis Tool Pack-Excel
• Cool accessories for Excel
• Empower Excel with the amazing DigDB Add-In
• Games in Excel
• The Spreadsheet Assistant for Excel
• Use MathEasy Add-In to simplify entering math formulas
• Using the Analysis ToolPack
• Using the Small Business Financial Manager in Excel with Quickbooks Data
  

31 Charting and Graphing Excel Tutorials

• Add a Trendline with 3 clicks
• Business Diagrams & Org Charts
• Charting with Time on the X-axis
• Charting Tips
• Create a Chart with 1 Keystroke
• Create a Time Line
• Creating a thermometer style chart
• Creating a transparent chart series
• Creating combination charts
• Demonstrate fractions with a pie chart
• Drawing with Excel – grid paper
• Expand the Chart Range
• Extend the Data Range
• Extending with Data Points
• Format Charts with Right-Click
• Histogram - Create a Dual Sided Histogram in Excel
• Gantt Chart with Conditional Formatting
• Handle missing data in a line chart
• In-cell Column Chart
• Layouts for column charts
• Multiple charts on a single Chart sheet
• Non-graphic chart directly in a range
• Saving a chart as a GIF file
• SmartArt Graphics in Excel 2007
• Speedometer Charts in Excel
• Students creating bar charts for survey data
• Summarize Data using a Pivot Charts
• Tips for the ‘Perfect Chart’
• Track Progress Towards a Goal
• Track Student Reading Progress with a Dynamic Chart
• Thermometer Charts

27 Excel Tutorials on Pivot Tables

• Access Data with Pivot Tables to Break Through Excel’s 65,536 row limit
• Add Median to Pivot Tables with DigDB’s One-Step-Summary
• Advanced Pivot Table Tips
• Cursor Meaning when Dropping Fields on a Pivot Table
• Monthly Summarizing
• Pareto Analysis with Pivot Tables
• Percent of Total in a Pivot Tables
• Pivot Charts
• Pivot Table: Use the Group Feature to Change to Monthly or Annual Output
• Pivot Tables: Consistent Colors on all Charts
• Pivot Tables: Correct Out-of-Sequence Data
• Pivot Tables: Group Daily Report up to Months
• Pivot Tables: Top 10 Customer Report with Top 10 AutoShow
• Pivot Tables: Use AutoFormat with Pivot Tables
• Pivot Tables: Use VBA to Print All Page Fields
• Pivot Tables: Use VBA to Transform Data for Optimal Analysis
• Pivot Tables to analyze market research data
• Pivot Tables to Summarize Data
• Produce a report for every department with Show Pages
• Replace Pivot Tables with DigDB’s One-Step-Summary
• Summarize Data by the Hour( =Hour() )
• Summarizing data with a pivot table
• Seasonality Analysis with a Pivot Tables
• Summary Table to Database Table
• Unique list of customers with a Pivot Tables
• Using Edit – GoTo to Clean up your Pivot Table
• What is a Pivot Table?

Popularity: 21% [?]