SPECIALISTS IN FINANCIAL MODELLING

Q&A on writing “Financial Modeling in Excel for Dummies”

Now that my new book “Financial Modeling in Excel for Dummies” is finally available, a lot of people have been asking me about the writing process and how it all came about. I think what they want to know but are too polite to ask is “what on earth were you thinking?” and I must admit that I asked tha
(more…)

Financial Modeling for Dummies

I am very excited to announce that I’ve just signed with my existing publisher, Wiley to start work on a new book Financial Modeling in Excel For Dummies. Yes, that’s not how I normally spell “modelling” I know, but they tell me a large part of the world spells it that way. And apparently that’s a pretty big market 🙂

(more…)

Webinar: Infographics in Excel

Nothing conveys complex information more quickly and effectively than a well-built and visually appealing infographic.  They are designed to entertain as well as inform, and the popularity of the infographic in social media has made them an effective way to distill complex information and draw attention to issues that may have otherwise been overlooked.

(more…)

Three Ways to Split Data without Using Power Query

I was only kidding. One of them IS Power Query. Seeing as Power Query is one of the best things to happen to Excel data analysis since the invention of the …. PivotTable, how could I possibly write about splitting data without mentioning Power Query? Note that Power Query is now confusingly called Get and Transform in Excel 2016 but I’m going to stick with the name Power Query – for now.
(more…)

Webinar: Scenario Tools in Excel

During this webinar, online trainer, Danielle Stein Fairhurst led us on a short technical demonstration of how to create scenarios using plain Excel without any add-ins or other software. Reduce uncertainty in decision making using built-in standard Excel tools to reduce volatility in outcomes by performing sensitivity and scenario analysis to mitigate risk. Danielle demonstrated tools such as manual selection, data tables and scenario manager, and then took some brief questions relating to scenarios from the general attendees.

You can view the recording below.  The recording features several Excel files and if you would like a copy of the accompanying Excel files as well as the Power Point Slides, please enter your details to access the Files.

 

Which version of Excel am I using?

No, it’s not a silly question and since the “Modern Excel” was introduced in 2010, the changes have been pretty subtle and it can be a little difficult to tell the difference.

(more…)