“That's taxpayer’s money that is going to support research and development and pilot projects to develop a food system that is based on environmental destruction and greed and disregard for animals, fish, and any of the other marine mammals that might be around it.” - Andrianna Natsoulas Andrianna Natsoulas is the campaign director for Don't Cage Our Oceans, an organization that exists to keep our oceans free from industrial fish farms. Offshore finfish farming is the mass cultivation of finfish in marine waters, in underwater or floating net pens, pods, and cages. Offshore finfish farms are factory farms that harm public health, the environment, and local communities and economies that rely on the ocean and its resources. Don’t Cage Our Oceans are a coalition of diverse organizations working together to stop the development of offshore finfish farming in the United States through federal law, policies, and coalition building. And, although it is not yet happening, right now the US Administration and Congress are promoting this kind of farming, which would be nothing short of disastrous for the oceans, the planet and the people and animals who live here. dontcageouroceans.org…
Player FM - Internet Radio Done Right
Checked 7d ago
Добавлено два года назад
Контент предоставлен Adam Shilton. Весь контент подкастов, включая эпизоды, графику и описания подкастов, загружается и предоставляется непосредственно компанией Adam Shilton или ее партнером по платформе подкастов. Если вы считаете, что кто-то использует вашу работу, защищенную авторским правом, без вашего разрешения, вы можете выполнить процедуру, описанную здесь https://ru.player.fm/legal.
Player FM - приложение для подкастов
Работайте офлайн с приложением Player FM !
Работайте офлайн с приложением Player FM !
))
Daily Deals
Automating Excel: Demystifying VBA, Office Script, Power Query & Python - Mark Proctor | Ep.069
Manage episode 411443416 series 3442672
Контент предоставлен Adam Shilton. Весь контент подкастов, включая эпизоды, графику и описания подкастов, загружается и предоставляется непосредственно компанией Adam Shilton или ее партнером по платформе подкастов. Если вы считаете, что кто-то использует вашу работу, защищенную авторским правом, без вашего разрешения, вы можете выполнить процедуру, описанную здесь https://ru.player.fm/legal.
Join Microsoft MVP Mark Proctor and Adam Shitlon as they delve into powerful tools like VBA and Power Query, and how they can revolutionize your workflow, automating tedious tasks and streamlining processes.
In this insightful episode, Mark addresses the common misconception that VBA is a dated language and explores its potential resurgence with the advent of AI. He also introduces the Unix philosophy, a framework for building scalable and maintainable automations. Additionally, they dive into the capabilities of Power Query, a powerful tool for data transformation and management. Tune in to gain valuable insights and stay ahead of the curve in the ever-evolving world of finance and technology.
------SHOW NOTES------
- Check out Excel Off the Grid - https://exceloffthegrid.com/
- Connect with Mark on LinkedIn - https://www.linkedin.com/in/markstephenproctor/
- Read Mark's hilarous LinkedIn post here - https://www.linkedin.com/posts/markstephenproctor_excel-is-not-a-database-conversation-examples-activity-7176512884670111744-NEWN
- See Mark's slide deck from the Global Excel Summit here - https://drive.google.com/file/d/1Q6mw6uAq6sl5tjp1AKQtH4fG0FyRCLAH/view?usp=drivesdk
------CHAPTERS------
- (00:00:00) - Mark discusses VBA's staying power within Excel
- (00:06:10) - Exploring the potential of AI to revive VBA
- (00:11:00) - Importance of data structure for effective automation
- (00:19:10) - Power Query: A game-changer for data transformation
- (00:26:50) - VBA vs. Office Scripts: Contrasting use cases
- (00:34:40) - Addressing concerns about VBA's perceived obsolescence
- (00:42:30) - Leveraging Power Query for data management
- (00:50:50) - The Unix philosophy: A framework for scalable automations
- (01:00:20) - Embracing a modular approach to automation
- (01:07:50) - Capturing ideas and staying productive on the go
And for more goodies, head over to www.techforfinance.com
79 эпизодов
ПоделитьсяManage episode 411443416 series 3442672
Контент предоставлен Adam Shilton. Весь контент подкастов, включая эпизоды, графику и описания подкастов, загружается и предоставляется непосредственно компанией Adam Shilton или ее партнером по платформе подкастов. Если вы считаете, что кто-то использует вашу работу, защищенную авторским правом, без вашего разрешения, вы можете выполнить процедуру, описанную здесь https://ru.player.fm/legal.
Join Microsoft MVP Mark Proctor and Adam Shitlon as they delve into powerful tools like VBA and Power Query, and how they can revolutionize your workflow, automating tedious tasks and streamlining processes.
In this insightful episode, Mark addresses the common misconception that VBA is a dated language and explores its potential resurgence with the advent of AI. He also introduces the Unix philosophy, a framework for building scalable and maintainable automations. Additionally, they dive into the capabilities of Power Query, a powerful tool for data transformation and management. Tune in to gain valuable insights and stay ahead of the curve in the ever-evolving world of finance and technology.
------SHOW NOTES------
- Check out Excel Off the Grid - https://exceloffthegrid.com/
- Connect with Mark on LinkedIn - https://www.linkedin.com/in/markstephenproctor/
- Read Mark's hilarous LinkedIn post here - https://www.linkedin.com/posts/markstephenproctor_excel-is-not-a-database-conversation-examples-activity-7176512884670111744-NEWN
- See Mark's slide deck from the Global Excel Summit here - https://drive.google.com/file/d/1Q6mw6uAq6sl5tjp1AKQtH4fG0FyRCLAH/view?usp=drivesdk
------CHAPTERS------
- (00:00:00) - Mark discusses VBA's staying power within Excel
- (00:06:10) - Exploring the potential of AI to revive VBA
- (00:11:00) - Importance of data structure for effective automation
- (00:19:10) - Power Query: A game-changer for data transformation
- (00:26:50) - VBA vs. Office Scripts: Contrasting use cases
- (00:34:40) - Addressing concerns about VBA's perceived obsolescence
- (00:42:30) - Leveraging Power Query for data management
- (00:50:50) - The Unix philosophy: A framework for scalable automations
- (01:00:20) - Embracing a modular approach to automation
- (01:07:50) - Capturing ideas and staying productive on the go
And for more goodies, head over to www.techforfinance.com
79 эпизодов
Все серии
×
1 How to Use AI to Gain a Human Edge: My 3-Pillar Approach to Staying Ahead [Future Finance Podcast] 46:57
In this thought-provoking episode, Adam Shilton joins Paul Barnhurst and Glenn Hopper to explore the current state of AI content creation. They examine AI-generated podcasts, synthetic data risks, and why AI still struggles with creating authentic, non-sterile content. The hosts share practical insights on how to effectively work with AI tools for learning, thinking, and doing tasks, rather than trying to outsource skills entirely. Adam's approach to AI as a supportive mechanism rather than a standalone entity offers valuable perspective for anyone looking to remain irreplaceable in an AI-driven world. The conversation also follows Adam's personal journey from corporate finance to entrepreneurship after his July TEDx talk. He candidly discusses building a business without a large savings cushion, finding problems worth solving rather than just having "good ideas," and his mission to help others build careers around their passions. His refreshing take on using technology to break down barriers and level the playing field provides inspiration for listeners considering similar transitions. Originally published on the Future Finance Podcast: - Website - https://www.thefpandaguy.com/future-finance - Spotify - https://open.spotify.com/show/2fwR53Rio39P6p7u7L73Fu — SHOW NOTES — - Information about Adam Shilton, founder, technologist, and TEDx speaker: [https://adamshilton.com](https://adamshilton.com/) - Rob Lennon's AI podcast host mentioned by Adam: Search "Rob Lennon AI podcast host" - Google's Notebook LM, an AI tool discussed by the hosts: https://deepmind.google/technologies/gemini/notebook/ - OpenAI Playground for testing prompts and voice bots: https://platform.openai.com/playground - Meta (Facebook) AI avatar profiles mentioned in the discussion: Search "Meta AI avatar profiles" - Ethan Mollick's book "Cointelligence" referenced by Adam: Search for "Ethan Mollick Cointelligence book" - Paul's training partner Ron Montero's book "Love Mondays": Search for "Love Mondays Ron Montero book" — CHAPTERS — (00:03:25) - Discussion about AI-generated podcasts and cloned voices. (00:06:30) - Exploring risks of AI learning from its own synthetic data. (00:10:15) - Glenn's perspective on limitations of synthetic data for AI training. (00:16:32) - Why AI still struggles with authenticity in writing and content. (00:20:45) - Using AI for improving content rather than creating from scratch. (00:24:10) - How to learn new skills with AI as a teaching assistant. (00:29:40) - The importance of domain expertise when working with AI. (00:35:20) - Adam's experience with creating "Franken-code" through AI assistance. (00:38:30) - Adam discusses his TEDx talk about technology and passion careers. (00:41:45) - Adam's journey into entrepreneurship without a traditional savings runway.…
Dive into the cutting-edge world of AI-powered data analysis with tech expert Adam Shilton. In this illuminating keynote from the Grow CFO Global Finance Summit, Adam breaks down how Python is revolutionizing Excel, explores real-world machine learning successes and failures, and provides a practical framework for selecting AI tools. Discover how finance professionals can leverage emerging AI capabilities, from autonomous assistance to advanced data visualization, making this episode essential for anyone looking to stay ahead in the data-driven future. ------SHOW NOTES------ - Microsoft Excel Python Integration Documentation - Mockaroo Random Data Generator: https://www.mockaroo.com - Kaggle Datasets: https://www.kaggle.com/datasets - Microsoft Copilot for Excel - Claude by Anthropic: https://claude.ai - ChatGPT Code Interpreter - Power BI - Google Colab for Python - Follow Richard Nero on LinkedIn for Copilot insights ------ CHAPTERS------ - (00:00:27) - Overview of keynote topics and AI's role in strategic decisions - (00:03:16) - Framework for understanding different data tasks and AI capabilities - (00:07:05) - Real-world examples of machine learning algorithms and implementations - (00:24:31) - Introduction to Python in Excel and practical demonstrations - (00:32:19) - Updates on AI tools including ChatGPT, Claude, and Copilot - (00:43:36) - Framework for selecting appropriate AI tools for data analysis - (00:52:19) - Call to action and practical steps to get started with AI For more, head over to www.adamshilton.com…
In this insightful keynote from the Grow CFO Global Finance Summit, tech expert Adam Shilton delivers a comprehensive framework for successful technology adoption in finance teams. From quantum computing's impact on future tech decisions to the latest in generative AI, Shilton breaks down why delaying tech adoption can sometimes be advantageous and how to avoid common pitfalls. The presentation focuses on practical frameworks for assessing, selecting, and implementing technology solutions while emphasizing the importance of thorough testing and pilot programs before full deployment. ———Show Notes——— Resources mentioned: - G2 Software Review Platform: [https://www.g2.com](https://www.g2.com/) - Grow CFO Slack Community (Join link available through Grow CFO) - Book Reference: "Decisive: How to Make Better Decisions in Life and Work" by Chip and Dan Heath Tools Mentioned: - Copilot for Microsoft 365 - Claude AI - Excel Labs - Otter (transcription tool) - Loom (video recording/documentation) ———Chapters——— - (00:00:00) - Introduction to Adam Shilton podcast and technology adoption best practices - (00:03:07) - Overview of recent innovations in tech and quantum computing basics - (00:11:02) - Discussion of generative AI advances and cost evolution - (00:21:27) - Virtual hands vs. virtual brains: Understanding automation and AI tools - (00:25:49) - Framework introduction: Start from zero approach to tech adoption - (00:31:01) - Analyzing complexity in processes before implementing new technology - (00:35:23) - Research methodology and integration considerations for new technology - (00:41:45) - Decision-making process and importance of pilot programs - (00:44:42) - Implementation phases and key project roles for successful deployment - (00:48:21) - Closing thoughts on AI's role in future strategic decisions…
1 How to Create an Unfair Advantage: Standing Out in the Age of AI - Hasan Kubba 1:09:12
1:09:12 
Прослушать Позже 
Прослушать Позже 
Списки 
Нравится 
Нравится1:09:12
Прослушать Позже Прослушать Позже Списки Нравится НравитсяIn this enlightening episode, Adam Shilton sits down with Hasan Kubba, bestselling author and expert in helping entrepreneurs become published authors. They delve into the world of unfair advantages, AI's impact on content creation, and the enduring value of traditional publishing. Hassan shares insider tips on book writing, establishing thought leadership, and positioning oneself at the top of the robot curve through creative work. The conversation takes unexpected turns, exploring the use of AI in content creation, the importance of authenticity, and the future of digital real estate. Hassan offers valuable insights on recognizing and leveraging unfair advantages, while Adam shares his experiences with AI-assisted content creation. This episode is a must-listen for anyone looking to level up their life through technology, productivity, and creative thinking. ———SHOW NOTES——— - Connect with Hasan - https://www.linkedin.com/in/startuphasan/ - Visit Hasan’s Website - https://www.hasankubba.com/ ———CHAPTERS——— (00:00:00) - Introduction to Hassan Kubba and the podcast theme (00:03:43) - Discussing unfair advantages and their importance in success (00:07:54) - Exploring the impact of AI on content creation (00:14:14) - The future of digital real estate and AI-powered search (00:20:18) - Insights on book writing and establishing thought leadership (00:27:39) - Leveraging AI tools for content creation without losing authenticity (00:35:34) - The importance of finding your unique voice in content (00:41:35) - Practical tips for using AI in writing and content production (00:50:55) - Hassan's journey from digital nomad to author and coach (00:56:50) - Concluding thoughts and where to find Hassan Kubba P.S - For more goodies, head over to www.adamshilton.com…
1 Unlocking Python: From Misconceptions to Mastery with Tony Roberts 1:18:05
1:18:05 Прослушать Позже Прослушать Позже Списки Нравится Нравится1:18:05
Прослушать Позже Прослушать Позже Списки Нравится НравитсяFor more visit adamshilton.com | Join me as we learn from Tony Roberts, founder of PyXLL, for an in-depth discussion on Python's role in Excel and beyond. We address misconceptions about Python, explore its versatility from beginner to advanced use cases, and examine the pros and cons of AI-assisted coding. Tony shares his journey creating PyXLL and explains how it empowers Excel users with Python's capabilities. The episode also covers cloud deployment considerations and the future of Python in corporate environments. Don't miss this opportunity to stay ahead of the curve with Python. ------SHOW NOTES------ - Check out PyXLL - https://www.pyxll.com/ - Watch PyXLL on YouTube - https://www.youtube.com/@python-excel - Connect with Tony - https://www.linkedin.com/in/troberts79/ ------CHAPTERS------ - (00:00:00) - Introduction of Tony Roberts and podcast overview - (00:01:18) - Misconceptions about Python's difficulty and capabilities - (00:24:46) - Time-saving benefits of AI in coding - (00:27:57) - Challenges with OpenAI Whisper API and debugging - (00:29:25) - Pragmatism in using AI for coding - (00:32:01) - Experimenting with AI tools for coding - (00:33:41) - Use of bots and AI in customer support - (00:39:02) - Coding mode differences in Microsoft Copilot - (00:45:39) - Ethical AI-generated communication in business - (00:48:49) - Importance of genuine interest in marketing - (00:52:56) - Transitioning from VBA to Python in corporate settings - (01:04:50) - Considerations for coding platform choices - (01:06:24) - Digital course plans and Python accessibility - (01:14:58) - Using Excel as a front end for Python functions - (01:17:21) - Conclusion and contact information…
Introducing 'The Adam Shilton Podcast'! It's been a while! Almost 2 months since I spoke at GrowCFOs Global Finance Summit, and a LOT has happened. Tech for Finance was my passion project alongside my full-time job, but as of July 2024, I'm now working for myself. This transition has brought some identity crises, especially feeling imposter syndrome in finance. A big shoutout to my friend Soufyan Hamid for his perspective: “You don’t need to have had cancer to cure it.” Yet, I realized the content I've been producing isn't 100% me. So, I've decided to align more with my expertise. In 'The Adam Shilton Podcast'! I'll cover a broader range of topics focused on tech mastery, productivity, and self-improvement. My passion for finance tech remains, but I aim to share much more of myself. Find me at adamshilton.com for the latest newsletters and subscribe to Framework Friday. Feel free to e-mail me at adam@adamshilton.com. I appreciate your support and look forward to catching up on 'The Adam Shilton Podcast'. See you on the other side!…
1 Global Finance Summit Keynote - AI & Machine Learning in Finance: Transformative Applications 1:03:41
1:03:41 Прослушать Позже Прослушать Позже Списки Нравится Нравится1:03:41
Прослушать Позже Прослушать Позже Списки Нравится НравитсяWatch the video of this presentation here . In this special episode, I present my keynote from the Grow CFO Global Finance Summit, exploring the now and future of AI and machine learning in finance. I the importance of pattern recognition, the role of generative AI, and practical use cases like spend and revenue analysis and outlier detection. Learn how tools like ChatGPT and Microsoft Copilot are reshaping financial management. Tune in for expert predictions, tips on improving your AI skills, and insights into deploying AI for enhanced financial operations and decision-making. ------ SHOW NOTES ------ - Check out GrowCFO here . - Download the presentation transcript and slides here - See the Google Colab code I used to run the models and predictions here . - Check out LABS.GENERATIVEAI here . ------ CHAPTERS ------ (00:00:00) - Introduction. (00:01:18) - Welcome and Summit Overview. (00:02:12) - AI Predictions and Partners. (00:03:32) - AI and Machine Learning in Finance. (00:04:41) - Poll and AI Impact. (00:07:07) - Session Overview. (00:07:32) - AI Tools and Techniques. (00:08:26) - Personal AI Journey. (00:10:33) - AI vs. Automation. (00:14:28) - Machine Learning in Finance. (00:17:11) - Training Data and Bias. (00:19:12) - Outlier Detection. (00:22:10) - Predictive Analytics. (00:23:09) - Experimentation with AI Models. (00:26:16) - Spend Forecast Case Study. (00:29:30) - Revenue Forecast Case Study. (00:34:38) - Generative AI. (00:39:49) - Building Bots with AI. (00:45:06) - AI Labs in Excel. (00:53:20) - General AI Tools. (00:56:27) - Future Predictions. (01:00:05) - Conclusion and Contact. (01:01:12) - Q&A Session. For more goodies, check out www.techforfinance.com…
1 Power Automate: Turn Manual to Magnificent and Create Massive Value - Damien Bird | Ep.072 1:20:58
1:20:58 Прослушать Позже Прослушать Позже Списки Нравится Нравится1:20:58
Прослушать Позже Прослушать Позже Списки Нравится НравитсяIn this insightful episode, Adam welcomes Damien Bird, the Microsoft Cloud Architect and Power Automate Guru with over 10,000 YouTube followers. They dive deep into the world of Power Platform, demystifying the terminology and exploring the vast possibilities of Power Automate. From personal productivity hacks to enterprise-level automation, Damien shares his expertise on leveraging this powerful tool. He also provides valuable insights into the integration of AI and generative models like Copilot Studio. Get ready to unlock new levels of efficiency and streamline your workflows! ------ SHOW NOTES ------ Watch Damien’s YouTube Videos – https://www.youtube.com/c/DamoBird365 Connect with Damien - https://www.linkedin.com/in/damobird365/ Check out Tech for Finance – www.techforfinance.com ------ CHAPTERS ------ (00:00:00) - Intro and welcome to Tech for Finance podcast (00:00:34) - Introducing guest Damien Bird, Microsoft Cloud Architect (00:02:09) - Explaining Microsoft Power Platform terminology (00:05:12) - Getting started with Power Automate for personal productivity (00:10:48) - Discussion on Microsoft Copilot Studio and generative AI (00:19:18) - Examples of automating processes with Power Automate (00:25:58) - Suggestions for low-hanging fruit and quick wins with Power Automate (00:34:21) - Exploring Power Automate Desktop for personal productivity (00:38:06) - How to get started with Power Automate (00:44:13) - Using Process Advisor for process mining and automation opportunities (00:52:01) - Changing data formats and generating documents with Power Automate (01:00:26) - Keeping up with updates and changes in Power Platform (01:08:24) - Damien's favorite app: YouTube Studio (01:12:07) - Exploring AI apps and tools like Poe and Metaculus (01:20:22) - Closing comments and where to find Damien online…
1 AI Overwhelm: How to Keep Up in the Age of Furious Change - Dave Hartley | Ep.071 1:03:10
1:03:10 Прослушать Позже Прослушать Позже Списки Нравится Нравится1:03:10
Прослушать Позже Прослушать Позже Списки Нравится НравитсяIn the age of rapid technological change, keeping up with the latest tools and trends can feel overwhelming. Dave Hartley, a technologist turned CPA, shares his insights on how businesses and individuals can navigate the AI revolution without getting left behind. He discusses the challenges of change management and the importance of being intentional about adopting new technologies. Dave also explores the generational gap in technology adoption, the potential impact of AI on the workforce, and the need for governance and risk management. He emphasizes the importance of finding the right balance between embracing innovation and ensuring security and accuracy. Whether you're a finance professional, a business leader, or simply someone interested in the future of work, this episode offers valuable perspectives on thriving in the age of furious change. Tune in for practical advice and thought-provoking insights. ------SHOW NOTES------ - Connect with Dave - https://www.linkedin.com/in/davehartley/ - Check out Anders CPA - https://anderscpa.com/ - Listen to 'But Who's Counting?' -https://open.spotify.com/show/4mieDwzhsSh44gQxRVLKXD ------CHAPTERS------ (00:00:00) - Intro: Change management challenges in the AI age (00:03:22) - Being intentional about remote work and employee experience (00:10:05) - Generational gap in technology adoption and AI acceptance (00:18:48) - Balancing innovation with security and risk management (00:27:49) - Pace of technological change and organizational readiness (00:36:42) - Governance and validation in the AI era (00:46:18) - Finding the right balance for AI adoption (00:54:19) - Dave's favorite productivity tool For more goodies, head over to www.techforfinance.com…
1 Accounting Meets Art: How to Use Visuals as the Ultimate Productivity Tool - Mike Manalac | Ep.070 1:14:39
1:14:39 Прослушать Позже Прослушать Позже Списки Нравится Нравится1:14:39
Прослушать Позже Прослушать Позже Списки Нравится НравитсяIn this episode, Adam Shilton and Mike Manalac dive into the creative side of accounting and finance. Mike, an illustrator and accounting manager at Google, shares how he incorporates drawing and visuals into his work to enhance collaboration, problem-solving, and overall productivity. They discuss the power of visual thinking, the role of technology in enabling creativity, and the future of work in a hybrid environment. Mike also offers insights into his book "No Flux Given" and shares tips for job seekers in the accounting field. Tune in for an engaging conversation that challenges traditional notions of accounting and finance. ------SHOW NOTES------ - Visit Mike's Website - www.mikefromaccounting.com - Connect with Mike - https://www.linkedin.com/in/mikemanalac/ ------CHAPTERS------ - (00:00:00) - Introduction and background on Mike Manalac - (00:03:42) - Mike's passion for drawing and incorporating it into work - (00:09:59) - Using virtual whiteboards for collaboration and visual thinking - (00:19:02) - The power of visuals in engaging audiences - (00:28:18) - Challenges and opportunities of hybrid work environments - (00:38:04) - The future of work and the role of AI - (00:48:00) - Mike's book "No Flux Given" and advice for job seekers - (00:58:22) - The importance of creativity and automation in accounting - (01:08:30) - Tools like Jeda AI for generating visuals - (01:14:05) - Closing remarks and where to find Mike For more goodies, head over to www.techforfinance.com…
1 Automating Excel: Demystifying VBA, Office Script, Power Query & Python - Mark Proctor | Ep.069 1:13:25
1:13:25 Прослушать Позже Прослушать Позже Списки Нравится Нравится1:13:25
Прослушать Позже Прослушать Позже Списки Нравится НравитсяJoin Microsoft MVP Mark Proctor and Adam Shitlon as they delve into powerful tools like VBA and Power Query, and how they can revolutionize your workflow, automating tedious tasks and streamlining processes. In this insightful episode, Mark addresses the common misconception that VBA is a dated language and explores its potential resurgence with the advent of AI. He also introduces the Unix philosophy, a framework for building scalable and maintainable automations. Additionally, they dive into the capabilities of Power Query, a powerful tool for data transformation and management. Tune in to gain valuable insights and stay ahead of the curve in the ever-evolving world of finance and technology. ------SHOW NOTES------ - Check out Excel Off the Grid - https://exceloffthegrid.com/ - Connect with Mark on LinkedIn - https://www.linkedin.com/in/markstephenproctor/ - Read Mark's hilarous LinkedIn post here - https://www.linkedin.com/posts/markstephenproctor_excel-is-not-a-database-conversation-examples-activity-7176512884670111744-NEWN - See Mark's slide deck from the Global Excel Summit here - https://drive.google.com/file/d/1Q6mw6uAq6sl5tjp1AKQtH4fG0FyRCLAH/view?usp=drivesdk ------CHAPTERS------ - (00:00:00) - Mark discusses VBA's staying power within Excel - (00:06:10) - Exploring the potential of AI to revive VBA - (00:11:00) - Importance of data structure for effective automation - (00:19:10) - Power Query: A game-changer for data transformation - (00:26:50) - VBA vs. Office Scripts: Contrasting use cases - (00:34:40) - Addressing concerns about VBA's perceived obsolescence - (00:42:30) - Leveraging Power Query for data management - (00:50:50) - The Unix philosophy: A framework for scalable automations - (01:00:20) - Embracing a modular approach to automation - (01:07:50) - Capturing ideas and staying productive on the go And for more goodies, head over to www.techforfinance.com…
1 Projection vs Reality: Avoid These Financial Modelling Mistakes - Danielle Stein Fairhurst | Ep.068 41:42
In this episode, we welcome Danielle Stein Fairhurst, a renowned Microsoft MVP, Author, and Corporate Trainer. Danielle shares her expertise in financial modeling, highlighting the crucial distinction between models and reality. We also delve into best practices for building accurate financial models, emphasising the importance of separating inputs from calculations and avoiding hard-coded assumptions. We also explore the role of visuals, collaboration, and lesser-known Excel functions in elevating your modeling game. Join us as we navigate the ever-evolving landscape of tech for finance. Like, subscribe, and stay ahead of the curve! ------SHOW NOTES------ - Subscribe to 'Framework Friday' - www.techforfinance.com - Connect with Danielle - https://www.linkedin.com/in/daniellesteinfairhurst/ - Using Excel for Business & Financial Modelling - https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 - Financial Modelling in Excel for Dummies - https://www.dummies.com/book/technology/software/microsoft-products/excel/financial-modeling-in-excel-for-dummies-281721/ ------CHAPTERS------ - (00:01:39) - Danielle's experience in Saudi Arabia - (00:05:57) - Common financial modeling mistakes - (00:11:15) - Understanding financial models vs. reality - (00:16:23) - Dangers of relying on AI models - (00:21:02) - Elevating financial models for collaboration - (00:27:04) - Importance of visuals in modeling - (00:31:49) - Collecting and managing model data - (00:35:32) - Lesser-known Excel functions for modeling - (00:37:49) - Women in Financial Modeling group…
In the ever-evolving world of AI chat tools, finding the right solution can be a daunting task. Fear not, as we present a comprehensive 6-step framework to help you navigate the sea of options. From budget constraints to security protocols, internet access needs, file management capabilities, data analysis requirements, and bot-building aspirations, we've got you covered. We dive deep into the offerings of industry giants like OpenAI, Microsoft, Google, Anthropic, and Mistral, dissecting their free and paid AI chat tools. But the burning question remains: Is ChatGPT still the best? Join us as we explore the pros and cons of each tool, providing expert insights and pro tips to guide your decision-making process. Stay ahead of the curve and make an informed choice that aligns with your specific needs. - (00:01:32) - Step 1: Budget considerations for AI chat tools - (00:02:17) - Step 2: Security protocols and data protection - (00:03:36) - Step 3: Internet access capabilities of AI chat tools - (00:05:38) - Step 4: File management and multi-modal capabilities - (00:06:50) - Step 5: Data analysis and visualization capabilities - (00:07:52) - Step 6: Bot-building and customization options - (00:09:13) - Example use case: CFO reviewing contracts - (00:10:06) - Example use case: Controller analyzing spend - (00:10:27) - Example use case: Finance business partner meetings - (00:11:22) - Bonus free AI chat tool recommendations - (00:13:24) - Determining if ChatGPT is still the best option For more goodies, head over to www.techforfinance.com…
What does it mean to have a "good spend culture"? Howard Katzenberg, founder and CEO of Glean AI, breaks it down. We explore building financial visibility, tightening spend control, and empowering employees to make better spending decisions. Howard shares insights from his experience as both a CFO and entrepreneur on understanding unit economics, marketing to different buyer personas, and negotiating win-wins with vendors. He also advocates for finance leaders getting their hands dirty—attending planning meetings, analyzing conversion funnels, and understanding the drivers behind costs. We also explore generative AI, easy onboarding, and why you should see spend forensics as strategic rather than just tactical. ------SHOW NOTES------- - Connect with Howard on LinkedIn - https://www.linkedin.com/in/howardkatzenberg/ - Check out Glean AI - https://www.glean.ai/ ------CHAPTERS------ (00:00:00) - Introducing Howard from Glean AI (00:03:37) - Advice to CFOs on understanding business operations (00:07:00) - Analyzing marketing and sales funnel performance (00:10:26) - Defining and improving company spend culture (00:14:23) - Automating accounts payable for better visibility (00:19:52) - Using AI to benchmark supplier pricing (00:24:37) - Onboarding customers to Glean's platform (00:27:48) - Integrating Glean with existing finance systems (00:31:42) - Competing with Bill.com in AP automation (00:35:44) - Leveraging AI technology at Glean For more goodies, head over to www.techforfinance.com…
1 Beyond Benchmarks: Will Whizzy Tech Make You a Better Finance Team? - It's Not All About the Numbers | Ep.065 51:21
In this episode of "It's Not About the Numbers," hosts Chris and Mike, along with special co-host Adam Shilton, a trailblazer in AI finance, dive deep into the role of technology in enhancing finance team efficiency, regardless of their size or budget. The discussion spans the value of benchmarking tech use in finance, the impact of automation and advanced tools, and personal anecdotes from the hosts' lives, reflecting on changes and the pace of technological adoption. The episode uniquely blends professional insights with personal stories, emphasizing the importance of technology in finance without losing sight of the human elements. ------SHOW NOTES------ Subscribe to 'It's not all about the numbers' - https://open.spotify.com/show/4znaA5D1A3eXXxXd5PTaV1 ------CHAPTERS------ (00:01:48) - Sharing what's happening in AI news (00:03:09) - Adam detailing his background (00:07:26) - Recapping busy weeks and AI developments (00:08:41) - Comparing AI models Gemini and ChatGPT (00:12:28) - Explaining Microsoft's Copilot AI offering (00:17:15) - Adam explaining his fear of advanced AI (00:21:38) - Tracing Adam's early interest in technology (00:25:41) - Visualizing Adam's work as an AI producer (00:28:03) - Asking how Adam developed communication skills (00:31:46) - Recalling a pivotal public speaking experience (00:34:37) - Answering a question on benchmarking tech maturity (00:42:32) - Sharing good and bad data (00:49:55) - Providing links to connect with Adam P.S - Don’t forget to head over to www.techforfinance.com and sign up to Framework Friday for 1 actionable tech framework you can use to stay ahead of the game.…
Добро пожаловать в Player FM!
Player FM сканирует Интернет в поисках высококачественных подкастов, чтобы вы могли наслаждаться ими прямо сейчас. Это лучшее приложение для подкастов, которое работает на Android, iPhone и веб-странице. Зарегистрируйтесь, чтобы синхронизировать подписки на разных устройствах.
Daily Deals
Player FM - приложение для подкастов
Работайте офлайн с приложением Player FM !
Работайте офлайн с приложением Player FM !
))
