Excel Roundup 20141027
If you'd like Microsoft to make Power Pivot available in all the Office 2013 and Office 365 packages, please sign the Friends of Power Pivot petition.
And if you're lucky enough to have the Power BI tools, Kasper de Jonge outlines how to get started with Power Pivot (Part 1). Watch the short video below, to see the steps.
Here’s what I posted recently:
- Use formulas and data arrangement to compare high and low scores in a clustered stacked chart. Download the sample file to see how it works.
- Show a running total in a pivot table, by date or any other field. Watch the short video, to see the steps.
- For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
Other Excel Articles
Here are a few of the Excel articles that I read recently, that you might find useful.
- Sumit Bansal shows 2 ways to extract usernames from a list of email addresses. And if you have Excel 2013, you can use the new Flash Fill feature..
- Jan Karel Pieterse is putting together an advanced Excel VBA course, and would like your input, in his survey.
- When he belatedly heard about Spreadsheet Day, Steven Levy republished his 30-year-old article on the significance and dangers of spreadsheets.
- Paolo Lenotti shares 5 Excel power hacks, to save you time and aggravation
- Jeff Weir is working on a system to create structured references for pivot tables.
- Adam Roberts found a way to get the colors from a Conditional Formatting scale. The ColorIndex property would be more accurate, but it's an interesting approach..
- If the built-in table row formatting doesn't meet your needs, Andrew Engwirda shows how to do alternate, alternate row banding, with conditional formatting
- Susan Harkin offers 6 "been around the block" tips for working more efficiently in Excel. Unfortunately, #5 doesn't work in Excel 2013 – that feature was moved to the Ribbon.
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
Advanced Excel Essentials, by Jordan Goldmeier – Pre-order today, for the Wednesday, Oct. 29th release
"For Intermediate or advanced excel users who wish to learn how to be more productive and develop more powerful applications…starts from the assumption that you are well-versed in Excel—and builds on your your skills to take them to the advanced level."
|LONDON||Abbot Katz is presenting a series of Excel courses in London on consecutive Monday evenings, November 3-24, at the offices of the Guardian newspaper near the Kings Cross station|
Excel Sumo -- The sporting contest of Microsoft Excel Spreadsheets, Formula and Add-Ins
Enter your best Excel solution in the Excel Sumo tournament by Nov 3, 2014. Free registration - read the details here
There are four categories of Excel Sumo for your submission (you can choose multiple): Business and Productivity, Lifestyle, Fun and Entertainment, Technical (e.g. VBA, Macros, Data Visualization)
|Excel VBA for Financials, 2-day course led by Excel experts, Jan Karel Pieterse and Tony de Jonker
This Dutch course is specifically aimed at the Finance professional. It has no frills, and no technical mumbo-jumbo – just the VBA you need to achieve more success in your daily job.
Date: November 19 and December 3, 2014
Location: Utrecht (Netherlands)
Share Your Events and Articles
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please share a link in the comments below, with a brief description. Thanks!
Links to Recent Excel Books on Amazon.com