Excel Roundup 20160208

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

In this week's roundup, find Excel help, new functions, Excel conferences, and much more.

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

Continue reading Excel Roundup 20160208

Excel Roundup 20160201

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

In this week's roundup, formula challenge, better charts, fixing numbers, and much more.

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

Continue reading Excel Roundup 20160201

How to Fix Excel Numbers That Don't Add Up

Fix Numbers That Don’t Add Up http://blog.contextures.com/

If you download bank statement data into Excel, or copy numbers from a website, those numbers might not add up correctly. The bank data can look like numbers, but Excel sometimes sees those numbers as text -- not real numbers.

You can fix the numbers manually, as shown in the video below, or use a macro to automate the fix.

Continue reading How to Fix Excel Numbers That Don't Add Up

Excel Roundup 20160125

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

In this week's roundup, Data Insights Summit, status bar messages, choose a chart, and much more.

Continue reading Excel Roundup 20160125

Excel Roundup 20160118

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

In this week's roundup, random numbers, big data, floating forms, chart labels and more.

Continue reading Excel Roundup 20160118

Excel Roundup 20160111

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

In this week's roundup, number formatting trick, pivot chart layout, spreadsheet comedy, and much more.

Continue reading Excel Roundup 20160111

Excel Roundup 20160104

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

Welcome back, and I hope you enjoyed your holiday break! It's taking most of my brain power to type 2016, instead of 2015, so this will be a short roundup, to get things rolling again. If you subscribe to my newsletter, the next issue will be sent on January 12, 2016.

Continue reading Excel Roundup 20160104

Excel Roundup 20151214

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

In this week's roundup, bad dashboards, new Workday function, calculation speed and much more.

Continue reading Excel Roundup 20151214

Excel Roundup 20151207

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

In this week's roundup, KPI dashboards, pricing lookups, autofit for merged cell rows, and more.

Continue reading Excel Roundup 20151207

Excel Roundup 20151130

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

In this week's roundup, prevent errors, break links, register for an Excel summit, download an Advent calendar, and more.

And it's Cyber Monday, so my Pivot Power Premium add-in is 20% off, until the end of the day. There are a few other Excel sales too, so check them out on my What's New page.

Continue reading Excel Roundup 20151130