New Workbook Based On Old One

xtremepivot table giveaway www.pivot-table.com

It's almost Halloween, and perhaps you're familiar with the horror story that I'm about to tell you. (And there is a treat at the end of the tale too.)

One day, not too long ago, Dr. Frankexcel needed to create new workbook. Instead of building the new workbook from scratch, Dr. F had a brilliant plan – open an old workbook, and use it as the base for the new file. Just open the old file, then quickly do a Save As, to create the new file, without damaging the existing one.

What could possibly go wrong? Bwaahhhaahhaa!

(adsbygoogle =

Continue reading New Workbook Based On Old One

Excel Roundup 20141027

If you'd like Microsoft to make Power Pivot available in all the Office 2013 and Office 365 packages, please sign the Friends of Power Pivot petition.

And if you're lucky enough to have the Power BI tools, Kasper de Jonge outlines how to get started with Power Pivot (Part 1). Watch the short video below, to see the steps.

(adsbygoogle = window.adsbygoogle || []).push({});

Continue reading Excel Roundup 20141027

Excel Roundup 20141020

In this video, sports scientist, John Lythe, shows how you can create 4 dynamic Excel charts in 10 minutes.

Or watch on YouTube: Make Four Dynamic Excel Charts in 10 Minutes

Continue reading Excel Roundup 20141020

Excel Roundup 20141013

Weekly Excel Roundup http://blog.contextures.com/

The Power Map feature was improved last month, and this short video shows some of the things you can do with custom maps in Excel.

Or watch on YouTube: 6 Cool Ways To Use Custom Maps in Power Map

Continue reading Excel Roundup 20141013

Excel Roundup 20141006

Weekly Excel Roundup http://blog.contextures.com/

In this video, Annie Cushing shows how to create a scrolling table, by using the INDEX function and a scroll bar form control. This technique would work nicely in a dashboard, where space is limited.

For more dashboard tips, take a look at Mynda Treacy’s Excel Dashboard course which has just opened for registration, until Oct. 23rd. Details are in the Announcements section, below.

Continue reading Excel Roundup 20141006

Excel Roundup 20140929

conditional format color

I’ve seen lots of non-spreadsheet items with “Excel” in their names, such as gum, and bowling gloves, and hand dryers.

However, this is the first time that I’ve seen a product named after a pivot table. Do you think that they help you analyze your data more efficiently? I wonder if they have a women’s version too.

Kenneth Cole REACTION Men's Pivot Table LE Oxford

Contextures Posts

Here’s what I posted recently:

Color data entry cells with conditional formatting, to make them easy to find Use GetPivotData function to pull the total amount from a pivot table on specific

Continue reading Excel Roundup 20140929

Excel Roundup 20140922

excel jambalaya calculator http://blog.contextures.com/

If you love Jambalaya, you’ll appreciate the Excel Jambalaya Calculator that Jay Crush has worked on for several years. He just released version 7.0, and you can read about the calculator, and get the file download link, in Judy Walker’s article in the New Orleans Times-Picayune.

I downloaded the file, and you can see a screen shot below. Now, if 150 people drop by for dinner, I’ll be able to cook up a giant batch! Please call ahead, to let me know if you’d like a full plate, or just an 8 oz bowl.

Continue reading Excel Roundup 20140922

Excel Roundup 20140915

Are you brave enough to enter the ModelOff competition, that tests your financial modeling skills in Excel?

To help you decide if you’d like to enter, there are workbooks with questions from previous years, available for download. For example, can you find and fix the errors in a workbook?

Continue reading Excel Roundup 20140915

Excel Roundup 20140908

event planning with Excel blog.contextures.com

If you have Excel, do you even need any other programs? In this week’s video, David Buchanan, from the Chef’s Resources website, shows how to use an Excel workbook to plan every step in an event, from the idea phase, to prep and ordering, to recipes. I like his description of this process as "mental mise en place" worksheets, to help you organize tasks.

Continue reading Excel Roundup 20140908

Excel Roundup 20140825

excel roundup 20140825 http://blog.contextures.com/

There is a free app available for Excel (2013 or Online version), that lets you create 8 different chart types, including some that aren’t standard Excel charts, such as box plots. The app is called XLMiner Data Visualization, and it’s created by Frontline Systems, which also makes the Solver add-in.

If you log in to your Microsoft account, you can download and install the app from the Microsoft Store. Then select data, and the chart appears in the app’s window. In the screen shot below, you can see the box plot chart that I created, in just a few seconds.

Continue reading Excel Roundup 20140825