Can Google Sheets Beat Excel: Microsoft MVP David Benaim Settles the Debate

Designing the Future. AI, UX, and the Next Generation of Microsoft Power Platform with Tchesco Ayih [MVP-MCT]

In this episode of the M365 Podcast, Mirko Peters sits down with Tchesco Ayih, Microsoft MVP, Microsoft Certified Trainer (MCT), international speaker, mentor, and Power Platform expert. Tchesco shares his inspiring journey into the Microsoft ecosystem, discusses the growing importance of user experience (UX) in low-code development, and explores how artificial intelligence is transforming the way organizations build business applications. From Power Apps and Dataverse to Copilot Studio and AI-powered development, this conversation provides valuable insights for anyone working with Microsoft technologies, citizen development, low-code platforms, or digital transformation initiatives. Tchesco explains why beautiful design is not just a nice-to-have feature but a critical component of successful business applications, and why user-centric thinking should always come before functionality. FROM TRADITIONAL DEVELOPMENT TO MICROSOFT POWER PLATFORM Tchesco's journey into the Microsoft ecosystem started as a traditional developer with a passion for user interfaces and design. After earning Azure certifications and sharing his learning journey online, an opportunity emerged that introduced him to Microsoft Power Platform. What initially began as curiosity quickly developed into a career dedicated to helping organizations build efficient business solutions using low-code technologies. Throughout the discussion, Tchesco highlights how continuous learning, community engagement, and technical curiosity played essential roles in shaping his professional path. His story serves as a reminder that modern technology careers often evolve through experimentation, networking, and a willingness to embrace emerging platforms.  THE MVP AND MCT JOURNEY Becoming a Microsoft MVP and Microsoft Certified Trainer did not happen overnight. Tchesco discusses how helping others in online communities became the foundation of his recognition within the Microsoft ecosystem. By answering technical questions, delivering community sessions, supporting Microsoft Learn Student Ambassadors, and consistently sharing knowledge, he built a reputation that eventually led to an MVP nomination. Key lessons from his journey include: * Consistently contribute to technical communities. * Share knowledge freely and help solve real problems. * Build expertise through hands-on experience. * Pursue Microsoft certifications to validate skills. * Seek mentorship from experienced professionals. * Give back to the community that helped your own growth. WHY UX IS THE SECRET INGREDIENT OF GREAT BUSINESS APPS One of the most passionate parts of the discussion centers around User Experience (UX). According to Tchesco, many Power Platform developers become overly focused on functionality and process automation while neglecting how users actually experience the application. A business process may work perfectly from a technical perspective, but if the application feels confusing, cluttered, or difficult to navigate, user adoption can suffer significantly. Tchesco argues that every application should be designed with accessibility, usability, and user satisfaction in mind. He emphasizes that developers should think beyond buttons and forms and consider: * User accessibility requirements. * Application navigation flows. * Visual hierarchy and layout. * User feedback cycles. * Readability and simplicity. * Long-term adoption and engagement. Rather than viewing UX as a separate discipline, Tchesco believes UX should be integrated into every stage of Power Platform development. DESIGN FIRST, FEATURES SECOND One of the most powerful takeaways from the conversation is Tchesco's belief that developers should begin with the user interface before implementing features. Many developers immediately start building databases, business logic, and automation workflows. However, Tchesco recommends designing the application's screens first, creating a clear structure for how users will interact with information before any technical implementation begins. A thoughtful interface helps developers: * Organize business processes logically. * Clarify data requirements. * Reduce development rework. * Improve stakeholder alignment. * Create more intuitive user journeys. * Increase overall user satisfaction. This design-first mindset helps teams build solutions that are both technically effective and enjoyable to use. UNDERSTANDING THE MICROSOFT POWER PLATFORM ECOSYSTEM For listeners new to the Power Platform, Tchesco provides a practical overview of the platform's major components and how they work together to accelerate digital transformation initiatives. The Microsoft Power Platform consists of: * Power Apps for low-code application development. * Power Automate for workflow automation. * Dataverse as a scalable relational data platform. * Power Pages for external-facing business websites. * Copilot Studio for conversational AI experiences. * Connectors that integrate hundreds of business systems. Together, these tools enable organizations to rapidly automate processes, modernize legacy workflows, and reduce development timelines that traditionally required months of custom coding. DATAVERSE: THE FOUNDATION OF MODERN BUSINESS SOLUTIONS The conversation explores why Dataverse has become one of the most important components of the Power Platform ecosystem. Tchesco describes Dataverse as much more than a simple database. Its relational architecture, deep integration with Microsoft services, security model, and performance capabilities make it a strong choice for enterprise-grade business applications. Compared to traditional approaches relying heavily on SharePoint lists, Dataverse enables more scalable and maintainable business solutions while supporting advanced application scenarios and automation workflows. AI, COPILOT STUDIO, AND THE FUTURE OF APPLICATION DEVELOPMENT Artificial Intelligence plays a major role throughout the discussion. Tchesco shares how AI has already transformed many aspects of his daily work, helping accelerate development, generate ideas, improve productivity, and reduce repetitive tasks. The conversation explores the growing role of: * AI-assisted development. * Prompt engineering. * Copilot Studio. * Agent-based experiences. * AI-powered business automation. * Conversational user interfaces. Rather than replacing developers, Tchesco views AI as a powerful assistant that increases productivity when used correctly. He compares AI to a junior colleague that can help complete tasks faster, while experienced professionals remain responsible for validation, governance, and final decision-making. PROMPT ENGINEERING IS BECOMING A CRITICAL SKILL One particularly interesting topic is the emergence of prompt engineering as an essential skill for modern developers. According to Tchesco, professionals who learn how to communicate effectively with AI systems will gain a significant advantage. Knowing how to provide clear context, detailed requirements, and accurate instructions can dramatically improve the quality of AI-generated outputs. As AI becomes increasingly embedded across Microsoft products and business applications, prompt-driven development is likely to become a standard part of the software development process.  GOVERNANCE AND RESPONSIBLE AI ADOPTION While enthusiastic about AI's potential, Tchesco also stresses the importance of governance. Organizations must establish clear guidelines around: * Data security. * Privacy protection. * AI usage policies. * Information sharing restrictions. * Compliance requirements. * Human oversight and validation. Successful AI adoption requires balancing innovation with responsible governance. Businesses that introduce AI without adequate controls may expose sensitive information or create risks that outweigh the benefits. COMMUNITY, LEARNING, AND GIVING BACK Beyond technology, this episode highlights the importance of community engagement. Tchesco attributes much of his professional growth to the Microsoft community. By participating in forums, speaking at conferences, mentoring others, and sharing knowledge, he has developed both technical expertise and professional opportunities. His message is clear: growth accelerates when individuals actively contribute rather than simply consume information. Whether through local user groups, virtual events, online forums, or international conferences, communities remain one of the most valuable resources available to technology professionals.  LOOKING AHEAD: THE FUTURE OF LOW-CODE DEVELOPMENT As the conversation concludes, Tchesco shares his perspective on the future of low-code technology. He believes low-code platforms will continue to expand rapidly over the coming years, enabling organizations to build solutions faster while empowering more people to participate in application development. At the same time, strong foundations in UX, governance, architecture, and problem-solving will remain essential. Technology may evolve, but understanding users and solving business challenges effectively will always be the real differentiator. For anyone interested in Microsoft Power Platform, AI-driven development, business applications, digital transformation, or user-centric design, this episode delivers practical insights and forward-looking perspectives from one of the community's most passionate advocates. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support [https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support?utm_source=rss&utm_medium=rss&utm_campaign=rss].

