Excel Roundup 20150622

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

In this week's roundup, plan your meals, fix dates, multiply cells, refer to tables, and many more Excel tips.

NOTE: Now that summer is here, I'll publish the Excel Roundup once every  two weeks, so you will see the next one on July 6th.

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 20150622

Excel Roundup 20150615

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

In this week's roundup, add custom chart labels, get started with VBA, compare worksheets, get info from hyperlinks, and many more Excel 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 20150615

Excel Roundup 20150608

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

In this week's roundup, build a nested IF formula, improve your dashboards, work with dates, and change a pivot table layout.

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 20150608

Excel Roundup 20150601

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

In this week's roundup, fix drop down lists that allow invalid entries, create an interactive chart, get a free Excel book on Kindle, and much more.

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 20150601

Excel Roundup 20150525

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

In this week's roundup, see how to reverse last and first names, pin a shape to a chart point, learn some Solver history, and more.

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 20150525

Excel Roundup 20150518

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

In this week's roundup, see how to choose a chart type, check formula speed, work with pivot table source data, 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 20150518

Excel Roundup 20150511

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

In this week's roundup, choose a file format, get an Excel book sampler, fix dates, and build an add-in.

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 20150511

Excel Roundup 20150504

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

In this week's roundup, look for formula inconsistencies, save time with keyboard shortcuts, use online Power BI 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 20150504

Excel Roundup 20150427

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

In this week's roundup, make VLOOKUP faster, use keyboard shortcuts, run macros when Excel is closed, 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 20150427

Upcoming Free Online Events for Excel Fans

There are a few upcoming Excel-related events that you might be interested in. These are online sessions, and all of them are free.

1-hour webinar on building Excel dashboards video course covering Excel 2013 fundamentals online conference, with a wide variety of Microsoft-related topics, including Excel

You can read the details below, and watch for the availability dates and deadlines.

Continue reading Upcoming Free Online Events for Excel Fans