Site In Db DateCalc DateFull Title

Youtube x Err:502 Sat, 13 Apr 2013 [Link] +0000 How to Show a Running Total on E
Youtube x Err:502 Wed, 17 Apr 2013 [Link] +0000 How to Highlight Pivot Table Cells
Youtube x Err:502 Sun, 21 Apr 2013 [Link] +0000 Fix Problems With Adding Slicers in
PT Blog x Err:502 Wed, 24 Apr 2013 [Link] +0000 Problems Adding Slicers in Excel 2
Youtube x Err:502 Wed, 24 Apr 2013 [Link] +0000 How to Close All Files in Excel 2013
Youtube x Err:502 Mon, 29 Apr 2013 [Link] +0000 Excel Mouse Shortcuts to Insert or
PT Blog x Err:502 Wed, 01 May 2013 [Link] +0000 GetPivotData Problems With Subto
Ctx Site x Err:502 Sat, 04 May 2013 [Link] EDT Worksheet Data Entry Form Multip
Youtube x Err:502 Sat, 04 May 2013 [Link] +0000 Enter Date and Time in Excel
Youtube x Err:502 Sat, 04 May 2013 [Link] +0000 How to Show Totals in an Excel Tab
Ctx Site x Err:502 Mon, 06 May 2013 [Link] EDT Calculate Annual Costs
Youtube x Err:502 Mon, 06 May 2013 [Link] +0000 Calculate Annual Expenses in Excel
Youtube x Err:502 Mon, 06 May 2013 [Link] +0000 Calculate Annual Costs and Savings
Ctx Blog x Err:502 Tue, 07 May 2013 [Link] +0000 Calculate Annual Costs and Savings
Youtube x Err:502 Tue, 07 May 2013 [Link] +0000 Quickly Move an Excel Pivot Table
Ctx Site x Err:502 Wed, 08 May 2013 [Link] EDT Get Travel Distance from Mileage
PT Blog x Err:502 Wed, 08 May 2013 [Link] +0000 Quickly Move a Large Pivot Table
Youtube x Err:502 Wed, 08 May 2013 [Link] +0000 Get Mileage from Excel Lookup Tab
Ctx Blog x Err:502 Thu, 09 May 2013 [Link] +0000 Get Mileage from Excel Lookup Tab
Youtube x Err:502 Sat, 11 May 2013 [Link] +0000 Quickly Clear Data Entry Cells in Ex
Youtube x Err:502 Mon, 13 May 2013 [Link] +0000 Create a Calculated Field in Excel P
Youtube x Err:502 Tue, 14 May 2013 [Link] +0000 Quickly Delete Objects and Shapes
Ctx Blog X Err:502 Tue, 14 May 2013 [Link] +0000 Use Slicers to Filter a Table in Exce
Ctx Site x Err:502 Wed, 15 May 2013 [Link] EDT Excel VBA Getting Started With Ma
PT Blog x Err:502 Wed, 15 May 2013 [Link] +0000 Create a Simple Calculated Field
Ctx Blog X Err:502 Thu, 16 May 2013 [Link] +0000 Quickly Clear Objects from Worksh
Youtube x Err:502 Fri, 17 May 2013 [Link] +0000 Sum Filtered Excel Table with AG
Youtube x Err:502 Sat, 18 May 2013 [Link] +0000 Find and Replace Line Breaks in Exc
Youtube x Err:502 Sun, 19 May 2013 [Link] +0000 Change Pivot Table Report Filter L
Ctx Blog X Err:502 Tue, 21 May 2013 [Link] +0000 Sum a Filtered List with AGGREGAT
PT Blog x Err:502 Wed, 22 May 2013 [Link] +0000 Change the Report Filter Layout
Youtube x Err:502 Thu, 23 May 2013 [Link] +0000 How to Change Excel Column Headi
Ctx Blog X Err:502 Thu, 23 May 2013 [Link] +0000 Was Your Career Helped by Excel?
Youtube x Err:502 Mon, 27 May 2013 [Link] +0000 Change Pivot Table Values to Vertic
Ctx Site x Err:502 Mon, 27 May 2013 [Link] EDT Excel IF Function Examples
Ctx Blog X Err:502 Tue, 28 May 2013 [Link] +0000 Find and Replace Line Breaks in Exc
Youtube x Err:502 Wed, 29 May 2013 [Link] +0000 Remove and Prevent Automatic Hype
Ctx Site x Err:502 Wed, 29 May 2013 [Link] EDT Excel VBA Create an ActiveX Text B
PT Blog x Err:502 Wed, 29 May 2013 [Link] +0000 Arrange Value Fields Vertically for
Ctx Blog X Err:502 Thu, 30 May 2013 [Link] +0000 Nesting IF Functions in Excel
Youtube x Err:502 Sat, 01 Jun 2013 [Link] +0000 How to Remove the Page 1 Waterm
Youtube x Err:502 Mon, 03 Jun 2013 [Link] +0000 How to Adjust the Pivot Table Field
Ctx Site x Err:502 Mon, 03 Jun 2013 [Link] EDT Create Excel Box Plot Chart
Ctx Site x Err:502 Mon, 03 Jun 2013 [Link] EDT Excel Pivot Table Field List
Youtube x Err:502 Tue, 04 Jun 2013 [Link] +0000 Create a Simple Box Plot - Box and
Ctx Blog X Err:502 Tue, 04 Jun 2013 [Link] +0000 Excel Page Break Preview Tips
Youtube x Err:502 Wed, 05 Jun 2013 [Link] +0000 Build Excel Box Plot With Charting U
PT Blog x Err:502 Wed, 05 Jun 2013 [Link] +0000 How to Adjust the Pivot Table Field
Youtube x Err:502 Thu, 06 Jun 2013 [Link] +0000 Add Average Marker to Excel Box P
Ctx Blog X Err:502 Thu, 06 Jun 2013 [Link] +0000 Interactive Excel Functions List
Youtube x Err:502 Fri, 07 Jun 2013 [Link] +0000 Quickly Remove an Excel Pivot Tabl
Youtube x Err:502 Fri, 07 Jun 2013 [Link] +0000 Sort an Excel Table by Selected Ico
Youtube x Err:502 Sat, 08 Jun 2013 [Link] +0000 Prevent New Pivot Items from Appe
Create a Simple Box Plot in Excel
Ctx Blog x Err:502 Tue, 11 Jun 2013 [Link] +0000
Excel Functions: AVERAGE,
MEDIAN, MODE
Ctx Blog x Err:502 Thu, 13 Jun 2013 [Link] +0000
Thu, 27 Jun 2013 [Link] +0000 Dependent Drop Down Lists in
Excel
Ctx Blog x Err:502
Tue, 25 Jun 2013 [Link] +0000 Calculate Loan Payments with
PMT Function
Ctx Blog x Err:502
Thu, 20 Jun 2013 [Link] +0000 Getting Started With Excel
UserForms
Ctx Blog x Err:502
Tue, 18 Jun 2013 [Link] +0000 Update Multiple Pivot Tables
20130618
Ctx Blog x Err:502
PT Blog x Err:502 Wed, 26 Jun 2013 [Link] +0000 Show Percent of Subtotal in Pivot
PT Blog x Err:502 Wed, 19 Jun 2013 [Link] +0000 Group and Ungroup Text Items in P
PT Blog x Err:502 Wed, 12 Jun 2013 [Link] +0000 Block New Pivot Items in Filtered F
Sat, 29 Jun 2013 [Link] EDT Excel Pivot Table Expand and
Collapse Fields
Ctx Site x Err:502
Ctx Site x Err:502 Fri, 28 Jun 2013 [Link] EDT Excel Data Tables
Sun, 23 Jun 2013 [Link] EDT Dependent Dropdowns from a
Sorted List
Ctx Site x Err:502
Ctx Site x Err:502 Sat, 22 Jun 2013 [Link] EDT Excel PMT Function
Youtube x Err:502 Sat, 29 Jun 2013 [Link] +0000 Expand and Collapse Details in an E
Youtube x Err:502 Sat, 29 Jun 2013 [Link] +0000 Autocomplete Entries With Excel D
Youtube x Err:502 Mon, 24 Jun 2013 [Link] +0000 Show Developer Tab on the Excel
Youtube x Err:502 Sat, 22 Jun 2013 [Link] +0000 Show Percent of Subtotal in Excel P
Youtube x Err:502 Sat, 22 Jun 2013 [Link] +0000 Excel UserForm for Data Entry De
Youtube x Err:502 Sat, 22 Jun 2013 [Link] +0000 How to Calculate Loan Payments w
Youtube x Err:502 Sat, 15 Jun 2013 [Link] +0000 How to Group Text Items in an Exce
URL Author
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link]
contextures
[Link]
contextures
[Link]
contextures
[Link]
contextures
[Link]
contextures
[Link]
contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link]
contextures
[Link] contextures
[Link]
contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
[Link] contextures
Contextures Blog -- Latest Posts

