Excel Roundup 20150420

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

IN this week's roundup, you'll learn about arrays and array formulas, see how to speed up macros, and many more tips.

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

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

Continue reading Excel Roundup 20150420

Excel Roundup 20150413

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

This week, attend a free dashboard webinar, find data with VLOOKUP, create a funnel chart, and many more tips.

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

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

Continue reading Excel Roundup 20150413

Track Project Tasks in Excel

Track Project Tasks in Excel http://blog.contextures.com/

If you're working on an Excel project with a client, or other employees in your company, how do you keep track of everything that needs to be done? If emails are flying back and forth, with questions, and comments, and specification changes, it's easy for things to slip through the cracks. Then, 5 minutes before the deadline, someone realizes that a key piece is missing!

Nobody wants that to happen, so it helps to have a system for keeping track of everything that has to be done.

Continue reading Track Project Tasks in Excel

Excel Roundup 20150406

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

This week, see how to add a table of contents in a workbook, customize the right-click menu, pick a random winner, and many more tips.

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

Continue reading Excel Roundup 20150406

Excel Roundup 20150330

This week, see how to highlight items in a dashboard, change the background colour in a chart, use Excel for project management, and many more tips.

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

Continue reading Excel Roundup 20150330

Excel Roundup 20150323

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

Have you used PowerMap in Excel? Microsoft's Excel team used it to illustrate the White House budget in 3D. You can read the details, and download the Excel file from their blog.

Continue reading Excel Roundup 20150323

Excel Roundup 20150316

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

In this short video, Sara Silverstein shows how to analyze several years of NCAA revenue data, by using a pivot table. Can you predict which sport brings in the biggest revenues?

Or watch on YouTube: Use Excel pivot tables to analyze massive data sets

Contextures Posts

Here’s what I posted recently:

Highlight numbers that are found in another list, with conditional formatting. This example uses lottery numbers, and you could use the same technique for other types of lists, such as names, or dates. For a humorous peek at what other people are saying about spreadsheets, read the latest

Continue reading Excel Roundup 20150316

Excel Roundup 20150309

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

Last week, we saw a preview of Tableau's Elastic app for spreadsheets. This week, you can see another beta add-in – BigPicture, from Palisade. It looks like Visio combined with Excel's built-in drawing tools and SmartArt graphics.

Currently, you can download a free copy of the beta, to try it out (Windows only, Excel 2007 or later).

Watch this short video, to see how it works -- the demo starts at the 1:30 mark.

Continue reading Excel Roundup 20150309

Excel Roundup 20150302

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

Spreadsheets are already fun, but Tableau wants to make them even more exciting, with its newest smartphone app, Elastic. In this video, Tableau's VP of Mobile & Strategic Growth, Dave Story, opens a spreadsheet file (csv format) from his inbox, and shows how Elastic works.

I don't see any information about the expected release date or pricing.

Continue reading Excel Roundup 20150302

Excel Roundup 20150223

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

The cover slide in this presentation, with its 3-D column and pie charts, led me to believe that the content wouldn't be too useful. However, a different person must have prepared the remaining slides, because they have some useful tips.

The last slide shows that the content is from Mike Alexander's book, Excel Dashboards & Reports for Dummies, which was published last year.

Continue reading Excel Roundup 20150223