Excel Roundup 20140127
We got a Mac in April 1984, when they were first released in Canada – 30 years ago! It’s still in the computer museum in our basement (that’s a fancy term for junk pile).
At an October 1983 sales conference, Fred Gibbons (Software Publishing Corp.), Bill Gates (Microsoft) and Mitch Kapor (Lotus Development) participated in the Macintosh Software Dating Game, hosted by Steve Jobs.
In his introduction, Bill Gates said, “In 1984, Microsoft expects to get half of its revenues from Macintosh software.” I wonder what the percentage is today.
Or watch on YouTube: 1983 Apple Software Dating Game
Here’s what I posted last week:
- Select multiple items from a drop down list, and the matching codes appear in the adjacent cell.
- Change a pivot table setting, so you can apply multiple filters per field.
- Use option buttons to select a survey response, and calculate the total score, based on a lookup table.
- Finally, 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.
Other Excel Articles
Here are a few of the Excel articles that I read last week, that you might find useful:
- Jon Peltier shows how users can select specific data to display in an interactive chart. There’s a screen shot below.
- Is your Excel file big and slow? Jeff Weir suggests a couple of ways to fix things.
- Doug Jenkins tested a few ways to find the maximum absolute value in a range.
- Using option buttons, Oscar Cronquist shows how to highlight groups of data in a bar chart.
- John Gagnon uses calculated fields to show marketing results in a pivot table
- Andrew Wulf describes how he developed the Macintosh spreadsheet software, Trapeze, and how a single bad review brought sales to a halt.
- If you thought that Excel was only for business, Sophie explains how she found romance in a spreadsheet.
- It’s a pain to program Winzip from Excel, and Scott Lyerly shares his Class Wrapper for Winzip, to make the task easier.
- On her Data Savvy blog, Meagan Longoria learns how to fix things after renaming fields in Power Pivot. The Excel Ribbon helped, rather than the Power Pivot Ribbon.
No matter how long you’ve been using Excel, there’s always something new to learn.
- Sign up for one or more of the free Business Analytics webinars offered in the 24 Hour PASS series, sponsored by Microsoft, Cisco and Dell. Topics inlclude: "Advanced Analytics in Excel 2013", "Querying in DAX", and"Predictive Analytics for Absolute Beginners". The online sessions run on Feb 5th and 6th, and you can see the schedule here: 24 Hour PASS Schedule
- Mynda Treacy’s Excel Dashboard course is open for registraion, and I highly recommend this online course, which has excellent content, and great student support from Mynda. Click the banner below, for more information. If you sign up for the course through that link, you can have my Excel Tools add-in as a bonus. Registration closes on Jan 30th.
Just enter the Referral Code – DebraD – in the box just below the Buy Now button, then email me a copy of your receipt, at firstname.lastname@example.org
What Did You Read?
If you read any other interesting Excel articles last week, that you’d like to share, please add a comment below.
Please include a brief description, and a link to the article.