title link category

Dependent Drop Down Lists in Excel [Link]
Excel Data Validation

Calculate Loan Payments with PMT Function [Link]

Excel Formulas

Getting Started With Excel UserForms [Link]

Excel VBA

Update Multiple Pivot Tables 20130618 [Link]

Pivot Table

Excel Functions: AVERAGE, MEDIAN, MODE [Link]

Excel Formulas

Create a Simple Box Plot in Excel [Link]

Excel charts

Interactive Excel Functions List [Link]

Excel Formulas

Excel Page Break Preview Tips [Link]

excel printing

Nesting IF Functions in Excel [Link]

Excel Formulas

Find and Replace Line Breaks in Excel [Link]

Excel tips
Cmts comments pubDate
0 [Link]
Thu, 27 Jun 2013 [Link] +0000
1
1 [Link]
Tue, 25 Jun 2013 [Link] +0000
1
1 [Link]
Thu, 20 Jun 2013 [Link] +0000
1
28 [Link]
Tue, 18 Jun 2013 [Link] +0000
1
1 [Link]
Thu, 13 Jun 2013 [Link] +0000
1
0 [Link]
Tue, 11 Jun 2013 [Link] +0000
1
4 [Link]
Thu, 06 Jun 2013 [Link] +0000
1
4 [Link]
Tue, 04 Jun 2013 [Link] +0000
1
0 [Link]
Thu, 30 May 2013 [Link] +0000
1
8 [Link]
Tue, 28 May 2013 [Link] +0000
1
Pivot Table Blog -- Latest Posts

