Search Contextures Sites


Newsletter Index


Excel news
by email




30 Excel Functions in 30 Days




Contextures News - Index - 2013

This is an index to past issues of the Excel Weekly News from Contextures. The newsletters are posted here approximately one month after the email date. Email subscribers have exclusive access to the content when it is first published.

To get each new issue by email, as soon as it is published, please sign up for the Excel Tips newsletter, using the form at the left.




  • 2013-06-25 -- See how a UserForm works, group text items in a pivot field
  • 2013-06-18 -- Create a simple box plot, block new items in a filtered pivot field
  • 2013-06-11 -- Adjust pivot table field list, interactive functions list
  • 2013-06-04 -- Nested IF functions, find and SUBSTITUTE line breaks


  • 2013-05-28 -- Total filtered data with AGGREGATE, change pivot table filter layout
  • 2013-05-21 -- Delete shapes, use Slicers
  • 2013-05-14 -- Move a large pivot table, calculate annual savings
  • 2013-05-07 -- Drop down list with symbols, chart shortcut key


  • 2013-04-30 -- Find and prevent errors, problems adding slicers
  • 2013-04-23 -- Conditional Formatting in pivot table
  • 2013-04-16 -- Multiple totals in pivot table
  • 2013-04-09 -- Drop down symbols, chart shortcuts
  • 2013-04-02 -- Custom sort, divide without formulas


  • 2013-03-26 -- Limit dates to a specific range, average based on multiple criteria
  • 2013-03-19 -- Running totals in pivot table, prevent invalid entries in combo boxes
  • 2013-03-12 -- Get accurate count in a pivot table, create a dependent combo boxes
  • 2013-03-05 -- Group numbers by tens in a pivot table, create a quick list of dates


  • 2013-02-26 -- Show message at top of sheet, quick grand totals
  • 2013-02-19 -- Round to a nickel, print new invoices, paste values shortcut
  • 2013-02-12 -- Date picker tool, pivot table Index
  • 2013-02-06 -- New FORMULATEXT function, chart baselines


  • 2013-01-29 -- Ugly charts, free Excel audit tool, custom ribbon tab intro
  • 2013-01-22 -- Create a custom Ribbon tab, test formula dependencies
  • 2013-01-15 -- Find records with unmatched amounts, get the basics of big data
  • 2013-01-08 -- Keep numbers aligned when Excel is zoomed, quick keyboard shortcuts



Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

Search Contextures

Search Contextures Sites





Privacy Policy


Contextures Inc., Copyright 2015
All rights reserved.