Azure Bicep Fundamentals for Real Projects

Learning Azure Bicep is easy. Building infrastructure that survives real-world enterprise environments is something entirely different. In this episode of the M365 FM Podcast, host Mirko Peters explores what separates hobbyist Infrastructure as Code from production-ready cloud architecture. Rather than focusing on syntax alone, this episode dives into the architectural thinking behind Azure Bicep, showing how modern organizations design scalable, secure, and governable Azure environments using Infrastructure as Code, Azure Policy, Deployment Stacks, Azure Verified Modules, Management Groups, and enterprise governance. You'll learn why Bicep is far more than a replacement for ARM Templates. It has become Microsoft's strategic language for defining Azure infrastructure, enforcing governance, automating deployments, and enabling cloud platforms that remain maintainable as organizations grow. Whether you're deploying your first storage account or designing enterprise landing zones across hundreds of Azure subscriptions, this episode provides the principles needed to build infrastructure that lasts. WHY BICEP IS MORE THAN BETTER SYNTAX Many developers view Bicep simply as an easier way to write ARM Templates. While the cleaner syntax, reusable modules, and improved readability are significant improvements, Microsoft's long-term vision goes much further. Bicep has evolved into the language that defines Azure governance, policy, security baselines, and infrastructure lifecycle management. Modern Infrastructure as Code is no longer about automating deployments—it's about codifying architectural decisions that remain consistent across teams, subscriptions, and cloud environments.  THINKING LIKE A CLOUD ARCHITECT One of the central themes throughout the episode is the difference between automation and architecture. Real-world Bicep projects are built around organizational standards rather than individual deployments. Topics include: * Infrastructure as Code * Enterprise architecture * Governance as Code * Management Groups * Azure Landing Zones * Resource ownership * Organizational standards * Platform engineering * Cloud operating models * Infrastructure lifecycle You'll discover why enterprise Bicep templates become long-term blueprints that survive team changes, organizational growth, and evolving business requirements. BUILDING REUSABLE BICEP MODULES As Azure environments become larger, reusable modules become the foundation of maintainable infrastructure. The episode explains how well-designed modules encapsulate organizational decisions including security baselines, naming conventions, monitoring requirements, compliance standards, and networking patterns. Rather than copying infrastructure between projects, organizations build internal module libraries that allow development teams to deploy secure infrastructure while automatically following corporate standards. The discussion covers: * Azure Verified Modules (AVM) * Resource modules * Pattern modules * Platform modules * Module registries * Versioning * Parameter validation * Variables * Outputs * Semantic versioning DEPLOYMENT STACKS AND INFRASTRUCTURE LIFECYCLE One of Microsoft's biggest Infrastructure as Code innovations is Deployment Stacks. Unlike traditional ARM deployments, Deployment Stacks introduce state awareness, allowing Azure to understand which resources belong together throughout their lifecycle. The episode explores how Deployment Stacks simplify environment management, resource cleanup, brownfield migrations, and governance while reducing orphaned resources and configuration drift. You'll also learn how Deployment Stacks compare with Terraform's state management model and why this represents a major architectural shift for Azure-native deployments.  MANAGEMENT GROUPS, POLICY, AND GOVERNANCE Enterprise Azure environments cannot be managed one subscription at a time. This episode explains why Management Groups form the true control plane for Azure governance. Topics include: * Azure Policy * Policy Initiatives * RBAC * Least Privilege * Management Group hierarchy * Subscription governance * Compliance * Security baselines * Governance as Code * Platform engineering By defining governance at the Management Group level, organizations can automatically enforce consistent security, compliance, and operational standards across hundreds of subscriptions. BUILDING ENTERPRISE LANDING ZONES Azure Landing Zones are much more than preconfigured subscriptions. They provide complete enterprise-ready cloud environments including networking, monitoring, identity integration, governance, security controls, and operational best practices. The discussion explores how organizations compose Landing Zones using reusable Bicep modules, allowing application teams to deploy workloads into standardized cloud environments without sacrificing flexibility.  BICEP VS TERRAFORM One of the most common questions facing cloud architects is whether to standardize on Azure Bicep or Terraform. Rather than declaring a winner, this episode explains the strengths of both platforms. Bicep provides immediate support for new Azure services, seamless Azure integration, and simplified Azure-native deployments. Terraform remains an excellent choice for organizations operating across Azure, AWS, Google Cloud, and hybrid environments. The right decision depends on business requirements, governance strategy, and long-term platform goals—not simply personal preference.  WHO SHOULD LISTEN? This episode is perfect for: * Azure Architects * Cloud Engineers * DevOps Engineers * Platform Engineers * Infrastructure Engineers * Azure Administrators * Enterprise Architects * Cloud Consultants * IT Decision Makers * Microsoft MVPs * Anyone learning Azure Bicep Whether you're writing your very first Bicep file, migrating from ARM Templates, implementing Azure Landing Zones, designing enterprise governance, or building reusable Infrastructure as Code libraries, this episode provides practical guidance drawn from real-world cloud architecture. If you want to move beyond simple deployments and start building Azure environments that are secure, scalable, reusable, and maintainable for years to come, this episode offers a comprehensive foundation for mastering Azure Bicep in real enterprise projects. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support [https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support?utm_source=rss&utm_medium=rss&utm_campaign=rss].