title link pubDate

Show Percent of Subtotal in Pivot Table [Link]
Wed, 26 Jun 2013 04
Group and Ungroup Text Items in Pivot Table [Link]
Wed, 19 Jun 2013 04
Block New Pivot Items in Filtered Field [Link]
Wed, 12 Jun 2013 04
How to Adjust the Pivot Table Field List [Link]
Wed, 05 Jun 2013 04
Arrange Value Fields Vertically for Printing [Link]
Wed, 29 May 2013 0
Change the Report Filter Layout [Link]
Wed, 22 May 2013 0
Create a Simple Calculated Field [Link]
Wed, 15 May 2013 0
Quickly Move a Large Pivot Table [Link]
Wed, 08 May 2013 0
GetPivotData Problems With Subtotals [Link]
Wed, 01 May 2013 0
Problems Adding Slicers in Excel 2010 [Link]
Wed, 24 Apr 2013 04
category Cmts
Custom Calculations 0 1
pivot table grouping 0 1
pivot table filters 0 1
pivot table field list 0 1
pivot table value fields 0 1
pivot table filters 7 1
Calculated Field 0 1
pivot tables 0 1
pivot table subtotals 0 1
pivot table filters 0 1
Contextures Site -- Latest Posts

title link

Excel Pivot Table Expand and Collapse Fields [Link]

Excel Data Tables [Link]

Dependent Dropdowns from a Sorted List [Link]

Excel PMT Function [Link]

Create Excel Box Plot Chart [Link]

Excel Pivot Table Field List [Link]

Excel VBA Create an ActiveX Text Box [Link]

Excel IF Function Examples [Link]

Excel VBA Getting Started With Macros [Link]

Get Travel Distance from Mileage Chart [Link]

Calculate Annual Costs [Link]

Worksheet Data Entry Form Multiple Areas [Link]

Scroll Items Up and Down in List [Link]

Pivot Table Conditional Formatting [Link]

Excel RSS Feeds [Link]

Excel Worksheet Tips [Link]

Excel Average Functions [Link]

Build Amazon Affiliate Links and HTML [Link]

Excel HLOOKUP Function [Link]

Excel UserForm With Dependent Combo [Link]

Boxes

Excel Interactive Chart Features [Link]

Change Pivot Table Date Range With Scroll [Link]

Bar

Excel Rounding Functions [Link]

Excel ISFORMULA Function [Link]

Excel FORMULATEXT Function [Link]

