Budget Scenarios+ more Excel tips
Excel Weekly News from Contextures October 14, 2014
In this week's Excel news, you'll see how to create a budget with multiple scenarios, and much more. Thank you for reading the Excel news, and I hope that you are enjoying the Excel articles. If you have suggestions for future topics, please let me know.
- Debra - firstname.lastname@example.org
- Advanced Filter Problem in Excel 2013
- Pivot Table Intro and Resources
- More Excel Tips
- Excel Announcements
- Video: Store and Show Multiple Scenarios
- Weekly Photo: A Very Fancy Dress
- Excel Tools
Mynda Treacy's Excel Dashboard course is open for registration, and you can save 20% if you sign up by this Thursday, October 16th.
I highly recommend this online course, which has excellent content, and great student support from Mynda. Her new Power Pivot course is available too, and you can get both courses in a bundle. I'm going through her Power Pivot course right now, and it's a great way to get started with this powerful Excel feature.
BONUS: If you sign up for the course through this link, you can have a copy of any one of my Contextures Products.
When you sign up, type DebraD in the Code box, and email me your receipt number.
Advanced Filter Problem in Excel 2013
Last week, I ran into a strange problem, while working on a simple Advanced Filter macro in Excel 2013. Sometimes the macro ran correctly, and at other times it showed an error message, for no apparent reason. After much trial and error, I finally solved the problem, and it all depended on which cell was selected. Excel can be a little frustrating at times!
Click here to see the details: Advanced Filter Problem in Excel 2013
Pivot Table Intro and Resources
Whether you're just getting started with pivot tables, or looking for advanced tips, you'll find something interesting in the articles that I've published on Jon Peltier's Excel charting website.
Click here to see the details: Pivot Table Intro and Resources
More Excel Tips
Here are a few of the Excel articles that I read recently, that you might find useful:
- Chandoo created an interactive chart to compare the top 100 cities from 2 time periods, from his website visitor data. Is your city in the list? Mine is!
- Christy Perry shows how to format numbers and dates within a formula, and there is a handy table of available formats.
- Bill Jelen says Excel will calculate faster if you use a laser printer. If that's not in your budget, he has a workaround too..
- Paul Turley uses VBA and a Power Pivot table to show comments in a pivot table
- Microsoft's James Marshall gives a quick tutorial on creating custom maps with Excel and Power Map.
- Finally, for a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
Here are some upcoming events, courses, recently published books, and other new items, related to Excel:
- New Book: Practical Numerical Methods for Chemical Engineers: Using Excel with VBA by Richard A. Davis “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.”
2-Day Course (Dutch): Excel VBA for Financials, 2-day course (in Dutch), led by Excel experts, Jan Karel Pieterse and Tony de Jonker. This 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)
Video: Store and Show Multiple Scenarios
With Excel Scenarios, you can store different sets of values (up to 32 cells) in a workbook. Then, without any programming, you can switch between the saved values. In this example, we store budget projections for two departments. View and print one department's budget, and then switch to the other department, all in the same cells.
A Very Fancy Dress
It's nice to do something different, after working in Excel all day, and recently I've been sewing. My project was a fancy dress for my granddaughter's Barbie doll, and it's finally finished. It's loosely modelled on Elsa's dress from the Frozen movie -- every 4-year-old girl's favourite. I hope you have some creative, non-Excel, hobbies too!
Recommended Excel Tools
In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, click on the links to take a look at their features, and decide if they're right for you.
- Contextures Excel UserForm Course
- Contextures Excel Tools Add-in
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- FastExcel V3
- Xtreme Pivot Table course
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.