Search Contextures Sites
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 firstname.lastname@example.org
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.
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.
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.
Recommended Excel ToolsThey aren't free, but these Excel tools are a worthwhile investment, so please click on the links to take a look at their features, and decide if they're right for you.
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
- Excel Pivot Table Intro Course
Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2014
All rights reserved.