Excel VBA - SendKeys [Link]

Excel Ribbon - Add Custom Tab [Link]

Excel Ribbon - Getting Started [Link]

Excel Charts VBA [Link]

Change All Pivot Charts With One Filter [Link]

Excel Budget Forecast vs Actual [Link]

Excel Select Date With Scroll Bar [Link]

Excel Pivot Chart Change Source Data [Link]

Cartesian Join in Excel Using MS Query [Link]

Show Sparklines for Hidden Data [Link]

DSUM With Excel Tables [Link]

Word Usage Chart [Link]

Product Code Lookup in Date Range [Link]

Formula Info List [Link]

Excel Troubleshooting - Format Cells [Link]

Excel Panel Chart Tutorial [Link]

Pivot Table VBA - Report Filters [Link]

Excel Printing Tips [Link]

Excel 2013 Information [Link]

Limit Budget Entries with Data Validation [Link]

Conditional Formatting in Filtered List [Link]

Change Specific Page Fields with Multiple [Link]
Selection Settings

CONVERT Function Made Easy [Link]

Excel VBA Code Documenter [Link]

Excel List AutoFilter VBA [Link]

Track Project Time [Link]

MultiPage Excel UserForm [Link]

Excel Weight Loss Tracker [Link]

Simple Excel Gantt Chart [Link]

Excel Advanced Filter Intro - Excel 2010 [Link]

Excel Scroll Bar Christmas Tree Example [Link]

Excel Pivot Table Select [Link]

Add and Remove Excel Hyperlinks [Link]

Excel Data Entry and Update Form [Link]

Excel VBA - Create a Worksheet List Box [Link]

Excel RANK Function [Link]

Split Points for Shared Rank [Link]

Excel Pivot Table Calculated Field [Link]

Excel Pivot Table Summary Functions [Link]

Rick Rothstein - Excel VBA Samples - Text [Link]

Customize the Excel Quick Access Toolbar [Link]

Shorten Data Validation List [Link]

Excel Template - Golf Scores [Link]

Excel Pivot Table Subtotals [Link]

Excel Data Validation Automatically Add [Link]

Items to Drop Down Lists

Excel Conditional Formatting - Data Bars [Link]

Excel Pivot Table Filters - Top 10 [Link]

Excel Pivot Table Report Filters [Link]

Excel VBA ComboBox Lists [Link]

Excel Quick Tips Videos 05 [Link]

Excel Quick Tips Videos 04 [Link]

Excel Quick Tips Videos 03 [Link]

Excel Quick Tips Videos 02 [Link]

Excel Quick Tips Videos 01 [Link]

Colour Filter Headings [Link]

Excel Advent Calendar [Link]

Excel VBA Intro - Record and Run a Macro in [Link]

Excel 2007

Excel Holiday Dinner Planner [Link]

Movie Collection Database Sample File [Link]

Pivot Table from Multiple Sheets [Link]

Excel -- You might be an Excel Nerd If [Link]

description pubDate In Main
List
Instead of viewing the details for all items in a pivot field, you Sat, 29 Jun 1
can collapse and expand specific items, or the entire pivot 2013
field. The Expand and Collapse commands do not affect items [Link]
that have been filtered. EDT

Use data tables to perform What If analysis in Excel, using one Fri, 28 Jun 1
or two variables. 2013
[Link]
EDT

Select an item in column 1, and drop down list in column 2 Sun, 23 1

only shows related items. Excel 2003 tutorial, based on sorted Jun 2013
list and OFFSET function. [Link]
EDT

Use the Excel PMT function to calculate loan payments based Sat, 22 Jun 1
on interest rate, number of payments, loan amount. 2013
[Link]
EDT

Video and detailed instructions show how to create a box plot Mon, 03 1
chart in Excel using a stacked column chart and error bars. Jun 2013
[Link]
EDT

Add or move pivot fields with the field list. Adjust the field list Mon, 03 1
width, sort order, layout and position, for easier use. Jun 2013
[Link]
EDT

Use Excel text box controls on the worksheet to enter data. Wed, 29 1
Link to cells, add manually or with VBA. May 2013
[Link]
EDT

Use the Excel IF function to test a value, then show a result, Mon, 27 1
depending if the test was TRUE or FALSE. May 2013
[Link]
EDT

