Search Contextures Sites

Excel Tips and Excel Tutorials

Puffin Truffles Gluten-Free Links  Debra's Blog

What's New Blog - Plan Party Seating With Excel Website - Excel Pivot Table Top 10 Filters  A Advanced Filter - Basics Advanced Filter - Criteria  Advanced Filter - Different Sheet video Advanced Filter - Unique Items video AutoFilter - Basics AutoFilter - Filter Text in Long String AutoFilter - Limits to Dropdown Lists AutoFilter - Programming AutoFilter - Protected Sheet  AutoFilter - Secret Toolbar Buttons video AutoFilter - Status Bar Record Count AutoFilter - Sum a Filtered List B Bar over character  31-Oct-06 Beyond the Keyboard Blank Cells, Fill  Video Blog, Contextures Book List, Excel 10-Jun-07 Books -- on my bookshelf   Books -- e-books, Microsoft Office  10-Feb-06 C Charting - Jon Peltier's Site Index Charting Links  Charts, Cluster Stack Utility Christmas Planner 21-Nov-08 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) UserForm ComboBox VBA 23-Feb-10 Comments - Add a Picture video Comments - Basics Comments - Change Indicator Colour Comments - Change Shape 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 Conditional Formatting - Basics  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 - 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 Count Cells  D Data Entry - Tips Data Entry - Fill Blank Cells  Video Data Entry - Convert Text to Numbers video Data Entry - Increase Numbers by Set Amount video Data Entry - Excel Videos  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 - Dependent Dropdown- Sorted List15-Jul-05   Data Validation - Dependent Lists   Data Validation - Dependent Lists INDEX 17-May-09 Data Validation - Documentation Data Validation - Font Size, List Length 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 from Other Workbook Data Validation Dropdowns are Too Wide  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 - Tips and Quirks updated 11-Oct-06 Dinner Planner, Holiday  10-Oct-2009  Dynamic Ranges, Naming  Dynamic Ranges, Naming with a Macro E Excel 2007 -- Articles List updated  16-Nov-07  Excel 2010 -- Articles List updated  18-Feb-10 Excel Add-ins List, Free  30-Aug-2009  Excel Events updated  09-Oct-09 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

F (cont'd) 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 Formatting Tips - Move Toolbar Palettes 29-Apr-08 Formulas visible on Worksheet  16-Jun-07 Functions Functions -- Count cells   Functions -- IFERROR 31-Dec-08 Functions -- INDEX   23-Nov-05 Functions -- INDIRECT 11-Nov-06 Functions -- MATCH    Video  Functions -- SUBTOTAL Functions -- Sum cells Functions -- TEXT Functions -- VLOOKUP  Video G-M GetPivotData   23-Jan-09 Gift Ideas for Excel Users updated 27-May-09 Govier, Roger - Sample Workbooks 18-May-09  Grades, Convert Percentages to Letter 30-May-09  Video INDEX Function   INDIRECT Function 11-Nov-06 Keyboard Shortcuts Macros, Copy to a workbook video Macros Prompt, Enable or Disable (FAQ) video Macros, Record and Run Excel 2007 - video  26-Nov-09 Macros Toolbar 24-Dec-05 MATCH Function    Video N-O 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, Convert Text to video Numbers, Increase by Set Amount video 18-May-08 Order Form   30-Jul-05 P Paste Values Mouse Shortcut  video 04-Feb-09 PeltierTech - Charting Site Index Pivot Tables, Beginning (Excel 2007)  Pivot Tables, Recipe Book (Excel 2003)  Pivot Tables, Recipe Book (Excel 2007)  Pivot Tables - Add-in -- Pivot Power    29-Apr-05 Pivot Tables - Add-in - Pivot Play PLUS  15-Mar-08 Pivot Tables - Clear Old Items  video updated 27-Jun-08  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 - Dynamic Data Source Pivot Tables - Field Settings Pivot Tables - FAQs 09-Oct-06  Pivot Tables - Filter Source Data 19-Jan-09 Pivot Tables - GetPivotData Pivot Tables - Grand Total at Top 15-May-08 Pivot Tables - Grouping Data Pivot Tables - Layout, Excel 2007 video 04-Jul-08 Pivot Tables - Multiple Consolidation Ranges  Pivot Tables - Pivot Cache  22-Mar-05 Pivot Tables - Printing  Pivot Tables - Protection  23-Apr-05  Pivot Tables - Report Filters 26-Feb-10 Pivot Tables - Running Totals video 13-Sep-08 Pivot Tables - Select Sections video 31-Aug-08 Pivot Tables - Show and Hide Items  Pivot Tables - Top 10 Filters 14-Mar-10 Pivot Tables - Unique Items Pivot Tables and Pivot Chart Intro PowerPivot for Excel Virtual Lab 10-Dec-09 Q-R-S Queries - Add-in - Pivot Play PLUS  15-Mar-08 Ranges, Naming Ribbon -- Navigation Command for Sheets 2007  17-Jul-08 Running Totals, Pivot Tables video 13-Sep-08 Sample Data  Sample Workbooks  updated 28-Jan-10  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 Shortcuts, Keyboard Sorting a List Sorting Data -- Programming 06-Aug-06  Store, The Excel Subtotal  Sum cells Sum a Filtered List   Survey Form   29-Oct-05 updated 11-Oct-06 T-U Table, Excel 21-Aug-08  updated  07-Aug-09 TEXT Function Toolbar -- Macros  24-Dec-05 Toolbar -- Navigate Workbook Sheets  updated 30-Oct-07 Topics Index Trailing Minus Signs Used Range, Reset (FAQ) UserForm, Create a   Video UserForm with ComboBoxes 23-Jan-06 UserForm ComboBox VBA 23-Feb-10 V-Z VBA Code, Copy to a workbook Video Index Videos, Excel Quick Tips 01 23-Dec-09 Videos, Excel Quick Tips 02 30-Dec-09 Videos, Excel Quick Tips 03 30-Dec-09 Videos, Excel Quick Tips 04 02-Jan-10 Videos, Excel Quick Tips 05 06-Jan-10 Videos, Excel Tutorial 01 updated 07-Sep-09 Videos, Excel Tutorial 02 10-May-08 Videos, Excel Tutorial 03 13-May-08 Videos, Excel Tutorial 04 updated 12-Jul-09 Videos, Excel Tutorial 05 01-Jun-08 Videos, Excel Tutorial 06 updated 25-Jul-08 Videos, Excel Tutorial 07 updated 31-Aug-08 Videos, Excel Tutorial 08 updated 30-May-09 Videos, Excel Tutorial 09 05-Feb-09 Videos, Excel Tutorial 10 19-Feb-09 Videos, Excel Tutorial 11 25-Feb-10 VLOOKUP function Video   Note: Some Excel tutorial links are to Contextures Blog and Contextures Pivot Table blog.

Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact   Privacy Policy   Contextures Inc., Copyright © 2009. All rights reserved.   Debra Dalgleish
Search Contextures Sites

Last updated: March 14, 2010 0:14 AM