direct tag

direct tag

direct tag

direct tag

direct tag

direct tag

direct tag

direct tag

direct tag

Open Loops 6/26/2015

On Fridays I pull the best of my blog readings to share with readers. Topics can come from anywhere, and cover anything. This week I highlight articles on

Checking whether you are getting the Internet speeds you are paying for
Cleaning water bottles
S… Continue reading

direct tag

direct tag

CP037: Error error on the wall, How do I fix you all? – Understanding & Fixing Excel Errors

In the 37th session of Chandoo.org podcast, Let’s debug ’em #VALUEs & #N/As.

What is in this session?

In this podcast,

  • Introduction to Excel formula errors
  • The easy kind: syntax errors
  • The triky ones: # ERRORs
  • Fixing errors – using IFERROR & ISERROR
  • Error checking & debug options
  • Using Errors deliberately – charts & data validation
  • A challenge for you – produce #NULL error
  • Conclusions

Continue reading

direct tag

direct tag

Introduction to Slicers – What are they, how to use them, tips, advanced techniques & interactive reports using Excel Slicers

Slicers are one of my favorite feature in Excel. And here is a quick demo to show why they are my favorite.

Slicers – what are they?

Slicers are visual filters. Using a slicer, you can filter your data (or pivot table, pivot chart) by clicking on the type of data you want.

For example, let’s say you are looking at sales by customer profession in a pivot report. And you want to see how the sales are for a particular region. There are 2 options for you do drill down to an individual region level.

  1. Add region as report filter and filter for the region you want.
  2. Add a slicer on region and click on the region you want.

With a report filter (or any other filter), you will have to click several times to pick one store. With slicers, it is a matter of simple click.

Read more to learn all about slicers Continue reading

direct tag

direct tag

direct tag

direct tag

direct tag

direct tag

direct tag