Search Contextures Sites

 

Contextures
Excel news
by email

 

 

 

Your worksheet formulas can create traffic-light charts, highlight chart elements, assign number formats, and more.

 

 

 

 

Peltier Tech Chart Tool

 

 

Learn how to create Excel dashboards.

 

 

 

 

 

 

 

 

 

My Blogs

All Blog Updates

Contextures Blog

Pivot Tables Blog

Excel Twitter Blog

Debra's Blog

Spreadsheet Day

 

 

 

 

30 Excel Functions in 30 Days

 

 

 

 

Learn how to create Excel dashboards.

 

 

 

 

Update Your Excel Skills

 

 

 

 

Time-saving
Pivot Table add-in

 

 

 

 

 

 

 

 

Gluten-Free Links

Twitter I'm on Twitter

Contextures on Google+

 

 

Excel Tips and Tutorials

Topic Index | 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
Video Index | VLOOKUP | COUNT | SUM | Pivot Tables Blog

What's New

Blog - Try the Interactive Functions Workbook

Try the Interactive Functions Workbook

Pivot - Block New Items from Filtered Field

Block New Items from Filtered Field

A

30 Functions in 30 Days 31-Jan-11
Advanced Filter - Excel 2010 Basics 01-Mar-11
Advanced Filter - Excel 2003 Basics
Advanced Filter - Criteria
Advanced Filter - Different Sheet video
Advanced Filter - Unique Items video
AlexJ - Sample Workbooks
Annual Cost Calculator 06-May-13
AutoFilter - Excel 2007 Basics 02-Dec-10
AutoFilter - Excel 2003 Basics
AutoFilter - Filter Text in Long String
AutoFilter - Limits to Dropdown Lists
AutoFilter - Programming, Lists 28-May-12
AutoFilter - Programming, Worksheet
AutoFilter - Protected Sheet
AutoFilter - Secret Toolbar Buttons video
AutoFilter - Status Bar Record Count
AutoFilter - Sum a Filtered List
AutoFilter - Videos
Average Functions 06-Mar-13

B

Bar over character 31-Oct-06
Beyond the Keyboard
Blank Cells, Fill Video
Blog, Contextures
Blogs, Latest Updates 26-Nov-10
Book List, Excel (Interactive) 09-Jul-12
Books -- on my bookshelf
Books -- e-books, Microsoft Office 10-Feb-06
Box Plot (Box and Whisker Chart) 05-Jun-13

C

Cartesian Join with MS Query 22-Nov-12
Charting - Jon Peltier's Site Index
Charting Links
Charts, Box Plot (Box and Whisker) 05-Jun-13
Charts, Cluster Stack Utility
Chart Error Bars VBA 03-Jan-13
Charts, Interactive 03-Mar-13
Charts, Line-Column 2 Axes 01-Oct-12
Charts, Panel 22-Aug-12
Charts, Waterfall
CheckBox, Change Formula 16-Aug-11
Christmas Planner 21-Nov-08
Christmas Tree Scroll Bar 16-Dec-10
Code, Copy to a workbook video 12-Jul-09
Coderre, Ron - Sample Workbooks 17-Jul-07
Column headers show numbers (FAQ)
Combine Text/Numbers (Concatenate)
ComboBox VBA, UserForm 23-Feb-10
ComboBoxes, Dependent, UserForm 06-Mar-13
Comments - Add a Picture video
Comments - Basics
Comments - Change Indicator Colour
Comments - Change Shape
Comments - Copy 21-Dec-12
Comments - Copy Text to Adjacent Cell 22-Sep-05
Comments - Extract Text to Word
Comments - Format All 09-Mar-06
Comments - Format Text 29-Sep-08
Comments - Insert Selected Picture 28-Jan-06
Comments - Number and List 22-Jan-06
Comments - Printing
Comments - Programming
Comments - Resize
Comments - Show in Centre 22-Jul-06
Concatenate UDF 08-Aug-10
Conditional Formatting - Basics
Conditional Formatting - Data Bars video 08-Apr-10
Conditional Formatting - Documentation 07-Mar-05
Conditional Formatting - Hide Cells to Print
Conditional Formatting - Hide Duplicates
Conditional Formatting - Hide Errors
Conditional Formatting - Lottery Numbers
Conditional Formatting - Other Sheet video
Conditional Formatting - Pivot Table 16-Apr-13
Conditional Formatting - Row video
Conditional Formatting - Shade Alt Rows 14-Feb-07
Conditional Formatting - Shade Bands 14-Feb-07
Conditional Formatting - Filtered Bands 23-Feb-07
Conditional Formatting - Coloured Shapes 22-Jun-07
Contextures Blog
Cost Calculator, Annual 06-May-13
Count Cells
COUNTIF Function Video