Beyond Prompt a Page: Building Enterprise-Ready AI Experiences in Power Apps with Sara Lagerquist [MVP]

Artificial Intelligence is changing how organizations build business applications, but moving beyond simple demos requires much more than adding a chatbot or generating code with AI. In this episode of the M365 Show, Microsoft MVP Sara Lagerquist shares how enterprise organizations can use Generative Pages, Model-Driven Apps, and the Microsoft Power Platform to build scalable, maintainable, and production-ready AI experiences. From architecture and governance to citizen development and modern application design, this conversation explores what the next generation of business applications looks like inside the Microsoft ecosystem. FROM BUSINESS ADMINISTRATOR TO MICROSOFT MVP Sara shares her unique journey into technology. Without a traditional IT background, she discovered Microsoft Dynamics CRM while working as an administrator and quickly realized that designing business solutions came naturally. Over the past twelve years she has evolved into an Applications Architect, Microsoft MVP, international speaker, and one of the leading experts in the Microsoft Power Platform. Her story demonstrates that understanding business processes can be just as valuable as writing code when building enterprise solutions.  WHY MODEL-DRIVEN APPS ARE STILL THE FOUNDATION While Canvas Apps receive significant attention, Sara explains why Model-Driven Apps continue to be her preferred foundation for many enterprise solutions. They provide built-in navigation, security, search capabilities, responsive layouts, and rapid development that dramatically reduces implementation time. Rather than replacing Model-Driven Apps, Microsoft is extending them with Generative Pages, allowing developers to create highly customized user experiences without sacrificing the benefits of the underlying platform. The result is a powerful combination of low-code productivity and enterprise scalability.  GENERATIVE PAGES: THE NEXT EVOLUTION OF POWER APPS One of the biggest topics in the episode is Microsoft's new Generative Pages feature. Sara explains why she believes Generative Pages represent the future of Power Apps by combining AI-assisted development with highly flexible user interfaces. Instead of spending days or weeks creating custom pages manually, developers can use AI to rapidly generate complex interfaces that integrate seamlessly into Model-Driven Apps. The discussion covers current capabilities, limitations, supported regions, preview features, and Microsoft's roadmap for expanding Generative Pages across the Power Platform.  WHY VISUAL STUDIO CODE OUTPERFORMS THE MAKER PORTAL Although Microsoft offers AI-powered page generation directly inside the Power Apps Maker Portal, Sara recommends a different workflow for professional development. She explains how Visual Studio Code, GitHub Copilot, and Microsoft's official Generative Pages extension provide significantly better results. Developers gain access to stronger AI models, planning workflows, wireframe generation, version control, and a far more efficient prompting experience than the browser-based interface currently provides. For organizations building production applications, this development approach offers greater flexibility while reducing costs and improving overall quality.  PROMPT ENGINEERING FOR ENTERPRISE APPLICATIONS Building AI-generated business applications starts long before writing the first prompt. Sara discusses how successful prompting begins with understanding business processes rather than focusing on user interface design. Instead of asking AI to simply create a page, architects should clearly define business goals, user journeys, data relationships, and expected outcomes. The conversation also explores iterative prompting, planning conversations with AI, wireframe generation, and using AI itself to improve prompt quality before development even begins.  DESIGNING FOR LONG-TERM MAINTAINABILITY One of the biggest challenges in enterprise development is ensuring applications remain understandable long after the original developer has moved on. Sara explains how AI can actually improve documentation by automatically generating architecture diagrams, implementation plans, process documentation, user manuals, screenshots, and development guidance throughout the entire project lifecycle. Rather than making applications harder to maintain, AI can significantly improve knowledge transfer when used correctly.  NEW CAPABILITIES COMING TO GENERATIVE PAGES During the interview, Sara shares several exciting announcements from the European Power Platform Conference. Upcoming improvements include support for additional data sources beyond Dataverse, enabling developers to integrate external systems directly into Generative Pages. Microsoft is also introducing the ability to embed Generative Pages directly inside Model-Driven App forms, opening entirely new possibilities for creating rich enterprise user experiences without relying on traditional custom development. These features have the potential to reshape how Power Apps solutions are designed over the coming years.  GOVERNANCE IN THE AGE OF AI As AI dramatically accelerates application development, governance becomes even more important. Sara discusses why organizations must shift their focus from controlling development speed to managing adoption, ownership, lifecycle management, security, and long-term maintenance. With AI capable of producing applications much faster than before, businesses need clear governance frameworks to ensure solutions remain secure, scalable, and aligned with business objectives. The conversation also explores Microsoft's evolving governance capabilities and the future of the Power Platform Admin Center.  THE FUTURE OF CITIZEN DEVELOPMENT Citizen developers continue to play an increasingly important role within modern organizations. Sara believes AI will lower technical barriers even further, allowing business users to build sophisticated solutions with minimal coding experience. However, she emphasizes that successful citizen development requires education around governance, security, architecture, and business process design rather than simply teaching users where to click inside Power Apps. The future belongs to professionals who understand both technology and business processes.  BUILDING BETTER BUSINESS PROCESSES One of the strongest messages throughout the episode is that organizations should stop thinking about recreating existing processes with AI. Instead, AI provides an opportunity to redesign how work gets done entirely. Rather than building "faster horses," businesses should rethink workflows from the ground up, creating entirely new experiences that take advantage of automation, intelligent decision-making, and modern low-code platforms. This shift in thinking may ultimately become the biggest transformation AI brings to enterprise software development.  COMMUNITY, LEARNING, AND STAYING CURRENT Sara also shares the story behind founding the Power Platform Community Sweden, which has grown into one of the country's most active communities for makers, consultants, and architects. She discusses the importance of conferences, community events, collaboration, and continuous learning in an ecosystem that evolves almost every month. With new AI features, Power Platform capabilities, and Microsoft announcements arriving constantly, staying connected to the community has become essential for every modern architect and developer.  RAPID FIRE INSIGHTS The episode concludes with a fun rapid-fire session covering Sara's favorite development habits, career advice, conference experiences, books, and lessons learned throughout her Microsoft journey. Her biggest takeaway for listeners is simple: explore Generative Pages today—but build them using professional development tools rather than relying solely on the Maker Portal. For anyone interested in enterprise AI development with Microsoft Power Apps, this episode provides an excellent starting point. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support [https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support?utm_source=rss&utm_medium=rss&utm_campaign=rss].

