In this week's roundup, plan your meals, fix dates, multiply cells, refer to tables, and many more Excel tips.
NOTE: Now that summer is here, I'll publish the Excel Roundup once every two weeks, so you will see the next one on July 6th.
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!
1. Contextures Posts
In case you missed them, here are the articles that I posted recently:
- Download my free Excel weekly meal planner - select meal items and print a shopping list. Functions calculate costs, with a pivot table and macro for the shopping list.
- For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
2. Fix Dates That Are Text
On the CFO blog, Bill Jelen shows 3 easy ways to change text dates into real dates
3. Excel Table References
Zack Barresse and Kevin Jones wrote a very comprehensive article on how to use structured referencing with Excel Tables. It covers both worksheet references, and VBA.
4. Number Formatting
Ann K Emery demonstrates a few quick ways to format numbers, and uses conditional formatting to highlight some of them.
5. Renaming Sheets
Instead of writing complex VBA code to let users rename a sheet, Doug Glancy taps into the power of the built-in Rename Sheet dialog box, and lets it do the heavy lifiting.
6. What is the Need?
Dan Harrison reminds us to validate the real business requirements, before building something in Excel. What someone asks for might not be what they really need!
As you know, Excel can meet all kinds of needs -- Kat Zhang uses Excel to outline her books, color coding the cells to keep track of plots, acts, and characters.
7. INDEX Function Examples
John Micheloudis uses the INDEX function with other functions, to get the sum or average for a range of cells
8. Excel is the Best
Rob Collie, from PowerPivot(Pro), explains why Excel, and its Power BI apps, make Excel the world's best data tool. Read the comments too, for a lively discussion.
9. Apply an Exchange Rate
Chandoo shows how to multiply a group of cells by a set amount, to see the values with an exchange rate applied. I think the rate should be about 0.88 though, to convert US dollars to Euros.
10. Quick Tips
To help you save time when adding things up, Marie McCooey shares her quick tips for AutoSum.
And if you're looking for more ways to get things done more quickly in Excel, try these 10 productivity tips from John Micheloudis