blog
165 TopicsNew in Excel for the web: The full Power Query experience
We’ve reached yet another milestone in Excel for the web: The full Power Query user experience is now generally available, including the import wizard and Power Query Editor. After we released the ability to refresh Power Query data from authenticated data sources, we were able to unlock the ability to complete the full user journey of importing data and editing it using Power Query. Getting started Learn all about Power Query in Excel for the web here > See this support article for more information on Power Query data sources in Excel versions. Note: Viewing and refreshing queries is available to all Microsoft 365 Subscribers. The full Power Query experience is available to all Microsoft 365 Subscribers with Business or Enterprise plans. Importing data You can import data into Excel using Power Query from a wide variety of data sources, for example: Excel Workbook, Text/CSV, XML, JSON, SQL Server Database, SharePoint Online List, OData, Blank Table, and Blank Query. Select Data > Get Data: In the Choose data source dialog box, select one of the available data sources: Connect to the data source. After you select the source, the authentication kind will be auto-populated, according to the relevant source (you can still change it, if you like). Press Next, and choose the table you wish to import: Press Transform data to open the table in the Power Query editor, where you can perform many powerful transformations. Note: You can open the editor whenever you need it, by using Data > Get Data > Launch Power Query Editor. When you are done, load the table – press Close & Load to load to the Excel grid: Or Close & Load to - to either load to the Excel grid, or create a connection-only query: See the query was created in the Queries & Connections pane: If you loaded to a table, you can see it on the Excel grid: You can refresh the created query from the Queries & Connections pane, or by using Data > Refresh/Refresh All. You can also perform operations, such as editing the query (with the Power Query Editor), renaming it, and more: What’s next? Future plans include adding data sources and advanced features. Feedback We hope you like this new addition to Excel and we’d love to hear what you think about it! Let us know by using the Feedback button in the top right corner in Excel - add #PowerQuery in your feedback so that we can find it easily. Want to know more about Excel for the web? See What's new in Excel for the web and subscribe to our Excel Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter. Jonathan Kahati, Gal Horowitz ~ Excel Team8.9KViews13likes15CommentsForo Estratégico en Ciberseguridad Nodo Binacional MGCI.
MGCI Nodo Binacional: Talleres Técnicos de Ciberseguridad. Descripción: ¿Buscas fortalecer tus habilidades técnicas con herramientas de Microsoft? Este foro es el centro de operaciones para nuestros próximos talleres de capacitación. Este espacio ofrece recursos exclusivos, noticias de la comunidad y un calendario de eventos virtuales para Mujeres México. Aprende sobre defensa de amenazas, identidad y cumplimiento desde una perspectiva, científica y certificada. Este es un espacio de la Microsoft Global Community Initiative (MGCI) diseñado para que pases de la teoría a la práctica. ¿Qué encontrarás aquí? Anuncios de próximos talleres. Guías de estudio para certificaciones mas. Networking con otros profesionales del sector en México. Bienvenidos. Iniciamos el camino en Ciberseguridad con MGCI México. ¡Hola a todos! Es un gusto saludarlos. Mi nombre es B Aurora Rz Valles, Especialista Certificada por CONAHCYT, Director Regional Mucpaz Binacional Mex-USA Nodo, Red Nacional de Tejedoras de la Patria En El Exterior en Derechos Humanos Internacional y me emociona darles la bienvenida oficial a este foro de la Microsoft Global Community Initiative (MGCI) en México. He creado este espacio con un objetivo claro: pasar de la teoría a la práctica. Queremos que este foro no sea solo de lectura, sino un centro de entrenamiento donde compartiremos fechas de próximos talleres, laboratorios en vivo y recursos estratégicos sobre el ecosistema de seguridad de Microsoft. Gaceta MUCPAZ Insight Blog | Edición 001/ May/ 2026. Impulsando a mujeres inmigrantes desde la tecnología y la construcción de paz Desde el programa MUCPAZ (Mujeres Constructoras de Paz), trabajamos para fortalecer el liderazgo femenino y promover comunidades más seguras, resilientes y conectadas. Nuestra misión es acompañar a mujeres especialmente inmigrantes en su camino hacia el emprendimiento, brindándoles herramientas prácticas que les permitan crecer con confianza y sostenibilidad. En este contexto, espacios como Microsoft Community y su ecosistema de aprendizaje juegan un papel clave, al facilitar el acceso a recursos tecnológicos, formación continua y redes de colaboración para la comunidad hispanoamericana. Como Region Binacional estamos comprometidos en apoyar a mujeres que desean iniciar o fortalecer sus negocios, integrando la tecnología como aliada estratégica. Uno de los pilares de este proceso es la seguridad digital, esencial para proteger tanto su información personal como sus emprendimientos. A través de este acompañamiento, promovemos el aprendizaje en áreas como: Alfabetización digital y uso de herramientas tecnológicas Seguridad digital y protección de datos Uso responsable y estratégico de redes sociales Comercio electrónico y plataformas digitales Educación financiera para emprendedoras Marketing digital con impacto social Liderazgo y redes colaborativas Acceso a recursos y oportunidades para mujeres inmigrantes. El respaldo de comunidades tecnológicas fortalece este camino, permitiendo que más mujeres hispanohablantes accedan a conocimiento, innovación y oportunidades reales de crecimiento. Creemos firmemente que cuando la tecnología se pone al servicio de las personas, se convierte en una herramienta de transformación social. Porque construir paz también es cerrar brechas digitales y abrir oportunidades. #TechCommunity #WomenInTech #DigitalSkills #CommunityImpact #LearningTogether294Views0likes4CommentsUse Copilot in Excel to build your brackets
The matchups are finally set, and the annual question is back: how do you pick a bracket that’s fun and gives you a real shot at predicting the winner—whether you’re following the men’s tournament, the women’s tournament, or both? This year, you can use Copilot in Excel as your bracket sidekick—turning past tournament patterns into quick “what-if” scenarios, stress-testing upset paths, and sanity-checking your picks against historic data. Instead of manually building an analysis, copy/pasting data, and building multiple versions, you can ask in natural language and let Copilot build the analysis for you right inside an Excel workbook. Below are a few fast, practical ways to use Copilot in Excel to build a bracket workbook, explore upside picks (hello, Cinderella runs), and model “if this happens, then what?” outcomes so you can fill your bracket with more confidence than the rest of the group. 1) Set up a bracket workbook Open a new workbook, then open Copilot in Excel. Make sure “Edit with Copilot” is turned on. Start by asking Copilot to create a bracket template: “Create a 2026 [men’s or women’s] college basketball bracket including all the latest teams and seeds. Build dropdowns for each round so I can choose the winner of each matchup all the way to a champion, formatted like a standard bracket. For each dropdown, show only the 2 teams in the matchup based on the winners chose in previous rounds using helper columns." With that foundation in place, you’ve got a clean structure for picks and scenario assumptions. From here, you can make your picks and Copilot can help you add calculations, create “what-if” views, and summarize the implications of different upset paths. Bonus: Want to theme your brackets around your favorite team? First have Copilot generate a simple skills sheet and ask it to follow the instructions when creating brackets. “Create a skills sheet for my favorite team, [Team]. Include the official team colors (with hex codes), mascot/nickname, text colors, and conditional formatting rules for winners/losers.” 2) Stress-test your bracket with real-world scenarios Now for the part that can actually give you an edge: use Copilot to spin up scenario tabs and see how your bracket performs under outcomes that happen all the time in March—Cinderella runs, unexpected seed collapses, and “hot team” momentum that goes against conventional logic. Try some follow-up Copilot prompts like: Cinderella path: “Pick a 10–13 seed to reach the Sweet 16 based on past tournament frequency. Create a version to reflect that upset path, and show which higher-seeded teams I’m fading.” All the 1-seeds don’t make it: “Create a version of my bracket where at least two 1-seeds lose before the Elite Eight. Identify the earliest-round upsets needed and how my champion pick changes.” Favorite team: “Assume my favorite team is [Team]. Build two paths: (1) optimistic (reach the Final Four) and (2) realistic (based on projected path). For each path, show who they’d likely face by seed line and which matchup round matters most for them.” Momentum model: “Calculate a “momentum multiplier” using the conference tournament games and recent performance for each team and use that to fill out a version of my bracket weighted by momentum.” 3) Compare bracket variants and choose your entry Once you’ve built a few scenario versions, Copilot can help you compare them—so you’re not guessing which bracket is better, you’re choosing the one whose risk/reward matches your needs. Use a prompt like: “Create a comparison analysis for all my bracket scenarios in this workbook including charts. Include number of upset picks by round, and my top 5 most ‘contrarian’ picks across all my brackets. Give a recommendation for which to submit if I’m trying to win my bracket challenge or simply play it safe.” Copilot can generate the comparison table, highlight the key differences, and summarize the tradeoffs in plain language—so you can decide whether you want a safer entry, a balanced upset strategy, or a bold bracket designed to win big. Your turn: build your bracket with Copilot Ready to try it? Open Excel, start a new workbook, and use Edit with Copilot to create your brackets. Once you’ve got a bracket you like, share it with your league, your family, or your coworkers.36KViews2likes0Comments