Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
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

December

June

  • 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

May

  • 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

April

  • 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

March

  • 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

February

  • 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

January

  • 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.