Use Excel macros to automate tasks, to same time and reduce Wed, 15 1
errors. May 2013
[Link]
EDT
Use INDEX and MATCH functions to find distance between Wed, 08 1
two cities. Conditional formatting highlights selected mileage May 2013
in lookup table. [Link]
EDT

Enter current expenses in Scenario A, and potential cost Mon, 06 1

reductions in Scenario B. Formulas calculate annual totals and May 2013
differences. [Link]
EDT

Enter data on a worksheet, in multiple data entry areas. Add Sat, 04 1

new records, view and update existing records. May 2013
[Link]
EDT

Sample code from Jim Cone. Select a list on the worksheet, Wed, 17 0
and click arrows to scroll the list items up or down. Apr 2013
[Link]
EDT

Set conditional formatting options when working with pivot Mon, 15 0

tables, to ensure the formatted range updates correctly. Apr 2013
[Link]
EDT

Create an XML map to show RSS feeds from blogs or websites, Mon, 25 0
on an Excel worksheet. Mar 2013
[Link]
EDT

View two sheets in the same Excel workbook, at the same Sat, 23 0
time, by adding a new window. View two workbooks as the Mar 2013
same time. Copy a worksheet and rename it. Copy a [Link]
worksheet to a different workbook. EDT

Use the AVERAGE, AVERAGEA, AVERAGEIF and AVERAGEIFS Mon, 18 0

functions in Excel to calculate the average for cell values, with Mar 2013
or without criteria. [Link]
EDT

Use formulas in Excel to create links and HTML code for Wed, 13 0
Amazon affiliate product links. Copy and paste to blog or Mar 2013
website. [Link]
EDT
Use the HLOOKUP function in Excel to find a value in a Tue, 12 0
horizontal list, and return another value from the selected Mar 2013
column. [Link]
EST

Use combo boxes on an Excel UserForm, to make data entry Wed, 06 0

easier. Select from first combo box, and related items appear Mar 2013
in second combo box. [Link]
EST

Click a check box, or type an X, to show and hide Excel chart Sun, 03 0
data. No programmig required. Mar 2013
[Link]
EST

Click the scroll bar to change the ending date for a pivot table Wed, 27 0
report. Set the number of months to be included. This Feb 2013
technique from AlexJ uses one line of programming, to refresh [Link]
the pivot table. EST

Use ROUND and other functions to round numbers up or Wed, 13 0

down in Excel. Feb 2013
[Link]
EST

Use ISFORMULA function in Excel 2013 to check for a formula Sun, 03 0

in a cell. Feb 2013
[Link]
EST

Use FORMULATEXT function in Excel 2013 to show the Tue, 29 0

formula contained in a cell. Jan 2013
[Link]
EST

Use SendKeys method in Excel VBA code to simulate Wed, 23 0

keystrokes. Problems may occur if wrong window is active. Jan 2013
[Link]
EST

Create a custom tab on Excel Ribbon that opens when specific Wed, 16 0
file is active. Modify macros to run when Ribbon button is Jan 2013
clicked. [Link]
EST

Examine sample file that create custom tab on Excel Ribbon. Sat, 12 Jan 0
Add Ribbon Callback to macros and test the buttons. 2013
[Link]
EST
Sample code to modify Excel charts with VBA programming. Thu, 03 0
Jan 2013
[Link]
EST

Pivot charts on dashboard are connected to slicer on separate Wed, 12 0

sheet. Change the dashboard filter, and all the connected Dec 2012
charts change. Sample file from AlexJ, Excel 2010 or later. [Link]
EST

Enter forecast and actual amounts in this Excel budget Thu, 06 0

template; formulas calculate the year to date variance. Dec 2012
[Link]
EST

In Excel, add a scroll bar, and click or drag to select an end Wed, 28 0
date for reports. No programming required. Nov 2012
[Link]
EST

Create an Excel pivot chart with keyboard shortcuts. Unlink a Sat, 24 0

pivot chart, and connect it to a different pivot table. Save time Nov 2012
by copying a formatted chart, instead of starting from scratch. [Link]
EST

In Excel, you can use MS Query to create a Cartesian join Thu, 22

between two tables. This will connect all the items in table 1 Nov 2012
with all the items in table 2. [Link]
EST

Macro changes all sparklines on the active sheet, so they will Sun, 18
show data, even if rows and columns are hidden. Excel 2010 Nov 2012
or later. [Link]
EST

