Danielle Stein Fairhurst
Microsoft MVP, Excel & Financial Modelling specialist
Sydney, Australia
Actions
Danielle Stein Fairhurst is a Microsoft MVP and the author of “Using Excel for Business and Financial Modelling” (3rd edition, 2019) and “Financial Modeling in Excel For Dummies” (2nd edition, 2022) She is a LinkedIn Learning Instructor and in 2022 she was awarded the “Lifetime Achievement Award” at the Financial Modelling Summit. Danielle founded the Financial Modellers’ Meetup groups which attracts participants from all over the world as well as a LinkedIn forum with over 180,000 members. An advocate for women in finance, she was on the Diversity Council for the ModelOff Financial Modeling World Championships and founded the Women in Financial Modelling online community. She is a Master Financial Modeler (FMI), holds a Master of Business Administration (MBA) from Macquarie Graduate School of Management (MGSM) and has taught management accounting subjects at the University of Sydney.
Area of Expertise
Topics
Dynamic Arrays - an Excel modelling game changer
Traditional Excel modelling has always emphasised maintaining consistency in formulas and performing calculations in separate contiguous blocks. However, Excel's dynamic array functions completely revolutionise the game, doing away with the possibility of inconsistent formulas and unlocking the infinite potential for constructing robust, error-free and totally dynamic financial model masterpieces!
Using Excel for Big Data
For decades, Excel has enjoyed the global dominance in the spreadsheet and analytical software market but with billions of rows of data being created every day, how does the humble Excel spreadsheet cope? Hear from Microsoft MVP, Excel modelling specialist, and author of “Using Excel for Business Analysis” and “Financial Modeling in Excel for Dummies”, Danielle Stein Fairhurst as we explore the competitive application of Modern Excel to the world of Big Data and data visualisation.
• Big data concepts
• History of the Excel spreadsheet
• New tools and features of Modern Excel
• Competitor analysis – is Excel dead?
• Learn how Excel fits into the world of big data
• Looking forward to the future of Excel
Infographics in Excel
Learn to find the meaning in your data and convert it to powerful visuals to tell your story using the standard Excel tools you already have.
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 distil complex information and draw attention to issues that may have otherwise been overlooked.
Explore your data to find the underlying story using nothing but standard Excel tools, and then convert the information into powerful visuals which tell the story. We’ll introduce the principles of good design, and how to create an informative and compelling infographic that will convey your message simply and clearly.
• Infographics in the age of big data
• Design principles
• Getting your message across
• New tools in Excel for Microsoft 365
• Working with dynamic data to make infographics customizable and updateable
Data Visualisation and Storytelling / Dashboards in Power BI
In the age of self-serve business intelligence, with tools to able to generate and analyse large quantities of data, having the skills to analyse and communicate the output of data has never been more in demand. Whilst the Power BI interface can create visuals quickly and easily, it is up to the user to ensure that they are meaningful and convey the message effectively. Report builders should not only be able to create visuals, but they also need the skills to uncover the hidden story behind the data and communicate it meaningfully. Hear from Excel modeller and author Danielle Stein Fairhurst as we study the principles of good visual design and how to convert your data into powerful visuals which effectively communicate the message uncovered by your analysis.
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top