D

Dashboard, Excel
Dashboard Course Review

Data Bars - Conditional Formatting video 08-Apr-10
Data Entry - Tips
Data Entry - Fill Blank Cells Video
Data Entry - Numbers Don't Add Up video
Data Entry - Excel Videos
Data Entry - Increase by Set Amount video
Data Entry Form, Update 06-Dec-10
Data Entry Form, Worksheet 22-Sep-06
Data, Sample (Interactive)

Data Validation - Basics video
Data Validation - Combo box 15-Jan-07
Data Validation - Combo box Named Range 15-Jan-07
Data Validation - Combo box - Click 18-Oct-08
Data Validation - Custom Criteria
Data Validation - Dates 21-Apr-12
Data Validation - Dependent Dropdown- Sorted List15-Jul-05
Data Validation - Dependent Lists
Data Validation - Dependent Lists INDEX 17-May-09
Data Validation - Documentation
Data Validation - Dropdowns Too Wide
Data Validation - Dropdowns Open at End of List 18-Aug-12
Data Validation - List Length
Data Validation - Font Size
Data Validation - Hide Used Items
Data Validation - Input Message in Text Box 05­Jun­05
Data Validation - Invalid Entries Allowed updated 11-Oct-06
Data Validation - List Auto Add New Items 10-Apr-10
Data Validation - List from Other Workbook
Data Validation - Make List Appear Larger
Data Validation - Make List Wider
Data Validation - Messages
Data Validation - Missing Arrows updated 11-Oct-06
Data Validation - Order Form 11-May-05
Data Validation - Select Multiple Items updated 15-Nov-11
Data Validation - Tips and Quirks updated 11-Oct-06
Data Validation - Videos
Data Validation - Videos, Basics
Delete Rows Macro 08-Aug-10
Dependent ComboBoxes on UserForm 06-Mar-13
Distance, Calculating 16-Sep-11
Drop Down List in Cell - Basics video
Duplicates -- Remove from a List (Excel 2003)
Duplicates -- Remove from a List (Excel 2007)
Dynamic Ranges, Naming video updated 21-Apr-10
Dynamic Ranges, Naming with a Macro

E

Easter Dates, Calculate 23-Sep-11
Error Bars, VBA 03-Jan-13
Excel 2007 -- Articles List updated 16-Nov-07
Excel 2010 -- Articles List updated 18-Feb-10
Excel 2013 -- Articles List updated 13-Jan-13
Excel Add-ins List, Free 30-Aug-2009
Excel Events updated 12-Sep-10
Excel Links
Excel Sites
Excel Store
Excel Table 21-Aug-08 updated 07-Aug-09

F

FAQs, Excel - Application and Files
FAQs, Excel - Dates and Times
FAQs, Excel - Index
FAQs, Excel - Macros, VBA
FAQs, Excel - Pivot Tables and Pivot Charts 09-Oct-06
FAQs, Excel - Worksheet Functions and Formats
File with that name is already open (FAQ)
File size, large (FAQ)
Fill colour doesn't work (FAQ)
Fill pattern doesn't print (FAQ)
Filter, Advanced
Filter, AutoFilter
Form, Create a UserForm
Form, Print Selected Items 23-Sep-06
Form, Survey 29-Oct-05 updated 11-Oct-06
Form, Worksheet Data Entry 22-Sep-06
Form, Data Entry and Update 06-Dec-10
Formatting - Move Toolbar Palettes 29-Apr-08
Formulas visible on Worksheet 16-Jun-07
FORMULATEXT Function 29-Jan-13
Functions, Interactive List updated 02-Jun-13
Functions -- 30 Functions in 30 Days 31-Jan-11
Functions -- Average 18-Mar-13
Functions -- Count cells Video updated 18-Apr-10
Functions -- COUNTIF Video
Functions -- FORMULATEXT 29-Jan-13
Functions -- HLOOKUP 12-Mar-13
Functions -- HYPERLINK
Functions -- IF 27-May-13
Functions -- IFERROR 31-Dec-08
Functions -- INDEX 23-Nov-05
Functions -- INDIRECT 11-Nov-06
Functions -- ISFORMULA 03-Feb-13
Functions -- MATCH Video
Functions -- MIN and MAX 30-Jul-12
Functions -- RANK Video 12-Sep-10
Functions -- Rounding 13-Feb-13
Functions -- SUBTOTAL
Functions -- Sum cells
Functions -- TEXT
Functions -- VLOOKUP Video

