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.

Dashboard Course

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!

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.