Excel Tips and Techniques

Table of Contents Table of Contents   Table of Contents Gluten-Free Links Puffin Truffles

A Advanced Filter - Basics Advanced Filter - Criteria AutoFilter - Basics AutoFilter - Filter Text in Long String AutoFilter - Limits to Dropdown Lists AutoFilter - Programming AutoFilter - Protected Sheet AutoFilter - Status Bar Record Count AutoFilter - Sum a Filtered List B Bar over character  31-Oct-06 Blank Cells, Fill  Video 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 updated 14-Jul-07 Charting Links Code, Copy to a workbook Coderre, Ron - Sample Workbooks 17-Jul-07  Column headers show numbers (FAQ) Combining Data 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 - 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 - Row 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 Consulting Services Count Cells  D Data Entry - Tips Data Entry - Fill Blank Cells Data Entry - Convert Text to Numbers Data Validation - Basics Data Validation - Combo box   15-Jan-07 Data Validation - Combo box Named Range  15-Jan-07 Data Validation - Custom Criteria Data Validation - Dependent Dropdown- Sorted List 15-Jul-05 Data Validation - Dependent Lists   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 - 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 Dynamic Ranges, Naming E Excel 2007 -- Articles List  updated 16-Nov-07  Excel Links Excel Sites  Excel User Conference

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 Formatting Tips - Move Toolbar Palettes  29-Apr-08 Formulas visible on Worksheet  16-Jun-07 Functions Functions -- Count cells   Functions -- INDEX   23-Nov-05 Functions -- INDIRECT 11-Nov-06 Functions -- MATCH   Functions -- Sum cells Functions -- VLOOKUP G-M GetPivotData   Gift Ideas for Excel Users  02-Dec-07 INDEX Function   INDIRECT Function 11-Nov-06 Keyboard Shortcuts Macros, Copy to a workbook Macros Prompt, Enable or Disable (FAQ) video Macro Toolbar 24-Dec-05 MATCH Function    N-O Names -- Naming Ranges video Names -- Use Names in Formulas  17-Jun-05 Navigation Toolbar for Workbook Sheets  21-Dec-05 Newsgroup Posting Statistics updated 01-May-08 Newsgroup Posting Statistics -- Annual 01-Jan-08 Numbers, Convert Text to video Order Form   30-Jul-05 P Pivot Tables - Add-in -- Pivot Power    29-Apr-05 Pivot Tables - Add-in - Pivot Play PLUS  15-Mar-08 Pivot Tables - Clear Old Items   Pivot Tables - Custom Calculations  07-Mar-05 Pivot Tables - Data Field Layout  video Pivot Tables - Dynamic Data Source Pivot Tables - Field Settings Pivot Tables - FAQs 09-Oct-06 Pivot Tables - GetPivotData Pivot Tables - Grand Total at Top   15-May-08 Pivot Tables - Grouping Data Pivot Tables - Multiple Consolidation Ranges  Pivot Tables - Pivot Cache   22-Mar-05 Pivot Tables - Printing  Pivot Tables - Protection   23-Apr-05 Pivot Tables - Show and Hide Items  Pivot Tables - Unique Items Pivot Tables and Pivot Chart Intro Q-R-S Queries - Add-in - Pivot Play PLUS  15-Mar-08 Ranges, Naming Sample Data  Sample Workbooks  updated 10-Mar-08  Sample Workbooks (Ron Coderre) updated 20-Sep-07  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  Sum cells Sum a Filtered List   Survey Form   29-Oct-05 updated 11-Oct-06 T-Z 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 UserForm with ComboBoxes 23-Jan-06 VBA Code, Copy to a workbook Video Instruction Clips 01 10-May-08 Video Instruction Clips 02 10-May-08 Video Instruction Clips 03 13-May-08 VLOOKUP function

Home

Excel Tips

Sample Spreadsheets

Contextures contact information

Last updated: May 15, 2008 7:37 PM