Excel Worksheet Navigation Tips

Excel Worksheet Navigation Tips http://blog.contextures.com/

It can be a real pain to find a specific sheet, if an Excel file has lots of worksheets. If I'm making a big file for a client, I'll often colour groups of sheet tabs, to they're easier to find. Then, if you want the admin lists sheets, look for the red group.

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

Continue reading Excel Worksheet Navigation Tips

Excel Roundup 20150817

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

In this week's roundup, take the pivot table survey, learn new chart tricks, see what's new in Power BI Desktop, and much more.

We're on our summer schedule now, so the next roundup will be published on Monday, August 31st.

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

Continue reading Excel Roundup 20150817

Excel Roundup 20150803

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

In this week's roundup, see the results from last week's Excel survey, find a seat for everyone, compare Excel and Power BI, and more.

We're on our summer schedule now, so the next roundup will be published on Monday, August 17rd.

Continue reading Excel Roundup 20150803

Excel Roundup 20150720

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

In this week's roundup, let me know if you like the version of Excel that you're using at work, get productivity tips, add a sneaky filter to a pivot table, and more.

We're on our summer schedule now, so the next roundup will be published on Monday, August 3rd.

Continue reading Excel Roundup 20150720

Copy Numbers Only in Excel

Copy just the numbers in Excel http://blog.contextures.com/

Someone emailed me recently, asking how to copy just the numbers, from a column that also contained some blank cells. The goal was to paste those numbers in another location, in a solid block, without all the blanks.

Continue reading Copy Numbers Only in Excel

Excel Roundup 20150706

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

In this week's roundup, create bullet charts, export dashboards, use the Rank feature in pivot tables, and many other Excel tips

We're on our summer schedule now, so the next roundup will be published on Monday, July 20th.

Continue reading Excel Roundup 20150706

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!

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!

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