Excel Roundup 20140929

I’ve seen lots of non-spreadsheet items with “Excel” in their names, such as gum, and bowling gloves, and hand dryers.

However, this is the first time that I’ve seen a product named after a pivot table. Do you think that they help you analyze your data more efficiently? I wonder if they have a women’s version too.

Kenneth Cole REACTION Men’s Pivot Table LE Oxford

Contextures Posts

Here’s what I posted recently:

Other Excel Articles

Here are a few of the Excel articles that I read recently, that you might find useful:

  • To enhance your dashboard, use the tips from Gašper Kamenšek, to show the Top 5 or Bottom 5 results, by clicking a radio button.
  • Bill Jelen (Mr. Excel) shows how to look for 3 specific names, in adjacent cells of a lookup table, by using an array formula that I hadn’t seen before. Watch the video from 1:15 to 2:45, if you’re pressed for time.

Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel.

Practical Numerical Methods for Chemical Engineers: Using Excel with VBA by Richard A. Davis

“This latest 3rd edition continues to expand the breadth of practical numerical methods with over 100 VBA macros for extending Excel’s power for engineering & scientific analysis. Engineers & scientists will find the enhanced coverage of computational tools applicable to a variety of problems in their own disciplines.”

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.”

jankarelpieterse 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)

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.”

modeloff2014 Registration is open 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.

  • Round 1 (online) is Oct. 25th, and Round 2 (online) is Nov. 8th.
  • The Top 16 finalists will compete in New York in December.

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

101excelformulas excelfunctionsheld01

_________________________________

You may also like...

1 Response

  1. JMichels says:

    This formula does not work correctly, it ignores the “Even” part of the syntax. When the two cells have the same amount, the result is always “Higher”. It does work correctly when one cell is higher or lower than the other. The two cells are numeric data.

    =IF(D85=0,,IF(D85>I85,”Higher”,IF(D85<I85,"Lower",IF(D85=I85,"Even",))))

    What is missing or needs to be changed so the results is "Even" when the two cells equal each other?

Leave a Reply

Your email address will not be published. Required fields are marked *