Month: September 2024
Microsoft 365 Copilot onboarding hub—where onboarding AI is as intuitive as using it
Securely onboarding AI across an organization can involve several processes. Applying access controls, monitoring integrations with existing infrastructure, managing end user adoption, and more can make the project downright daunting. Add on challenges like staffing shortages and limited in-house AI expertise and you just might decide to put off introducing AI—even a system as valuable as Microsoft 365 Copilot—until tomorrow, or even next month.
At FastTrack for Microsoft 365, we get it.
We also know AI is too important to put off. So, to continue helping admins implement AI across their organizations as seamlessly and responsibly as possible, Microsoft 365 engineers have updated a few key portions of the Microsoft 365 Copilot onboarding hub.
These updates help simplify Microsoft 365 Copilot onboarding processes so you can empower your organization to achieve more with AI quicker and more securely than ever before.
What’s new at the Microsoft 365 Copilot onboarding hub?
The Microsoft 365 Copilot onboarding hub has a fresh look and feel, including an upgraded, modern UI, stateful personalization, and exportable project management.
1. Modern UI
The first thing you may notice is the sleek, new card-based layout that now displays Microsoft 365 Copilot’s Readiness assessment and three setup guides: Quickstart, Foundations+, and Advanced configurations.
2. Microsoft 365 Copilot setup guides: Interactive, personalized, actionable
Don’t let the onboarding hub’s pretty (inter)face fool you though, there’s more value behind those cards than meets the eye. First, here’s a quick run-down of each:
Readiness assessment: Start here to optimize your tailored setup experience. The responses you provide help Copilot’s setup guides determine which tasks you should complete, and in what order, for the safest and most efficient onboarding experience.
Quickstart: In this, Copilot’s most streamlined setup guide, you can safely get Copilot up and running right away, with minimal configuration and customization. If your organization needs a little more time to shore up data hygiene and governance, you can temporarily restrict Copilot search with RSS (Restricted SharePoint Search) while completing those projects.
Foundations+: Build on your Quickstart setup by following steps in the Foundations+ setup guide for fine-tuning data protection settings and readiness options according to your organizational policies.
Advanced configuration: Leverage the full potential of Copilot with advanced security, privacy, and data protection controls. This Advanced configuration guide also provides advanced Microsoft 365 Copilot adoption resources to help you boost end-user engagement.
Each Microsoft 365 Copilot setup guide uses automated wizards with customizable, stateful personalization to lead you, step-by-step, through streamlined, interactive setup experiences.
This means Copilot setup guides are personalized according to your organization’s specific scenarios and requirements, resulting in a unique and highly proficient onboarding experience.
How it works: Information from your Microsoft 365 organization profile, combined with your readiness assessment responses, prepopulates each guide for a comprehensive overview of your organization’s environment. This, coupled with Microsoft’s engineering expertise, allows each setup guide to accurately suggest your next task and lead you through the most efficient and secure path to onboarding Microsoft 365 Copilot.
As you advance and complete tasks, each guide also tracks your progress, accounts for tasks you’ve already finished, and adjusts Microsoft’s next suggested actions accordingly. Look for personalized task tables within the guides as well as suggested action cards at the Copilot onboarding hub.
If you take a break, Copilot’s setup guides remember what steps you’ve already completed and suggest the next recommended task when you return.
For example:
Say you’re an organization that owns E5 licensing and has deployed sensitive data policies—maybe you’re a bank. By responding “Yes” to Copilot’s readiness assessment question, “Does your organization have regulated or sensitive data types?” you might be instructed to review and apply Microsoft Purview best practices next to ensure Microsoft’s strongest security and compliance standards.
On the other hand, you could be a small organization that wants to add Copilot to your Teams subscription primarily to iterate on images. If you respond “No” to the readiness assessment question, “Do you have regulated or sensitive data types?” the guide is likely to minimize your number of basic onboarding steps.
Mature organizations and long-time customers who’ve already deployed several Microsoft 365 products may have already completed Microsoft Purview best practices. If you’re an admin in this scenario, you’ll likely have fewer steps in your Microsoft 365 Copilot onboarding journey. The guides will detect and update previously completed or nonapplicable tasks and highlight your remaining, pertinent tasks.
In another scenario, maybe your organization purchased 100 Microsoft 365 Copilot licenses. You’ve finished assigning them all and have completed every onboarding guide. Back at the Microsoft 365 Copilot onboarding hub, you may find personalized suggested action cards to guide you on next steps. For example:
3. Expanded project management for your Microsoft 365 Copilot onboarding tasks
We know admins rely on integrated and comprehensive project management tools to assign tasks, set deadlines, and track setup progress. To help make your job easier, Microsoft engineers have streamlined project management too.
Now you can find workload monitoring inside each Microsoft 365 Copilot setup guide that is:
Assignable: Easily distribute tasks among team members.
Trackable: Keep an eye on progress.
Schedulable: Set deadlines and timelines.
Exportable: Track Copilot onboarding tasks outside of the hub.
The option to export task management is a new and practical update. To carry it out, simply place task information into a CSV, and then import the information to your usual project management software.
Why use FastTrack for Microsoft 365 resources to onboard Copilot?
Can we set up and onboard Microsoft 365 Copilot manually instead, by following a Microsoft Learn article? you might wonder.
Yes, you can. In fact, Microsoft Learn articles are valuable, comprehensive resources for anyone looking to understand Microsoft technologies. They’re also freely accessible and kept up to date.
However, Learn articles are static resources with universal guidance and information that’s applicable to many different industries and user environments. Following them to onboard Microsoft 365 Copilot across your organization involves interpreting which tasks and best practices apply to your specific environment and then making sure you’ve fulfilled each one.
Microsoft 365 Copilot setup guides: a more efficient and secure way to onboard AI
Aligned with Microsoft’s commitment to making AI broadly and responsibly available—thereby empowering every person and every organization on the planet to achieve more—Microsoft engineers have designed Microsoft 365 Copilot automated setup guides to be:
Tailored to your current state: From a panoramic vantage point, each Microsoft 365 Copilot setup guide assesses your organization’s environment to curate the most relevant onboarding and configuration path for you. This allows for pointed, prescriptive recommendations you can rely on.
Incorporated with Microsoft best practices: You’ll get a smooth, guided setup experience with prepopulated information and step-by-step instructions defined by Microsoft experts for an optimal setup experience.
Streamlined: You’ll know you’re prioritizing the correct order of operations as you progress through your Microsoft 365 Copilot onboarding journey. You won’t have to worry whether you’ve made a wrong move or missed a helpful resource.
Comprehensive: Should you need additional onboarding or adoption resources, Copilot’s guides will connect you to the right resource at the right point in your setup journey.
Make the Microsoft 365 Copilot onboarding hub your destination for onboarding AI
With modern UI, improved automation, and new capabilities, the Microsoft 365 Copilot onboarding hub and setup guides offer a faster and safer way to onboard AI.
Replace guesswork and wasted time with efficiency and security.
Feel confident you’re onboarding AI responsibly.
Shorten your time to discovering value with Microsoft 365 Copilot.
Head over to the Microsoft 365 Copilot onboarding hub and empower your end users to achieve more today, instead of waiting until tomorrow.
Navigating to the Microsoft 365 Copilot onboarding hub
Bookmark the Microsoft 365 Copilot onboarding hub for quickest access or navigate there by following these instructions:
Sign in to the Microsoft 365 admin center.
Follow Setup from the side menu and select Advanced deployment guides & assistance.
Scroll down or filter guides by Product and select Set up Microsoft 365 Copilot.
This takes you directly to Setup Microsoft 365 Copilotopilot for Microsoft 365, your Microsoft 365 Copilot onboarding hub. You’ve arrived!
Need onboarding assistance?
Customers with eligible licenses can submit a request for assistance to FastTrack for help onboarding Copilot.
Microsoft Tech Community – Latest Blogs –Read More
Office LTSC 2024 is now available
Microsoft 365 offers the cloud-backed apps, security, and storage that customers worldwide rely on to achieve more in a connected world – and lays a secure foundation for leveraging generative AI to go even further. Investing in our cloud productivity solutions and the AI-powered innovation they support will continue to be Microsoft’s priority.
Still, we know that some customer scenarios require a different approach. Some devices must never be connected to the internet; others need to remain unchanged for years at a time. We remain committed to supporting our customers and these scenarios. Earlier this year, we offered a public preview of Microsoft Office Long Term Servicing Channel (LTSC) 2024. Today, we’re announcing the general availability of this next perpetual version of Office for commercial and government customers.
An updated solution for specialized needs
Office LTSC 2024 offers a locked-in-time version of familiar productivity tools, updated with a subset of the features that have been added to Microsoft 365 Apps for enterprise over the last three years. New features for this release include Dynamic Charts and more than a dozen new text and array functions in Excel, enhanced search and meeting creation options in Outlook, and improvements to performance, security, and accessibility. Learn more about what’s new.
Office LTSC 2024 will be supported for five years under the Fixed Lifecycle Policy, and – like prior versions – will be deployable alongside Microsoft 365 Apps using a common set of tools to enable customers to more easily manage hybrid environments. Learn more about how to deploy and manage Office LTSC at Overview of Office LTSC 2024.
Choosing the best productivity suite for your organization
While Office LTSC 2024 offers many significant improvements over the previous Office LTSC release, as an on-premises product it does not include the cloud-based capabilities of Microsoft 365 Apps, like real-time collaboration, AI-driven automation, or cloud-backed security and compliance capabilities. And for customers who need additional flexibility on deployment and connectivity – but not a fully disconnected solution – Microsoft 365 has options that can help. For example, device-based licensing can simplify management of Microsoft 365 Apps in settings like computer labs or hospitals where devices are shared by many users. And extended offline access can be used to maintain access to Microsoft 365 Apps on devices that need to be disconnected from the internet for up to six months at a time. Microsoft 365 (or Office 365) is also required to subscribe to Microsoft 365 Copilot; as a disconnected product, Office LTSC does not qualify.
Microsoft 365 Apps [1]
Office LTSC 2024
Apps included
Word, Excel, PowerPoint, Outlook, OneNote, OneDrive, Microsoft Access (Windows Only), Microsoft Publisher (Windows Only) [2], Sway, Microsoft Forms
Word, Excel, PowerPoint, Outlook, OneDrive, OneNote, Microsoft Access (Windows Only) [3]
Desktop apps
Premium apps installed on up to 5 PCs or Macs
Classic apps installed on 1 PC or Mac
Mobile apps
Create & edit on up to 5 phones + 5 tablets
Web apps
Create & edit online
Eligible for Microsoft 365 Copilot add-on [4]
Cloud storage
1 TB per user
Feature updates
New features and security updates delivered via Current, Monthly, or Semi-Annual channels
Security updates only
Shared devices
Shared computer activation or device-based licensing available
Device-based licensing only
Connectivity requirements
Internet connection required for activation, license validation, and internet-based functionality. Extended offline access available to enable devices to stay disconnected for up to six months at a time.
No internet connection required
Embracing the future of work
Microsoft 365 offers the most secure, productive, and cost-effective solution for most organizations, and positions customers to unlock the transformative power of AI with Microsoft 365 Copilot. Especially as we approach the end of support for Office 2016 and Office 2019 on October 14, 2025, we encourage customers still using these solutions to transition to a Microsoft 365 subscription that suits their needs as a small business or a larger organization. And for scenarios where that is not possible – where a disconnected, locked-in-time solution is required – this new release reflects our commitment to supporting that need.
Learn more
Office LTSC 2024 is available to existing commercial and government volume-licensed customers today, along with new on-premises versions of Project and Visio. These products will be generally available to all customers on October 1. We will share more about Office 2024 for consumers in the coming weeks. For more information about Office LTSC 2024 and how it compares to Microsoft 365 Apps for enterprise, please visit the Office LTSC plan comparison page. If your organization is ready to take the next step toward the AI-powered future, find out how to get started with Microsoft 365 today.
Notes:
[1] Applies to Microsoft 365 Apps for enterprise and Microsoft 365 Apps for business. All Microsoft 365 and Office 365 suites that include desktop apps also include everything listed here – and more. Learn about the available options.
[2] Microsoft Publisher will be retiring in October 2026.
[3] Microsoft Access is included only with Office LTSC Professional Plus.
[4] Microsoft 365 Copilot may not be available for all markets and languages. To purchase, customers must have a qualifying Microsoft 365 plan for enterprise or business.
Microsoft Tech Community – Latest Blogs –Read More
Gelombang Kedua Microsoft Copilot: Pages, Python di Excel, dan Agents
Read the English version here.
Hari ini kami meluncurkan gelombang berikutnya dari Microsoft 365 Copilot, menyatukan web + work + Pages sebagai sistem desain yang betul-betul baru untuk bekerja.
Pertama, Business Chat adalah pola kerja baru yang mengubah semua konten organisasi Anda menjadi database yang kaya akan informasi dan insights, memungkinkan Anda berkolaborasi dengan Copilot seperti partner. Business Chat membawa data yang ada di web dan data dari pekerjaan Anda ke dalam Copilot Pages – sebuah artefak digital pertama untuk era AI.
Kedua, kami melakukan transformasi pada Copilot di aplikasi Microsoft 365. Pelanggan kami memberi tahu kami bagaimana Copilot in Teams telah mengubah pengalaman rapat selamanya. Faktanya, pengalaman ini menjadi pengalaman dengan nilai tertinggi dari semua pengalaman yang Copilot hadirkan. Kini, kami senang dapat melakukan hal yang sama untuk analisis data tingkat advanced di Excel, storytelling dinamis di PowerPoint, mengelola kotak inbox Anda di Outlook, dan masih banyak lagi.
Ketiga, kami memperkenalkan Copilot agents, memudahkan dan mempercepat proses automasi serta proses operasional bisnis Anda – memungkinkan Anda untuk meningkatkan kapabilitas tim Anda.
Kami senang dapat membagikan pembaruan ini dengan pelanggan kami di seluruh dunia. Dari perusahaan besar hingga bisnis berskala kecil, mereka setiap harinya membantu Copilot menjadi lebih baik. Hampir 1.000 pelanggan telah memberikan feedback langsung seputar Copilot. Sejak Copilot tersedia secara umum, kami telah menghadirkan lebih dari 150 fitur dan kemampuan baru. Kini dengan GPT4o dan orkestrasi yang semakin meningkat, kami meningkatkan kinerja Copilot secara signifikan. Rata-rata, respons Copilot menjadi lebih dari dua kali lebih cepat, dan tingkat kepuasan telah meningkat hampir 3X*. Saat Anda menggabungkan semua ini, kami telah membangun feedback loop AI terbaik di dunia dengan Copilot. Dan kami akan terus membawa semua model terbaru ke Copilot dengan cepat, meningkatkan kapabilitas produk berdasarkan masukan Anda dengan cepat, serta menambahkan kemampuan baru dan model baru, termasuk OpenAI o1 dengan kemampuan penalaran lanjutan.
Memperkenalkan Copilot Pages—artefak digital baru untuk era AI
Copilot adalah antarmuka (UI) baru untuk AI. Ini semua dimulai dengan BizChat, pusat jaringan (central hub) yang menggabungkan semua data Anda—data web, data kerja, dan data lini bisnis—langsung ke dalam alur kerja Anda. BizChat merupakan tempat Anda dapat bekerja dengan Copilot seperti partner, merealisasikan nilai dari semua konten di organisasi Anda, sehingga setiap artefak menjadi aset bisnis yang dapat digunakan kembali. Hari ini, kami mengumumkan Copilot Pages, sebuah kanvas dinamis dan persisten di BizChat, yang dirancang untuk kolaborasi AI multiplayer. Ini adalah langkah pertama dalam sistem desain baru kami untuk knowledge work.
Dengan Pages, semua data di organisasi Anda—baik yang dibuat oleh manusia atau AI—menjadi persisten, dapat diakses, dan berharga. Pages mengambil konten hasil produksi AI yang bersifat sementara dan membuatnya tahan lama, sehingga Anda dapat mengeditnya, menambahkannya, dan membagikannya dengan orang lain. Anda dan tim Anda dapat bekerja secara kolaboratif dalam sebuah page dengan Copilot, melihat pekerjaan semua orang secara real time, dan beriterasi dengan Copilot seperti partner; menambahkan lebih banyak konten dari data Anda, file, dan web ke Page Anda. Ini adalah pola kerja baru yang sesungguhnya—multiplayer, kolaborasi manusia ke AI ke manusia. Untuk pelanggan Microsoft 365 Copilot, Pages mulai diluncurkan hari ini, dan akan tersedia secara umum akhir September 2024 mendatang.
Dalam beberapa minggu mendatang, kami juga akan membawa Pages ke lebih dari 400 juta orang yang memiliki akses ke Microsoft Copilot versi gratis, saat mereka sign in dengan akun Microsoft Entra—menawarkan kombinasi pengalaman web (web grounding), perlindungan data Perusahaan (Enterprise Data Protection), dan Pages. Hari ini, Anda dapat mencoba Microsoft Copilot di Microsoft.com/copilot, serta menyematkan Copilot langsung ke dalam alur kerja Anda di aplikasi Microsoft 365, dan segera, di Outlook serta Teams.
Meningkatkan produktivitas dengan Copilot
Bagi jutaan orang di seluruh dunia, pekerjaan terjadi di aplikasi Microsoft 365. Di situlah bekerja bersama Copilot sudah menjadi kebiasaan sehari-hari, memberikan manfaat dari sisi produktivitas pribadi dan penghematan waktu. Dengan Gelombang Kedua, kami mengambil semua yang kami pelajari dari pelanggan kami dan menggunakannya untuk membuat Copilot menjadi lebih baik lagi.
Copilot in Excel
Ketika orang ingin bekerja dengan data dan mendapatkan nilai nyata dari data tersebut, mereka beralih ke Excel—ini adalah antarmuka untuk semua data bisnis Anda. Hari ini, kami senang dapat mengumumkan bahwa Copilot in Excel sekarang tersedia secara umum. Kini, Anda dapat bekerja dengan data yang belum diformat dalam bentuk tabel. Kami telah menambahkan keterampilan baru untuk memanfaatkan kekuatan optimal Excel, dengan dukungan bagi lebih banyak rumus/formula seperti XLOOKUP dan SUMIF; pemformatan bersyarat; dan kemampuan untuk beriterasi dengan Copilot pada visualisasi seperti grafik dan PivotTable, agar sesuai dengan berbagai kebutuhan Anda. Copilot di Excel sekarang juga dapat bekerja dengan teks, selain dengan data numerik.
Kami bahkan telah melangkah lebih jauh. Hari ini, kami mengumumkan Copilot in Excel dengan Python, menggabungkan kekuatan Python—salah satu bahasa pemrograman untuk bekerja dengan data paling populer di dunia—dengan Copilot in Excel. Sekarang, siapapun dapat bekerja dengan Copilot untuk melakukan analisis lanjutan seperti forecasting, analisis risiko, machine learning, dan memvisualisasikan data kompleks—semua menggunakan bahasa sehari-hari, tanpa memerlukan pemrograman/coding. Ini seperti memiliki tambahan data analyst yang terampil di tim. Copilot in Excel dengan Python saat ini tersedia dalam versi pratinjau publik (public preview).
Copilot in PowerPoint
Tidak ada yang dapat mengubah ide menjadi presentasi rapi hanya dalam satu prompt. Sekarang, tersedia secara umum, Narrative builder di PowerPoint membantu Anda bekerja dengan Copilot seperti partner, beriterasi bersama untuk membangun draf pertama yang menarik dalam hitungan menit, sambil tetap mengendalikan proses kreatif. Copilot menggunakan prompt Anda untuk membangun outline dengan topik yang dapat Anda edit dan perbaiki untuk membuat draf pertama presentasi Anda. Segera, Anda akan dapat menambahkan file ke outline untuk memperkuat landasan topik Anda. Dan dengan Brand manager, Copilot dapat memanfaatkan template brand perusahaan Anda, sehingga presentasi Anda siap digunakan untuk perusahaan dan sesuai brand yang diwakilkan. Segera, Copilot akan dapat menyertakan gambar yang disetujui perusahaan dari SharePoint Organization Asset Library Anda.
Copilot in Teams
Dalam berbagai rapat, ada dua percakapan penting: yang diucapkan, dan yang terjadi di chat. Copilot in Teams sekarang dapat menalar transkrip serta chat rapat untuk memberi Anda gambaran lengkap tentang apa yang dibahas. Misalnya, Anda dapat meminta Copilot untuk memberitahukan apakah ada pertanyaan yang Anda lewatkan dalam rapat. Copilot akan dengan cepat memindai apa yang dikatakan peserta rapat, serta apa yang diketik dalam chat, untuk melihat apakah ada yang tidak terjawab. Sekarang dengan Copilot in Teams, tidak ada pertanyaan, ide, atau kontribusi yang tertinggal. Fitur ini tersedia secara umum mulai bulan ini.
Copilot in Outlook
Kita semua berkutat dengan terlalu banyak email. Sekarang, dengan Prioritize my inbox, Copilot in Outlook membantu Anda menemukan pesan yang penting dengan cepat, menganalisis inbox Anda berdasarkan konten email dan role Anda—seperti siapa atasan Anda dan thread email mana yang Anda selama ini telah responsif. Tidak perlu lagi menyaring pesan panjang—Copilot secara otomatis menghasilkan ringkasan singkat dari setiap email dan menyertakan alasan mengapa pesan tersebut diprioritaskan, bersama dengan insights utama. Segera, Anda akan dapat mengajarkan Copilot topik, kata kunci, atau orang tertentu yang penting bagi Anda; memastikan email tersebut ditandai sebagai prioritas tinggi. Fitur-fitur ini akan mulai tersedia dalam versi pratinjau publik mulai akhir 2024.
Copilot in Word
Saat bekerja di Word, Anda sering kali perlu membawa konten dari dokumen dan aplikasi lain. Namun, mencari dan menggabungkan informasi yang Anda butuhkan, bisa memakan waktu dan mengganggu penulisan Anda. Mulai tersedia akhir bulan ini, Copilot in Word akan memungkinkan Anda merujuk tidak hanya data dari web; data kerja seperti Word, PowerPoint, PDF; dan dokumen terenkripsi; tetapi juga data email dan rapat. Seluruh pengintegrasian informasi ini langsung disertakan ke dalam alur kerja Anda, sehingga Anda dapat menyelesaikan draf pertama yang baik dengan cepat. Copilot in Word adalah partner menulis yang baik. Pembaruan terbaru meliputi on-canvas start experience dengan rekomendasi prompt untuk memulai proses kreatif Anda, dan kemampuan untuk berkolaborasi dengan Copilot saat Anda mengerjakan bagian tertentu dari dokumen Anda – keduanya tersedia secara umum.
Copilot in OneDrive
OneDrive adalah sebuah repositori lengkap di mana para profesional menyimpan konten kerja pribadi mereka—tetapi kita semua menghabiskan terlalu banyak waktu untuk mencoba menemukan dokumen yang tepat atau mengingat dokumen mana yang memiliki konten yang kita butuhkan. Copilot in OneDrive dapat menalar semua file Anda dengan cepat untuk menemukan informasi yang Anda butuhkan, memudahkan Anda untuk mendapatkan insights, merangkum file, dan membandingkan hingga lima file dengan ringkasan yang jelas serta mudah dibaca, tentang detail dan perbedaan dalam masing-masing file tanpa membuka file tersebut. Copilot in OneDrive sekarang mulai di-roll out, dan akan tersedia secara umum pada bulan ini.
Meningkatkan kapabilitas tim Anda dengan Copilot agents
Mempercepat setiap proses bisnis dengan Copilot—untuk meningkatkan pendapatan dan mengurangi biaya—adalah cara terbaik memperoleh keunggulan kompetitif di era AI. Memperkenalkan Copilot agents, yang sekarang tersedia secara umum. Agents adalah asisten AI yang dirancang untuk mengotomatisasi dan menjalankan proses bisnis, bekerja dengan atau untuk manusia. Kapabilitas mereka beragam, dari agent sederhana yang bekerja dengan format prompt-dan-respons, agent yang menggantikan tugas berulang, hingga agent yang lebih advanced dan otonom. Dengan Copilot agents, Anda dapat melakukan semua ini dan bahkan lebih banyak lagi, dengan membawa kekuatan agent langsung ke dalam alur kerja Anda. Copilot agents bekerja untuk Anda di balik layar, sepenuhnya dikelola dan diorkestrasikan oleh Copilot. Sederhana dan aman untuk dikelola, semua Copilot agents memiliki prinsip Responsible AI dan janji yang sama—data Anda tidak pernah meninggalkan batas kepercayaan Microsoft 365, dan semuanya terjadi dalam tenant Anda. Anda juga dapat memanfaatkan agent yang sudah dibangun sebelumnya seperti Visual creator agent, AI yang membantu Anda membuat gambar, desain, dan (segera) video.
Untuk mempermudah pengembangan Copilot agents, hari ini kami mengumumkan agent builder, pengalaman baru dan sederhana yang didukung oleh Copilot Studio.
Sekarang, siapapun dapat membuat Copilot agent langsung di BizChat atau SharePoint dengan cepat, merealisasikan nilai dari repositori pengetahuan luas yang disimpan dalam file SharePoint Anda. Bayangkan, misalnya, menggunakan agent builder untuk membangun agent langsung di alur kerja Anda di BizChat, menghubungkannya ke SharePoint untuk memberdayakannya dengan data proses bisnis yang relevan secara cepat, dan dalam beberapa saat Anda sudah memiliki sumber daya pengetahuan kuat yang dapat Anda bagikan dengan kolega Anda di Teams ataupun Outlook. Anda dapat me-mention agen (dengan @mention) seperti Anda me-mention rekan kerja Anda yang lain, berbagi informasi baru, dan mengajukan pertanyaan yang dapat agent Anda jawab secara real time. Jika Anda ingin mengembangkan agent yang lebih advanced dari sana, Anda dapat menyesuaikannya lebih lanjut di Copilot Studio, men-deploy-nya untuk melakukan hal-hal seperti menghubungkan Anda ke sumber data, atau mengambil tindakan tertentu atas nama Anda.
Copilot agents dan agent builder di BizChat akan diluncurkan secara umum kepada semua pelanggan dalam beberapa minggu mendatang. Copilot agents dan agent builder di SharePoint akan memasuki versi pratinjau publik pada awal Oktober.
Pelanggan memperoleh beragam manfaat dari Copilot
Selama 18 bulan terakhir, bekerja dengan Copilot telah menjadi kebiasaan sehari-hari bagi orang-orang di mana saja, membantu mereka menyelesaikan tugas lebih cepat, mengadakan rapat yang lebih bermakna, berkolaborasi lebih efektif, dan menyederhanakan proses bisnis. Pelanggan Copilot tumbuh lebih dari 60 persen dari kuartal ke kuartal, sementara jumlah orang yang setiap harinya menggunakan Copilot di tempat kerja telah berlipat ganda. Hari ini, kami mengumumkan bahwa Vodafone menginvestasikan Copilot bagi 68.000 karyawan. Amgen menggunakan Copilot untuk mempercepat penelitian tentang penyakit langka. Agen layanan pelanggan di Teladoc menghemat hingga lima jam setiap minggunya setelah menggunakan Copilot untuk menyusun respons terhadap pertanyaan umum klien. Marketers di Finastra menggunakan Copilot untuk beralih dari ideasi konten ke proses produksi 75 persen lebih cepat. Rata-rata, pengguna Copilot di Honeywell menghemat 92 menit per minggu setelah menggunakan Microsoft 365 Copilot, setara dengan 74 jam selama satu tahun penuh penggunaan**.
“Dulunya, ketika kami membangun kampanye besar seperti kampanye Finance is Open, kami memerlukan waktu tiga bulan untuk menghasilkan konten kampanye tersebut. Sekarang, kami bisa melakukannya dengan Copilot dalam waktu kurang dari satu bulan”. – Joerg Klueckmann, Head of Corporate Marketing & Communications, Finastra
Melihat ke Depan
Hari ini adalah permulaan dari gelombang kedua inovasi Copilot—dalam dua bulan ke depan, kami akan berbagi lebih banyak lagi tentang bagaimana Copilot meningkatkan produktivitas dan mempercepat nilai bisnis bagi setiap pelanggan. Stay tuned.
Mulailah menggunakan Copilot hari ini—kunjungi Microsoft365.com/copilot atau unduh aplikasi Microsoft 365 di perangkat seluler Anda.
Untuk insights dari riset terbaru mengenai masa depan pekerjaan dan generative AI, kunjungi WorkLab.
###
*Di antara respons Copilot dalam Bahasa Inggris
**Statistik berasal dari internal survei Honeywell terhadap 5.000 karyawan, dengan 611 di antaranya merespons.
Can anyone help me with my code? I want to apply the windowing function to my code with a duration of 200 ms to observe the leakage.
function [y, signalT, notch_intensity] = signalfunccycle(Gridlength, startfreq, endfreq, notchstart1, notchend1, datalength)
close all;
clear all;
PIx2 = 2 * pi; % used to calculate the frequency values of the output signal
fstart = 0;
Gridlength = 200e-3;
startfreq = 40e3;
endfreq = 200e3;
stimeStep = 5e-8;
datalength = round(Gridlength / stimeStep);
notchstart1 = 116000;
notchend1 = 119000;
dataN = datalength;
Stimelength = Gridlength;
fend = 10^6;
Fs = dataN / Gridlength;
NFFT = dataN; % Number of points used in the FFT analysis
fstep = (Fs – fstart) / NFFT; % Point step
T = 1 / Fs;
Stime = linspace(0, Stimelength, dataN);
t = (0:dataN-1) * T; % Length of time
signal = zeros(1, length(t));
f1 = notchstart1;
f2 = notchend1;
f3 = notchstart1;
f4 = notchend1;
for freq = startfreq:0.5*10^3:endfreq
if (f1 <= freq && freq <= f2) || (f3 <= freq && freq <= f4)
continue;
end
signal = sin(PIx2 * freq * t + pi) + signal;
end
%% Time-domain signal graphs
figure(1);
plot(Stime, signal);
grid on;
title(‘signal’);
xlabel(‘time’);
ylabel(‘amplitude’);
%% FFT
fMax = NFFT / 2 + 1; % The maximum frequency to plot
signalFFT0 = fft(signal, NFFT); % FFT of the signal
signalFFT_phase = angle(fft(signal, NFFT)); % Phase of the FFT result
signalFFT = abs(fft(signal, NFFT)); % Absolute value (modulus) of the FFT result
signalFFTShow = 2 * signalFFT / dataN; % Actual amplitude values
signalFFTShow(1) = signalFFTShow(1) / 2; % DC component
f = Fs / 2 * linspace(0, 1, fMax); % Actual frequencies
% Plot FFT of the signal
figure(2);
plot(f, signalFFTShow(1:fMax), ‘r’, ‘LineWidth’, 3); % Red color, line width set to 3
grid on; % Display grid lines
title(‘FFT Signal’);
xlabel(‘Frequency’);
ylabel(‘Amplitude’);
%% Phase function modulation
signalstart = startfreq;
signalend = endfreq;
Istart = round(signalstart / fstep);
Iend = round(signalend / fstep);
Itotal = Iend – Istart;
N1start1 = round(f1);
N1end1 = round(f2);
N1start2 = round(f3);
N1end2 = round(f4);
signalphase(1:NFFT) = 0;
for I = 1:NFFT
if (I <= N1end1 && I >= N1start1) || (I <= N1end2 && I >= N1start2)
signalphase(I) = 0;
else
signalphase(I) = pi / 2 * (I – Istart) + 1 * pi / Itotal / 2 * (I – Istart)^2;
end
end
signalF = 1/2 * signalFFTShow .* exp(1i * (signalphase + signalFFT_phase));
signalT = ifft(NFFT * signalF);
t1 = (0:NFFT-1) * T;
%% Phase spectrogram
x1 = 1:NFFT;
figure(3);
plot(x1, signalphase)
xlabel(‘frequency’);
ylabel(‘Phase’);
title(‘Phase spectrum’);
%% Signal waveform after modulation
signaltime = (0:NFFT-1) * T;
figure(4);
plot(signaltime, real(signalT));
xlabel(‘time’);
ylabel(‘amplitude’);
signalT_real = real(signalT);
savefile = ‘signalT_real.txt’;
x = Stime’;
y = signalT_real’;
save(savefile, ‘x’, ‘y’, ‘-ASCII’)
%% STFT Calculation
NN = 10;
win_size = round(datalength / NN);
overlap = 0;
fft_size = win_size * 2 + 1;
stft_result = [];
for i = 1:win_size*(1-overlap):length(signalT)-win_size
window = signalT(i:i+win_size-1);
fft_result = fft(window, fft_size+1);
stft_result = [stft_result; abs(fft_result(1:fft_size))];
end
time_axis = linspace(0, Gridlength, size(stft_result, 1));
freq_axis = linspace(fstart, fend, fft_size);
% Extract intensity for notch frequencies (116 to 119 kHz)
notch_indices = find(freq_axis >= 116000 & freq_axis <= 119000);
notch_intensity = mean(stft_result(:, notch_indices), 2);
% Plot the STFT spectrogram
figure(5);
imagesc(time_axis * 1000, freq_axis / 1000, stft_result.’);
axis([Gridlength * 950 Gridlength * 1050 110e3 / 1000 125e3 / 1000]);
colorbar;
ylabel(‘Frequency (kHz)’);
xlabel(‘Time (ms)’);
% % Plot the intensity over time for the notch frequencies
% figure(6);
% plot(time_axis * 1000, notch_intensity, ‘LineWidth’, 2);
% xlabel(‘Time (ms)’);
% ylabel(‘Intensity’);
% title(‘Intensity at Notch Frequencies (116 to 119 kHz)’);
% grid on;
endfunction [y, signalT, notch_intensity] = signalfunccycle(Gridlength, startfreq, endfreq, notchstart1, notchend1, datalength)
close all;
clear all;
PIx2 = 2 * pi; % used to calculate the frequency values of the output signal
fstart = 0;
Gridlength = 200e-3;
startfreq = 40e3;
endfreq = 200e3;
stimeStep = 5e-8;
datalength = round(Gridlength / stimeStep);
notchstart1 = 116000;
notchend1 = 119000;
dataN = datalength;
Stimelength = Gridlength;
fend = 10^6;
Fs = dataN / Gridlength;
NFFT = dataN; % Number of points used in the FFT analysis
fstep = (Fs – fstart) / NFFT; % Point step
T = 1 / Fs;
Stime = linspace(0, Stimelength, dataN);
t = (0:dataN-1) * T; % Length of time
signal = zeros(1, length(t));
f1 = notchstart1;
f2 = notchend1;
f3 = notchstart1;
f4 = notchend1;
for freq = startfreq:0.5*10^3:endfreq
if (f1 <= freq && freq <= f2) || (f3 <= freq && freq <= f4)
continue;
end
signal = sin(PIx2 * freq * t + pi) + signal;
end
%% Time-domain signal graphs
figure(1);
plot(Stime, signal);
grid on;
title(‘signal’);
xlabel(‘time’);
ylabel(‘amplitude’);
%% FFT
fMax = NFFT / 2 + 1; % The maximum frequency to plot
signalFFT0 = fft(signal, NFFT); % FFT of the signal
signalFFT_phase = angle(fft(signal, NFFT)); % Phase of the FFT result
signalFFT = abs(fft(signal, NFFT)); % Absolute value (modulus) of the FFT result
signalFFTShow = 2 * signalFFT / dataN; % Actual amplitude values
signalFFTShow(1) = signalFFTShow(1) / 2; % DC component
f = Fs / 2 * linspace(0, 1, fMax); % Actual frequencies
% Plot FFT of the signal
figure(2);
plot(f, signalFFTShow(1:fMax), ‘r’, ‘LineWidth’, 3); % Red color, line width set to 3
grid on; % Display grid lines
title(‘FFT Signal’);
xlabel(‘Frequency’);
ylabel(‘Amplitude’);
%% Phase function modulation
signalstart = startfreq;
signalend = endfreq;
Istart = round(signalstart / fstep);
Iend = round(signalend / fstep);
Itotal = Iend – Istart;
N1start1 = round(f1);
N1end1 = round(f2);
N1start2 = round(f3);
N1end2 = round(f4);
signalphase(1:NFFT) = 0;
for I = 1:NFFT
if (I <= N1end1 && I >= N1start1) || (I <= N1end2 && I >= N1start2)
signalphase(I) = 0;
else
signalphase(I) = pi / 2 * (I – Istart) + 1 * pi / Itotal / 2 * (I – Istart)^2;
end
end
signalF = 1/2 * signalFFTShow .* exp(1i * (signalphase + signalFFT_phase));
signalT = ifft(NFFT * signalF);
t1 = (0:NFFT-1) * T;
%% Phase spectrogram
x1 = 1:NFFT;
figure(3);
plot(x1, signalphase)
xlabel(‘frequency’);
ylabel(‘Phase’);
title(‘Phase spectrum’);
%% Signal waveform after modulation
signaltime = (0:NFFT-1) * T;
figure(4);
plot(signaltime, real(signalT));
xlabel(‘time’);
ylabel(‘amplitude’);
signalT_real = real(signalT);
savefile = ‘signalT_real.txt’;
x = Stime’;
y = signalT_real’;
save(savefile, ‘x’, ‘y’, ‘-ASCII’)
%% STFT Calculation
NN = 10;
win_size = round(datalength / NN);
overlap = 0;
fft_size = win_size * 2 + 1;
stft_result = [];
for i = 1:win_size*(1-overlap):length(signalT)-win_size
window = signalT(i:i+win_size-1);
fft_result = fft(window, fft_size+1);
stft_result = [stft_result; abs(fft_result(1:fft_size))];
end
time_axis = linspace(0, Gridlength, size(stft_result, 1));
freq_axis = linspace(fstart, fend, fft_size);
% Extract intensity for notch frequencies (116 to 119 kHz)
notch_indices = find(freq_axis >= 116000 & freq_axis <= 119000);
notch_intensity = mean(stft_result(:, notch_indices), 2);
% Plot the STFT spectrogram
figure(5);
imagesc(time_axis * 1000, freq_axis / 1000, stft_result.’);
axis([Gridlength * 950 Gridlength * 1050 110e3 / 1000 125e3 / 1000]);
colorbar;
ylabel(‘Frequency (kHz)’);
xlabel(‘Time (ms)’);
% % Plot the intensity over time for the notch frequencies
% figure(6);
% plot(time_axis * 1000, notch_intensity, ‘LineWidth’, 2);
% xlabel(‘Time (ms)’);
% ylabel(‘Intensity’);
% title(‘Intensity at Notch Frequencies (116 to 119 kHz)’);
% grid on;
end function [y, signalT, notch_intensity] = signalfunccycle(Gridlength, startfreq, endfreq, notchstart1, notchend1, datalength)
close all;
clear all;
PIx2 = 2 * pi; % used to calculate the frequency values of the output signal
fstart = 0;
Gridlength = 200e-3;
startfreq = 40e3;
endfreq = 200e3;
stimeStep = 5e-8;
datalength = round(Gridlength / stimeStep);
notchstart1 = 116000;
notchend1 = 119000;
dataN = datalength;
Stimelength = Gridlength;
fend = 10^6;
Fs = dataN / Gridlength;
NFFT = dataN; % Number of points used in the FFT analysis
fstep = (Fs – fstart) / NFFT; % Point step
T = 1 / Fs;
Stime = linspace(0, Stimelength, dataN);
t = (0:dataN-1) * T; % Length of time
signal = zeros(1, length(t));
f1 = notchstart1;
f2 = notchend1;
f3 = notchstart1;
f4 = notchend1;
for freq = startfreq:0.5*10^3:endfreq
if (f1 <= freq && freq <= f2) || (f3 <= freq && freq <= f4)
continue;
end
signal = sin(PIx2 * freq * t + pi) + signal;
end
%% Time-domain signal graphs
figure(1);
plot(Stime, signal);
grid on;
title(‘signal’);
xlabel(‘time’);
ylabel(‘amplitude’);
%% FFT
fMax = NFFT / 2 + 1; % The maximum frequency to plot
signalFFT0 = fft(signal, NFFT); % FFT of the signal
signalFFT_phase = angle(fft(signal, NFFT)); % Phase of the FFT result
signalFFT = abs(fft(signal, NFFT)); % Absolute value (modulus) of the FFT result
signalFFTShow = 2 * signalFFT / dataN; % Actual amplitude values
signalFFTShow(1) = signalFFTShow(1) / 2; % DC component
f = Fs / 2 * linspace(0, 1, fMax); % Actual frequencies
% Plot FFT of the signal
figure(2);
plot(f, signalFFTShow(1:fMax), ‘r’, ‘LineWidth’, 3); % Red color, line width set to 3
grid on; % Display grid lines
title(‘FFT Signal’);
xlabel(‘Frequency’);
ylabel(‘Amplitude’);
%% Phase function modulation
signalstart = startfreq;
signalend = endfreq;
Istart = round(signalstart / fstep);
Iend = round(signalend / fstep);
Itotal = Iend – Istart;
N1start1 = round(f1);
N1end1 = round(f2);
N1start2 = round(f3);
N1end2 = round(f4);
signalphase(1:NFFT) = 0;
for I = 1:NFFT
if (I <= N1end1 && I >= N1start1) || (I <= N1end2 && I >= N1start2)
signalphase(I) = 0;
else
signalphase(I) = pi / 2 * (I – Istart) + 1 * pi / Itotal / 2 * (I – Istart)^2;
end
end
signalF = 1/2 * signalFFTShow .* exp(1i * (signalphase + signalFFT_phase));
signalT = ifft(NFFT * signalF);
t1 = (0:NFFT-1) * T;
%% Phase spectrogram
x1 = 1:NFFT;
figure(3);
plot(x1, signalphase)
xlabel(‘frequency’);
ylabel(‘Phase’);
title(‘Phase spectrum’);
%% Signal waveform after modulation
signaltime = (0:NFFT-1) * T;
figure(4);
plot(signaltime, real(signalT));
xlabel(‘time’);
ylabel(‘amplitude’);
signalT_real = real(signalT);
savefile = ‘signalT_real.txt’;
x = Stime’;
y = signalT_real’;
save(savefile, ‘x’, ‘y’, ‘-ASCII’)
%% STFT Calculation
NN = 10;
win_size = round(datalength / NN);
overlap = 0;
fft_size = win_size * 2 + 1;
stft_result = [];
for i = 1:win_size*(1-overlap):length(signalT)-win_size
window = signalT(i:i+win_size-1);
fft_result = fft(window, fft_size+1);
stft_result = [stft_result; abs(fft_result(1:fft_size))];
end
time_axis = linspace(0, Gridlength, size(stft_result, 1));
freq_axis = linspace(fstart, fend, fft_size);
% Extract intensity for notch frequencies (116 to 119 kHz)
notch_indices = find(freq_axis >= 116000 & freq_axis <= 119000);
notch_intensity = mean(stft_result(:, notch_indices), 2);
% Plot the STFT spectrogram
figure(5);
imagesc(time_axis * 1000, freq_axis / 1000, stft_result.’);
axis([Gridlength * 950 Gridlength * 1050 110e3 / 1000 125e3 / 1000]);
colorbar;
ylabel(‘Frequency (kHz)’);
xlabel(‘Time (ms)’);
% % Plot the intensity over time for the notch frequencies
% figure(6);
% plot(time_axis * 1000, notch_intensity, ‘LineWidth’, 2);
% xlabel(‘Time (ms)’);
% ylabel(‘Intensity’);
% title(‘Intensity at Notch Frequencies (116 to 119 kHz)’);
% grid on;
end matlab code MATLAB Answers — New Questions
Is it possible to realize such loop in MATLAB?
Good day, everyone!
For example, we have some x variable.
Is it possible to realize such loop (using "for") to get these results?
1-st iteration: x-1
2-nd iteration: (x-1)*(x-2)
3-rd iteration: (x-1)*(x-2)*(x-3)
etc.Good day, everyone!
For example, we have some x variable.
Is it possible to realize such loop (using "for") to get these results?
1-st iteration: x-1
2-nd iteration: (x-1)*(x-2)
3-rd iteration: (x-1)*(x-2)*(x-3)
etc. Good day, everyone!
For example, we have some x variable.
Is it possible to realize such loop (using "for") to get these results?
1-st iteration: x-1
2-nd iteration: (x-1)*(x-2)
3-rd iteration: (x-1)*(x-2)*(x-3)
etc. loops MATLAB Answers — New Questions
HP print drivers
Hello I just bought a brand new surface 11th edition. And I am trying to download the printer drivers but my surface is throwing missing plug play or inf errors. I had hp printer support try to help me but it seems not to work on the surface end as all my other computers connect fine. 2/3 surfaces that work out of that office cannot print to the laser jet 4301 fdw printer why?
Heres what I know…
Surface 11 runs on a AWD processor.
So i tried the universal AWD installer but nothing
general installers say the surface doesnt have the plug play installed
and another universal installer said that it doesnt have the correct infs
Hello I just bought a brand new surface 11th edition. And I am trying to download the printer drivers but my surface is throwing missing plug play or inf errors. I had hp printer support try to help me but it seems not to work on the surface end as all my other computers connect fine. 2/3 surfaces that work out of that office cannot print to the laser jet 4301 fdw printer why? Heres what I know… Surface 11 runs on a AWD processor. So i tried the universal AWD installer but nothinggeneral installers say the surface doesnt have the plug play installedand another universal installer said that it doesnt have the correct infs Read More
Detecting Palindromes using Copilot for Excel
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. Today I have a list of words and would like to detect which ones are Palindromes. What is a Palindrome? A Palindrome is a word or sequence of characters that is the same backwards and forwards.
To get started, I ask Copilot:
Add a column to indicate whether the words are palindromes
Looking at B2:B88, here’s 1 formula column to review and insert in Column C:
Is Palindrome
Determines whether each word is a palindrome by checking if the word reads the same backward as forward, and returns “Yes” or “No” accordingly.
=IF([@Words]=TEXTJOIN(“”,,MID([@Words],SEQUENCE(LEN([@Words]),1,LEN([@Words]),-1),1)),”Yes”,”No”)
I’m not sure what the formula is doing, so I click on the “Show explanation” dropdown and it says:
Determines whether each word in the “Words” column is a palindrome by using the following steps:
Uses the SEQUENCE function to generate a sequence of numbers from the length of the word down to 1.
Uses the MID function to extract each character of the word in reverse order based on the sequence generated.
Uses the TEXTJOIN function to concatenate the reversed characters into a single string.
Compares the original word with the reversed string using the IF function.
Returns “Yes” if the word is a palindrome and “No” otherwise.
The suggested formula column sounds like it is doing the right thing, so I click on the button to insert the column:
Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.
Thanks for reading,
Microsoft Excel Team
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. Today I have a list of words and would like to detect which ones are Palindromes. What is a Palindrome? A Palindrome is a word or sequence of characters that is the same backwards and forwards.
List of words: airplane, apple, backpack, banana, bed, bib, boat, book, bottle, building, bus, camera, car, chair, civic, clock, cloud, coffee, computer, dad, deed, deified, deleveled, desk, detartrated, door, eye
To get started, I ask Copilot:
Add a column to indicate whether the words are palindromes
Copilot in Excel pane with the above prompt
Looking at B2:B88, here’s 1 formula column to review and insert in Column C:
Is Palindrome
Determines whether each word is a palindrome by checking if the word reads the same backward as forward, and returns “Yes” or “No” accordingly.
=IF([@Words]=TEXTJOIN(“”,,MID([@Words],SEQUENCE(LEN([@Words]),1,LEN([@Words]),-1),1)),”Yes”,”No”)
I’m not sure what the formula is doing, so I click on the “Show explanation” dropdown and it says:
Determines whether each word in the “Words” column is a palindrome by using the following steps:
Uses the SEQUENCE function to generate a sequence of numbers from the length of the word down to 1.
Uses the MID function to extract each character of the word in reverse order based on the sequence generated.
Uses the TEXTJOIN function to concatenate the reversed characters into a single string.
Compares the original word with the reversed string using the IF function.
Returns “Yes” if the word is a palindrome and “No” otherwise.
The suggested formula column sounds like it is doing the right thing, so I click on the button to insert the column:
Table with 2 columns containing the list of words and a new “Is Palindrome” column with Yes and No values to indicate if it is a palindrome
Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.
Thanks for reading,
Microsoft Excel Team
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.
Read More
Copilot in Excel examples for the week of September 16th
The Excel team is happy to share some examples of how Copilot in Excel can help you. Here’s what you can look forward to this week:
Monday, 16-Sep – Detecting Palindromes using Copilot for Excel
Tuesday, 17-Sep – (coming soon)
Wednesday, 18-Sep – (coming soon)
Thursday, 19-Sep – (coming soon)
Friday, 20-Sep – (coming soon)
Here are some additional examples from the last few weeks if you missed them:
Copilot in Excel examples for the week of August 12th
Copilot in Excel examples for the week of August 19th
Copilot in Excel examples for the week of August 26th
Copilot in Excel examples for the week of September 3rd
Copilot in Excel examples for the week of September 9th
Stay tuned,
Microsoft Excel Team
The Excel team is happy to share some examples of how Copilot in Excel can help you. Here’s what you can look forward to this week:
Monday, 16-Sep – Detecting Palindromes using Copilot for Excel
Tuesday, 17-Sep – (coming soon)
Wednesday, 18-Sep – (coming soon)
Thursday, 19-Sep – (coming soon)
Friday, 20-Sep – (coming soon)
Here are some additional examples from the last few weeks if you missed them:
Copilot in Excel examples for the week of August 12th
Copilot in Excel examples for the week of August 19th
Copilot in Excel examples for the week of August 26th
Copilot in Excel examples for the week of September 3rd
Copilot in Excel examples for the week of September 9th
Stay tuned,
Microsoft Excel Team Read More
Copilot+ for Planner assigning multiple tasks to bucket… almost there
So, as we all know, the bulk move capability has been removed from Planner (we won’t talk about “Bruno”) , however I’ve been experimenting with Copilot+ for Planner Premium and I was able to assign tasks to different buckets with the command “add the tasks to the “In progress” bucket. Unfortunately this adds ALL the tasks in the plan 🙄. I’ve been trying several variations so that it only applies the action to the selected tasks but I always get the message “I can’t do that just yet.” I’m wondering if it is a question of mnemonic or it simply can perform an action on all tasks or 1 task.
Any suggestions?
This will go a long way with you know who (sorry for the “Encanto” reference, just watched it for the nth time with my kid on the weekend 🤣)
So, as we all know, the bulk move capability has been removed from Planner (we won’t talk about “Bruno”) , however I’ve been experimenting with Copilot+ for Planner Premium and I was able to assign tasks to different buckets with the command “add the tasks to the “In progress” bucket. Unfortunately this adds ALL the tasks in the plan 🙄. I’ve been trying several variations so that it only applies the action to the selected tasks but I always get the message “I can’t do that just yet.” I’m wondering if it is a question of mnemonic or it simply can perform an action on all tasks or 1 task.Any suggestions?This will go a long way with you know who (sorry for the “Encanto” reference, just watched it for the nth time with my kid on the weekend 🤣) Read More
Change Column status to Expiring
I’m creating a training tracker as a SharePoint list. Within the list I have a date column for when a course is going to require a refresher, which is a calculated column based of Date of Training + Refresher period.
If I set up a choice column with the following options – In Date, Expiring and Expired, how can I achieve the following:
When a refresher date is 30 days away the status changes to ‘Expiring’
Step 1: Create a New Scheduled Flow
Log into Power Automate at powerautomate.microsoft.com.Click on Create > Scheduled flow.Name the flow (e.g., “Expiring Training Flow”) and set the recurrence to Daily:Trigger: Recurrence.Frequency: 1 day.
Step 2: Get Items from SharePoint
Add a New Step > Get Items from SharePoint.
Site Address: Select your SharePoint site.List Name: Choose your list that contains the RefresherDate and Status columns.
Do not apply any filter here — you will handle this in the flow.
Step 3: Initialize Variables for Date Ranges
We will initialize variables to store the dates in dd-MM-yyyy format for comparison with the RefresherDate.
Variable 1: Today’s Date
Add a New Step > Initialize Variable.Name: TodayDateType: StringValue:
This sets today’s date in dd-MM-yyyy format.
Variable 2: 30 Days from Today
Add another Initialize Variable.Name: ExpiringStartDateType: StringValue:
This sets the date 30 days from today in dd-MM-yyyy format.
Step 4: Apply to Each (Loop through SharePoint Items)
Add a New Step > Apply to Each.In the Select an output from previous steps, choose value from the dynamic content of the Get Items step (this will loop through each item in the list).
Step 5: Add Condition to Ensure RefresherDate Is Not Null
Before comparing the dates, ensure that the RefresherDate is not null.
Inside the Apply to Each, add a Condition:First value: items(‘Apply_to_each’)?[‘RefresherDate’]Condition: is not equal toSecond value: Leave empty (this checks if RefresherDate is not null).
Step 6: Add Condition to Check If RefresherDate is Between Today and 30 Days
Now we will add a condition to check if the RefresherDate is between today and 30 days from today.
Inside the If Yes branch (after checking for null), add a New Condition to compare the RefresherDate to today’s date and 30 days from today.
Condition 1 (Check if RefresherDate is less than or equal to 30 days from today):
First value:
Condition: is less than or equal toSecond value: variables(‘ExpiringStartDate’)
AND
Condition 2 (Check if RefresherDate is greater than or equal to today):
First value:
Condition: is greater than or equal toSecond value: variables(‘TodayDate’)
This ensures that the RefresherDate is between today and 30 days away, in dd-MM-yyyy format.
Step 7: Update the Status to “Expiring”
In the If Yes branch (if the RefresherDate is within the range), add an Update Item action to update the status.
Site Address: Choose your SharePoint site.List Name: Select your SharePoint list.ID: Use the ID from the dynamic content in the Apply to Each loop.Status: Set the Status column to “Expiring”.
Hi I’m creating a training tracker as a SharePoint list. Within the list I have a date column for when a course is going to require a refresher, which is a calculated column based of Date of Training + Refresher period.If I set up a choice column with the following options – In Date, Expiring and Expired, how can I achieve the following:When a refresher date is 30 days away the status changes to ‘Expiring’ AI gave me the solution below, however it keeps failing. Any help greatly appreciated. Step 1: Create a New Scheduled FlowLog into Power Automate at powerautomate.microsoft.com.Click on Create > Scheduled flow.Name the flow (e.g., “Expiring Training Flow”) and set the recurrence to Daily:Trigger: Recurrence.Frequency: 1 day.Step 2: Get Items from SharePointAdd a New Step > Get Items from SharePoint.Site Address: Select your SharePoint site.List Name: Choose your list that contains the RefresherDate and Status columns.Do not apply any filter here — you will handle this in the flow.Step 3: Initialize Variables for Date RangesWe will initialize variables to store the dates in dd-MM-yyyy format for comparison with the RefresherDate.Variable 1: Today’s DateAdd a New Step > Initialize Variable.Name: TodayDateType: StringValue: plaintextCopy codeformatDateTime(utcNow(), ‘dd-MM-yyyy’)This sets today’s date in dd-MM-yyyy format.Variable 2: 30 Days from TodayAdd another Initialize Variable.Name: ExpiringStartDateType: StringValue: plaintextCopy codeformatDateTime(addDays(utcNow(), 30), ‘dd-MM-yyyy’)This sets the date 30 days from today in dd-MM-yyyy format.Step 4: Apply to Each (Loop through SharePoint Items)Add a New Step > Apply to Each.In the Select an output from previous steps, choose value from the dynamic content of the Get Items step (this will loop through each item in the list).Step 5: Add Condition to Ensure RefresherDate Is Not NullBefore comparing the dates, ensure that the RefresherDate is not null.Inside the Apply to Each, add a Condition:First value: items(‘Apply_to_each’)?[‘RefresherDate’]Condition: is not equal toSecond value: Leave empty (this checks if RefresherDate is not null).Step 6: Add Condition to Check If RefresherDate is Between Today and 30 DaysNow we will add a condition to check if the RefresherDate is between today and 30 days from today.Inside the If Yes branch (after checking for null), add a New Condition to compare the RefresherDate to today’s date and 30 days from today.Condition 1 (Check if RefresherDate is less than or equal to 30 days from today):First value: plaintextCopy codeformatDateTime(items(‘Apply_to_each’)?[‘RefresherDate’], ‘dd-MM-yyyy’)Condition: is less than or equal toSecond value: variables(‘ExpiringStartDate’)ANDCondition 2 (Check if RefresherDate is greater than or equal to today):First value: plaintextCopy codeformatDateTime(items(‘Apply_to_each’)?[‘RefresherDate’], ‘dd-MM-yyyy’)Condition: is greater than or equal toSecond value: variables(‘TodayDate’)This ensures that the RefresherDate is between today and 30 days away, in dd-MM-yyyy format.Step 7: Update the Status to “Expiring”In the If Yes branch (if the RefresherDate is within the range), add an Update Item action to update the status.Site Address: Choose your SharePoint site.List Name: Select your SharePoint list.ID: Use the ID from the dynamic content in the Apply to Each loop.Status: Set the Status column to “Expiring”. Read More
cells in a workbook from cells in other workbooks
Hi,
I have a workbook called ‘InvoiceList’ the cells are populated with information from my invoices which are each a separate workbook.
Up to now I have populated the cells either by using ‘=’ then navigating to the cell I want the information from, or by using the same method then dragging the cell in the InvoiceList workbook and editing the new cells to reference the next invoice number.
example:
A cell in the invoiceList worksheet contains the following: ='[INV101.xlsx]Sheet1′!$F$17
where the F17 cell contains the customers name.
The next cell (to the right) in the InvoiceList work sheet contains: ='[INV101.xlsx]Sheet1′!$H$20
where the H20 cell contains the date of the invoice.
There are more cells with more information so I end up with a summary of that invoice.
In the next row, I want the same information but for my next invoice number.
Here’s my question – is there an easy way to populate the cells in my InvoiceList workbook? If I drag down a cell or cells, ideally the ‘101’ in the example would become 102, 103 etc.
I’m sure this must be easy for you guru’s – but I’m a ‘needs-must’ user 🙂
Cheers
Mark
Hi,I have a workbook called ‘InvoiceList’ the cells are populated with information from my invoices which are each a separate workbook.Up to now I have populated the cells either by using ‘=’ then navigating to the cell I want the information from, or by using the same method then dragging the cell in the InvoiceList workbook and editing the new cells to reference the next invoice number.example:A cell in the invoiceList worksheet contains the following: ='[INV101.xlsx]Sheet1′!$F$17where the F17 cell contains the customers name.The next cell (to the right) in the InvoiceList work sheet contains: ='[INV101.xlsx]Sheet1′!$H$20where the H20 cell contains the date of the invoice.There are more cells with more information so I end up with a summary of that invoice.In the next row, I want the same information but for my next invoice number.Here’s my question – is there an easy way to populate the cells in my InvoiceList workbook? If I drag down a cell or cells, ideally the ‘101’ in the example would become 102, 103 etc.I’m sure this must be easy for you guru’s – but I’m a ‘needs-must’ user 🙂CheersMark Read More
New Copilot enhancements help small and medium-sized businesses innovate
Copilot has made a large impact on small and medium-sized businesses over the past year, and we are excited to share how wave two of Microsoft 365 Copilot innovations announced today can help you achieve even more for your business, no matter the size.
In a recent survey of companies with up to 300 employees, business leaders responded they are experiencing on average a 12% faster time to market for new products and services.1
Our customers tell us they are experiencing the impact of Copilot in many aspects of how they do business. ICG, a startup construction firm, is using Copilot to write customer proposals six times faster, which lets their sales team pursue more opportunities and revenue. PKSHA, a software development firm, tells us that Copilot helped their customer success team by reducing time spent on data analysis by 75%, allowing the team to provide insightful recommendations to customers more quickly.
“As a small to mid-sized defense contractor and one of the first U.S. companies to roll out Microsoft 365 Copilot company-wide, IDT is committed to accelerating the delivery of solutions to the Department of Defense. We believe AI-driven technologies like Copilot hold tremendous potential for enhancing our capabilities. The initial results of Copilot’s integration across various functions, including program management, software development, and deployment, have been highly encouraging. We are excited to continue expanding our use of Copilot in partnership with Microsoft, driving innovation and increasing the speed at which we deliver disruptive innovation to our customers.”
– Rob Hornbuckle, Chief Information and Operations Officer, Innovative Defense Technologies
Let’s explore how our latest AI innovations can help you serve your customers as you scale and grow, and help you make your business stand out among the competition.
Microsoft is innovating on behalf of your business
Your AI assistant for work
We’re making the free Microsoft Copilot more accessible to users with a Microsoft Entra ID account. It can be easily accessed at Microsoft.com/copilot and the Microsoft 365 app. Soon you will be able to pin it directly into Microsoft Teams and Microsoft Outlook so it is more available during your day-to-day work. You can use it to ask questions relevant to your business, like summarizing industry trends, all with enterprise data protection so your data is encrypted and private.
You can also enter prompts like “compare a competitor’s product to my product” and ask it to reference your internal product spec sheet by manually adding the file. Copilot will be able to reason over your file and grab the latest publicly available information from the internet to provide a response.
While Microsoft Copilot is available to users with an Entra ID account, Business Chat (BizChat) requires a Microsoft 365 Copilot subscription, which can be accessed at Microsoft365.com/copilot.
BizChat combines the power of web-based insights with the Microsoft Graph to bring together data from across your documents, presentations, email, calendar, notes, and contacts—and contextualizes this data with information from the web. Like an assistant, it has a deep understanding of you, your job, your priorities, and your organization. It can find whatever you need in your files (even the files you forgot existed), connect the dots across all your content and context swiftly, and even integrate with the apps you use to run your business.
We have enhanced your BizChat experience with Copilot Pages, a persistent canvas for collaboration. Just click on “Edit in Pages” at the bottom of a Copilot response. This will create a page and open it alongside the chat that includes Copilot’s response. Pages takes the AI-generated content and makes it durable, so you can edit it, add to it and share it with your team, just like you would a Microsoft Word document. You and your team can work together in real time—asking Copilot more questions and adding more content. Copilot Pages will be generally available later this month and will also be accessible in the free Microsoft Copilot.
Analyze your business data
Microsoft Excel is widely used by small businesses for inventory management, dashboards, project workbacks and data analysis as well as other work tasks. Analyzing data can be challenging, but with Copilot, all you have to do is ask to get insights.
Copilot in Excel is now generally available. Just ask Copilot to analyze the data written within your spreadsheets or textual content written in documents and provide actionable insights. Then ask Copilot to visualize the insights in a chart, scatter plot or PivotTable. Copilot can even recommend the right visualization for you to better understand complex data and make more informed decisions with your team.
Furthermore, Copilot in Excel with Python adds the capabilities of Python to let you leverage these advanced analytic capabilities in natural language with no coding required. Just ask your questions using everyday language to enable predictive modeling and text analytics. Iterate with Copilot right in Excel to generate heatmaps and word clouds. These capabilities are rolling out to Microsoft 365 Insiders and will continue rolling out to all our customers over the next few months. Find out more about Copilot in Excel updates.
Get Through the Busy Work, to the Work-Work
Copilot can help you spend less effort on time-consuming, day-to-day work so you can focus your energy on growing your business.
While meeting transcripts contain important information, there is often rich discussion that also happens in meeting chats. Now available, this new feature in Copilot in Teams can answer questions using information from both the transcript and meeting chat to give you a complete picture of what was discussed, helping you stay on top of your meeting details.
Copilot in Outlook will soon be able to help you better manage your inbox with Prioritize my inbox. Copilot will combine the context of your role in your organization and previous work emails to surface the messages most important to you so you can spend less time triaging your inbox and focus on what’s most important. This feature will be in public preview starting late 2024.
Make your business stand out
Copilot in PowerPoint works alongside you to turn your ideas into professional presentations. With the new Narrative builder in PowerPoint, you can ask Copilot to build an outline of your presentation and once you’ve adjusted the outline, you can then ask Copilot to build the slides. It can use your company’s template, or even create custom images generated just for you. You will never have to start from a blank slide again.
Use Copilot agents across all your business apps
Often, small business infrastructure is a combination of disparate tools and software to meet specific process and customer requirements. Copilot can help coordinate all these business functions and workflows using agents, so you can orchestrate your business from a single place.
Copilot agents are generally available in BizChat so you don’t have to spend time switching between different tools or trying to contextualize information from different sources. These agents will allow you and your team to streamline your processes and focus more on the task at hand.
You can build your own custom agent to reason over specific SharePoint sites using agent builder, a lightweight Microsoft Copilot Studio experience integrated into Microsoft 365 Copilot. Click on “Build a Copilot agent” in BizChat and then make the agent available to your team.
In Copilot Studio, you can also create agents for your third-party systems or edit existing agents. You can @ mention the agent as you would any other teammate to ask it questions specifically about that site. Agents are accessible from any device that has BizChat, including mobile devices. Copilot agents and Copilot Studio agent builder will be rolling out to general availability over the coming weeks.
Get Started
To use Copilot right away, just access Microsoft Copilot in the Microsoft 365 app and at Microsoft.com/copilot. You will need to sign in with your Entra ID account.
To use Copilot across all your Microsoft 365 apps and work data, you can purchase Microsoft 365 Copilot as an add-on to your Microsoft 365 Business Basic, Microsoft 365 Standard or Microsoft 365 Business Premium subscriptions. If you do not already have these core productivity offerings you can purchase them now.
Find out more about Microsoft 365 Copilot or reach out to a Cloud Solution Partner to learn more.
You can start taking steps to prepare, understand licensing and technical requirements, familiarize yourself with new capabilities, and explore the new small and medium-sized business Copilot Success Kit.
______________________________________
1 “New Technology: The Projected Total Economic Impact™: Of Copilot for Microsoft 365 for SMB,” a commissioned study conducted by Forrester Consulting on behalf of Microsoft. Results are based on a composite organization.
Microsoft Tech Community – Latest Blogs –Read More
Unlock the power of Copilot in Excel, now generally available
Today, we unveiled the next wave of Copilot including the announcement that Copilot in Excel is now generally available and ready to assist data-driven professionals around the world. In addition, we also announced the public preview of Copilot in Excel with Python, enabling powerful advanced analysis.
Previously, we talked about the vision of how Copilot in Excel could revolutionize the way you understand your data and make better business decisions. We’ve been listening to your feedback and are excited to share improvements for those of you who depend on Excel regularly. Copilot in Excel is built into your workbook, enabling you to iterate with it quickly and easily. This integration allows you to continually prompt as you work, making it feel like you have an Excel expert right by your side.
We heard from those of you who are avid users, that you need even more to supercharge your Excel experience. Copilot in Excel with Python can help you gain deeper insights without needing to be a Python expert.
In this post, we’ll share some lessons from our own Microsoft team members who have been trying out Copilot in Excel in their work. Let’s take a closer look at how Copilot in Excel can help you carry out your daily Excel needs and conduct advanced analysis.
Copilot is your personal Excel expert
Those of you who are frequent Excel users can spend hours every day just formatting your data sheets to more clearly view and use your data. Let Copilot be your personal Excel expert and help you with these frequent tasks. Copilot can now reason over structured data, not just tables, and it can complete tasks such as adding filters or splitting text. Copilot can also help you highlight important information with formula based conditional formatting. For example, Copilot simplifies the process of highlighting crucial information, such as spending that’s higher than revenue in a sales sheet.
Excel has hundreds of different formulas to help you organize, visualize and get insights out of your data. While many of you rely on the same formulas every day, we’ve heard that you would like to expand your use of formulas as well as easily access the ones you use regularly. Now you don’t need to do an online search to look up formulas, you can just ask Copilot right in your spreadsheet. Recently we added support for complex formulas like XLOOKUP and SUMIF as well.
“Copilot helps me with automating some of the repetitive tasks I have…It increases my productivity…helping me write the formulas.” – Victoria, Microsoft Manager
Copilot not only executes formulas and formatting, but it also provides steps and explanations along the way. When you ask Copilot a question, it will now respond with a suggestion and an explanation of all the steps to show its “thinking”. You can preview the suggested action and then choose to apply – keeping you in control.
When Copilot can’t make a direct change to your data, it will provide you with steps you can take to make the change yourself – saving you from research outside of Excel and keeping you in the flow of your work. By demystifying these elements, Copilot empowers you to take full advantage of Excel’s capabilities, turning what could be a time-consuming task into a seamless and efficient experience.
Gain insights with everyday language
Data-driven decision-making is critical for business success. But often gaining insights is one of the most difficult parts of working with data. Copilot can help! Simply request insights from Copilot using natural language, whether you are requesting patterns or analyzing trends.
“When I get a new data that I need to analyze, I use Copilot with a quick prompt of just ‘show me insights on the data’ and Copilot quickly gives me a very broad range of tables and charts that I can explore further and analyze deeper.” – Victoria, Microsoft Manager
As part of Copilot’s analysis, we’re excited to announce that it now recommends the best visual formats, like bar charts, line graphs, or PivotTables and formulates the right sets of fields, layouts, and filters for you – creating a specific chart or PivotTable so you can get all the benefits of Excel’s powerful capabilities without being an expert! For example, a sales consultant can easily understand the relationship between ad spend and campaign reach, with Copilot generating a PivotTable to aid in planning the next quarter’s budget.
Copilot in Excel with Python
Analysts often have specific needs to conduct analysis which takes time and expertise. Now using Copilot in Excel with Python, you can conduct advanced analysis that was previously out of reach. You can use natural language to describe the analysis you want to perform, and Copilot will automatically generate, explain, and insert Python code into your Excel spreadsheet.
This unlocks powerful analytics via Python for visualizations, cleaning data, machine learning, predictive analytics, and more – without needing to be Python proficient yourself. Copilot in Excel with Python also renders stunning visuals that were previously not possible or were difficult to create. Unique visuals like heatmaps, pairplots, multiplots, and violin plots help you understand and communicate your analysis.
Python in Excel leverages Anaconda Distribution for Python which includes the most popular Python libraries such as pandas, Matplotlib and scikit-learn. Now, Copilot in Excel with Python can use these libraries too, unlocking their potential with everyday language.
Copilot in Excel with Python not only analyzes and visualizes, but it also shares its thinking, showing and explaining the code it’s using so that you understand how it’s working. It creates a dedicated analysis sheet, with a sandbox for you to collaborate with Copilot, while leaving the original source data untouched. The analysis is refreshable so when source data is updated, you can get an updated analysis as well.
“Copilot in Excel advanced analysis gives me the opportunity to build graphs faster and easier and also format them just right the first time. So instead of having to figure out Python by myself or also trying to figure out where exactly in the formula I need to change my inputs so that the graph looks right, I can just communicate that to Copilot and it’s going to do that for me. “ – Anca, Microsoft Manager
Because it’s all in Excel you can easily share and collaborate with others. For those who are comfortable with Python in Excel, you can even edit the code directly in the spreadsheet giving you full control to adjust as you wish.
“When it comes to collaboration that’s obviously the core of Excel … It’s purely a collaboration tool and it’s used for providing different perspectives and always making sure there’s a collaborative sense. You never do a model on your own…” – Wes, Microsoft Analyst
Copilot in Excel with Python is rolling out to Windows for Insiders and requires a Microsoft 365 Copilot license. Once enabled you can simply click the “Advanced analysis” prompt suggestion or write a customized prompt asking Copilot to “analyze with Python”. We’re also excited to announce that Python in Excel (the experience outside of Copilot), is now generally available in Excel for Windows. To learn more about Python in Excel read the announcement blog.
Transform text to actionable insights
Not all analysis is done with numerical data and we’ve heard from many of you that you need help making sense of text-based data. We’ve taken this feedback and have expanded Copilot’s capabilities beyond traditional numerical analysis. We’re excited to announce that Copilot can now analyze text, transforming raw textual data into actionable insights. This innovation ensures that Copilot can handle complex datasets, whether they are numerical or textual, with the same level of precision and efficiency, ultimately driving better business outcomes.
For instance, a marketing manager can obtain a summary of product reviews to better understand opportunities and challenges. Being able to analyze text with Copilot saves the marketing manager valuable time and energy. And having a summary in seconds means they can make informed decisions or even take action much more efficiently than before.
Copilot in Excel with Python helps you go even further by analyzing text-based data too. This provides even deeper insights such as sentiment analysis and keyword extraction, powerful text analytics libraries such as NLTK, and unique visuals like a word cloud that help communicate text-based trends.
Copilot in action with Microsoft’s Finance team
Play the video to learn more about how Anca, Victoria and Wes from our Microsoft Finance team utilize Copilot in Excel for their daily needs and advanced analysis.
Transform how you work with data
Excel has long been the cornerstone of data analysis for businesses, researchers, and analysts worldwide. We’re excited to continue Copilot in Excel’s evolution into an assistant that helps transform raw data into actionable insights with greater efficiency and accuracy than ever before. Copilot in Excel with Python brings us a step closer to the vision of analysts leveraging the power of conversational AI with Copilot in Excel to transform how they work with complex data.
Try Copilot in Excel today with a Microsoft 365 Copilot license and join the Microsoft 365 Insider’s program for Copilot in Excel with Python.
Please send feedback in the app and check out below for more information:
Microsoft 365 Announcement blog: Microsoft 365 Copilot Wave 2 blog
Python in Excel now generally available: announcement blog
Support article: Get started with Copilot in Excel – Microsoft Support
Support article: Copilot in Excel with Python – Microsoft Support
LinkedIn Learning course – free through the end of 2025: Excel with Copilot: AI-Driven Data Analysis | LinkedIn Learning
You may also be interested in Microsoft 365 Copilot finance agent, which delivers generative AI capabilities purpose-built for finance professionals. Agents allow you to enhance Microsoft 365 Copilot by connecting it to new data sources and applications and expanding its functionality. Check out this site for more information.
Microsoft Tech Community – Latest Blogs –Read More
Microsoft Entra Hybrid Join – Devices Stuck in “Pending” Status
Hello Team, We are facing an issue with our on-premises Active Directory (AD) integrated with Active Directory Federation Services (AD FS). We have correctly configured Microsoft Entra hybrid join using Microsoft Entra Connect, following the official documentation. However, we have observed that all our devices are showing up in Microsoft Entra devices with a status of “Pending”, and this status remains unchanged indefinitely. To troubleshoot, we have already tried running the following command: dsregcmd /leave. After rebooting the PCs, the issue persists. Running the below command, results in the following output:C:Usersabc> dsregcmd /debug /join DsrCLI: logging initialized.DsrCLI: logging initialized.DsrCmdJoinHelper::Join: ClientRequestId: e58946ab-b851-1759-3658-69824b6857fDsrCmdAccountMgr::IsDomainControllerAvailable: DsGetDcName success { domain:contoso.local forest:contoso.local domainController:\dc1.contoso.local isDcAvailable:true }PreJoinChecks Complete.preCheckResult: JoindeviceKeysHealthy: undefinedisJoined: undefinedisDcAvailable: YESisSystem: YESkeyProvider: undefinedkeyContainer: undefineddsrInstance: undefinedelapsedSeconds: 1resultCode: 0x0Automatic device join pre-check tasks completed.TenantInfo::Discover: Call to DsrBeginDiscover failed before wait. 0x80070057DsrCmdJoinHelper::Join: TenantInfo::Discover failed with error code 0x80070057.DSREGCMD_END_STATUSAzureAdJoined : NOEnterpriseJoined : NO We also ran the DSRegTool PowerShell script but did not encounter any significant errors. Given the error code 0x80070057 and the devices not registering with Azure AD, we suspect there could be an issue either with the tenant discovery process or with certain configuration steps that might have been overlooked. Has anyone encountered this error before or have any insights into further troubleshooting steps to resolve this issue? Any guidance would be greatly appreciated. Thanks Read More
Supercharge Your Business. Excel Made Easy: How Copilot Can Revolutionize Your Small Business
Excel is Now SUPER Powered with Copilot in Excel with Python
Managing a small business can be tough, and making decisions based on data analysis can often feel overwhelming. You’re constantly inundated with data on sales, customers, competitors, and the market.
Microsoft Excel is an indispensable tool for small businesses, offering a wide array of features that can streamline operations, enhance productivity, and drive growth. Whether you’re managing finances, analyzing data, or collaborating with your team, Excel provides the functionality needed to tackle these tasks efficiently. This blog will highlight some of the most interesting and beneficial features of Microsoft Excel for small businesses, showcasing how this versatile software can be a game-changer.
One of the standout features of Excel is its powerful data analysis capabilities. Small businesses can leverage tools like PivotTables, charts, and conditional formatting to gain insights into their operations. PivotTables allow users to summarize large datasets and extract meaningful patterns, while charts provide a visual representation of data, making it easier to understand trends and make informed decisions. Conditional formatting helps highlight important data points, ensuring that critical information stands out.
Excel’s financial management tools are another major asset for small businesses. With built-in templates for budgeting, expense tracking, and financial forecasting, Excel simplifies the process of managing finances. Small businesses can create detailed financial reports, monitor cash flow, and plan for future growth with ease. The ability to customize these templates to fit specific business needs further enhances their utility.
Project management is another area where Excel excels. Small businesses can use Excel to plan, track, and manage projects from start to finish. Features like Gantt charts and task lists help keep projects on schedule and within budget. By organizing tasks, setting deadlines, and monitoring progress, businesses can ensure that projects are completed efficiently and effectively. This level of organization is crucial for small businesses that need to maximize their resources.
Collaboration is made easy with Excel’s cloud-based features. Teams can work on the same document simultaneously, regardless of their location, thanks to Excel’s real-time collaboration capabilities. This fosters better communication and ensures that everyone is on the same page. Additionally, Excel’s sharing and commenting features make it simple to provide feedback and make revisions, enhancing the collaborative process and improving overall productivity.
But how do you make sense of this information? How do you spot the trends to take actions that benefit your business? Microsoft 365 provides tools to simplify this analysis. Introducing Copilot in Excel and Copilot in Excel with Python, designed to help you more easily make sense of the numbers impacting your business.
Copilot in Excel: Your Very Own Excel Expert
Copilot in Excel is like having an Excel expert at your fingertips, available 24/7. Copilot in Excel can analyze your company’s data, uncover trends, and deliver actionable insights. Here’s how it can help:
• Quick Data Analysis: Copilot can look at your data, analyzing it to find important trends and patterns. This means you can make decisions faster without spending hours on the numbers and it also ensures that tasks are performed consistently and accurately.
• Easy Questions: You can ask Copilot questions, like “What were our best-selling products last month?” and get a quick answer. This enables you to take advantage of Excel’s many functions even if you are unfamiliar with them.
• Automate Tasks: Copilot can handle repetitive tasks like formatting data and creating reports. This minimizes the risk of human error, which is common when manually adjusting data, and gives you more time to focus on growing your business.
Consider this scenario: you have a spreadsheet of the year’s sales and marketing spend against your company’s products. With simple natural language prompts, Copilot in Excel can detect the profit you made, and the profit margin of each product. With this, you get valuable insight on what’s making you money, and what isn’t. With Copilot in Excel this analysis is done quickly and accurately, without having to spend hours on end creating formulas and double-checking them when they break.
In the same spreadsheet, you can get important takeaways like where you’re seeing the best sales. Just ask Copilot in natural language to “group units by state” and it will automatically generate a chart that illustrates sales by state. You can even put that chart on a new sheet with one click to focus on it or share with others.
Get Even More Insights with Copilot in Excel with Python
Python, a versatile and widely used programming language, is popular in sectors like finance but can feel out of reach for those who do not know Python code. Copilot now harnesses the power of Python in Excel to enable deep analysis using everyday language. Copilot in Excel with Python enables people across segments such as marketing, sales, and healthcare to leverage the power of Python without needing to be proficient in it. For instance, marketers can utilize Copilot to conduct robust analyses of customer data, monitor campaign performance, and refine marketing strategies – all using natural language. Because this is integrated directly into your spreadsheet, you can access powerful visualizations, machine learning, predictive analytics, and more, all without needing to write any Python code or be a data scientist. Here is what it can do:
• Data Analysis: Python can handle more complex data analysis than Excel alone.
• Custom Charts: Create unique charts and graphs that make your data easier to understand, including word clouds, heatmaps, pairplots, and multiplots.
• Predict Trends: Python can conduct forecasting, so you can make better decisions.
Use Copilot in Excel to analyze text (not just numerical data). See raw textual data turned into actionable insights so you can clearly understand what to do next to drive your business forward.
How These Features Support Your Business
Imagine having a dedicated Excel expert at your fingertips—one who is always ready to scrutinize information, identify trends, and generate actionable insights. With Copilot in Excel, this becomes a reality. You can iterate with Copilot, asking questions, like you would a colleague. By collaborating with Copilot, you can harness advanced analysis tools to transform your data into valuable intelligence. Simply click the Copilot button within Excel to get started.
Copilot in Excel is now generally available and included in both Microsoft Copilot Pro and Copilot for Microsoft 365 subscriptions. Copilot in Excel with Python is in preview and offered through the Microsoft Insider Program. Learn more details in the announcement. If you’re interested in using Python in Excel without Copilot, check out more details on the Python in Excel announcement.
Microsoft Tech Community – Latest Blogs –Read More
Use LogicApps and Copilot for Security to auto-process ISAC Emails
Information Sharing and Analysis Center (ISAC) is an organization that provides a central resource for gathering information on cyber and related threats to critical infrastructure and plays an important role in safeguarding industries from emerging threats. By bridging the gap between private and public sectors, ISACs provide timely and actionable intelligence on vulnerabilities that impact critical infrastructure. However, manually processing the ISAC threat bulletins can be overwhelming and slow, leaving security teams scrambling to respond in time. This document explores how leveraging automation through Logic Apps and Microsoft’s Copilot for Security can streamline ISAC email processing, empowering organizations to respond to vulnerabilities faster and more effectively.
In the US, several industries have their own ISACs which are registered with the National Council of ISACs, a subset of these ISACs are given below:
Auto-ISAC: ISAC for the Automotive Industry
E-ISAC: ISAC for the Electric Industry
FS-ISAC: ISAC for the Financial service industry
Health-ISAC: ISAC for the Health care industry
ONG-ISAC: ISAC for Oil & Gas industry
Canada, the UK, and other countries also have localized and industry-specific ISACs for their regions.
ISACs send out threat bulletins in email format which contain CVEs and other threat intel. The receiving members of these bulletins are expected to scan their environment for the mentioned CVEs/threat intel thus allowing for proactive remediation. Below is a sample of a threat bulletin sent by Health-ISAC (available for download here😞
The normal process of scanning CVEs contained in an ISAC requires each CVE to be manually verified against the vulnerability management tool. Other high-priority work can prevent the security analysts from analyzing the CVEs till several days after receiving the ISAC email.
As a large language model (LLM) focused on security, Copilot can take the manual effort out of this analysis by auto converting the generic ISAC bulletin into actionable information that only includes the CVEs that exist in your environment. With the help of Logic Apps to retrieve and parse out the email, an agent type workflow that analyzes the ISAC email and converts it to actionable information can be built. In the next section we will discuss how to build this Logic App.
Logic App
Logic App is a low-code / no-code platform provided in Azure. With it’s over 1000 connectors, it has tremendous capabilities in building automated workflows. This article assumes familiarity with Logic Apps and to get more understanding on building and using Logic Apps, documentation is available here. The user deploying a Logic App needs at least a ‘Contributor’ role in the Azure resource group to which the Logic App is being deployed.
The starting point of the Logic App flow is the trigger that allows a Logic App flow to be executed when the trigger event has occurred. In our example, we use an email trigger and configure it for the specific Outlook mailbox that receives the ISAC email.
To extract the CVEs contained in the email, we will need 2 variables, cveArray, and uniqueCVEArray which are initialized separately.
The subject of the email will determine if it should be processed further. A conditional clause handles the situation, resulting in a true or branch.
Most ISAC emails will have “ISAC” in the email subject which is what determines the outcome. Adding another condition that checks the sender’s email is also recommended as it further ensures that the Logic App runs for a legitimate ISAC email only.
If the conditions have evaluated to true, we continue further execution in the Logic App. Most ISAC emails arrive in HTML format, and two connectors are leveraged. One to extract the HTML body (which is contained in a JSON provided by the Outlook trigger) and another to convert the HTML document to text as shown below:
Once the email body is extracted, we are ready to extract the CVEs. Copilot for Security can natively perform this task however, it’s not the most efficient method with large emails. Hence, we extract the CVEs in the Logic App itself. There are many options to accomplish this, we have chosen the JavaScript connector:
We define a Regular Expression (RegEx) with JavaScript to identify CVEs:
*Note that if the JavaScript Code connector is run in a consumption Logic App, it will need an integration account to run correctly.
The extracted CVEs are now assigned to cveArray variable, however if the same CVE is mentioned multiple times in the email body it will have repeated entries. To remove the duplicates we use the union() function on cveArray and the unique CVEs are then stored in another variable uniqueCVEArray. The data is now ready to send to Copilot for Security.
The Copilot for Security Logic App connector can issue prompts and receive responses. The first prompt will send all CVEs from uniqueCVEArray and ask Copilot to extract those CVEs. While not mandatory, this step ensures that Copilot parses out and understands the CVEs to be presented and prevents wrong input to be provided to downstream prompts.
The second prompt asks Copilot to show how many of the CVEs are present in the environment. This prompt uses KQL to query Microsoft Defender’s Threat and Vulnerability Management (TVM) data to find the CVEs. If you are using another TVM tool you can write a Copilot API plugin for it and modify this prompt to allow Copilot to analyze the CVEs using your specific tool.
*Note that if the Logic App is going to be run frequently, it is more efficient from an SCU consumption perspective to convert the KQL query into a KQL plugin. Or you can also specify the KQL directly in the prompt, where the new prompt is shown below:
“Execute the KQL:
DeviceTvmSoftwareVulnerabilities | where CveId in (AllCVEs) | summarize count() by CveId
where AllCVEs is the list of all CVEs shown previously”
Once we have the CVE scan information our next prompt requests Copilot to write a report and enrich the CVE information with data from Microsoft Defender Threat Intelligence (MDTI) and only include the CVEs that were found in the environment.
The results of the CVE’s found and its enriched data will be sent as another email to one or more users. Microsoft Outlook sends formatted emails in HTML format so now we need to convert the report generated by Copilot to HTML format, and in our last prompt we ask Copilot to do just that.
Our last connector is for sending the email via Outlook. This takes the HTML report and sends it as an email to specific users.
Note that in the body of the email we included additional details like Copilot SessionID, the CVE scan report (from the 3rd prompt) and the last HTML report (from 4th prompt). The HTML report is the only one that users are interested in, but having those additional fields helps in initial deployment where you may need to tweak the output to customize it for your environment.
The email received from the last Outlook plugin is shown below. The report format can be easily changed by modifying the 3rd and 4th prompts:
In this article, we showed how to build a Logic App that can act as an agent to process ISAC emails containing CVE information. The Logic App takes a generic ISAC threat bulletin, and with help from Copilot converts the generic email to an actionable email that contains only the CVEs that are present in your environment and enriches the context by providing more information on each.
Depending on the number of ISAC or other CVE-related emails received per week, this Logic App can save several minutes to hours of work for a security organization.
Microsoft Tech Community – Latest Blogs –Read More
Microsoft 365 Copilot Wave 2: AI Innovations in SharePoint and OneDrive
Today, Satya Nadella and Jared Spataro introduced Wave 2 of Microsoft 365 Copilot innovations, including new Copilot agents that automate and streamline processes. Now anyone can easily create an agent with specific subject-matter expertise—from a coach to a brainstorm partner to a field-service technician. These updates represent a big stride forward in helping drive customer value with Copilot, and SharePoint and OneDrive will play a key part in this wave of Copilot innovations.
SharePoint has become the foundational content management platform for enterprises―powering OneDrive, SharePoint sites, Teams, Loop, Stream, and more. It facilitates team collaboration, business processes, knowledge management, and employee communication with robust content services. With hundreds of millions of active users adding over 2.5 billion new files daily, SharePoint is a wealth of valuable organizational knowledge and insights that users can now harness with Copilot agents.
We are excited to announce the public preview of Copilot agents in SharePoint, a new experience that enables any user to quickly create and share agents right from within SharePoint for specific purposes. With a few clicks, you can create and share a Copilot agent in SharePoint―no coding skills required, all while respecting the organization’s security policies. These agents can work on your behalf answering questions about source material, reasoning over that material, and acting like a well-informed teammate would. Copilot agents in SharePoint will enter public preview in early October.
OneDrive is the common files experiences for Microsoft 365 and is the common place you get to all your content, either standalone, in Teams, Outlook, or the Microsoft 365 app. This is why we are also excited to announce Copilot in OneDrive. With it, you can efficiently summarize, get answers from, and compare your files in OneDrive faster than ever. These features are rolling out now and will be generally available by the end of September.
Copilot in SharePoint is now rolling out to customers, with additional features coming later this year. Copilot in SharePoint helps site creators author pages and create stunning sites, using AI and natural language. Simply explain the page you need, and Copilot builds it for you.
Super charge productivity with Copilot agents in SharePoint
Create an agent in just a few clicks: Creating a Copilot agent in SharePoint is a simple starting point for users looking to use AI tools tailored for their particular needs. Make Copilot your own. Use it to collaborate with others using the same relevant knowledge base and make critical decisions efficiently, or to spend less time consuming information so you can focus on more meaningful work. And you can create these agents right from where you’re already working in SharePoint.
Copilot agents in SharePoint work for you, your team, and cross-functional collaborators to help enhance knowledge sharing and teamwork. Let’s say you want to create a Copilot agent for a project you’re kicking off this quarter with a few other teammates. From your SharePoint document library, select only the folders or files you want. Then, with one click, you can create and immediately begin using your new agent. It reasons over the scoped set of SharePoint content to answer your questions, summarize information, or provide valuable insights, giving the most current and accurate response.
Secure by design: Creating an agent is as straightforward as creating a file. Agents in SharePoint are saved as Copilot files stored in the site where they’re initiated, ensuring consistent management and governance with site content.
Anyone with edit permissions on a SharePoint site, such as a site member, can create an agent scoped to the content they choose, and the agent will adhere to each user’s SharePoint permissions and the organization’s security policies. These Copilot agents, along with your other Microsoft 365 data, stay within the Microsoft 365 trust boundary.
Customize your agent: To further customize the agent you created in SharePoint, click the edit button to add more files, update the branding, modify starter prompts, and more. You can easily enhance your agent in Copilot Studio with more advanced customization, such as adding actions to automate workflows or additional data sources beyond SharePoint.
Share and collaborate: Similar to files in other Microsoft 365 productivity apps, you can easily add the agent to a Teams chat or share a link via email to collaborate with others. All you need to do to interact with the agent is @mention it.
Sharing this agent with collaborators for a specific project helps foster teamwork and knowledge sharing so you can all get insights and make decisions based on the same current, relevant information.
Built-in Copilot agent scoped to your SharePoint site: In addition to user–created Copilot agents, every SharePoint site will have a prebuilt Copilot agent grounded in all the content within that site. Any site member can use this Copilot agent to ask questions and gain insights from the site.
How to use Copilot agents: Here are a few examples that might inspire you to create Copilot agents from SharePoint for your own unique needs:
Everyone can benefit from an onboarding or transition buddy. An agent can help you get up to speed in a new role or provide support and guidance to others as you transition to a new team.
Marketing with a product launch agent enables a large, cross-functional team to filter and reason over various marketing documents to understand key dates and deliverables and make decisions or next steps.
Sales teams can get a key advantage with a conversation agent. Copilot can use customer details and interactions to suggest pertinent questions and content, optimizing conversations and engagement
HR can use an onboarding agent to guide new employees through company policies and provide them with instant, relevant answers.
Customer service can find answers and respond to customer questions with a triage agent. It can also surface trends and suggest fixes for common issues.
Engineering and product support can use a field incident report agent to analyze the types of issues coming in from the field and provide an analysis of what product issues should be prioritized.
Copilot agents in SharePoint make it easy to scale knowledge, enhance team collaboration, and drive operational efficiency from where you’re already working. It’s coming to public preview in early October, so give it a try in SharePoint soon.
Boost your efficiency at work with Copilot in OneDrive
Copilot in OneDrive is designed to help you rapidly find the files you need, discover content faster, and enhance your productivity to be more efficient―streamlining your daily tasks without ever opening a file.
Summarize files quickly: Faster extraction of key information in OneDrive is a productivity booster. With Copilot in OneDrive, you can summarize one or multiple files in your OneDrive web app without opening each file. Additionally, you can generate an FAQ from a document to use or share as a reference asset. For example, after returning from an extended vacation, you can summarize project plans and meeting notes to catch up on your work with one click in OneDrive
Compare documents with ease: Locating the right data or understanding the differences between multiple files is time-consuming. You can now select up to five files―even mixing formats such as Word docs, PowerPoints, and PDFs―and have Copilot offer a detailed comparison across all the files. This lets you get a high-level understanding of the information you’re working with.
Get answers on specific content: Sometimes you need to find a quick answer to a question or information that can help you with a project you’re working on. Now, you can ask Copilot questions about the information you need from the documents you choose to gain insights and do your best work.
The new Copilot in OneDrive features―summarizing content, asking questions about relevant files, and comparing documents―give you the most value out of your content.
Build SharePoint sites effortlessly with Copilot in SharePoint
Every month, millions of users create and edit sites and pages in SharePoint. Copilot in SharePoint now puts your words to work to create beautiful sites and pages. You can use AI and natural language to author pages and create content-rich sites.
Rewrite text to fit the perfect tone: Spend less time adjusting the messaging on your SharePoint sites and pages, and let the rich text editor give you suggestions to make your text more engaging.
Use natural language to create beautiful pages: Easily create visually appealing SharePoint pages. With Copilot, you can type in the kind of content you want to create, including the language, tone, and information, and it will do the work for you. You can also provide existing content―like a Word document or PowerPoint presentation―to Copilot, and it will transform that content into a beautiful page.
Copilot in SharePoint leverages all the features of the new SharePoint user experience designed to enable you to make more compelling, visually appealing content. With this capability, you can:
Apply branding and theming
Adjust typography and fonts
Create a grid and layout
Add videos and imagery
Use animations and motion
Using Copilot in SharePoint ensures your sites incorporate the newest design elements while staying true to your company brand.
Get started today
We are excited for you to begin using OneDrive and SharePoint features that are part of this next wave of Copilot innovation. You can experience many of these new capabilities that are rolling out today and preview others in the coming weeks.
Watch for the public preview of Copilot agents in SharePoint in early October.
Join Copilot agents and SharePoint product experts on October 16th for an exclusive Meet the Makers episode.
Copilot in OneDrive is rolling out now and will be fully available by the end of September.
Learn more at Microsoft OneDrive: AI Innovations for a New Era of Work and Home on October 8th.
Text rewrite capabilities of Copilot in SharePoint are rolling out now, with natural language page creation coming in early 2025.
Microsoft Tech Community – Latest Blogs –Read More
Python in Excel – Available Now
Combining the Power of Python and the Flexibility of Excel
Python in Excel is now generally available for Windows users of Microsoft 365 Business and Enterprise. Last August, in partnership with Anaconda, we introduced an exciting new addition to Excel by integrating Python, making it possible to seamlessly combine Python and Excel analytics within the same workbook, no setup required. Since then, we’ve brought the power of popular Python analytics libraries such as pandas, Matplotlib, and NLTK to countless Excel users.
Watch to learn more about Python in Excel:
“Seamless integration of Python data structures like pandas data frames and NumPy arrays in Excel is a total game changer. This expanded access to Python will create exciting new opportunities for innovation as well as making it even easier for business analysts and data scientists to collaborate.”
Wes McKinney, creator of pandas
With Python in Excel, users can harness advanced analytics for visualizations, data cleaning, machine learning, predictive analytics, and now, even more! Here are a few examples of what is possible, inspired by what our community of analysts is building within the Insiders Audience and internally at Microsoft.
Leverage predictive analytics
Advanced modeling capabilities in Python offer detailed and flexible optimization analysis – such as Monte Carlo simulations. These capabilities allow users to handle complex scenarios, providing deeper insights into their data.
Apply Monte Carlo simulations to project possible expenses.
Visualize network connections
NetworkX is a powerful tool for creating and analyzing complex networks, offering flexibility to model and visualize relationships between nodes effectively.
Use network models to view changes over time.
“Using Python in Excel has significantly streamlined my workflow… It has made complex data handling and visualization straightforward and efficient. The feature requires no setup, saving me significant time. The integration has made advanced data manipulation more accessible.”
Jack McCullogh, Principal Partner PM – Microsoft Business and Industry Copilots
Parse natural language
The NLTK and word cloud libraries in Python provide robust tools for text analysis and visualization. NLTK excels in natural language processing tasks, while word cloud generates visually engaging representations of textual data.
Extract and examine text to derive insights.
“Progressive analysts, who rely on data analytics for insights, could benefit by what we’ve seen with the latest advancements like Python in Excel. Excel’s integration with Copilot brings AI capabilities closer to where data currently resides—within our workbooks. Bringing all of this together with the ability to prompt in plain language could help analysts to leverage state-of-the-art analytics, such as advanced visualizations, allowing them to use just Excel and excel at their craft.”.
Pawan Divikarla, Business Leader, Progressive Insurance
Continuous Improvements
Modern editing
A great Python experience requires modern editing. This includes new features like syntax highlighting, code completion, and aid when referencing data with the xl() function – all of these have been added directly to the Formula Bar. Furthermore, we recently announced the Python Editor, a new surface that is a great companion for authoring code and leverages many of the same experiences found in Visual Studio Code.
Manage all your Python formulas from a single location.
Copilot in Excel with Python
Today we announced the public preview of Copilot in Excel with Python, which is designed to leverage AI to unlock the power of Python in Excel to a broader set of users. With Copilot, you can use natural language to describe the analysis you want to perform, and it will automatically generate, explain, and insert Python code into your Excel spreadsheet.
Dive deeper into your data with Copilot in Excel with Python, all without writing a single line of code.
“With a two sentence Copilot prompt, I was tickled to see Copilot in Excel write Python using RandomForestRegressor from sklearn module, which basically opened the world of machine learning to me. With working Python code in hand, I believe I can tune the parameters to achieve the desire output. When I had to learn Python before I could even start, I didn’t start.”
Mark Hodge, Microsoft 365 Global Blackbelt
Security is our priority
Python code used by Excel runs on the Microsoft Cloud with enterprise-level security as a compliant Microsoft 365 connected experience, just like OneDrive. The Python code runs in its own hypervisor isolated container using Azure Container Instances and secure, source-built packages from Anaconda through a secure software supply chain. Python in Excel keeps your data private by preventing the Python code from knowing who you are, and opening workbooks from the internet in further isolation within their own separate containers. Data from your workbooks can only be sent via the built-in xl() Python function, and the output of the Python code can only be returned as the result of the =PY() Excel function. The containers stay online as long as the workbook is open or until a timeout occurs. Your data does not persist in the Microsoft Cloud.
Learn more about our Data Security
Empowering Excel users
We believe there is a significant opportunity for anyone using Excel for analysis to greatly enhance their work with Python. Alongside incorporating numerous examples, tutorials, and tips into Excel, there are courses for Python in Excel on LinkedIn Learning. A new series, announced today, will be available for free for 30 days! After that time, it will be available to LinkedIn Premium or LinkedIn Learning subscribers.
Thank you for your feedback during Preview
We appreciate everyone who tested the feature, provided early feedback, identified issues, and created content during the initial rollout within the Insiders audience. Your assistance and feedback were crucial in getting us to our current version. We are inspired by what the community has built using Python in Excel already and are excited for even more users to now have access to this powerful feature.
We want your feedback!
Excel and Python users can give feedback directly within the application (go to Help > Feedback), suggest improvements on our Feedback portal, or engage with our team on GitHub.
Availability
Python in Excel is now generally available for Windows users of Microsoft 365 Business and Enterprise. With qualifying Microsoft 365 subscriptions, you can calculate Python formulas with standard compute and automatic recalculation mode. For faster calculations with premium compute and access to manual or partial recalculation modes, you must purchase the Python in Excel add-on license or request the license from your administrator.
To learn more about specific details on versions and channels, please see Python in Excel availability.
Other resources:
Introduction to Python in Excel
Getting started with Python in Excel
Learn Python in Excel with LinkedIn Learning
Microsoft Tech Community – Latest Blogs –Read More
Copilot pages for IT Admins – Sep 2024 update
Today we announced Copilot Pages, a first step in our new design system for knowledge work. Copilot Pages is a dynamic, persistent canvas in Copilot chat designed for multi-player collaboration. With Pages, you can turn insightful Copilot responses into something durable with a side-by-side page that you can edit and, when ready, share with your team to collaborate.
Copilot Pages starts rolling out today for Microsoft 365 Copilot users and soon for Microsoft 365 subscribers.
If you have a Microsoft 365 Copilot license, you and your team can work with Copilot directly on the page when you open it in full screen. In a multiplayer approach, prompt Copilot together as a team to improve and expand responses, learn from each other’s prompts, and organize complex information. With Copilot Pages, human to AI interactions come to life. We see collaborative prompting as the next great step forward in evolving Copilot from an individual, point-in-time exercise into a collaborative experience.
This update is to help IT Admins understand how Copilot Pages work and what it means for their organization. Copilot Pages are .loop files.
Who gets Copilot Pages?
Users with access to Microsoft 365 Copilot will be able to create Copilot Pages, and soon users with access to Microsoft Copilot our free commercial Copilot product will also be able to create pages
Copilot Pages are files that users can extend permissions to others using your organizations file sharing settings. If you need to further limit interaction with .loop files, use Conditional Access. Conditional Access can fully block users from opening the .loop file.
What is created when a user creates a Copilot Page?
A Copilot Page comes to life in your files ecosystem as a .loop file in a new user-owned SharePoint Embedded container. There are two main concepts to Loop: files and containers.
Files: Loop pages and components are .loop files. Copilot Pages are displayed to the right of a Copilot Business Chat. When shared as a component they are displayed as little interactive boxes in Microsoft 365 apps (this is how Loop components work). IT admins manage these .loop files just like any other files (.docx, .pptx, .xlsx, etc.). They support all the features of the SharePoint file system, including everything detailed here.
Containers: Copilot Pages are stored in a new user-owned SharePoint Embedded container, one per user. All content that Loop stores in SharePoint Embedded containers count against the tenant’s SharePoint quota. All your governance and compliance processes apply the same way they would to a user’s OneDrive. Management and graph APIs for these containers will soon be accessible to tools like AvePoint, ShareGate, your in-house tooling, and others.
IT Admin controls
Copilot Pages are rolling out to M365 Copilot users today and soon for M365 subscribers. Because they are .loop files, you can control them using Loop admin switches. Note that disabling Loop in your tenant does not disable Copilot Pages. We added a new switch specifically for Copilot Pages to ensure they’re easily controlled in your organization.
Copilot Pages are default enabled in your tenant (like all Loop integrations). The diagram shows the existing controls and highlights the new Copilot Pages control:
This article covers the Cloud Policy controls for all Loop components, but we’ll cover the “B” cloud policy explicitly here.
B: Create and view Loop files in Microsoft 365 Copilot Chat (Not Configured == Enabled) | To change the default configuration for Copilot Pages, follow these instructions:
Sign in to https://config.office.com/ with your Microsoft 365 admin credentials.
Select Customization from the left pane.
Select Policy Management.
Create a new policy configuration or edit an existing one.
From the Choose the scope dropdown list, choose either All users or select the group for which you want to apply the policy. For more information, See Microsoft 365 Groups for Cloud Policy.
In Configure Settings, choose this setting: For Create and view Loop files in Microsoft 365 Copilot Chat:
Enabled: Copilot chat experience is available to the users.
Disabled: Copilot chat experience isn’t available to the users.
Not configured: Copilot chat experience is available to the users. Save the policy configuration. Reassign priority for any security group, if required. (If two or more policy configurations are applicable to the same set of users, the one with the higher priority is applied.)
Save the policy configuration.
Reassign priority for any security group, if required. (If two or more policy configurations are applicable to the same set of users, the one with the higher priority is applied.)
In case you create a new policy configuration, or change the configuration for an existing policy, there can be a delay in the change being reflected as described below:
If there were existing policy configurations prior to the change, then it may take 90 mins for the change to be reflected.
If there were no policy configurations prior to the change, then it may take 24 hours for the change to be reflected.
Manage Pages content
All Copilot Pages support the capabilities listed here. In summary, that includes admin toggles, GDPR and EUDB compliance, Intune device management, Conditional Access policies, Information Barriers, Customer Lockbox, individual file recycle bin, version history, audit logs, eDiscovery, export, legal hold, retention policies, sensitivity labels, and data loss prevention.
For many organizations, these capabilities are more than enough for the default Enabled state of Loop experiences. For larger organizations with advanced governance, sharing, and management tools, the following additional capabilities coming in Q4 CY2024 may be of interest to IT Admins:
Retention labels at the file level
Programmatic API access to content in SharePoint Embedded containers (enables third-party Governance, Management, and Compliance tools)
Guest/external access via Entra B2B config for tenants with sensitivity labels
SharePoint Admin Center columns to identify user-owned containers
New user-owned storage containers
The diagram illustrates where Copilot Pages are saved, in a new user-owned SharePoint Embedded container. This content is lifetime-managed with the user account and is deleted when the user account is deleted from the organization. There is a default timeline where it is first soft deleted (can be recovered by an IT Admin) and then purged.
Similarly, when a user leaves, there is an IT Admin workflow to enable access to these containers before deletion so that valuable content can be copied to new locations. The capability to see another user’s Copilot Pages in the Loop app that were assigned before deletion is scheduled for Q4 CY2024.
User-owned containers will be identifiable in the SharePoint Admin Center by two new columns: Principal Owner and Ownership Type. Principal owner will be set to the username when the container is user-owned. And Ownership Type will be User.
Quota
All use of SharePoint Embedded storage counts against your tenant’s SharePoint quota. This is documented here.
Purview and Compliance
There are several compliance and manageability capabilities built into the SharePoint platform that Loop fully supports. Please see this learn article for an inventory. In the next sections, we’ll summarize the top areas we get questions about.
Legal Hold, eDiscovery, and export
Because .loop files are just like all the other files in your SharePoint ecosystem, Purview understands them and supports them natively with very little change. You can place SharePoint Embedded containers on legal hold using the URL to the container just like placing a SharePoint site on hold. You can search for content to place on hold using full text search in Purview. You can export the content in a review set that includes .loop files and automatically convert to .html for offline readable format using Purview Premium.
If you use third-party tools for eDiscovery or export for compliance, programmatic API access to content in SharePoint Embedded containers is coming in Q4 CY2024
Multi-Geo
The user-owned SharePoint Embedded container that holds Copilot Pages is created in the user’s preferred data location.
Sensitivity Labels and Data Loss Prevention
Two ways to control over sharing in your organization are fully supported in .loop files. The first is sensitivity labeling, which you can configure per Copilot page. And, if Copilot finds content that has a source label higher than the page, when adding it onto the page by pressing “Edit in Page,” it will automatically upgrade the sensitivity label. Sensitivity Labels can control things like external sharing rights, encryption of data, and more.
The second is data loss prevention, a security conscious scanner that detects very sensitive information and immediately blocks all sharing and triggers the owner of the file to remove it before full collaboration can be restored.
Audit
Because all .loop files are stored in the SharePoint ecosystem, full audit activity is available in the unified audit log that SharePoint events are already part of. Creates, updates, reads and deletes are all logged with attribution.
Governance Tooling
Governance of a user-owned container is a lot simpler than shared content like an M365 group or a SharePoint site, or even a shared Loop workspace, since it is typically lifetime managed with the user account and no additional regular governance is required. However, if you use third-party tools for governing user-owned containers, programmatic API access to content in SharePoint Embedded containers is coming in Q4 CY2024.
We hope this summary leaves you feeling confident about Copilot Pages in your organization.
Microsoft Tech Community – Latest Blogs –Read More
Major updates to the Copilot Success Kit
As we continue our journey to empowering you and your organization with AI experiences, we are thrilled to announce several significant updates to the Copilot Success Kit.
The Copilot Success Kit is designed to:
Accelerate your time to value with Microsoft 365 Copilot.
Enable your progressive skilling journey with AI tools.
These updates are part of our ongoing commitment to support our community and ensure you have access to the latest resources and guidance.
New content and features
The Implementation Summary Guide for Leaders has been updated to provide clearer guidance on the three essentials for Copilot success: Leadership, human change, and technical readiness.
The User Enablement Guide has been updated to include guidance on leveraging Microsoft Viva to drive healthy usage and user satisfaction. This comprehensive guide provides detailed instructions and best practices for enabling users to adopt and embrace AI capabilities.
The Technical Readiness Guide has been refreshed with updated Microsoft Copilot Studio and App Assure guidance. This guide focuses on the technical readiness aspects of implementing Copilot and provides valuable insights to ensure your organization is ready to leverage AI effectively.
The Accelerate Copilot with Microsoft Viva guide demonstrates how features and functions across the Viva Suite can accelerate your implementation of Copilot. This includes updated training content and user onboarding toolkits, designed to empower your workforce and drive successful AI usage.
The Use Microsoft Viva Amplify for your Copilot rollout guide provides examples of how Microsoft Digital, our IT organization who empowers our workforce, used Viva Amplify to implement Copilot in our organization. Learn from our experiences and best practices.
Delivering business results with Microsoft 365 Copilot helps you understand the crucial role of functional business leaders in driving successful AI adoption in your organization and provides specific guidance on how to engage them in your AI transformation journey.
Scenario Library enhancements: We have added new industry and functional use cases to the online, interactive Scenario Library. This update also includes Subject Matter Expert videos that showcase new value in various applications such as Word, Excel, and PowerPoint. These videos are designed to help you understand how to leverage Copilot in different scenarios and maximize its potential.
The Get Started with Microsoft 365 Copilot in Excel guide, included in the Trainer Kit within the Success Kit, provides practical examples for both new and power users of Excel.
Upcoming events and training
To support your adoption efforts, we are hosting a series of events and training sessions in the coming weeks and months. Watch our Copilot Adoption Hub and Microsoft Community Learning channel for more information.
We are excited to provide these guides and based on customer feedback believe they will enhance your experience with Copilot. Stay tuned for more information and be sure to join our upcoming events to learn more about how you can leverage these new resources to drive success in your organization. Comment below and in our community to give your feedback on how we can continue to improve our resources to support your journey.
Download the kit and more adoption resources on our Copilot Adoption Hub at https://adoption.microsoft.com/copilot.
Microsoft Tech Community – Latest Blogs –Read More