Search Contextures Sites


Newsletter Index


Get weekly Excel tips from Debra




30 Excel Functions in 30 Days




Contextures News

Excel Weekly News from Contextures Jan. 22, 2013

Create a custom Ribbon tab, test formula dependencies, and other tips, in this week's Excel news from Contextures.

 -  Debra

Create Custom Tab for a Workbook

If a workbook contains macros, you can add a custom tab on the Excel Ribbon, with buttons to run those macros.

In this video you can see how to set up the workbook's macros, and use the free Custom UI Editor to create the Ribbon tab. I avoided working with the Ribbon for a long time, but this tool makes it easy to get started. Take the plunge, and try adding a custom tab for one of your workbooks.

To see the details, and to download the sample file, click here: Excel Ribbon - Add a Custom Tab

Open Excel 2013 With a Blank Template

Are you using Excel 2013 yet? It's not in the stores, but you can download Office 2013 if you have an MSDN or Technet subscription, so I've been working with it, and testing the new features.

When you open Excel 2013, it shows a selection of templates, and you can pick one to work with. I prefer using the blank template, and found a way to open that, instead of seeing all the templates.

To see the instructions for turning off the templates window, click here: Open Blank Workbook in Excel 2013

Dependencies in Formulas and UDFs

On his UDF and Excel Performance Stuff blog, Excel MVP Charles Williams runs a few tests, to see how and when formulas and User Defined Functions (UDFs) are recalculated.

Charles recommends staying away from Volatile functions, and reports another bug with the EVALUATE function.

pivot subtotals video

To see my written instructions, and the code, click here: Volatile Dependencies

Excerpts From New Data Viz Book

Andy Kirk, from Visualising Data, is the author of a new book, Data Visualization: a successful design process.

pivot subtotals video

Andy has a couple of excerpts on his website that you can download, in pdf format. Aside from the interesting content, the excerpts will give you an idea of Andy's writing style, and the type of content in the book, if you're thinking about buying it.

Visit Andy's site to download the files: Sample Excerpts from Data Visualization

And while you're there, take a look at his excellent list of Visualization Tools and Resources.

Excel Dashboard Course Re-opens

Mynda Treacy from My Online training Hub is re-opening her Excel Dashboard course, and if you sign up by January 30th, you can get it for 20% off. The course is video based, delivered online and is available 24/7. You also receive comprehensive workbooks and sample dashboards to keep. There's even an option to download the videos.

The previous classes were very successful, and you can read the glowing reviews from the students, who loved all the techniques that they learned in the course, and are using them to impress their colleagues. Click here to find out details of the course, read the student comments, and watch the 'behind the scenes' video that shows you what you'll receive as a member.

Remember, if you sign up by January 30th, you can get the dashboard course for 20% off.

Learn Excel Dashboards

Contextures Products

Save time with our "Done For You" Excel products.


Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.



Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.