Microsoft Excel Training and Tips

My Favorite Excel Tutorials and Tips

A selection of some of my most relevent tutorials and tips

Pivot Tables:

• Tutorial: Create Pivot Tables
• Tutorial: Work with Pivot Tables
• Tutorial: Group Data in Pivot Tables
• Tutorial: Filter data with slicers in Pivot Tables
• Tutorial: Create Pivot Charts

Other Excel topics:

• Tip: Count Autofiltered Rows
• Tip: Handle missing data in a line chart
• Tip: Comparing Two Lists With Conditional Formatting
• Tip: Alternate Row Shading Using Conditional Formatting
• Tip: Calculate The Number Of Days In A Month

Take a minute and pass along your favorite Excel tip to us at Budget & Planning

Using Excel

Demos, Tutorials, Courses, and Documents concerning Excel

Microsoft Resources:

• Microsoft: Excel 2013 Training
• Courses: Excel 2010
• Keyboard shortcuts in Excel
• Examples: Excel

Excel Forums

Users from around the world post questions and answers concerning Excel

• Mr.Excel
• Contextures
• Excel Forum

Other Excel Sources

As I come across additional Excel resources on the web, I will post them here

• Excel Easy - A web based tutorial site with a pretty good sampling of Excel features and tools, from the very basic to advanced.