G

GetPivotData 23-Jan-09
Gift Ideas for Excel Users updated 27-May-09
Golf Scores Template 25-Apr-10
Govier, Roger - Sample Workbooks 18-May-09
Grades, Convert Percentages to Letter 30-May-09 Video

H

Holiday Planner 21-Nov-08
HLOOKUP Function 12-Mar-13
HYPERLINK Function
Hyperlinks, Add, Remove 11-Dec-10

I

IF Function 27-May-13
INDEX Function Video
INDIRECT Function 11-Nov-06
ISFORMULA Function 03-Feb-13

K

Keyboard Shortcuts - Interactive List

L

Last Row, Excel VBA 29-Feb-12
Line-Column Chart on 2 Axes 01-Oct-12
List Box, Excel VBA 29-Nov-10
Lists - AutoFilter VBA
Lists, Drop Down in Cell - Basics video
Longitude, Latitude 16-Sep-11

M

Macros, Add to Quick Access Toolbar video 31-Jul-10
Macros, Copy to a workbook video
Macros - Getting Started 15-May-13
Macros Prompt, Enable or Disable (FAQ) video
Macros, Record and Test Excel 2007 09-Aug-10
Macros Toolbar 24-Dec-05
MATCH Function Video
Meal Planner, Holiday 10-Oct-2009
Meal Planner, Weekly 07-Sep-10
Microsoft Query, Cartesian Join 22-Nov-12
MIN and MAX Functions 30-Jul-12

N

Names -- Naming Ranges video
Names -- Naming Dynamic Ranges with a macro 22-Feb-09
Names -- Use Names in Formulas 17-Jun-05
Navigation Command for Sheets 2007 17-Jul-08
Navigation Toolbar for Sheets 2003 21-Dec-05
Nerd, You Might Be An Excel Nerd 03-Aug-2009
Newsgroup Posting Statistics -- Annual 01-Jan-09
Numbers Don't Add Up video
Numbers, Increase by Set Amount video 18-May-08

O

Order Form 30-Jul-05

P

Panel Charts 22-Aug-12
Paste Values Mouse Shortcut
video 04-Feb-09
PeltierTech - Charting Site Index
Pivot Charts, Create 24-Nov-12
Pivot Charts, Source Data 24-Nov-12
Pivot Tables, Beginning (Excel 2007)
Pivot Tables, Recipe Book (Excel 2003)
Pivot Tables, Recipe Book (Excel 2007)
Pivot Tables - Add-in - PivotPower updated 08-Mar-11
Pivot Tables - Add-in - PivotPower Premium 20-Sep-12
Pivot Tables - Add-in - Pivot Play PLUS 15-Mar-08
Pivot Tables - Calculated Field 08-Sep-10
Pivot Tables - Calculated Item 16-Mar-11
Pivot Tables - Clear Old Items video updated 27-Jun-08
Pivot Tables - Conditional Formatting 16-Apr-13
Pivot Tables - Create in Excel 2007 video 19-Feb-09
Pivot Tables - Custom Calculations 07-Mar-05
Pivot Tables - Custom PivotTable Style, Copy - video 22-Jul-09
Pivot Tables - Data Field Layout video
Pivot Tables - Data Source 19-Apr-12
Pivot Tables - Dynamic Data Source
Pivot Tables - Field Settings
Pivot Tables - FAQs 09-Oct-06
Pivot Tables - Field List 03-Jun-13
Pivot Tables - Filter Source Data 19-Jan-09
Pivot Tables - Filters, Report Filters 26-Feb-10
Pivot Tables - Filters, Top 10 video 14-Mar-10
Pivot Tables - Formatting 21-Sep-10
Pivot Tables - Format Copy 18-Nov-10
Pivot Tables - Format macro video 15-Aug-10
Pivot Tables - GetPivotData
Pivot Tables - Grand Total at Top 15-May-08
Pivot Tables - Grouping Data
Pivot Tables - Interactive Filters 23-Sep-10
Pivot Tables - Layout, Excel 2007 video 04-Jul-08
Pivot Tables - Multiple Consolidation Ranges video updated 16-Apr-10
Pivot Tables - Pivot Cache 22-Mar-05
Pivot Tables - Printing
Pivot Tables - Protection 23-Apr-05
Pivot Tables - Report Filters video 26-Feb-10
Pivot Tables - Report Filters Programming 18-Aug-12
Pivot Tables - Running Totals video 13-Sep-08
Pivot Tables - Select Sections video 16-Dec-10
Pivot Tables - Show and Hide Items
Pivot Tables - Sorting 03-Jul-10
Pivot Tables - Subtotals video 16-Apr-10
Pivot Tables - Summary Functions 18-Aug-10
Pivot Tables - Top 10 Filters video 14-Mar-10
Pivot Tables - Unique Items
Pivot Tables and Pivot Chart Intro
Planner, Christmas 21-Nov-08
Planner, Holiday Meal 10-Oct-2009
Planner, Weekly Meal 07-Sep-10
PowerPivot for Excel Virtual Lab 10-Dec-09
PowerPivot from Identical Files 07-Sep-10
Preview Picture, Save with 15-Apr-12
Print One Page Wide 13-Aug-12
Print Headings All Pages 13-Aug-12
Project Management Templates