ARM Templates Were a Mistake: Lessons from the Bicep Shift

Infrastructure as Code transformed cloud computing by replacing manual portal clicks with version-controlled, repeatable deployments. But while Azure Resource Manager (ARM) templates represented a major leap forward, they also introduced a new challenge: complexity. In this episode of the M365 FM Podcast, host Mirko Peters explores why ARM Templates were both a revolutionary innovation and a design mistake that ultimately led Microsoft to create Bicep—a modern, developer-friendly language built specifically for Azure. This episode goes beyond syntax comparisons to examine the deeper architectural, organizational, and governance lessons behind Microsoft's evolution from ARM Templates to Bicep. You'll discover why Infrastructure as Code isn't simply about automation—it's about governance, reproducibility, security, and preparing for an AI-native future where infrastructure is increasingly generated by intelligent agents rather than humans. THE DEATH OF CLICKOPS Every organization begins with portal clicks. Creating a virtual machine through the Azure Portal feels fast, intuitive, and safe. But as cloud environments grow, manual deployments become impossible to govern. The episode explains how ClickOps inevitably leads to configuration drift, undocumented changes, inconsistent environments, and growing security risks. Topics include: * Manual deployments * Configuration drift * Infrastructure governance * Change management * Compliance * Auditability * Reproducibility * Cloud operations * Security posture * Version control You'll learn why manual infrastructure eventually becomes the biggest obstacle to secure cloud operations. WHY ARM TEMPLATES CHANGED EVERYTHING When Microsoft introduced ARM Templates, organizations finally gained the ability to define Azure infrastructure as code. For the first time, deployments became repeatable, version-controlled, and automatable. However, ARM Templates were built using JSON—a format designed for machines rather than humans. The discussion explores why deeply nested JSON, verbose syntax, difficult error messages, and limited readability created significant friction for engineers working with large Azure environments. Although ARM Templates solved Infrastructure as Code, they also exposed the limitations of using JSON as a programming language.  THE BICEP REVOLUTION Microsoft created Bicep to solve the human side of Infrastructure as Code. Rather than replacing ARM, Bicep compiles directly into ARM Templates while providing a dramatically simpler authoring experience. The episode explores: * Native Azure language * Strong typing * Modules * Parameters * Variables * IntelliSense * Reusable components * Resource references * Visual Studio Code integration By removing unnecessary complexity, Bicep allows architects to focus on infrastructure design instead of syntax. GOVERNANCE IS THE REAL GOAL One of the strongest messages throughout the episode is that Infrastructure as Code isn't primarily about automation. It's about governance. When infrastructure exists as version-controlled code, organizations gain complete visibility into every change, every deployment, and every configuration. The discussion explains how modern governance combines: * Infrastructure as Code * Azure Policy * Git * CI/CD pipelines * Code reviews * Drift detection * Azure Landing Zones * Compliance automation * Security baselines Instead of relying on documentation and human memory, organizations can continuously enforce infrastructure standards through code. AI IS CHANGING INFRASTRUCTURE Large Language Models are beginning to generate Infrastructure as Code automatically. That creates incredible opportunities—but also significant risks. The episode explores why AI-generated infrastructure still requires human governance, policy validation, and automated security controls. Topics include: * AI-generated Bicep * Infrastructure automation * Policy as Code * AI governance * Secure deployments * Human approval * Agentic AI * Infrastructure validation * Continuous compliance The future isn't AI replacing cloud architects—it's AI accelerating infrastructure creation while governance ensures every deployment remains secure. BICEP VS TERRAFORM The conversation also explores one of today's biggest architectural decisions. Should organizations standardize on Bicep or Terraform? Rather than declaring a universal winner, the episode explains where each technology excels. Bicep offers deep Azure integration, immediate support for new Azure services, and seamless alignment with Microsoft's governance ecosystem. Terraform remains the preferred choice for organizations managing true multi-cloud environments across Azure, AWS, and Google Cloud. Choosing the right tool depends less on syntax and more on long-term platform strategy.  WHO SHOULD LISTEN? This episode is perfect for: * Azure Architects * Cloud Engineers * Platform Engineers * DevOps Engineers * Infrastructure Engineers * Security Architects * Enterprise Architects * Azure Administrators * Microsoft MVPs * IT Decision Makers * Anyone building Azure infrastructure Whether you're maintaining legacy ARM Templates, starting new Azure projects with Bicep, implementing Azure Landing Zones, or preparing for AI-assisted infrastructure development, this episode provides valuable insights into the future of cloud governance. If you want to understand why Microsoft's shift from ARM Templates to Bicep represents far more than a new language—and why Infrastructure as Code is becoming the foundation for secure, AI-driven cloud operations—this episode offers a practical roadmap for the next generation of Azure architecture. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support [https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support?utm_source=rss&utm_medium=rss&utm_campaign=rss].

