Search Contextures Sites
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
Spreadsheet Day 2013
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.
Show Percent Difference in Pivot Table Amounts
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
Check Winning Numbers with COUNTIF Function
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
More Excel Tips
Here are a few more Excel articles that I read this week, that you might find useful:
- Instead of creating an Excel wizard with UserForms, Jordan Goldmeier shows you how to create a spreadsheet-based wizard.
- Can anything possibly be better than a pivot table? It's hard to believe, but Gasper Kamensek says that a PowerPivot pivot table is superior to an Excel pivot table.
- For a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.
- If you work with time and dates in Excel (and who doesn't?), Chandoo has a list of 42 time and date tips for you.
Video: Conditional Formatting Bars
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.
Excel Dashboard Course Recommendation
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.)
Fading Fall Flowers
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.
Recommended Excel Tools
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.
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2014
All rights reserved.