# Excel Tips and Tutorials

## 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 Events updated 12-Sep-10
Excel Sites
Excel Store
Excel Table 21-Aug-08 updated 07-Aug-09

## 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

## I

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

## O

Order Form 30-Jul-05

## 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
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
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
Tables, Data, for What If Analysis 28-Jun-13
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

## W-Z

Waterfall Charts
Weight Loss Tracker 07-Jan-12
What If Analysis, Data Tables 28-Jun-13
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

Contextures
Excel news
by email

My Blogs

Pivot Tables Blog

Time-saving

Contextures