Can Google Sheets Beat Excel: Microsoft MVP David Benaim Settles the Debate

For decades, Microsoft Excel has been the undisputed king of spreadsheets. It powers everything from personal budgets to enterprise reporting, financial modeling, and business intelligence. But Google Sheets has steadily evolved into a powerful cloud-first alternative that challenges many long-held assumptions about spreadsheet software. In this episode of the M365 Show, Microsoft MVP David Benaim joins host Mirko Peters for an in-depth discussion about the strengths, weaknesses, and future of both platforms. Rather than declaring a single winner, David explains why choosing the right spreadsheet depends on your workflow, collaboration needs, automation requirements, and business environment. Whether you're an Excel power user, a Google Workspace enthusiast, a data analyst, or simply curious about modern productivity tools, this episode delivers practical insights backed by years of real-world consulting, training, and Microsoft MVP experience. EXCEL'S 40-YEAR LEGACY David shares the fascinating history of Excel, from its early competition with Lotus 1-2-3 to becoming the world's most widely used spreadsheet application. Despite countless predictions that "Excel is dead," it continues to evolve with powerful new capabilities including Power Query, Power Pivot, Python integration, AI assistance, and seamless integration with the Microsoft ecosystem. The conversation explores why millions of businesses still rely on Excel every day and why spreadsheets continue to be one of the most flexible productivity tools ever created.  WHY GOOGLE SHEETS IS OFTEN UNDERESTIMATED Many professionals still remember Google Sheets as a lightweight online spreadsheet with limited functionality. David explains why that perception is now outdated. Over the past decade, Google has introduced hundreds of improvements, transforming Google Sheets into a serious platform for modern collaboration. Features like cloud-native editing, powerful sharing capabilities, Smart Fill, AI-powered workflows, advanced formulas, and innovative table functionality make it an excellent solution for many organizations. The discussion highlights several areas where Google Sheets actually outperforms Excel, particularly when teams collaborate across organizations or work entirely in the cloud.  GOOGLE SHEETS VS. EXCEL: FEATURE-BY-FEATURE COMPARISON Instead of relying on marketing claims, David compares both platforms across the features professionals actually use every day. Topics include: * Spreadsheet tables and structured data * Formula capabilities * Advanced lookup functions * Pivot Tables * Power Query * Python integration * Google Query functions * VBA vs Google Apps Script * Office Scripts * Performance * Scalability * Business reporting * Automation * Enterprise workflows The discussion demonstrates that both platforms have unique strengths and that understanding those differences allows organizations to choose the best tool for each scenario. REAL-TIME COLLABORATION                                One area where Google Sheets continues to impress is real-time collaboration. David explains why Google's cloud-first approach often provides a smoother experience when multiple people edit the same spreadsheet simultaneously, especially when working with external partners, consultants, and customers. The conversation also compares Microsoft's co-authoring capabilities in Excel, SharePoint, and OneDrive, discussing where Microsoft has improved significantly and where Google still maintains an advantage.  AI IS TRANSFORMING SPREADSHEETS Artificial Intelligence is changing how professionals build reports, analyze data, clean spreadsheets, and automate repetitive work. David compares Microsoft's Copilot with Google's Gemini while also discussing Claude and ChatGPT integrations for Excel. The episode explores: * AI-generated formulas * Data cleaning * Automatic research * Smart Fill * Context-aware spreadsheet automation * AI-assisted reporting * Business productivity improvements Rather than replacing spreadsheets, AI is making them more powerful than ever before. David explains where current AI tools already save significant amounts of time and where they still have room for improvement. POWER BI, BUSINESS INTELLIGENCE, AND MODERN DATA PLATFORMS As organizations become increasingly data-driven, spreadsheets often serve as the starting point before data moves into enterprise reporting platforms. David explains Microsoft's journey from Excel to Power Pivot, Power Query, and eventually Power BI, discussing why business intelligence tools became necessary for enterprise-scale reporting. The conversation also explores Google's Looker Studio and compares its capabilities with Microsoft's analytics ecosystem, helping listeners understand when spreadsheets are enough and when dedicated BI platforms provide additional value.  THE FUTURE OF SPREADSHEETS Will spreadsheets still exist ten years from now? David believes the answer is an emphatic yes. While AI will automate more repetitive work, professionals will continue to need flexible environments where they can quickly analyze data, perform calculations, build reports, and make business decisions. Rather than disappearing, spreadsheets are evolving into intelligent workspaces that combine automation, cloud collaboration, AI, scripting, and business intelligence into a single productivity platform.  EXCEL COMEDY: MAKING SPREADSHEETS FUN One of the most entertaining parts of the conversation is David's unique career outside of Microsoft. Besides being a Microsoft MVP, trainer, consultant, and content creator, David performs stand-up comedy centered entirely around Excel and spreadsheets. He shares how office frustrations, formulas, macros, pivot tables, and even spreadsheet bugs can become surprisingly funny stories that resonate with professionals around the world. It's a refreshing reminder that technology education doesn't always have to be serious.    The episode concludes with a rapid-fire challenge where David shares his immediate opinions on some of the biggest debates in the Microsoft ecosystem. Highlights include his choices between: * Excel vs Google Sheets * Copilot vs Gemini * Windows vs Mac * Keyboard vs Mouse * XLOOKUP vs INDEX MATCH * Power Query vs Pivot Tables * VBA vs Office Scripts * Features Microsoft should copy from Google * Features Google should copy from Microsoft His answers may surprise even experienced spreadsheet professionals. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support [https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support?utm_source=rss&utm_medium=rss&utm_campaign=rss].