Use DSUM to calculate totals for a database that is a named Wed, 14

Excel Table, for Excel 2007 and later Nov 2012
[Link]
EST

Select words from drop down list and chart shows how Fri, 09 Nov
frequently they were used in speeches, by each political party 2012
[Link]
EST
Find the promo code and discount rate for the selected Wed, 07
product, based on the order date Nov 2012
[Link]
EST

Code creates a list of formulas on each worksheet, by inserting Wed, 26

a new sheet for each list. Remove formula list sheets by Sep 2012
running the cleanup macro [Link]
EDT

When troubleshooting an Excel file, use color code to mark Wed, 29

cells with formulas, text, numbers, data validation. Aug 2012
[Link]
EDT

Step by step instructions for creating a panel chart, with four Wed, 22
sets of data, side-by-side, in a single chart. Aug 2012
[Link]
EDT

Sample Excel VBA programming to change pivot table report Sat, 18

filters. Aug 2012
[Link]
EDT

Fit wide Excel sheets onto one printed page in width. Show Mon, 13
headings rows on every printed page. Aug 2012
[Link]
EDT

Links to Excel 2013 articles, from Microsoft and other sources. Fri, 10 Aug
2012
[Link]
EDT

Limit the total amount that is entered in an Excel budget Wed, 25

worksheet, by using data validation to check the total. Create Jul 2012
a custom message that appears when the amount goes over [Link]
budget. You can also see the unbudgeted amount that is still EDT
available, and adjust the entries if required

A coloured border separates dates in a list, and the conditional Tue, 17 Jul
formatting formula works even if some rows are hidden. 2012
[Link]
EDT
Create a list of page fields that should be automatically Sun, 15 Jul
changed. Change any of the specified page fields in a pivot 2012
table, and the same selections are made in all other pivot [Link]
tables that contain that page field. Also changes the Multiple EDT
Item Selection settings to match changed page fields.

Convert amounts from one measurement unit to another, Fri, 13 Jul

such as feet to metres. Excel VBA clears cells when new unit is 2012
selected. [Link]
EDT

Sample code from Professor Lee Townsend creates a list of Thu, 28

VBA procedures in a workbook, and shows which procedures Jun 2012
call others. Also lists worksheet shapes and connected macros. [Link]
EDT

Examples of Excel List AutoFilter VBA programming, for use Mon, 28

with the List AutoFilters found in named Excel tables (multiple May 2012
allowed per worksheet). Each named table is a ListObject, and [Link]
has its own AutoFilter property. EDT

Use Excel VBA to enter project task start and stop time, by Sun, 26
double-clicking on a cell. Excel formulas total the time per Feb 2012
task, and overall total time. [Link]
EST

Add Help buttons to a worksheet, and open a UserForm to a Mon, 06

specific page, to show relevant help Feb 2012
[Link]
EST

Set weight loss goals and track weekly progress. Dashboard Sat, 07 Jan
summarizes your results and shows target line. 2012
[Link]
EST

Simple task list and Gantt chart, uses the WORKDAY formula Wed, 11
to calculate days. File is in Excel 2007 format, with no macros. May 2011
[Link]
EST

Use an advanced filter to extract records from a list in Excel. Tue, 01

You can find unique records only, or a list of items that meet Mar 2011
specific criteria. [Link]
Page has been updated to show instructions for Excel 2007 EST
and Excel 2010, with the Excel Ribbon commands.
Use an Excel scroll bar on a worksheet, to decorate a Sat, 18
Christmas tree, without using macros. Dec 2010
Sample file has features that you can adapt to other [Link]
workbooks, such as text box with changing message, and EST
conditional formatting.
Includes written instructions and video demonstration of scroll
bar.

Turn on the Enable Selection feature in a pivot table, and then Thu, 16
click row or label headings to select specific sections of pivot Dec 2010
table. [Link]
Click to select entire pivot table, including report filters. Select EST
labels, values, or both.

Create hyperlinks with drag and drop; HYPERLINK function; Sat, 11

stop or undo hyperlinks. Dec 2010
[Link]
EST

Enter or update records on data entry sheet; drop boxes; Tue, 07

navigation buttons; mandatory cells. Dec 2010
[Link]
EST

Select multiple items in List Box. Store selected items on Mon, 29

separate worksheet. Nov 2010
[Link]
EST

