Excel Roundup 20131125
Forget that old-fashioned mouse! Now you can control Excel during a presentation, by using your phone. Well, assuming that you have Excel 2013, and a Windows phone.
There is a link to the Office Remote app download page in the Excel Articles section below.
Here’s what I posted last week:
- Use MAX and IF with multiple criteria, to find the latest date that a product price was changed, for a specific customer.
- Set up a pivot table so it shows missing items, and add temporary data, if necessary.
- No, it’s not the best way to present data, but if you have to make a pie chart, keep it simple and easy to read.
- 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:
- The IT Faculty of the Institute of Chartered Accountants in England & Wales has posted a draft version of their Twenty Principles for Good Spreadsheet Practice, and they would like your feedback.
- Microsoft Research just released its Office Remote application, which lets you use your Windows phone to navigate through an Excel 2013 workbook during a presentation.
- On the Visual.ly blog, someone shared their map of Australia and a column chart, both created by colouring worksheet cells.
- It doesn’t have to be complicated! Learn an easy way to make bullet charts and boxplots in Excel, on the Excel Charts Blog
- If you’re using APIs to pull data for Excel apps, be sure to format the numbers correctly. The Office Developer Team shares some sample code.
- Instead of using macros, add a hyperlink to a shape, for workbook navigation. Mynda Treacy shows the steps.
- When you’re programming an Excel file, it’s nice to have a quick way to open the workbook, with everything unlocked and ready to edit. Scott Lyerly shares his trick for adding a back door to your Excel files
- Do you love pivot tables? Data journalist, Nassos Stylianou loves them too, and shares a few tips on the Digitally Focused blog.
- If you need to calculate the last day of any month, you can use Chandoo’s simple formula.
New Excel Books on Amazon
Here are the latest Excel books on Amazon. I did a technical edit on one of Conrad Carlberg’s books, long ago, and he always covers a topic clearly and completely. I read the first chapter of Data Smart online, and was impressed that the author introduced INDEX and MATCH as key formulas. Then, a few paragraphs later, he touted VLOOKUP as “like MATCH on steroids”, so I’ll have to read more, to see where this ends up!
Decision Analytics: Microsoft Excel, by Conrad Carlberg.
“Carlberg guides you through using decision analytics to segment customers (or anything else) into sensible and actionable groups and clusters. Next, you’ll learn practical ways to optimize a wide spectrum of decisions in business and beyond—from pricing to cross-selling, hiring to investments—even facial recognition software uses the techniques discussed in this book!”
Excel 2013 for Dummies eLearning Kit, by Faithe Wempen
“This complete Excel 2013 package includes a full-color printed book and a For Dummies interactive eLearning course on CD. You'll discover the basics of the Excel interface, how to navigate it, and how to make the most of key features including charts, formulas, functions, macros, and more. Follow the material sequentially or jump in and out as you wish - it's set up so you can learn at your own pace. Throughout, you will benefit from illustrations, animations, voiceover explanations, and the option of closed captioning if you find you learn better when you can read the instructions."
Data Smart, by John W. Foreman
“Not to disillusion you, but data scientists are not mystical practitioners of magical arts. Data science is something you can do. Really. This book shows you the significant data science techniques, how they work, how to use them, and how they benefit your business, large or small. It's not about coding or database technologies. It's about turning raw data into insight you can act upon, and doing it as quickly and painlessly as possible.”
Exploratory Data Analysis in Business and Economics, by Thomas Cleff
“This textbook, “Descriptive Statistics and Modern Data Analysis”, aims to familiarise students of economics and business as well as practitioners in firms with the basic principles, techniques, and applications of descriptive statistics and data analysis. Drawing on practical examples from business settings, it demonstrates the basic descriptive methods of univariate and bivariate analysis.”
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.