Excel Weekly News from Contextures Oct 22, 2013
Show % Difference + more Excel tips
In this week's Excel news, you'll see how to show percent difference in a pivot table, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
On October 17, 1979, the first version of the VisiCalc spreadsheet application was shipped, and that's why we celebrate Spreadsheet Day on October 17th. I hope that you had a party at your office, and carried on the festivities at home.
In honour of the occasion, I posted a collection of my favourite Excel tweets on my Spreadsheet Day blog, and listed a few interesting spreadsheet articles on my Contextures blog.
With one of the built-in custom calculations in a pivot table, you can quickly show the percent difference between two amounts. In this example, forecast amounts have been entered for each product, and the pivot table shows the % difference between the forecast and the actual units sold.
Click here to see the details: Show Percent Difference in Pivot Table Amounts
The COUNTIF function can check a range of cells, and see if it contains a specific value. For example, type your lucky number in cell D2, and use a COUNTIF formula to see if that number is found in the list of winning numbers. If you have multiple numbers to check, you can use an array-entered COUNTIF formula – press Ctrl + Shift + Enter, instead of just pressing Enter.
Click here to see the details: Check Winning Numbers with COUNTIF Function
Here are a few more Excel articles that I read this week, that you might find useful:
In Excel 2007, data bars were added to the conditional formatting options, and this feature was improved in Excel 2010. Data bars can be used in cells with numbers, to give a quick visual representation of the data.
Watch this short video to see how they work.
For a limited time, Mynda Treacy from My Online training Hub is opening her Excel Dashboard Course, and if you sign up by October 24th, you can get the course for 20% off.
I've been through this course, and highly recommend it. The course is video based, delivered online and is available 24/7. You'll receive comprehensive workbooks and sample dashboards to keep, and there's even an option to download the videos.
Bonus: If you sign up for Mynda's course through one of my links, I'll send you a copy of my new Excel add-in -- Contextures Excel Tools -- when it's ready next month. (If you signed up for one of Mynda's earlier courses through my link, send me an email if you'd like a copy of the new add-in.)
We cleaned out our garden on the weekend, so it will be ready for a new crop next spring. Most of the plants have stopped growing, except for the weeds, of course -- they thrive in any weather! So, it was surprising to see that these lovely purple flowers are still blooming, trailing over the fence from the neighbour's yard.
In addition to all the free
Excel tips and tutorials, there are other Excel tools that you can
invest in. To learn more about the products listed below, click
on the links to take a look at their features, and decide if they're
right for you.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.