{"id":7793,"date":"2016-12-08T00:03:11","date_gmt":"2016-12-07T23:03:11","guid":{"rendered":"\/\/www.myexcelonline.com\/podcast\/?p=849"},"modified":"2024-02-06T16:03:19","modified_gmt":"2024-02-06T15:03:19","slug":"012-financial-modelling-danielle-stein-fairhurst-from-plumsolutions","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/012-financial-modelling-danielle-stein-fairhurst-from-plumsolutions\/","title":{"rendered":"012: Financial Modelling with Danielle Stein Fairhurst from PlumSolutions"},"content":{"rendered":"<div class=\"smart-track-player-container stp-color-f77223-EEEEEE spp-stp-desktop\" data-uid=\"ee274f6a\"><\/div><div class=\"spp-shsp-form spp-shsp-form-ee274f6a\"><\/div>\n<p><span style=\"text-decoration: underline;\"><a href=\"\/\/traffic.libsyn.com\/myexcelonline\/012_-_Financial_Modelling_with_Danielle_Stein_Fairhurst.mp3\" target=\"_blank\" rel=\"noopener\">Listen on Web Browser &gt;&gt;<\/a><\/span><\/p>\n<p>Danielle Stein Fairhurst is an MBA and an expert in Financial Modelling. \u00a0She is the owner of <a href=\"http:\/\/www.plumsolutions.com.au\/\" target=\"_blank\" rel=\"noopener nofollow\">www.PlumSolutions.com.au,<\/a>\u00a0a company\u00a0dedicated to helping Financial Modellers via\u00a0her online courses, training seminars and consulting gigs.<\/p>\n<p>Danielle is also the author of <em><strong><a href=\"http:\/\/amzn.to\/2glLEcG\" target=\"_blank\" rel=\"noopener nofollow\">Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals<\/a>\u00a0<\/strong><\/em>and an expert in her field, who resides in Sydney, Australia.<\/p>\n<p><em>You can subscribe to the show on\u00a0<strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener\">iTunes<\/a><\/strong>\u00a0to get automatic\u00a0updates so you don&#8217;t miss out on these awesome interviews and Excel insights!<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/012-financial-modelling-danielle-stein-fairhurst-from-plumsolutions\/#Danielles_Online_Excel_Courses\" title=\"Danielle&#8217;s Online Excel\u00a0Courses\">Danielle&#8217;s Online Excel\u00a0Courses<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/012-financial-modelling-danielle-stein-fairhurst-from-plumsolutions\/#Danielles_Book\" title=\"Danielle&#8217;s Book\n\">Danielle&#8217;s Book\n<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/012-financial-modelling-danielle-stein-fairhurst-from-plumsolutions\/#Danielles_Excel_Favorites\" title=\"Danielle&#8217;s Excel Favorites\n\">Danielle&#8217;s Excel Favorites\n<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/012-financial-modelling-danielle-stein-fairhurst-from-plumsolutions\/#Interview_Links\" title=\"Interview Links\">Interview Links<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/012-financial-modelling-danielle-stein-fairhurst-from-plumsolutions\/#Connect_with_Danielle\" title=\"Connect with\u00a0Danielle\n\">Connect with\u00a0Danielle\n<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/012-financial-modelling-danielle-stein-fairhurst-from-plumsolutions\/#Listen_to_the_MyExcelOnline_Podcast_on_your_favorite_platform\" title=\"Listen to the MyExcelOnline Podcast on your favorite platform!\">Listen to the MyExcelOnline Podcast on your favorite platform!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/012-financial-modelling-danielle-stein-fairhurst-from-plumsolutions\/#Free_Resources\" title=\"Free Resources!\">Free Resources!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/012-financial-modelling-danielle-stein-fairhurst-from-plumsolutions\/#Thanks_for_Listening\" title=\"Thanks for Listening!\">Thanks for Listening!<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Danielles_Online_Excel_Courses\"><\/span><strong>Danielle&#8217;s Online Excel\u00a0Courses<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/plumsolutions.com.au\/affiliates\/idevaffiliate.php?id=102_2\" target=\"_blank\" rel=\"noopener nofollow\"><strong>7 Days of Financial Modelling<\/strong><\/a>\u00a0is a <strong>FREE Mini-Course<\/strong> where each day you\u2019ll receive a short video jam-packed with Financial Modelling tips, tricks and best practice.<\/li>\n<li><a href=\"https:\/\/plumsolutions.com.au\/affiliates\/idevaffiliate.php?id=102_3\" target=\"_blank\" rel=\"noopener nofollow\"><strong>Financial Modelling in Excel Intermediate<\/strong><\/a> teaches\u00a0how to design and create a user-friendly model which can then be used by anyone with limited knowledge of Excel.<\/li>\n<li><strong><a href=\"https:\/\/plumsolutions.com.au\/affiliates\/idevaffiliate.php?id=102_3\" target=\"_blank\" rel=\"noopener nofollow\">Advanced Financial Modelling in Excel<\/a><\/strong>\u00a0builds on your existing modelling skills and applies new techniques to better analyse financial data, predict revenues and cost and assess risks to justify business decisions.<\/li>\n<li><strong><a href=\"https:\/\/plumsolutions.com.au\/affiliates\/idevaffiliate.php?id=102_3\" target=\"_blank\" rel=\"noopener nofollow\">Online Course Bundle<\/a><\/strong> &#8211; Introduction, Intermediate &amp; Advanced Financial Modelling<\/li>\n<\/ul>\n<p><strong>***<\/strong> Apply the discount code <strong>MYEXCELONLINE<\/strong> in the checkout area to receive a<strong>\u00a0$50 discount<\/strong> on any of the above courses <strong>***<\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Danielles_Book\"><\/span><strong>Danielle&#8217;s Book<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>\n<h4 class=\"title\"><em><strong><a href=\"http:\/\/amzn.to\/2glLEcG\" target=\"_blank\" rel=\"noopener nofollow\">Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals<\/a>\u00a0on Amazon<\/strong><\/em><\/h4>\n<\/li>\n<li><em><strong><a href=\"http:\/\/amzn.to\/2h7mxJn\" target=\"_blank\" rel=\"noopener nofollow\">Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals<\/a>\u00a0on Kindle<\/strong><\/em><\/li>\n<li><strong><em><a href=\"http:\/\/amzn.to\/2uhsU2h\" target=\"_blank\" rel=\"noopener nofollow\">Financial Modeling in Excel For Dummies<\/a> on Amazon<\/em><\/strong><\/li>\n<\/ul>\n<div class='content-column one_half'><a href=\"http:\/\/amzn.to\/2glLEcG\" target=\"_blank\" rel=\"noopener nofollow\"><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-855 size-medium\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/fmodel-215x300.png\" alt=\"\" width=\"215\" height=\"300\" title=\"\"><\/a><\/p><\/div>\n<div class='content-column one_half last_column'><p>&nbsp;<\/p>\n<p><a href=\"http:\/\/amzn.to\/2sQFg3v\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1042 size-medium\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/dummies-239x300.jpg\" alt=\"\" width=\"239\" height=\"300\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/dummies-239x300.jpg 239w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/dummies.jpg 398w\" sizes=\"(max-width: 239px) 100vw, 239px\" title=\"\"><\/a><\/p><\/div><div class='clear_column'><\/div>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Danielles_Excel_Favorites\"><\/span><strong>Danielle&#8217;s Excel Favorites<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><strong>Keyboard Shortcuts:<\/strong>\n<ul>\n<li>CTRL\u00a0+ Z to\u00a0go back or undo<\/li>\n<\/ul>\n<\/li>\n<li><strong>Excel Tip:<\/strong>\u00a0Mixed References for <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"Formulas\" data-wpil-keyword-link=\"linked\">Formulas<\/a> and do not over complicate things<\/li>\n<li><strong>Function:<\/strong>\u00a0<a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/sumif-function-introduction\/\" target=\"_blank\" rel=\"noopener\">SUMIF<\/a> and <a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/sumifs-function-introduction\/\" target=\"_blank\" rel=\"noopener\">SUMIFS<\/a><\/li>\n<li><strong>Excel Add-Ins:<\/strong> <a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/installing-power-query-excel-2010\/\" target=\"_blank\" rel=\"noopener\">Power Query<\/a> and <a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/installing-power-pivot-excel-2010\/\" target=\"_blank\" rel=\"noopener\">Power Pivot<\/a><\/li>\n<li><strong>Online Learning Resource: <\/strong>Excel blogs and newsletters<\/li>\n<li><strong>Excel Books:<\/strong>\n<ul>\n<li><a href=\"http:\/\/amzn.to\/2glRgng\" target=\"_blank\" rel=\"noopener nofollow\">Excel 2016 for Dummies<\/a> on Amazon<\/li>\n<li><a href=\"http:\/\/amzn.to\/2h7sK85\" target=\"_blank\" rel=\"noopener nofollow\">Excel VBA Programming for Dummies<\/a> on Amazon<\/li>\n<li><a href=\"http:\/\/amzn.to\/2glPeDC\" target=\"_blank\" rel=\"noopener nofollow\">Excel Dashboard and Reports for Dummies<\/a> on Amazon<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Interview_Links\"><\/span><strong>Interview Links<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"http:\/\/www.modeloff.com\/\" target=\"_blank\" rel=\"noopener nofollow\">ModelOff.com <\/a>The Financial Modelling World Championships<\/li>\n<li><a href=\"http:\/\/www.plumsolutions.com.au\/articles\/creating-splash-simple-waterfall-charts\" target=\"_blank\" rel=\"noopener nofollow\">Create an Excel Waterfall Chart tutorial<\/a> by Danielle Stein Fairhurst<\/li>\n<li><a href=\"http:\/\/www.eusprig.org\/horror-stories.htm\" target=\"_blank\" rel=\"noopener nofollow\">Spreadsheet horror stories <\/a>by uneducated Excel users \ud83d\ude41<\/li>\n<\/ul>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Connect_with_Danielle\"><\/span><strong>Connect with\u00a0Danielle<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/au.linkedin.com\/in\/daniellesteinfairhurst\" target=\"_blank\" rel=\"noopener nofollow\">LinkedIn<\/a><\/li>\n<li><a href=\"https:\/\/www.linkedin.com\/groups\/1724487\" target=\"_blank\" rel=\"noopener nofollow\">LinkedIn Financial Modelling Group<\/a><\/li>\n<li><a href=\"http:\/\/www.plumsolutions.com.au\/workshops\/meetup\" target=\"_blank\" rel=\"noopener nofollow\">Financial Model Meetups worldwide\u00a0<\/a><\/li>\n<\/ul>\n<h2 class=\"text-center\"><span class=\"ez-toc-section\" id=\"Listen_to_the_MyExcelOnline_Podcast_on_your_favorite_platform\"><\/span><strong>Listen to the MyExcelOnline Podcast on your favorite platform!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/itunes.apple.com\/us\/podcast\/my-excel-online-podcast\/id1019164720?l=en\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1057 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/available-on-itunes-logo-300x112.jpg\" alt=\"\" width=\"300\" height=\"112\" title=\"\"><\/a><\/p>\n<p><a href=\"http:\/\/www.stitcher.com\/s?fid=69832&amp;refid=stpr\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1051 size-full aligncenter\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Stitcher-button.png\" alt=\"\" width=\"300\" height=\"150\" title=\"\"><\/a><\/p>\n<p><a href=\"https:\/\/play.google.com\/music\/m\/I5hjkav2s3dgtv72ovqol3qbgre?t=My_Excel_Online_Podcast&amp;pcampaignid=MKT-na-all-co-pr-mu-pod-16\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1052 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/google-300x116.png\" alt=\"\" width=\"300\" height=\"116\" title=\"\"><\/a><\/p>\n<p><a href=\"https:\/\/www.iheart.com\/show\/263-my-excel-online-podc\/\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1064 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/iheart-300x80.png\" alt=\"\" width=\"300\" height=\"80\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Free_Resources\"><\/span><strong>Free Resources!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<ol>\n<li><strong>Excel Tutorial <\/strong><strong>Blog<\/strong><strong>:<\/strong> Learn all the essential tips to get you up and running and using Excel to its full potential.\u00a0 Choose from Formulas, Pivot Tables, Charts, Analysis, Shortcuts, Macros plus more &gt;&gt;\u00a0<a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/\" target=\"_blank\" rel=\"noopener\"><strong>CLICK HERE TO VIEW<\/strong><\/a><\/li>\n<\/ol>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li><strong>Free Excel Webinars:<\/strong> Learn the power of Pivot Tables and Power Query with our free webinars. <strong>\u00a0<a href=\"\/\/www.myexcelonline.com\/meo-staging\/115-23.html\" target=\"_blank\" rel=\"noopener\">CLICK HERE TO VIEW NOW<\/a><\/strong><\/li>\n<\/ol>\n<p><a href=\"\/\/www.myexcelonline.com\/meo-staging\/115-23.html\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1015 size-large\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/Free-Webinars-1024x512.jpg\" alt=\"\" width=\"1024\" height=\"512\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Thanks_for_Listening\"><\/span><strong>Thanks for Listening!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Thank you for joining me this week. If you have some feedback that you\u2019d like to share, then please leave a note in the comment section below!<\/p>\n<p>If you enjoyed this episode, please\u00a0<strong>share<\/strong>\u00a0it using the social media buttons you see at the bottom of the post.<\/p>\n<p>Also,\u00a0<strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener\">please leave an honest review for The MyExcelOnline Podcast on iTunes<\/a>!<\/strong>\u00a0Ratings and reviews\u00a0are\u00a0<strong>extremely<\/strong>\u00a0<strong>helpful<\/strong>\u00a0and greatly appreciated! They do matter in the rankings of the show, and I read each and every one of them.<\/p>\n<p>If you have any questions you can send me an email to <strong><a href=\"mailto:podcast@myexcelonline.com\" target=\"_blank\" rel=\"noopener\">podcast@myexcelonline.com<\/a><\/strong><\/p>\n<p>Don\u2019t forget to subscribe to the show on\u00a0<strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener\">iTunes<\/a><\/strong>\u00a0to get automatic\u00a0updates so you don&#8217;t miss out on these awesome interviews and Excel insights!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Listen on Web Browser &gt;&gt; Danielle Stein Fairhurst is an MBA and an expert in Financial Modelling. \u00a0She is the owner of www.PlumSolutions.com.au,\u00a0a company\u00a0dedicated to helping Financial Modellers via\u00a0her online courses, training seminars and consulting gigs. Danielle is also the author of Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals\u00a0and an expert [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":7713,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[334],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7793"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=7793"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7793\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/7713"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=7793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=7793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=7793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}