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

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

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

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

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

Excel Roundup 20140811

101 excel formulas

Does Ed Bott include your favorites in his list of 6 Excel power tips?

He included one of my favourites – Paste As Values. However, I usually Paste Values by dragging with the right-mouse button pressed, instead of using a keyboard shortcut. You can see that technique in the very short video below. Do you use the mouse or keyboard for Paste As Values?

Or watch on YouTube: Change Excel Formulas to Values With Mouse

Continue reading Excel Roundup 20140811

Excel Roundup 20140728

Power Query for Power BI and Excel

The Office 365 Garage Series has a video on what’s new in the Office Apps, and they demonstrate some cool new features. The Excel App is mentioned at the 7:12 mark, when they look at the new APIs for formatting.

However, at the 3:12 mark, they downplay the old development methods, including VBA and COM, and rave about the new methods -- HTML and JavaScript, that are used for the online versions of Office.

Apparently it’s almost impossible to find people who are still working in the older development platforms. What do you think of the chart they use to

Continue reading Excel Roundup 20140728