Q

Queries - Add-in - Pivot Play PLUS 15-Mar-08
Quick Access Toolbar, Customize video 31-Jul-10

R

Ranges, Naming
RANK Function Video 12-Sep-10
Rothstein, Rick - Excel VBA 08-Aug-10
Ribbon -- Custom tabs, Add 11-Jan-13
Ribbon -- Custom tabs, Intro 16-Jan-13
Ribbon -- Navigation Command for Sheets 2007 17-Jul-08
Rounding Functions 13-Feb-13
RSS Feeds on Worksheet 25-Mar-13
Running Totals, Pivot Tables video 13-Sep-08

S

Sample Data (Interactive)
Sample Workbooks updated 16-Feb-11
Sample Workbooks (AlexJ)
Sample Workbooks (Ron Coderre) updated 20-Sep-07
Sample Workbooks (Roger Govier) updated 18-May-09
Scenarios -- Automatically Show 10-Apr-05
Scenarios -- Create and Show 03-Apr-05
Scenarios -- Programming 12-Apr-05
Scenarios -- Scenario Summaries 03-Apr-05
Scroll Bar, Date Range 28-Nov-12
Scroll Bar, Worksheet 16-Dec-10
Shortcuts, Keyboard - Interactive List
SendKeys 23-Jan-13
Sort a List Excel 2010 / 2007 updated 05-Jul-11 videos
Sort a List Excel 2003 videos
Sort Data -- Programming 06-Aug-06
Spreadsheet Day
Store, The Excel
Subtotal
Sum cells
Sum a Filtered List
Survey Form 29-Oct-05 updated 11-Oct-06

T

Table, Excel 21-Aug-08 updated 07-Aug-09
Text Box, ActiveX 29-May-13
TEXT Function
Toolbar -- Macros 24-Dec-05
Toolbar -- Navigate Workbook Sheets updated 30-Oct-07
Topics Index
Trailing Minus Signs

U

Used Range, Reset (FAQ)
Used Range, Select 29-Feb-12
UserForm, Create a Video
UserForm with ComboBoxes 23-Jan-06
UserForm Dependent ComboBoxes 06-Mar-13
UserForm ComboBox VBA 23-Feb-10

V

VBA AutoFilter - Lists
VBA AutoFilter - Worksheet
VBA Chart Error Bars 03-Jan-13
VBA Code, Copy to a workbook
VBA - Getting Started 15-May-13
VBA SendKeys 23-Jan-13
Video Index
Videos, AutoFilter
Videos, Comments
Videos, Data Entry
Videos, Data Validation
Videos, Data Validation Basics
Videos, INDEX function
Videos, RANK function
Videos, VLOOKUP function

VLOOKUP function Videos

Excel Expert Course

W-Z

Waterfall Charts
Weight Loss Tracker 07-Jan-12
Worksheet Tips 23-Mar-13
XML Maps for RSS Feed 25-Mar-13

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

Search

Search Contextures Sites

 

 

Privacy Policy

 

Contextures Inc., Copyright ©2013
All rights reserved.

 

 

Last updated: June 18, 2013 9:04 AM