Contextures - Microsoft Excel Tips and Tutorials

Search Contextures Sites

• Home
• Excel Tips
• Excel Files
• Products
• Blog
• Contact
• RSS

Contextures Excel news by email Email: Name (optional): We respect your email privacy                                     My Blogs All Blog Updates Contextures Blog Pivot Tables Blog Excel Twitter Blog Debra's Blog Spreadsheet Day                                 Time-saving Pivot Table add-in                 Gluten-Free Links 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 Pivot - 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 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

Home Excel Tips Excel Files Products Blog Contact   Privacy Policy   Contextures Inc., Copyright ©2013 All rights reserved.   Debra Dalgleish

Last updated: June 18, 2013 9:04 AM