Use Excel RANK function to compare numbers; show student Sun, 12

with highest score; break ranking ties. Sep 2010
[Link]
EDT

If 2 or more players have same rank, they split points available Sat, 11
for that rank, down to next occupied rank. For example, if 3 Sep 2010
players share rank 1, they split total points for ranks 1, 2 and [Link]
3. EDT

With a pivot table calculated field, you can create a formula to Wed, 08
perform calculations on the total for other fields in the pivot Sep 2010
table. For example, calculate a discount for orders that total [Link]
more than $100, or a bonus for sales reps who pass a target EDT
amount.

When you add a field to the pivot table's Values area, 11 Wed, 18
different functions, such as Sum, Count and Average, are Aug 2010
available to summarize the data. The summary functions in a [Link]
pivot table are similar to the worksheet functions with the EDT
same names, with a few differences as noted in this article.
An enhanced Concatenate function from Excel MVP Rick Sun, 08
Rothstein allows you to select a range of cells, and specify a Aug 2010
delimiter, such as a hyphen or comma, to quickly and easily [Link]
join the text strings. Also, sample code to delete rows where a EDT
specific word appears in the selected column, or where the
word does not appear.

To run macros that you create, or commands that you use Sat, 31 Jul
frequently, and commands that aren't on the Excel Ribbon by 2010
default, you can add icons to the Excel Quick Access Toolbar. [Link]
This video shows you the easy steps to follow, using the EDT
example of adding a macro icon to the QAT.

Shorten a Data Validation list by using Advanced Filter to Thu, 06

extract a list of names that start with selected letter; file May 2010
contains macros to automate list updates and filter. [Link]
EDT

Excel template tracks golf scores. Excel functions calculate Sun, 25

annual totals, averages, best, worst scores. Conditional Apr 2010
formatting highlights par, below par holes. [Link]
EDT

Excel pivot table subtotals are automatically created when you Fri, 16 Apr
add more fields to Row and Column areas. Change summary 2010
function, create multiple subtotals. [Link]
EDT

Create an Excel Data Validation drop down list that allows Sat, 10
users to add new items. New data validation items will be Apr 2010
automatically added to the drop down list, and the list is [Link]
sorted alphabetically. EDT

Use Excel Excel Conditional Formatting - Data Bars to visually Thu, 08

compare the values in a table, with in cell bars. Apr 2010
[Link]
EDT

Use Excel Pivot Table Value Filters to focus on the top 10, Sun, 14
bottom 10 or a specific portion of the total values in your data. Mar 2010
[Link]
EST

Use Excel Pivot Table Report Filters to focus on specific data in Fri, 26 Feb
your pivot table. 2010
[Link]
EST
Add single column and multiple column lists in Excel Tue, 23
ComboBox controls. Feb 2010
[Link]
EST

Excel tips in a set of very short videos, including shortcuts to Wed, 06

create a list of dates by week, enter dates and times, Jan 2010
customize the Excel 2007 status bar and change the default [Link]
number of sheets. EST

Excel tips in a set of very short videos, including change Sat, 02 Jan
hyperlinks to text, print all sheets, create a quick pivot table 2010
and create a formatted Excel Table. [Link]
EST

Excel tips in a set of very short videos, including move to edge Wed, 30
of range, create list of dates, select large range, rearrange Dec 2009
data. [Link]
EST

Excel tips in a set of very short videos, including select a Wed, 30

random name, change formulas to values, show message, Dec 2009
quickly name cells. [Link]
EST

Excel tips in a set of very short videos, including freeze panes, Wed, 23
print comments and create a quick series of numbers. Dec 2009
[Link]
EST

UPDATE: Event code colours the filtered column headings, Mon, 07

when an AutoFilter is applied. Updated to prevent Dec 2009
unnecessary clearing of Undo stack, per tip from Nigel Hunt. [Link]
EST

Click a numbered square and a macro reveals a Christmas Wed, 02

picture each day. Formulas show current date and days till Dec 2009
Christmas. [Link]
EST

Record a macro to automate a task, show the Developer tab Thu, 26

on Ribbon, run the recorded macro. Nov 2009
[Link]
EST

Create a detailed preparation schedule for holiday meals. Sat, 10 Oct

Enter details and Excel calculates start times. 2009
[Link]
EDT

