Excel Roundup 20150608

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!

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. Excel in the Classroom

If math teacher Mohammed Ladak could only use one piece of software in his classroom, he would choose Excel. See a few examples of how he uses it in lessons.

3. Take Dashboard to Next Level

Watch a video presentation by Stephen Hughes, on Taking Dashboards to the Next Level, hosted by the Excel BI Virtual Chapter of the PASS BA Conference. The video is about an hour long, and the presentation starts at the 4:00 mark.

4. Work With Dates

Doug Jenkins takes a detailed look at how Excel handles the display and entry of dates, and how they’re affected by regional settings.

5. Setting Excel Options

Sumit Bansal shares a few tips for making it easier to work in your Excel files. It’s easier to change settings for #3 and #6 on the Ribbon, and use that manual calculation setting with caution!

6. Build Nested IF Formulas

Glen Feechan breaks down the steps for building a nested IF formula on the worksheet.

There are simple IF and nested IF examples on my IF function page.

7. Find Last Table Row

Excel programming can get a bit tricky, when you’re working with named tables. Zack Barresse shares his sample code to find the last row or column that is part of a named table.

8. Fix the Chart Gap

Ann K Emery shows how to make columns in a chart closer together. It’s a simple step, but can make a big improvement in the chart’s appearance.

9. Answer What If Questions

Mary Ann Richardson sets up a two-variable data table, to get the answer to a “What If” question, then adds conditional formatting, to highlight the top 10 and bottom 10 results.

You can see another example, and a one-variable data table, on my Contextures website.

10. Text Functions in Power Query

Ken Puls builds text functions in Power Query, to match the Excel’s built-in worksheet functions.

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


You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *