Excel Roundup 20140922
If you love Jambalaya, you’ll appreciate the Excel Jambalaya Calculator that Jay Crush has worked on for several years. He just released version 7.0, and you can read about the calculator, and get the file download link, in Judy Walker’s article in the New Orleans Times-Picayune.
I downloaded the file, and you can see a screen shot below. Now, if 150 people drop by for dinner, I’ll be able to cook up a giant batch! Please call ahead, to let me know if you’d like a full plate, or just an 8 oz bowl.
Here’s what I posted recently:
- Use a macro to quickly format numbers in pivot table, based on each field's formatting in the source data.
- Worksheet combo box will not use a list from a named range that is directly based on a formatted table.
- 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:
- Chandoo shows how to use the TEXT function in a SUMPRODUCT formula, to get a total for July sales.
- Excel has several functions to round numbers, and Ken Puls shows how to do the same things in Power Query.
- Neil Saunders finds an error in biological data in Excel. Does it really make our minds lazy?.
- If your chart titles are overlapping the chart labels, watch Jon Acampora’s video to see how to fix the problem.
- Bill Meade uses crib sheets to help remember all the Excel tricks that he’s learned.
- Jeff Weir digs into the Formula Auditing tools, and has suggestions for some improvements.
- See how to create a simple User Defined Function in Excel, by watching Sara Silverstein’s short video.
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
|Financial Modeling for Business Owners and Entrepreneurs, by Tom Y. Sawyer."You’ll learn to create operational and financial models in Excel that describe the workings of your company in quantitative terms."|
|Excel VBA for Financials, 2-day course led by Excel experts, Jan Karel Pieterse and Tony de JonkerThis 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)
|Beginning Power BI with Excel 2013, by Dan Clark"Guides you step by step through the process of analyzing and visualizing your data. Daniel R. Clark, an expert in BI training and a regular speaker on these topics, takes you through each tool in turn, using hands-on activities to consolidate what you’ve learned in each chapter."|
|Registration has opened for this year's ModelOff competition.Test your financial modeling skills against top modelers from around the world. Participants from over 100 countries progress through two Online Qualification Rounds with a Live Finals Event held in New York.
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