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.
- 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?