Enhance Excel Financial Models and Dashboards using ChatGPT @SimonSezIT
Enhance Excel Financial Models and Dashboards using ChatGPT  @SimonSezIT
Uploaded February 2026 | Updated November 2026, 22 hours ago
Learn how to use ChatGPT to enhance Excel financial models and build smarter, more dynamic dashboards. This video covers creating and projecting income statements, performing common-size and ratio analysis, and automating dashboard creation using AI. Ideal for finance professionals looking to improve accuracy, efficiency, and insight without complex coding.

📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

00:00:00 – Fundamentals of Financial Statements and ChatGPT Integration
00:07:09 - Creating Income Statements with ChatGPT
00:13:09 - Projecting Income Statements with ChatGPT
00:21:34 - Building Common Size Income Statements
00:26:56 - Analyzing Common Size Income Statements
00:33:16 - Streamlining Ratio Calculations with ChatGPT
00:38:24 - Enhancing Financial Ratio Analysis with AI
00:43:42 - Automating Financial Dashboard Creation

🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ simonsezit.com/courses

🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 11,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpages.co/ssit-14-day-free

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 400+ hour training course playlist here ➡️
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

✅ Check out our free video playlist for Excel beginners 👉youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z

✅ Excel 2021 Tutorials for Intermediate Users here 👉youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3

✅ Microsoft Excel Tips and Tricks 👉youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

✅ Microsoft Office 2021 and Office 365 Training here 👉youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

💬Stay in touch!
SimonSezIT.com: SimonSezIT.com
LinkedIn: linkedin.com/company/simon-sez-it
FaceBook: facebook.com/SimonSezIT

🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
Enhance Excel Financial Models and Dashboards using ChatGPTHow to Create Management Reports in QuickBooks Online with AI Accounting AgentHow to Use Copilot in Teams (AI Prompts to get You Started)Top Essential Word 365 TipsHow to Use REPT Function in ExcelMicrosoft Word 365 Essentials: Cut, Copy, and PasteHow to Add Sparklines in Excel - Use in Dashboards and Reports to Compare Data.Microsoft Word 365 Features You Need to Know (for Beginners)The Complete Guide to Dates and Times in ExcelChatGPT for Inventory: Order Management SolutionsInside a Zero-Chaos Outlook 365 Inbox: Manage Your Mail Like a Pro (New Outlook)Learn Microsoft Project: Work Quickly with Keyboard Shortcuts and Key Tips
Simon Sez IT |

Enhance Excel Financial Models and Dashboards using ChatGPT

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER