Microsoft Excel Podcast Shows

Microsoft Excel is Microsoft's spreadsheet and data analysis application for organising, calculating, analysing, and visualising business data. Available through Microsoft 365 on desktop, web, and mobile, Excel provides formulas, functions, tables, charts, PivotTables, Power Query, data analysis tools, and AI-powered capabilities through Microsoft Copilot.

Excel & Microsoft Copilot

Microsoft Copilot in Excel uses AI to help users analyse data, identify trends, create formulas, summarise information, and generate insights. Copilot can help explain formulas, highlight patterns and anomalies, and provide suggestions for working with structured data, making complex spreadsheet analysis more accessible.

Excel Formulas, Functions & Data Analysis

Excel provides a comprehensive collection of formulas and functions for calculations, data manipulation, lookup operations, conditional logic, statistical analysis, and financial modelling. Features such as XLOOKUP, dynamic arrays, LET, LAMBDA, PivotTables, and conditional formatting help users analyse large datasets and build powerful business spreadsheets.

Power Query & Power Pivot

Power Query enables users to connect to, transform, clean, and combine data from databases, files, APIs, and other data sources. Power Pivot provides data modelling capabilities using relationships, calculated measures, and DAX. Together, these tools enable Excel users to build sophisticated data analysis and reporting solutions.

Excel Online & Collaboration

Excel for the web enables users to create, edit, and analyse spreadsheets directly in a browser. Workbooks can be stored in OneDrive or SharePoint Online, allowing multiple users to collaborate in real time. Excel also integrates with Microsoft Teams for sharing and working on spreadsheets within collaborative workspaces.

Excel & Power Platform Integration

Excel integrates with Power BI, Power Apps, Power Automate, and Microsoft Dataverse to support business intelligence and process automation. Excel data can be imported into Power BI for reporting, used as a data source for Power Apps and Power Automate, and connected with business systems to automate data processing and reporting workflows.

Key Microsoft Excel Topics on D365Hub

• Microsoft Excel and Copilot — AI-powered data analysis and insights
• Excel formulas, functions, XLOOKUP, dynamic arrays, and advanced calculations
• PivotTables, charts, dashboards, and Excel data visualisation
• Power Query for data import, transformation, and data cleansing
• Power Pivot, data models, relationships, and DAX
• Excel integration with Power BI, Power Apps, and Power Automate
• Excel and Microsoft Dataverse integration scenarios
• Excel Online, OneDrive, SharePoint, and real-time collaboration
• Office Scripts and Excel automation
• Microsoft Graph APIs and Excel workbook automation