Excel Roundup 20150706

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.

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

1. Contextures Posts

In case you missed them, here are the articles that I posted recently:

  • For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.

2. Bullet Charts

Jon Peltier has updated and simplified his instructions for creating bullet charts in Excel. If you make other types of complex charts, you can save time with Jon’s Excel Charting Utility.

3. Export Your Dashboards

If you ever need to export an Excel dashboard to Work, PowerPoint, PDF, XPS or pictures, download a copy of Robert Mundigl’s Dashboard Exporter template. You can export one date range, or several, and save yourself from hours of cutting and pasting.

4. Using COUNTIF

Alan Murray shows 5 ways to use the COUNTIF function. For example, use it with data validation, to prevent duplicates, or set a conditional formatting rule that highlights items that occur three or more times in a list.

5. Introduction to Slicers

Chandoo wrote a great introduction to Slicers, so if you haven’t used that feature yet, or aren’t familiar with all the things that Slicers can do, be sure to read it, and download the sample file.

6. Announcements

  • From July 1 – 10, Jan Karel Pieterse is having a summer sale — get 25% off his Excel utilities – RefTreeAnalyser (easy auditing of formulas) and Excel File Remediation Utility (helps you salvage Excel models with problematic content accumulated during a long editing history)  
    To get your 25% discount, use this coupon code: JKPADS-Summer2015
  • Power Query experts Ken Puls and Miguel Escobar have opened registration for their next online Power Query training. On August 12th and 13th, you’ll have live online training (4 hours per day). Then attend a live online follow-up Q&A session, a week later (Aug. 20). The class size is limited, so register early!


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