Excel Automation

The Real-Time Data (RTD) function in Microsoft Excel is a powerful tool that allows you to refresh values from real-time data servers in Excel spreadsheets.

When you need to quickly calculate, summarize, and analyze data, Microsoft Excel has the perfect tool. Let’s walk through the Pivot Table Basics including setting up a data set, inserting the Pivot Table, and working with the numbers.

In this guide, I’ll be taking you into the heart of what-if analysis, exploring tools like Scenario Manager, Data Tables, and Goal Seek. I’ll walk through setting up your first scenario (with less drama than my story, promise), comparing potential outcomes with data tables, and using Goal Seek to hit your targets square on.

Looking for an easier way to use Excel? Microsoft Excel 365 is your answer, bringing the tool you know and love to any device. Let’s walk through how to get it, why it’s better, and some minor differences from previous versions of Excel.

Almost everyone in Finance uses Excel, but very few know how to organize Excel like a pro. Let’s walk through four of the best tools to make your spreadsheets stand out from the crowd.

Microsoft Excel is an amazing tool, but it’s not without its quirks. Some common errors you might encounter include #DIV/0!, #VALUE!, #REF!, #N/A, and #NAME?. Each error has a different cause – from dividing by zero to referencing a nonexistent cell.