Search Contextures Sites

Excel Tips and Excel Tutorials

Puffin Truffles Gluten-Free Links Debra's Blog

What's New Blog - Create Pivot Table from Other Files Website - PowerPivot from Identical Files 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 AutoFilter - Videos 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) ComboBox VBA, UserForm 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 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 - 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 COUNTIF Function Video D Dashboard, Excel Data Bars - Conditional Formatting video 08-Apr-10 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 - List Auto Add New Items 10-Apr-10 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 Data Validation - Videos Data Validation - Videos, Basics Delete Rows Macro 08-Aug-10 Dinner Planner, Holiday 10-Oct-2009 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 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 14-Jun-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

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 - Move Toolbar Palettes 29-Apr-08 Formulas visible on Worksheet 16-Jun-07 Functions Functions -- Count cells Video updated 18-Apr-10 Functions -- COUNTIF Video 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 Golf Scores Template 25-Apr-10 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, Add to Quick Access Toolbar video 31-Jul-10 Macros, Copy to a workbook video Macros Prompt, Enable or Disable (FAQ) video Macros, Record and Test Excel 2007 09-Aug-10 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 - Filters, Report Filters 26-Feb-10 Pivot Tables - Filters, Top 10 video 14-Mar-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 - 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 - Running Totals video 13-Sep-08 Pivot Tables - Select Sections video 31-Aug-08 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 PowerPivot for Excel Virtual Lab 10-Dec-09 PowerPivot from Identical Files 07-Sep-10 Q-R-S Queries - Add-in - Pivot Play PLUS 15-Mar-08 Quick Access Toolbar, Customize video 31-Jul-10 Ranges, Naming Rothstein, Rick - Excel VBA 08-Aug-10 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 Excel Sort Add-in -- Excel Special Sort 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, AutoFilter Videos, Data Entry Videos, Data Validation Videos, Data Validation Basics Videos, VLOOKUP 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 09-Apr-10 Videos, Excel Tutorial 07 updated 31-Aug-08 Videos, Excel Tutorial 08 updated 26-Apr-10 Videos, Excel Tutorial 09 updated 31-Jul-10 Videos, Excel Tutorial 10 updated 16-Apr-10 Videos, Excel Tutorial 11 25-Feb-10 Videos, Excel Tutorial 12 updated 28-Jun-10 VLOOKUP function Videos 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 ©2010 All rights reserved.   Debra Dalgleish
Search Contextures Sites

Last updated: September 6, 2010 3:55 PM