Month: December 2023
Microsoft Excel—the workhorse for so many jobs
Microsoft Excel is one of the core apps in the Microsoft 365 suite and is quite familiar to many small and medium business (SMB) users. But are you getting the most out of Excel?
Excel can do much more than create and edit spreadsheets
Customers who explore Excel’s features a bit more find that they can apply it to many tasks. You can quickly learn to use it as a data analytics tool, and it’s also great for building quick custom dashboards. You can also design a custom template so that your work is always on-brand. Excel can do a lot, by being a little inventive in how you use it.
Bandido Solutions uses Excel to talk to customers
Jimmy Davidson, owner of Bandido Solutions and Bandido Woodworks uses Microsoft 365 to support his business. He’s found that Microsoft Teams is key for working across three locations and Microsoft OneNote helps his team make sure that punch lists are continuously managed and up-to date, but most of all, he looks to Excel to run across his business and directly communicate about complex projects with his customers.
“If I had to pick one app in the Microsoft 365 Business suite, it would be Excel,” Davidson says. “It’s the root of our organization.”
Davidson stands out because he not only uses Excel for its core spreadsheet features, he also uses it as a communication channel with his customers. And he especially values how Excel allows his work to be transparent to his customers. By sending breakdowns that list the tasks and timelines for a kitchen or bath remodel to customers in Excel, Davidson can show them how their estimates were built, line by line. Since many of his customers are already familiar with Excel, using it allows Davidson and his customers to discuss the work together and quickly clarify any concerns or adjust schedules. The openness of communication builds rapport and trust and helps move projects along more quickly.
By using Excel’s template capabilities, Davidson can design a reuseable document format that lets customers see their breakdowns visually, using dashboard graphics to make the project schedule easy to understand and act on. He can still include the source spreadsheets in supplementary tabs, but what the customer sees first will be an easy-to-consume summary of the project that they are looking to his company to do for them. That new kitchen or bath now seems like a reality.
Resources
Find the right Microsoft 365 business plan for your business.
Learn more about how to set up and use your Microsoft 365 subscription and find tips and templates to help you accomplish your business tasks.
Get free resources, tech training, and guidance to keep your business thriving and growing.
Partners can access training resources, customer decks and deployment checklists to do more with Microsoft 365.
Microsoft Tech Community – Latest Blogs –Read More
Microsoft Excel—the workhorse for so many jobs
Microsoft Excel is one of the core apps in the Microsoft 365 suite and is quite familiar to many small and medium business (SMB) users. But are you getting the most out of Excel?
Excel can do much more than create and edit spreadsheets
Customers who explore Excel’s features a bit more find that they can apply it to many tasks. You can quickly learn to use it as a data analytics tool, and it’s also great for building quick custom dashboards. You can also design a custom template so that your work is always on-brand. Excel can do a lot, by being a little inventive in how you use it.
Bandido Solutions uses Excel to talk to customers
Jimmy Davidson, owner of Bandido Solutions and Bandido Woodworks uses Microsoft 365 to support his business. He’s found that Microsoft Teams is key for working across three locations and Microsoft OneNote helps his team make sure that punch lists are continuously managed and up-to date, but most of all, he looks to Excel to run across his business and directly communicate about complex projects with his customers.
“If I had to pick one app in the Microsoft 365 Business suite, it would be Excel,” Davidson says. “It’s the root of our organization.”
Davidson stands out because he not only uses Excel for its core spreadsheet features, he also uses it as a communication channel with his customers. And he especially values how Excel allows his work to be transparent to his customers. By sending breakdowns that list the tasks and timelines for a kitchen or bath remodel to customers in Excel, Davidson can show them how their estimates were built, line by line. Since many of his customers are already familiar with Excel, using it allows Davidson and his customers to discuss the work together and quickly clarify any concerns or adjust schedules. The openness of communication builds rapport and trust and helps move projects along more quickly.
By using Excel’s template capabilities, Davidson can design a reuseable document format that lets customers see their breakdowns visually, using dashboard graphics to make the project schedule easy to understand and act on. He can still include the source spreadsheets in supplementary tabs, but what the customer sees first will be an easy-to-consume summary of the project that they are looking to his company to do for them. That new kitchen or bath now seems like a reality.
Resources
Find the right Microsoft 365 business plan for your business.
Learn more about how to set up and use your Microsoft 365 subscription and find tips and templates to help you accomplish your business tasks.
Get free resources, tech training, and guidance to keep your business thriving and growing.
Partners can access training resources, customer decks and deployment checklists to do more with Microsoft 365.
Microsoft Tech Community – Latest Blogs –Read More
Microsoft Excel—the workhorse for so many jobs
Microsoft Excel is one of the core apps in the Microsoft 365 suite and is quite familiar to many small and medium business (SMB) users. But are you getting the most out of Excel?
Excel can do much more than create and edit spreadsheets
Customers who explore Excel’s features a bit more find that they can apply it to many tasks. You can quickly learn to use it as a data analytics tool, and it’s also great for building quick custom dashboards. You can also design a custom template so that your work is always on-brand. Excel can do a lot, by being a little inventive in how you use it.
Bandido Solutions uses Excel to talk to customers
Jimmy Davidson, owner of Bandido Solutions and Bandido Woodworks uses Microsoft 365 to support his business. He’s found that Microsoft Teams is key for working across three locations and Microsoft OneNote helps his team make sure that punch lists are continuously managed and up-to date, but most of all, he looks to Excel to run across his business and directly communicate about complex projects with his customers.
“If I had to pick one app in the Microsoft 365 Business suite, it would be Excel,” Davidson says. “It’s the root of our organization.”
Davidson stands out because he not only uses Excel for its core spreadsheet features, he also uses it as a communication channel with his customers. And he especially values how Excel allows his work to be transparent to his customers. By sending breakdowns that list the tasks and timelines for a kitchen or bath remodel to customers in Excel, Davidson can show them how their estimates were built, line by line. Since many of his customers are already familiar with Excel, using it allows Davidson and his customers to discuss the work together and quickly clarify any concerns or adjust schedules. The openness of communication builds rapport and trust and helps move projects along more quickly.
By using Excel’s template capabilities, Davidson can design a reuseable document format that lets customers see their breakdowns visually, using dashboard graphics to make the project schedule easy to understand and act on. He can still include the source spreadsheets in supplementary tabs, but what the customer sees first will be an easy-to-consume summary of the project that they are looking to his company to do for them. That new kitchen or bath now seems like a reality.
Resources
Find the right Microsoft 365 business plan for your business.
Learn more about how to set up and use your Microsoft 365 subscription and find tips and templates to help you accomplish your business tasks.
Get free resources, tech training, and guidance to keep your business thriving and growing.
Partners can access training resources, customer decks and deployment checklists to do more with Microsoft 365.
Microsoft Tech Community – Latest Blogs –Read More
Microsoft Excel—the workhorse for so many jobs
Microsoft Excel is one of the core apps in the Microsoft 365 suite and is quite familiar to many small and medium business (SMB) users. But are you getting the most out of Excel?
Excel can do much more than create and edit spreadsheets
Customers who explore Excel’s features a bit more find that they can apply it to many tasks. You can quickly learn to use it as a data analytics tool, and it’s also great for building quick custom dashboards. You can also design a custom template so that your work is always on-brand. Excel can do a lot, by being a little inventive in how you use it.
Bandido Solutions uses Excel to talk to customers
Jimmy Davidson, owner of Bandido Solutions and Bandido Woodworks uses Microsoft 365 to support his business. He’s found that Microsoft Teams is key for working across three locations and Microsoft OneNote helps his team make sure that punch lists are continuously managed and up-to date, but most of all, he looks to Excel to run across his business and directly communicate about complex projects with his customers.
“If I had to pick one app in the Microsoft 365 Business suite, it would be Excel,” Davidson says. “It’s the root of our organization.”
Davidson stands out because he not only uses Excel for its core spreadsheet features, he also uses it as a communication channel with his customers. And he especially values how Excel allows his work to be transparent to his customers. By sending breakdowns that list the tasks and timelines for a kitchen or bath remodel to customers in Excel, Davidson can show them how their estimates were built, line by line. Since many of his customers are already familiar with Excel, using it allows Davidson and his customers to discuss the work together and quickly clarify any concerns or adjust schedules. The openness of communication builds rapport and trust and helps move projects along more quickly.
By using Excel’s template capabilities, Davidson can design a reuseable document format that lets customers see their breakdowns visually, using dashboard graphics to make the project schedule easy to understand and act on. He can still include the source spreadsheets in supplementary tabs, but what the customer sees first will be an easy-to-consume summary of the project that they are looking to his company to do for them. That new kitchen or bath now seems like a reality.
Resources
Find the right Microsoft 365 business plan for your business.
Learn more about how to set up and use your Microsoft 365 subscription and find tips and templates to help you accomplish your business tasks.
Get free resources, tech training, and guidance to keep your business thriving and growing.
Partners can access training resources, customer decks and deployment checklists to do more with Microsoft 365.
Microsoft Tech Community – Latest Blogs –Read More
Microsoft Excel—the workhorse for so many jobs
Microsoft Excel is one of the core apps in the Microsoft 365 suite and is quite familiar to many small and medium business (SMB) users. But are you getting the most out of Excel?
Excel can do much more than create and edit spreadsheets
Customers who explore Excel’s features a bit more find that they can apply it to many tasks. You can quickly learn to use it as a data analytics tool, and it’s also great for building quick custom dashboards. You can also design a custom template so that your work is always on-brand. Excel can do a lot, by being a little inventive in how you use it.
Bandido Solutions uses Excel to talk to customers
Jimmy Davidson, owner of Bandido Solutions and Bandido Woodworks uses Microsoft 365 to support his business. He’s found that Microsoft Teams is key for working across three locations and Microsoft OneNote helps his team make sure that punch lists are continuously managed and up-to date, but most of all, he looks to Excel to run across his business and directly communicate about complex projects with his customers.
“If I had to pick one app in the Microsoft 365 Business suite, it would be Excel,” Davidson says. “It’s the root of our organization.”
Davidson stands out because he not only uses Excel for its core spreadsheet features, he also uses it as a communication channel with his customers. And he especially values how Excel allows his work to be transparent to his customers. By sending breakdowns that list the tasks and timelines for a kitchen or bath remodel to customers in Excel, Davidson can show them how their estimates were built, line by line. Since many of his customers are already familiar with Excel, using it allows Davidson and his customers to discuss the work together and quickly clarify any concerns or adjust schedules. The openness of communication builds rapport and trust and helps move projects along more quickly.
By using Excel’s template capabilities, Davidson can design a reuseable document format that lets customers see their breakdowns visually, using dashboard graphics to make the project schedule easy to understand and act on. He can still include the source spreadsheets in supplementary tabs, but what the customer sees first will be an easy-to-consume summary of the project that they are looking to his company to do for them. That new kitchen or bath now seems like a reality.
Resources
Find the right Microsoft 365 business plan for your business.
Learn more about how to set up and use your Microsoft 365 subscription and find tips and templates to help you accomplish your business tasks.
Get free resources, tech training, and guidance to keep your business thriving and growing.
Partners can access training resources, customer decks and deployment checklists to do more with Microsoft 365.
Microsoft Tech Community – Latest Blogs –Read More
What’s new in Microsoft Intune (2312) December edition
In the December What’s New, we’re reprising four focus areas from the past year:
Cloud-native for device management
MacOS management
Microsoft Intune Suite
Microsoft Security Copilot in Intune
Additionally, for those just beginning their cloud-native journey, we’re including a link to the inaugural version of a guide on how to migrate to Microsoft Intune from other management solutions.
Let me know how these new capabilities—or any of those highlighted in 2023 What’s New blogs—are working for you by commenting on this post or connecting with me on LinkedIn.
Cloud native for device management
“Cloud native” is becoming mainstream as more customers fully adopt cloud-native endpoint management strategies. This means accelerating cloud adoption for endpoint management, establishing a digital estate from the cloud, evolving modern management beyond hybrid, and building a cloud-native defense-in-depth strategy.
Customers have reported transformations that enhance security and save money. Michael Wallent’s recent blog post (the first of a 3-part series) showcases these benefits and more around shifting the way we think about device management.
Throughout the year, we released new capabilities to help you accelerate time to value by getting employees up and running faster, managing and protecting applications, getting a real-time view of what’s going on across your device landscape, and applying security policies in minutes.
We’ve been providing cloud-native solutions, from improved management for Windows and drivers and firmware updates in Intune to Windows Local Administrator Password Solution (LAPS). Now we’re adding capabilities in Windows Autopilot, like app install pre-provisioning improvements and streamlining unified security settings management with integration of Microsoft Defender for Endpoint native endpoint settings and Intune. We think you’ll be pleased!
The year in Mac management
In 2023, we continued to innovate macOS management in exciting ways. Our customers shared that the best possible experience would be a single solution capable of managing all their endpoints across platforms in one place. We listened, releasing software update policy for macOS, complex app management for macOS, remote help for macOS, and more.
Our cross-platform approach enables you to manage your entire estate in one place. This can save you time and money by eliminating the need for multiple management platforms and on-premises point solutions.
You can see an updated list of macOS capabilities in the article, Now is the time—manage your Mac endpoints with Microsoft Intune. You can also join the conversation in the Mac Admins community. There will be much more in 2024, so check out the coming attractions in Microsoft Intune reinvents Mac management.
Microsoft Intune Suite
Launched in March, the Intune Suite provides mission-critical advanced endpoint management and security capabilities. The Intune Suite delivers and continues to develop additional depth in technical assistance with the following:
Remote Help
Windows Standard User support with Endpoint Privilege Management
AI driven advanced endpoint analytics
Secure corporate data and application access from personal mobile devices with Tunnel for Mobile App Management, and enterprise grade, an advanced app management all natively integrated across the Microsoft Cloud.
Based on this connected fabric, Intune can increase IT and Security team collaboration, broaden visibility, converge workflows, and unify data in a way that’s unmatched and leads to added simplicity, security, and savings.
Since the release of the Intune Suite, thousands of organizations have integrated their remote support tools in Intune with Remote Help and ServiceNow integration. Remote Help is now available on Windows, Android, and macOS systems. Customers use Remote Help to support workers anywhere they are, to improve efficiency, and to mitigate security risks. You can learn more about Remote Help by watching Simple and secure helpdesk support using Remote Help in Intune at Microsoft Technical Takeoff.
Customers are balancing security and productivity with Endpoint Privilege Management by allowing everyone to run as standard Windows users, elevating app privileges only when needed, and reducing security risks by enforcing least-privilege access. Policy-based elevation management streamlines IT workstreams, enables employee productivity without comprising security and delivers insights based on elevation audits for a comprehensive view across the organization. You can learn more about Endpoint Privilege Management, including the upcoming support approval workflow, in Uplevel security with Endpoint Privilege Management + Windows LAPS.
Microsoft Tunnel for mobile app management provides a micro-VPN solution for employees who require access to on-premises resources from personal mobile devices. The capability allows IT to set up secure access for mobile users and doesn’t require device enrollment. You can provide mobile access to corporate resources while still applying security policies and protecting data with Intune, offering end users flexibility to work efficiently without any concern for the need to enroll their personal devices and allows you to embrace bring-your-own-device policies without compromising security. For more on tunnel, read Announcing Microsoft Tunnel for MAM for iOS and Android.
AI driven advanced endpoint analytics enables you to use your data, combined with the insights from the entire ecosystem to enable IT to proactively remediate real issues end users face. Anomaly detection today provides alerts and reporting device level events and signals such as application hangs, crashes and stop error restarts, with additional types of anomalies being added over time. We are also adding in new capabilities that provide deeper, more granular insights so you can discover unreported issues and proactively improve device performance and end user experience. For more on advanced endpoint analytics watch Advanced analytics: supercharge real-time reporting with insights that matter at Microsoft Technical Takeoff.
We’ve continuously added capabilities to unify endpoint management and security operations in the cloud, focusing on delivering value through centralized data and insights into device health and performance. This enables IT to keep users happy and productive while simplifying operations. In calendar year 2024, we’ll deliver even more value with advanced analytics, Cloud PKI, and enterprise app management. For demos and more information, watch Modern management innovation shaping endpoint security at Ignite.
Microsoft Security Copilot in Intune
This year, we launched Security Copilot, now available in early access, where Intune device and policy data can be used to enrich security investigations, driving faster investigations and mitigations.
Additionally, we launched the private preview of Security Copilot embedded experiences in the Intune admin center. Here, you’ll be able to use natural language to troubleshoot devices without needing to navigate through various sources to gather information about the impacted device.
Security Copilot assists in translating business intent into policy configuration through natural language prompts. It also helps in understanding settings and their impact, and surfaces Microsoft recommendations. Along with generating policies, it allows you to assess the potential impact of deploying these policies in your enterprise and determine if a deployment is likely to cause policy conflicts. For demos and more information, watch Generative AI and the next generation of Intune features at Microsoft Technical Takeoff.
Getting started with Intune migrations
Wondering how to get started with all these management and security solutions? Customers and partners often ask us to provide guidance on migrating to Microsoft Intune from cloud-native or existing management solutions. In response, we’ve released a guide offering a high-level look at architectural differences customers should consider when migrating.
We provide information on the framework and processes that Microsoft has developed through thousands of migrations with enterprise customers. You can find the guide here. It’s a work in process, so please let us know if there’s anything we can do to improve it for you.
Your feedback is welcome
This is our final What’s New of the 2023 release cycle. We want to know what you think of our new capabilities. Please share your thoughts by commenting on this post or connecting with me on LinkedIn.
Stay up to date! Bookmark the Microsoft Intune Blog and follow us on LinkedIn or @MSIntune on X to continue the conversation.
Microsoft Tech Community – Latest Blogs –Read More
2023 in Review
As we wrap up 2023, we on the Excel team want to express our heartfelt gratitude to you all across our Excel community. We greatly appreciate each and every one of you for your continued contribution to the community, helping others learn more about Excel, and giving us feedback to make Excel even better.
2023 was filled with excitement for Excel, from Excel esports on ESPN8: The Ocho to the Excel Collegiate Challenge, the Excel World Championship, and more.
Excel esports on ESPN8: The Ocho. For the second year in a row, Excel esports returned to ESPN8: The Ocho, joining an incredible lineup of “43 hours of unique and groundbreaking programming and sports.” David Pierce / The Verge asks, “Can the next big thing in gaming be… spreadsheets” in his article “Excel’s esports revolution is coming back to ESPN this week.”
Excel Collegiate Challenge. Over 3,000 students from hundreds of universities and colleges worldwide participated in this year’s Excel Collegiate Challenge. 50+ students representing ~30 universities and colleges from 10+ countries made it to the Finals in early December at the University of Arizona televised on ESPN and livestreamed on YouTube.
Excel World Championship. On Saturday, December 9th, the Excel World Championship took over the HyperX esports arena in Las Vegas for the Finals of this year’s Excel esports season. 16 of the world’s top Excel experts came together to solve fun and challenging case questions, in Excel, in front of a packed house of excited fans, along with thousands of engaged viewers on ESPN, YouTube, and Twitch cheering for their favorite Excel legends!
Robert McMillan / Wall Street Journal captured how “The excitement is off the charts at the Olympics of competitive ‘spreadsheeting’” in “Inside the World Excel Championships (Yes, You Read That Right).” Will Pavia / The Times followed Andrew “The Annihilator” Ngai’s “nearly denied victory” in “Glitch almost costs reigning champion in Microsoft Excel World Championship.” Daisy Dumas / The Guardian detailed how Andrew won the event in “‘You didn’t just succeed, you Exceled’: Sydney man dubbed the ‘Annihilator’ wins Excel world championship.”
2023 was also an incredibly exciting year of innovations and delights, from Python in Excel and Copilot in Excel to formula suggestions and formula by example and inserting pictures and checkboxes into cells, and more! Below are only a few highlights – see our monthly What’s New in Excel series for more.
Copilot in Excel. Helps you do more with your data in Excel tables by generating formula column suggestions, showing insights in charts and PivotTables, and highlighting interesting portions of data. Read more >
Formula Suggestions. Helps you create formulas more quickly and accurately by offering relevant suggestions based on your data and context. Type “=” at the beginning of a cell, and Formula Suggestions will show you different formulas that you can apply to your data, along with a specified range. Read more >
Formula by Example. Looks for patterns as you enter data in the worksheet. When it recognizes a pattern, Formula by Example offers a formula to fill the rest of the column with the recognized pattern. Read more >
Checkboxes. Quickly visualize and set TRUE and FALSE values in a cell using checkboxes to simplify data entry and reduce errors. Read more >
Insert pictures into cells. Insert local pictures, directly into cells, from your device or from the stock image libraries. Read more >
GROUPBY & PIVOTBY. Perform data aggregations using a single formula. Read more >
Python in Excel. Natively combine Python and Excel analytics within the same workbook – with no setup required. Type Python directly into a cell, the Python calculations run in the Microsoft Cloud, and your results are returned to the worksheet, including plots and visualizations. Read more >
Thank you for your continued contribution to the community. We look forward to 2024 with even more excitement, innovations, and delights with you all.
Subscribe to our Excel Blog and the Insiders Blog to get the latest updates, and join our Excel Community to stay connected with us and other Excel fans around the world.
Microsoft Tech Community – Latest Blogs –Read More
2023 in Review
As we wrap up 2023, we on the Excel team want to express our heartfelt gratitude to you all across our Excel community. We greatly appreciate each and every one of you for your continued contribution to the community, helping others learn more about Excel, and giving us feedback to make Excel even better.
2023 was filled with excitement for Excel, from Excel esports on ESPN8: The Ocho to the Excel Collegiate Challenge, the Excel World Championship, and more.
Excel esports on ESPN8: The Ocho. For the second year in a row, Excel esports returned to ESPN8: The Ocho, joining an incredible lineup of “43 hours of unique and groundbreaking programming and sports.” David Pierce / The Verge asks, “Can the next big thing in gaming be… spreadsheets” in his article “Excel’s esports revolution is coming back to ESPN this week.”
Excel Collegiate Challenge. Over 3,000 students from hundreds of universities and colleges worldwide participated in this year’s Excel Collegiate Challenge. 50+ students representing ~30 universities and colleges from 10+ countries made it to the Finals in early December at the University of Arizona televised on ESPN and livestreamed on YouTube.
Excel World Championship. On Saturday, December 9th, the Excel World Championship took over the HyperX esports arena in Las Vegas for the Finals of this year’s Excel esports season. 16 of the world’s top Excel experts came together to solve fun and challenging case questions, in Excel, in front of a packed house of excited fans, along with thousands of engaged viewers on ESPN, YouTube, and Twitch cheering for their favorite Excel legends!
Robert McMillan / Wall Street Journal captured how “The excitement is off the charts at the Olympics of competitive ‘spreadsheeting’” in “Inside the World Excel Championships (Yes, You Read That Right).” Will Pavia / The Times followed Andrew “The Annihilator” Ngai’s “nearly denied victory” in “Glitch almost costs reigning champion in Microsoft Excel World Championship.” Daisy Dumas / The Guardian detailed how Andrew won the event in “‘You didn’t just succeed, you Exceled’: Sydney man dubbed the ‘Annihilator’ wins Excel world championship.”
2023 was also an incredibly exciting year of innovations and delights, from Python in Excel and Copilot in Excel to formula suggestions and formula by example and inserting pictures and checkboxes into cells, and more! Below are only a few highlights – see our monthly What’s New in Excel series for more.
Copilot in Excel. Helps you do more with your data in Excel tables by generating formula column suggestions, showing insights in charts and PivotTables, and highlighting interesting portions of data. Read more >
Formula Suggestions. Helps you create formulas more quickly and accurately by offering relevant suggestions based on your data and context. Type “=” at the beginning of a cell, and Formula Suggestions will show you different formulas that you can apply to your data, along with a specified range. Read more >
Formula by Example. Looks for patterns as you enter data in the worksheet. When it recognizes a pattern, Formula by Example offers a formula to fill the rest of the column with the recognized pattern. Read more >
Checkboxes. Quickly visualize and set TRUE and FALSE values in a cell using checkboxes to simplify data entry and reduce errors. Read more >
Insert pictures into cells. Insert local pictures, directly into cells, from your device or from the stock image libraries. Read more >
GROUPBY & PIVOTBY. Perform data aggregations using a single formula. Read more >
Python in Excel. Natively combine Python and Excel analytics within the same workbook – with no setup required. Type Python directly into a cell, the Python calculations run in the Microsoft Cloud, and your results are returned to the worksheet, including plots and visualizations. Read more >
Thank you for your continued contribution to the community. We look forward to 2024 with even more excitement, innovations, and delights with you all.
Subscribe to our Excel Blog and the Insiders Blog to get the latest updates, and join our Excel Community to stay connected with us and other Excel fans around the world.
Microsoft Tech Community – Latest Blogs –Read More
2023 in Review
As we wrap up 2023, we on the Excel team want to express our heartfelt gratitude to you all across our Excel community. We greatly appreciate each and every one of you for your continued contribution to the community, helping others learn more about Excel, and giving us feedback to make Excel even better.
2023 was filled with excitement for Excel, from Excel esports on ESPN8: The Ocho to the Excel Collegiate Challenge, the Excel World Championship, and more.
Excel esports on ESPN8: The Ocho. For the second year in a row, Excel esports returned to ESPN8: The Ocho, joining an incredible lineup of “43 hours of unique and groundbreaking programming and sports.” David Pierce / The Verge asks, “Can the next big thing in gaming be… spreadsheets” in his article “Excel’s esports revolution is coming back to ESPN this week.”
Excel Collegiate Challenge. Over 3,000 students from hundreds of universities and colleges worldwide participated in this year’s Excel Collegiate Challenge. 50+ students representing ~30 universities and colleges from 10+ countries made it to the Finals in early December at the University of Arizona televised on ESPN and livestreamed on YouTube.
Excel World Championship. On Saturday, December 9th, the Excel World Championship took over the HyperX esports arena in Las Vegas for the Finals of this year’s Excel esports season. 16 of the world’s top Excel experts came together to solve fun and challenging case questions, in Excel, in front of a packed house of excited fans, along with thousands of engaged viewers on ESPN, YouTube, and Twitch cheering for their favorite Excel legends!
Robert McMillan / Wall Street Journal captured how “The excitement is off the charts at the Olympics of competitive ‘spreadsheeting’” in “Inside the World Excel Championships (Yes, You Read That Right).” Will Pavia / The Times followed Andrew “The Annihilator” Ngai’s “nearly denied victory” in “Glitch almost costs reigning champion in Microsoft Excel World Championship.” Daisy Dumas / The Guardian detailed how Andrew won the event in “‘You didn’t just succeed, you Exceled’: Sydney man dubbed the ‘Annihilator’ wins Excel world championship.”
2023 was also an incredibly exciting year of innovations and delights, from Python in Excel and Copilot in Excel to formula suggestions and formula by example and inserting pictures and checkboxes into cells, and more! Below are only a few highlights – see our monthly What’s New in Excel series for more.
Copilot in Excel. Helps you do more with your data in Excel tables by generating formula column suggestions, showing insights in charts and PivotTables, and highlighting interesting portions of data. Read more >
Formula Suggestions. Helps you create formulas more quickly and accurately by offering relevant suggestions based on your data and context. Type “=” at the beginning of a cell, and Formula Suggestions will show you different formulas that you can apply to your data, along with a specified range. Read more >
Formula by Example. Looks for patterns as you enter data in the worksheet. When it recognizes a pattern, Formula by Example offers a formula to fill the rest of the column with the recognized pattern. Read more >
Checkboxes. Quickly visualize and set TRUE and FALSE values in a cell using checkboxes to simplify data entry and reduce errors. Read more >
Insert pictures into cells. Insert local pictures, directly into cells, from your device or from the stock image libraries. Read more >
GROUPBY & PIVOTBY. Perform data aggregations using a single formula. Read more >
Python in Excel. Natively combine Python and Excel analytics within the same workbook – with no setup required. Type Python directly into a cell, the Python calculations run in the Microsoft Cloud, and your results are returned to the worksheet, including plots and visualizations. Read more >
Thank you for your continued contribution to the community. We look forward to 2024 with even more excitement, innovations, and delights with you all.
Subscribe to our Excel Blog and the Insiders Blog to get the latest updates, and join our Excel Community to stay connected with us and other Excel fans around the world.
Microsoft Tech Community – Latest Blogs –Read More
C code generation: memory allocation for reference model in multi-instance mode
I am generating c code for model reference hierarchy using Embedded Coder.
There are reference models which are called multiple times from a parent model.
In the generated code, the block signals and block states data for each instance of reference model is accumulated in block states data of parent model creating a large structure(which causes compilation error).
I would like to have a single memory allocation(global) for this reference model data and reuse it for all instances.
I tried changing many settings related to code generation/optimization, but could not fix this.
Is there any method to achieve this?
/* Block states (default storage) for model ‘ParentModel’ */
typedef struct {
MdlrefDW_ChildModel_T Instance1;
MdlrefDW_ChildModel_T Instance2;
MdlrefDW_ChildModel_T Instance3;
…
}DW_ParentModel_xxxx_T
ChildModel is having an image processing logic and MdlrefDW_ChildModel_T is having a size of 200MB.
So when the number of instances increases, size of final _DW structure increases significantly.I am generating c code for model reference hierarchy using Embedded Coder.
There are reference models which are called multiple times from a parent model.
In the generated code, the block signals and block states data for each instance of reference model is accumulated in block states data of parent model creating a large structure(which causes compilation error).
I would like to have a single memory allocation(global) for this reference model data and reuse it for all instances.
I tried changing many settings related to code generation/optimization, but could not fix this.
Is there any method to achieve this?
/* Block states (default storage) for model ‘ParentModel’ */
typedef struct {
MdlrefDW_ChildModel_T Instance1;
MdlrefDW_ChildModel_T Instance2;
MdlrefDW_ChildModel_T Instance3;
…
}DW_ParentModel_xxxx_T
ChildModel is having an image processing logic and MdlrefDW_ChildModel_T is having a size of 200MB.
So when the number of instances increases, size of final _DW structure increases significantly. I am generating c code for model reference hierarchy using Embedded Coder.
There are reference models which are called multiple times from a parent model.
In the generated code, the block signals and block states data for each instance of reference model is accumulated in block states data of parent model creating a large structure(which causes compilation error).
I would like to have a single memory allocation(global) for this reference model data and reuse it for all instances.
I tried changing many settings related to code generation/optimization, but could not fix this.
Is there any method to achieve this?
/* Block states (default storage) for model ‘ParentModel’ */
typedef struct {
MdlrefDW_ChildModel_T Instance1;
MdlrefDW_ChildModel_T Instance2;
MdlrefDW_ChildModel_T Instance3;
…
}DW_ParentModel_xxxx_T
ChildModel is having an image processing logic and MdlrefDW_ChildModel_T is having a size of 200MB.
So when the number of instances increases, size of final _DW structure increases significantly. simulink, code generation, reference models, multiinstance, global memory, heap, internal data buffer MATLAB Answers — New Questions
Known Issue: Some management settings become permanent on Android 14
Google recently identified two issues in Android 14 that make some management policies permanent on non-Samsung devices. When a device is upgraded from Android 13 to Android 14, certain settings are made permanent on the device. Additionally, when devices that have been upgraded to Android 14 are rebooted, other settings are made permanent on the device.
For example, let’s say you are managing a device with a personally-owned work profile running Android 13, with the settings Block camera and Block apps from unknown sources enabled in the management profile. When that device updates to Android 14, the camera will become permanently blocked, even if you later disable the Block camera setting in Intune. After the update to Android 14, when the device reboots, apps from unknown sources will also become permanently blocked, even if you later disable Block apps from unknown sources in Intune.
Due to the severity of the issue, we do not recommend updating non-Samsung devices to Android 14 at this time. On Android Enterprise devices, you can use Intune device restrictions policies to postpone system updates. For more details, see Managing system updates on Microsoft Intune managed Android Enterprise corporate devices.
Issue 1: A device that has been upgraded to Android 14 is rebooted
When devices that have been upgraded to Android 14 are rebooted, certain settings are made permanent on the device. Devices that shipped with Android 14 will not be affected.
This issue currently affects devices enrolled with personally-owned work profiles.
Settings affected
Personally-owned work profile
Threat scan on apps
Block apps from unknown sources
Fully managed, Dedicated and Corporate-owned work profile
Google recently released a fix for this issue on fully managed, dedicated, and corporate-owned fully managed devices. Prior to this, some settings could also have become permanent on devices after rebooting. We’ll update this post with the list of affected settings soon.
Issue 2: A device is upgraded from Android 13 to Android 14
When a device is upgraded from Android 13 to Android 14, certain settings are made permanent on the device.
The following enrollment types are affected by this issue:
Fully managed
Dedicated
Corporate-owned work profile
Personally-owned work profile
Settings affected
Fully managed, Dedicated and Corporate-owned work profile
Date and Time changes
Roaming data services
Wi-Fi access point configuration
Bluetooth configuration
Tethering and access to hotspots
USB file transfer
External media
Beam data using NFC
Developer settings
Microphone adjustment
Volume changes
Factory reset
USB storage
System error warnings
Copy and paste between work and personal profiles
Add new users
Users can configure credentials
User removal
Account changes
Allow users to enable app installation from unknown sources in the personal profile
Personally-owned work profile
Camera (set to ‘Block’)
VPN (set to ‘Enabled’)
Copy and paste between work and personal profile
Prevent app installations from unknown sources in the personal profile
Add or remove accounts (set to ‘Block all account types’)
One lock for device and work profile
Next steps
Currently, the only way to clear settings that have become permanent is:
(Personally-owned work profile) Remove the work profile from the device.
Note: If configured, the settings Threat scan on apps and Block apps from unknown sources cannot be cleared by removing the work profile.
(All enrollment types) Factory reset the device.
Google is currently sharing patches with other device OEMs for these issues, which OEMs will integrate into their OS update images going forward. Device OEMs will determine if, and how, their devices will receive these fixes. When released, these OEM patches will prevent these issues in the future, but if a device has already upgraded to Android 14 and experienced the issue, any settings that have been made permanent will remain on the device.
We’ll continue to provide updates on this post as they’re available. If you have any questions leave a comment below or reach out to us on X @IntuneSuppTeam.
Microsoft Tech Community – Latest Blogs –Read More
App Slow With UIAxes
Hi. I’m creating apps on app designer which use components such as sliders to control a plot. When plotting on a UIAxes, there is significant delay. However, when having the app plot on a separate figure, there is no delay. Does anyone know the reason for this and if there’s a way to plot on the UIAxes without the delay? Thanks.
I’m going to use an app modelling a cylinder removing a lot of the additional unnecessary stuff, so the type of problem is as clear as possible. The plot consists of surf, patch, and plot3. For all apps, the goal is not plotting data per say, but rather creating shapes, often in 3 dimensions. Therefore, the data is generally arrays of type double which don’t generally get over 100 elements.
I’m using MATLAB R2020a.
These are the two methods:
I drag and drop a UIAxes on to the app and plot on that axis. This takes about 3 seconds to update the plot each time I move the slider. This is a screenshot of the setup:
I create a separate regular figure (not uifigure) and plot it on that. This has almost no delay:
This is the code used to create the separate figure and have them aligned neatly (I don’t think it’s that important but it clarifies what I’m doing):
global ax %needed so it can be accessed through component callbacks
divide=.2;%the fraction of the screen filled by the app
set(0,’units’,’pixels’)
pixels=get(0,’screensize’);
app.UIFigure.Position=[0,0,divide*pixels(3),pixels(4)];
fig=figure; %new figure
fig.Position=[divide*pixels(3),0,(1-divide)*pixels(3),pixels(4)];
ax=axes(fig); %axis it will be plotted on
Here is the code which I used (I removed much of the code used in the original app to simplify things) (the code is based off of Clay M. Thompson’s cylinder function, and I kept the copyright text in the code):
function torsion(ax,ax2,M,G,L,r,display_in)
% Clay M. Thompson 4-24-91, CBM 8-21-92.
% Copyright 1984-2002 The MathWorks, Inc.
cla(ax)
% engineering equations:
J=1/4*r^4;
phi=M*L/(J*G);
% set up cylinder:
n = 50;
r = [r r]’;
r = r(:); % Make sure r is a vector.
m = length(r); if m==1, r = [r;r]; m = 2; end
theta = (0:n)/n*2*pi;
sintheta = sin(theta); sintheta(n+1) = 0;
x = r * cos(theta);
y = r * sintheta;
z = (0:m-1)’/(m-1) *L* ones(1,n+1);
hold(ax,’on’)
% plot cylinder
surf(ax,x,y,z,’EdgeColor’,’none’,’FaceAlpha’,1)
patch(ax,x(1,:),y(1,:),z(1,:),[.25 0 .7])
patch(ax,x(1,:),y(1,:),z(2,:),[.25 0 .7])
%plot helices
z_vals=linspace(0,L,n*L/(2*pi*r(1)));
for i=0:n-1
angle0=i*(2*pi)/n;
anglef=angle0+phi;
theta_part=linspace(angle0,anglef,length(z_vals));
x_part=(r*1.01)*cos(theta_part);
y_part=(r*1.01)*sin(theta_part);
z_vals=linspace(0,L,length(x_part));
plot3(ax,x_part,y_part,z_vals,’k’,’LineWidth’,.5)
end
% plot circles
for i=z_vals
plot3(ax,x,y,i*ones(1,n+1),’k’,’LineWidth’,.5)
end
endHi. I’m creating apps on app designer which use components such as sliders to control a plot. When plotting on a UIAxes, there is significant delay. However, when having the app plot on a separate figure, there is no delay. Does anyone know the reason for this and if there’s a way to plot on the UIAxes without the delay? Thanks.
I’m going to use an app modelling a cylinder removing a lot of the additional unnecessary stuff, so the type of problem is as clear as possible. The plot consists of surf, patch, and plot3. For all apps, the goal is not plotting data per say, but rather creating shapes, often in 3 dimensions. Therefore, the data is generally arrays of type double which don’t generally get over 100 elements.
I’m using MATLAB R2020a.
These are the two methods:
I drag and drop a UIAxes on to the app and plot on that axis. This takes about 3 seconds to update the plot each time I move the slider. This is a screenshot of the setup:
I create a separate regular figure (not uifigure) and plot it on that. This has almost no delay:
This is the code used to create the separate figure and have them aligned neatly (I don’t think it’s that important but it clarifies what I’m doing):
global ax %needed so it can be accessed through component callbacks
divide=.2;%the fraction of the screen filled by the app
set(0,’units’,’pixels’)
pixels=get(0,’screensize’);
app.UIFigure.Position=[0,0,divide*pixels(3),pixels(4)];
fig=figure; %new figure
fig.Position=[divide*pixels(3),0,(1-divide)*pixels(3),pixels(4)];
ax=axes(fig); %axis it will be plotted on
Here is the code which I used (I removed much of the code used in the original app to simplify things) (the code is based off of Clay M. Thompson’s cylinder function, and I kept the copyright text in the code):
function torsion(ax,ax2,M,G,L,r,display_in)
% Clay M. Thompson 4-24-91, CBM 8-21-92.
% Copyright 1984-2002 The MathWorks, Inc.
cla(ax)
% engineering equations:
J=1/4*r^4;
phi=M*L/(J*G);
% set up cylinder:
n = 50;
r = [r r]’;
r = r(:); % Make sure r is a vector.
m = length(r); if m==1, r = [r;r]; m = 2; end
theta = (0:n)/n*2*pi;
sintheta = sin(theta); sintheta(n+1) = 0;
x = r * cos(theta);
y = r * sintheta;
z = (0:m-1)’/(m-1) *L* ones(1,n+1);
hold(ax,’on’)
% plot cylinder
surf(ax,x,y,z,’EdgeColor’,’none’,’FaceAlpha’,1)
patch(ax,x(1,:),y(1,:),z(1,:),[.25 0 .7])
patch(ax,x(1,:),y(1,:),z(2,:),[.25 0 .7])
%plot helices
z_vals=linspace(0,L,n*L/(2*pi*r(1)));
for i=0:n-1
angle0=i*(2*pi)/n;
anglef=angle0+phi;
theta_part=linspace(angle0,anglef,length(z_vals));
x_part=(r*1.01)*cos(theta_part);
y_part=(r*1.01)*sin(theta_part);
z_vals=linspace(0,L,length(x_part));
plot3(ax,x_part,y_part,z_vals,’k’,’LineWidth’,.5)
end
% plot circles
for i=z_vals
plot3(ax,x,y,i*ones(1,n+1),’k’,’LineWidth’,.5)
end
end Hi. I’m creating apps on app designer which use components such as sliders to control a plot. When plotting on a UIAxes, there is significant delay. However, when having the app plot on a separate figure, there is no delay. Does anyone know the reason for this and if there’s a way to plot on the UIAxes without the delay? Thanks.
I’m going to use an app modelling a cylinder removing a lot of the additional unnecessary stuff, so the type of problem is as clear as possible. The plot consists of surf, patch, and plot3. For all apps, the goal is not plotting data per say, but rather creating shapes, often in 3 dimensions. Therefore, the data is generally arrays of type double which don’t generally get over 100 elements.
I’m using MATLAB R2020a.
These are the two methods:
I drag and drop a UIAxes on to the app and plot on that axis. This takes about 3 seconds to update the plot each time I move the slider. This is a screenshot of the setup:
I create a separate regular figure (not uifigure) and plot it on that. This has almost no delay:
This is the code used to create the separate figure and have them aligned neatly (I don’t think it’s that important but it clarifies what I’m doing):
global ax %needed so it can be accessed through component callbacks
divide=.2;%the fraction of the screen filled by the app
set(0,’units’,’pixels’)
pixels=get(0,’screensize’);
app.UIFigure.Position=[0,0,divide*pixels(3),pixels(4)];
fig=figure; %new figure
fig.Position=[divide*pixels(3),0,(1-divide)*pixels(3),pixels(4)];
ax=axes(fig); %axis it will be plotted on
Here is the code which I used (I removed much of the code used in the original app to simplify things) (the code is based off of Clay M. Thompson’s cylinder function, and I kept the copyright text in the code):
function torsion(ax,ax2,M,G,L,r,display_in)
% Clay M. Thompson 4-24-91, CBM 8-21-92.
% Copyright 1984-2002 The MathWorks, Inc.
cla(ax)
% engineering equations:
J=1/4*r^4;
phi=M*L/(J*G);
% set up cylinder:
n = 50;
r = [r r]’;
r = r(:); % Make sure r is a vector.
m = length(r); if m==1, r = [r;r]; m = 2; end
theta = (0:n)/n*2*pi;
sintheta = sin(theta); sintheta(n+1) = 0;
x = r * cos(theta);
y = r * sintheta;
z = (0:m-1)’/(m-1) *L* ones(1,n+1);
hold(ax,’on’)
% plot cylinder
surf(ax,x,y,z,’EdgeColor’,’none’,’FaceAlpha’,1)
patch(ax,x(1,:),y(1,:),z(1,:),[.25 0 .7])
patch(ax,x(1,:),y(1,:),z(2,:),[.25 0 .7])
%plot helices
z_vals=linspace(0,L,n*L/(2*pi*r(1)));
for i=0:n-1
angle0=i*(2*pi)/n;
anglef=angle0+phi;
theta_part=linspace(angle0,anglef,length(z_vals));
x_part=(r*1.01)*cos(theta_part);
y_part=(r*1.01)*sin(theta_part);
z_vals=linspace(0,L,length(x_part));
plot3(ax,x_part,y_part,z_vals,’k’,’LineWidth’,.5)
end
% plot circles
for i=z_vals
plot3(ax,x,y,i*ones(1,n+1),’k’,’LineWidth’,.5)
end
end app designer, plot, axes, delay MATLAB Answers — New Questions
Known Issue: Some management settings become permanent on Android 14
Google recently identified two issues in Android 14 that make some management policies permanent on non-Samsung devices. When a device is upgraded from Android 13 to Android 14, certain settings are made permanent on the device. Additionally, when devices that have been upgraded to Android 14 are rebooted, other settings are made permanent on the device.
For example, let’s say you are managing a device with a personally-owned work profile running Android 13, with the settings Block camera and Block apps from unknown sources enabled in the management profile. When that device updates to Android 14, the camera will become permanently blocked, even if you later disable the Block camera setting in Intune. After the update to Android 14, when the device reboots, apps from unknown sources will also become permanently blocked, even if you later disable Block apps from unknown sources in Intune.
Due to the severity of the issue, we do not recommend updating non-Samsung devices to Android 14 at this time. On Android Enterprise devices, you can use Intune device restrictions policies to postpone system updates. For more details, see Managing system updates on Microsoft Intune managed Android Enterprise corporate devices.
Issue 1: A device that has been upgraded to Android 14 is rebooted
When devices that have been upgraded to Android 14 are rebooted, certain settings are made permanent on the device. Devices that shipped with Android 14 will not be affected.
This issue currently affects devices enrolled with personally-owned work profiles.
Settings affected
Personally-owned work profile
Threat scan on apps
Block apps from unknown sources
Fully managed, Dedicated and Corporate-owned work profile
Google recently released a fix for this issue on fully managed, dedicated, and corporate-owned fully managed devices. Prior to this, some settings could also have become permanent on devices after rebooting. We’ll update this post with the list of affected settings soon.
Issue 2: A device is upgraded from Android 13 to Android 14
When a device is upgraded from Android 13 to Android 14, certain settings are made permanent on the device.
The following enrollment types are affected by this issue:
Fully managed
Dedicated
Corporate-owned work profile
Personally-owned work profile
Settings affected
Fully managed, Dedicated and Corporate-owned work profile
Date and Time changes
Roaming data services
Wi-Fi access point configuration
Bluetooth configuration
Tethering and access to hotspots
USB file transfer
External media
Beam data using NFC
Developer settings
Microphone adjustment
Volume changes
Factory reset
USB storage
System error warnings
Copy and paste between work and personal profiles
Add new users
Users can configure credentials
User removal
Account changes
Allow users to enable app installation from unknown sources in the personal profile
Personally-owned work profile
Camera (set to ‘Block’)
VPN (set to ‘Enabled’)
Copy and paste between work and personal profile
Prevent app installations from unknown sources in the personal profile
Add or remove accounts (set to ‘Block all account types’)
One lock for device and work profile
Next steps
Currently, the only way to clear settings that have become permanent is:
(Personally-owned work profile) Remove the work profile from the device.
Note: If configured, the settings Threat scan on apps and Block apps from unknown sources cannot be cleared by removing the work profile.
(All enrollment types) Factory reset the device.
Google is currently sharing patches with other device OEMs for these issues, which OEMs will integrate into their OS update images going forward. Device OEMs will determine if, and how, their devices will receive these fixes. When released, these OEM patches will prevent these issues in the future, but if a device has already upgraded to Android 14 and experienced the issue, any settings that have been made permanent will remain on the device.
We’ll continue to provide updates on this post as they’re available. If you have any questions leave a comment below or reach out to us on X @IntuneSuppTeam.
Microsoft Tech Community – Latest Blogs –Read More
Known Issue: Some management settings become permanent on Android 14
Google recently identified two issues in Android 14 that make some management policies permanent on non-Samsung devices. When a device is upgraded from Android 13 to Android 14, certain settings are made permanent on the device. Additionally, when devices that have been upgraded to Android 14 are rebooted, other settings are made permanent on the device.
For example, let’s say you are managing a device with a personally-owned work profile running Android 13, with the settings Block camera and Block apps from unknown sources enabled in the management profile. When that device updates to Android 14, the camera will become permanently blocked, even if you later disable the Block camera setting in Intune. After the update to Android 14, when the device reboots, apps from unknown sources will also become permanently blocked, even if you later disable Block apps from unknown sources in Intune.
Due to the severity of the issue, we do not recommend updating non-Samsung devices to Android 14 at this time. On Android Enterprise devices, you can use Intune device restrictions policies to postpone system updates. For more details, see Managing system updates on Microsoft Intune managed Android Enterprise corporate devices.
Issue 1: A device that has been upgraded to Android 14 is rebooted
When devices that have been upgraded to Android 14 are rebooted, certain settings are made permanent on the device. Devices that shipped with Android 14 will not be affected.
This issue currently affects devices enrolled with personally-owned work profiles.
Settings affected
Personally-owned work profile
Threat scan on apps
Block apps from unknown sources
Fully managed, Dedicated and Corporate-owned work profile
Google recently released a fix for this issue on fully managed, dedicated, and corporate-owned fully managed devices. Prior to this, some settings could also have become permanent on devices after rebooting. We’ll update this post with the list of affected settings soon.
Issue 2: A device is upgraded from Android 13 to Android 14
When a device is upgraded from Android 13 to Android 14, certain settings are made permanent on the device.
The following enrollment types are affected by this issue:
Fully managed
Dedicated
Corporate-owned work profile
Personally-owned work profile
Settings affected
Fully managed, Dedicated and Corporate-owned work profile
Date and Time changes
Roaming data services
Wi-Fi access point configuration
Bluetooth configuration
Tethering and access to hotspots
USB file transfer
External media
Beam data using NFC
Developer settings
Microphone adjustment
Volume changes
Factory reset
USB storage
System error warnings
Copy and paste between work and personal profiles
Add new users
Users can configure credentials
User removal
Account changes
Allow users to enable app installation from unknown sources in the personal profile
Personally-owned work profile
Camera (set to ‘Block’)
VPN (set to ‘Enabled’)
Copy and paste between work and personal profile
Prevent app installations from unknown sources in the personal profile
Add or remove accounts (set to ‘Block all account types’)
One lock for device and work profile
Next steps
Currently, the only way to clear settings that have become permanent is:
(Personally-owned work profile) Remove the work profile from the device.
Note: If configured, the settings Threat scan on apps and Block apps from unknown sources cannot be cleared by removing the work profile.
(All enrollment types) Factory reset the device.
Google is currently sharing patches with other device OEMs for these issues, which OEMs will integrate into their OS update images going forward. Device OEMs will determine if, and how, their devices will receive these fixes. When released, these OEM patches will prevent these issues in the future, but if a device has already upgraded to Android 14 and experienced the issue, any settings that have been made permanent will remain on the device.
We’ll continue to provide updates on this post as they’re available. If you have any questions leave a comment below or reach out to us on X @IntuneSuppTeam.
Microsoft Tech Community – Latest Blogs –Read More
DIVIDING A SIGNAL INTO SHORTER SEGMENTS AND SAVING THEM
Hello, I have a signal of 30 minutes duration. It is a csv file. I want to divide it into non overlapping segments of 10 sec duration and save them as different recordings. The sampling frequency of the signal is 360 Hz. How can I achieve this in matlab?Hello, I have a signal of 30 minutes duration. It is a csv file. I want to divide it into non overlapping segments of 10 sec duration and save them as different recordings. The sampling frequency of the signal is 360 Hz. How can I achieve this in matlab? Hello, I have a signal of 30 minutes duration. It is a csv file. I want to divide it into non overlapping segments of 10 sec duration and save them as different recordings. The sampling frequency of the signal is 360 Hz. How can I achieve this in matlab? signal manipulation, signal processing, segmentation MATLAB Answers — New Questions
Known Issue: Some management settings become permanent on Android 14
Google recently identified two issues in Android 14 that make some management policies permanent on non-Samsung devices. When a device is upgraded from Android 13 to Android 14, certain settings are made permanent on the device. Additionally, when devices that have been upgraded to Android 14 are rebooted, other settings are made permanent on the device.
For example, let’s say you are managing a device with a personally-owned work profile running Android 13, with the settings Block camera and Block apps from unknown sources enabled in the management profile. When that device updates to Android 14, the camera will become permanently blocked, even if you later disable the Block camera setting in Intune. After the update to Android 14, when the device reboots, apps from unknown sources will also become permanently blocked, even if you later disable Block apps from unknown sources in Intune.
Due to the severity of the issue, we do not recommend updating non-Samsung devices to Android 14 at this time. On Android Enterprise devices, you can use Intune device restrictions policies to postpone system updates. For more details, see Managing system updates on Microsoft Intune managed Android Enterprise corporate devices.
Issue 1: A device that has been upgraded to Android 14 is rebooted
When devices that have been upgraded to Android 14 are rebooted, certain settings are made permanent on the device. Devices that shipped with Android 14 will not be affected.
This issue currently affects devices enrolled with personally-owned work profiles.
Settings affected
Personally-owned work profile
Threat scan on apps
Block apps from unknown sources
Fully managed, Dedicated and Corporate-owned work profile
Google recently released a fix for this issue on fully managed, dedicated, and corporate-owned fully managed devices. Prior to this, some settings could also have become permanent on devices after rebooting. We’ll update this post with the list of affected settings soon.
Issue 2: A device is upgraded from Android 13 to Android 14
When a device is upgraded from Android 13 to Android 14, certain settings are made permanent on the device.
The following enrollment types are affected by this issue:
Fully managed
Dedicated
Corporate-owned work profile
Personally-owned work profile
Settings affected
Fully managed, Dedicated and Corporate-owned work profile
Date and Time changes
Roaming data services
Wi-Fi access point configuration
Bluetooth configuration
Tethering and access to hotspots
USB file transfer
External media
Beam data using NFC
Developer settings
Microphone adjustment
Volume changes
Factory reset
USB storage
System error warnings
Copy and paste between work and personal profiles
Add new users
Users can configure credentials
User removal
Account changes
Allow users to enable app installation from unknown sources in the personal profile
Personally-owned work profile
Camera (set to ‘Block’)
VPN (set to ‘Enabled’)
Copy and paste between work and personal profile
Prevent app installations from unknown sources in the personal profile
Add or remove accounts (set to ‘Block all account types’)
One lock for device and work profile
Next steps
Currently, the only way to clear settings that have become permanent is:
(Personally-owned work profile) Remove the work profile from the device.
Note: If configured, the settings Threat scan on apps and Block apps from unknown sources cannot be cleared by removing the work profile.
(All enrollment types) Factory reset the device.
Google is currently sharing patches with other device OEMs for these issues, which OEMs will integrate into their OS update images going forward. Device OEMs will determine if, and how, their devices will receive these fixes. When released, these OEM patches will prevent these issues in the future, but if a device has already upgraded to Android 14 and experienced the issue, any settings that have been made permanent will remain on the device.
We’ll continue to provide updates on this post as they’re available. If you have any questions leave a comment below or reach out to us on X @IntuneSuppTeam.
Microsoft Tech Community – Latest Blogs –Read More
Issues connecting MATLAB to Turtlebot4
I am trying to connect MATLAB R2023b on Ubuntu 22.04 to my Turtlebot4 using:
rosinit("http://192.168.1.3:11311");
I have checked my ROS_MASTER_URI on both my PC and the RPi.
On my PC:
$ echo $ROS_MASTER_URI
http://localhost:11311
On my RPi:
$ echo $ROS_MASTER_URI
http://192.168.1.3:11311
When I tried to do rosinit, MATLAB outputs the error:
Cannot connect to ROS master at http://192.168.1.3:11311. Check the specified address or hostname.
Am I missing something here? Any help would be greatly appreciated!I am trying to connect MATLAB R2023b on Ubuntu 22.04 to my Turtlebot4 using:
rosinit("http://192.168.1.3:11311");
I have checked my ROS_MASTER_URI on both my PC and the RPi.
On my PC:
$ echo $ROS_MASTER_URI
http://localhost:11311
On my RPi:
$ echo $ROS_MASTER_URI
http://192.168.1.3:11311
When I tried to do rosinit, MATLAB outputs the error:
Cannot connect to ROS master at http://192.168.1.3:11311. Check the specified address or hostname.
Am I missing something here? Any help would be greatly appreciated! I am trying to connect MATLAB R2023b on Ubuntu 22.04 to my Turtlebot4 using:
rosinit("http://192.168.1.3:11311");
I have checked my ROS_MASTER_URI on both my PC and the RPi.
On my PC:
$ echo $ROS_MASTER_URI
http://localhost:11311
On my RPi:
$ echo $ROS_MASTER_URI
http://192.168.1.3:11311
When I tried to do rosinit, MATLAB outputs the error:
Cannot connect to ROS master at http://192.168.1.3:11311. Check the specified address or hostname.
Am I missing something here? Any help would be greatly appreciated! matlab, ros2, turtlebot4 MATLAB Answers — New Questions
Known Issue: Some management settings become permanent on Android 14
Google recently identified two issues in Android 14 that make some management policies permanent on non-Samsung devices. When a device is upgraded from Android 13 to Android 14, certain settings are made permanent on the device. Additionally, when devices that have been upgraded to Android 14 are rebooted, other settings are made permanent on the device.
For example, let’s say you are managing a device with a personally-owned work profile running Android 13, with the settings Block camera and Block apps from unknown sources enabled in the management profile. When that device updates to Android 14, the camera will become permanently blocked, even if you later disable the Block camera setting in Intune. After the update to Android 14, when the device reboots, apps from unknown sources will also become permanently blocked, even if you later disable Block apps from unknown sources in Intune.
Due to the severity of the issue, we do not recommend updating non-Samsung devices to Android 14 at this time. On Android Enterprise devices, you can use Intune device restrictions policies to postpone system updates. For more details, see Managing system updates on Microsoft Intune managed Android Enterprise corporate devices.
Issue 1: A device that has been upgraded to Android 14 is rebooted
When devices that have been upgraded to Android 14 are rebooted, certain settings are made permanent on the device. Devices that shipped with Android 14 will not be affected.
This issue currently affects devices enrolled with personally-owned work profiles.
Settings affected
Personally-owned work profile
Threat scan on apps
Block apps from unknown sources
Fully managed, Dedicated and Corporate-owned work profile
Google recently released a fix for this issue on fully managed, dedicated, and corporate-owned fully managed devices. Prior to this, some settings could also have become permanent on devices after rebooting. We’ll update this post with the list of affected settings soon.
Issue 2: A device is upgraded from Android 13 to Android 14
When a device is upgraded from Android 13 to Android 14, certain settings are made permanent on the device.
The following enrollment types are affected by this issue:
Fully managed
Dedicated
Corporate-owned work profile
Personally-owned work profile
Settings affected
Fully managed, Dedicated and Corporate-owned work profile
Date and Time changes
Roaming data services
Wi-Fi access point configuration
Bluetooth configuration
Tethering and access to hotspots
USB file transfer
External media
Beam data using NFC
Developer settings
Microphone adjustment
Volume changes
Factory reset
USB storage
System error warnings
Copy and paste between work and personal profiles
Add new users
Users can configure credentials
User removal
Account changes
Allow users to enable app installation from unknown sources in the personal profile
Personally-owned work profile
Camera (set to ‘Block’)
VPN (set to ‘Enabled’)
Copy and paste between work and personal profile
Prevent app installations from unknown sources in the personal profile
Add or remove accounts (set to ‘Block all account types’)
One lock for device and work profile
Next steps
Currently, the only way to clear settings that have become permanent is:
(Personally-owned work profile) Remove the work profile from the device.
Note: If configured, the settings Threat scan on apps and Block apps from unknown sources cannot be cleared by removing the work profile.
(All enrollment types) Factory reset the device.
Google is currently sharing patches with other device OEMs for these issues, which OEMs will integrate into their OS update images going forward. Device OEMs will determine if, and how, their devices will receive these fixes. When released, these OEM patches will prevent these issues in the future, but if a device has already upgraded to Android 14 and experienced the issue, any settings that have been made permanent will remain on the device.
We’ll continue to provide updates on this post as they’re available. If you have any questions leave a comment below or reach out to us on X @IntuneSuppTeam.
Microsoft Tech Community – Latest Blogs –Read More
How getting Atlas image from fMRI images.
Hello everyone,
I am currently working on medical images resting state fMRI from Dhcp( Developing Human Connectome Project) datasets and i need to get their Atlas images using fMRI. But whenever I am trying i could not implement or find a code MATLAB to do it, this is really a new thing for me i never work on it. Please Can anyone suugest me what can i do or from where can i start ? I really need help. Thanks in advance!Hello everyone,
I am currently working on medical images resting state fMRI from Dhcp( Developing Human Connectome Project) datasets and i need to get their Atlas images using fMRI. But whenever I am trying i could not implement or find a code MATLAB to do it, this is really a new thing for me i never work on it. Please Can anyone suugest me what can i do or from where can i start ? I really need help. Thanks in advance! Hello everyone,
I am currently working on medical images resting state fMRI from Dhcp( Developing Human Connectome Project) datasets and i need to get their Atlas images using fMRI. But whenever I am trying i could not implement or find a code MATLAB to do it, this is really a new thing for me i never work on it. Please Can anyone suugest me what can i do or from where can i start ? I really need help. Thanks in advance! atlas images, fmri MATLAB Answers — New Questions
Known Issue: Some management settings become permanent on Android 14
Google recently identified two issues in Android 14 that make some management policies permanent on non-Samsung devices. When a device is upgraded from Android 13 to Android 14, certain settings are made permanent on the device. Additionally, when devices that have been upgraded to Android 14 are rebooted, other settings are made permanent on the device.
For example, let’s say you are managing a device with a personally-owned work profile running Android 13, with the settings Block camera and Block apps from unknown sources enabled in the management profile. When that device updates to Android 14, the camera will become permanently blocked, even if you later disable the Block camera setting in Intune. After the update to Android 14, when the device reboots, apps from unknown sources will also become permanently blocked, even if you later disable Block apps from unknown sources in Intune.
Due to the severity of the issue, we do not recommend updating non-Samsung devices to Android 14 at this time. On Android Enterprise devices, you can use Intune device restrictions policies to postpone system updates. For more details, see Managing system updates on Microsoft Intune managed Android Enterprise corporate devices.
Issue 1: A device that has been upgraded to Android 14 is rebooted
When devices that have been upgraded to Android 14 are rebooted, certain settings are made permanent on the device. Devices that shipped with Android 14 will not be affected.
This issue currently affects devices enrolled with personally-owned work profiles.
Settings affected
Personally-owned work profile
Threat scan on apps
Block apps from unknown sources
Fully managed, Dedicated and Corporate-owned work profile
Google recently released a fix for this issue on fully managed, dedicated, and corporate-owned fully managed devices. Prior to this, some settings could also have become permanent on devices after rebooting. We’ll update this post with the list of affected settings soon.
Issue 2: A device is upgraded from Android 13 to Android 14
When a device is upgraded from Android 13 to Android 14, certain settings are made permanent on the device.
The following enrollment types are affected by this issue:
Fully managed
Dedicated
Corporate-owned work profile
Personally-owned work profile
Settings affected
Fully managed, Dedicated and Corporate-owned work profile
Date and Time changes
Roaming data services
Wi-Fi access point configuration
Bluetooth configuration
Tethering and access to hotspots
USB file transfer
External media
Beam data using NFC
Developer settings
Microphone adjustment
Volume changes
Factory reset
USB storage
System error warnings
Copy and paste between work and personal profiles
Add new users
Users can configure credentials
User removal
Account changes
Allow users to enable app installation from unknown sources in the personal profile
Personally-owned work profile
Camera (set to ‘Block’)
VPN (set to ‘Enabled’)
Copy and paste between work and personal profile
Prevent app installations from unknown sources in the personal profile
Add or remove accounts (set to ‘Block all account types’)
One lock for device and work profile
Next steps
Currently, the only way to clear settings that have become permanent is:
(Personally-owned work profile) Remove the work profile from the device.
Note: If configured, the settings Threat scan on apps and Block apps from unknown sources cannot be cleared by removing the work profile.
(All enrollment types) Factory reset the device.
Google is currently sharing patches with other device OEMs for these issues, which OEMs will integrate into their OS update images going forward. Device OEMs will determine if, and how, their devices will receive these fixes. When released, these OEM patches will prevent these issues in the future, but if a device has already upgraded to Android 14 and experienced the issue, any settings that have been made permanent will remain on the device.
We’ll continue to provide updates on this post as they’re available. If you have any questions leave a comment below or reach out to us on X @IntuneSuppTeam.
Microsoft Tech Community – Latest Blogs –Read More