Sample file uses Data Validation and Advanced Filter to extract Sat, 05
a list of movies for selected category or actor; file contains Sep 2009
macros to automate list updates and filter. [Link]
EDT
Sample file from Excel MVPs, Kirill Lapin (KL), with Mon, 24
amendments by Hector Miguel Orozco Diaz. Uses code to Aug 2009
automatically create a pivot table from multiple sheets in a [Link]
workbook. EDT

Yes, you might be an Excel Nerd if any of the entries in the Mon, 03
Contextures Blog giveaway sound familiar. A humorous look at Aug 2009
Excel, from those who live there. [Link]
EDT
YouTube -- Latest Videos
pubDate
Sat, 29 Jun 2013 [Link] +0000
Sat, 29 Jun 2013 [Link] +0000
Mon, 24 Jun 2013 [Link] +0000
Sat, 22 Jun 2013 [Link] +0000
Sat, 22 Jun 2013 [Link] +0000
Sat, 22 Jun 2013 [Link] +0000
Sat, 15 Jun 2013 [Link] +0000
Sat, 08 Jun 2013 [Link] +0000
Fri, 07 Jun 2013 [Link] +0000
Fri, 07 Jun 2013 [Link] +0000
Thu, 06 Jun 2013 [Link] +0000
Wed, 05 Jun 2013 [Link] +0000
Tue, 04 Jun 2013 [Link] +0000
Mon, 03 Jun 2013 [Link] +0000
Sat, 01 Jun 2013 [Link] +0000
Wed, 29 May 2013 [Link] +0000
Mon, 27 May 2013 [Link] +0000
Thu, 23 May 2013 [Link] +0000
Sun, 19 May 2013 [Link] +0000
Sat, 18 May 2013 [Link] +0000
Fri, 17 May 2013 [Link] +0000
Tue, 14 May 2013 [Link] +0000
Mon, 13 May 2013 [Link] +0000
Sat, 11 May 2013 [Link] +0000
Wed, 08 May 2013 [Link] +0000
title
Expand and Collapse Details in an Excel Pivot Table
Autocomplete Entries With Excel Drop Down List
Show Developer Tab on the Excel Ribbon
Show Percent of Subtotal in Excel Pivot Table
Excel UserForm for Data Entry Demo
How to Calculate Loan Payments with Excel PMT Function
How to Group Text Items in an Excel Pivot Table
Prevent New Pivot Items from Appearing After Manual Filter
Quickly Remove an Excel Pivot Table Field
Sort an Excel Table by Selected Icon or Color
Add Average Marker to Excel Box Plot - Box and Whisker Chart
Build Excel Box Plot With Charting Utility
Create a Simple Box Plot - Box and Whisker Chart - in Excel
How to Adjust the Pivot Table Field List
How to Remove the Page 1 Watermark on Excel Worksheet
Remove and Prevent Automatic Hyperlinks in Excel
Change Pivot Table Values to Vertical Layout for Printing
How to Change Excel Column Headings from Numbers to Letters
Change Pivot Table Report Filter Layout
Find and Replace Line Breaks in Excel
Sum Filtered Excel Table with AGGREGATE or SUBTOTAL
Quickly Delete Objects and Shapes on Excel Worksheet
Create a Calculated Field in Excel Pivot Table
Quickly Clear Data Entry Cells in Excel
Get Mileage from Excel Lookup Table
FixLink author In Main
[Link] contextures List 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
[Link] contextures 1
 Contextures Products
Pivot Power Premium Add-in
UserForms for Data Entry ebook Kit
Contextures Excel Tools Add-in
Data Entry Search Popup
Data Entry Popup
30 Excel Functions in 30 Days eBook Kit

Contextures Sites & News

Contextures Excel Newsletter
Contextures Excel Tips Website
Contextures Excel Blog
Excel Pivot Tables Blog

Other Excel Products

Contextures Recommends

[Link] 06/03/2021
Time-saving tools for pivot table power users
Step by step instructions and videos
Make instant backups, sort sheets, and many more tools
Makes data entry easier when choosing from long list
Select single or multiple items from a listbox, to enter in a single cell
Sample workbook and easy to follow user guide for key Excel functions

Weekly Excel tips, tutorials, videos, and news

Hundreds of tutorials, tips and sample files
Read the Excel tutorials and share your comments
Pivot table tutorials and tips, with comments and questions

Other Excel tools and training, recommended by Debra

[Link] 06/03/2021