Excel Tips and Tutorials

An extensive collection of easy-to-follow Excel tutorials, with videos, free workbooks and step-by-step instructions.

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z | Pivot Tables Blog

Video Index | Pivot Table Index | VLOOKUP | COUNT | SUM

What's New

Pivot Table Percentages: Show pivot table values as percentages, to make it easy to compare totals. See % of Column, % of Parent Row and % of Parent Total.

Pivot Tables & BI: Ken Puls ( sits down with the team from Excel TV to show how you can use pivot tables to build Business Intelligence (BI) solutions in Excel. There are 3 free videos in the series, so click here to get started.

Debra D Blog: How to build date queries in an Access database, using criteria from a form text box, or pop up prompt

Also see: Previous News || Excel Events || Excel Humour

Note: Some Excel tutorial links are to Contextures Blog and Contextures Pivot Table blog.

Don't Miss Our Excel Tips

Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.

Get weekly Excel tips from Debra





Get weekly Excel tips from Debra



pivot power free




Excel Data Entry Popup List



Peltier Tech Charts for Excel 3.0


Gluten-Free Links

Twitter I'm on Twitter

on Google+


Last updated: September 21, 2017 1:43 PM
Contextures RSS Feed