HOW DO I GET THE STOCK PRICE FOR MICROSOFT MSFT 5 YEARS AGO AT OPEN IN ONE CELL ONLY WITHOUT THE OBNOXIOUS ARRAY THATS A WASTE OF SPACE. ALL I CARE FOR IS OPEN OR CLOSE. ITS RIDICULOUS TO ME THAT ONE OF THE LARGEST STOCK MARKET CAPS ON EARTH ISNT USER FRIENDLY WHEN IT COMES TO SUCH A SIMPLE ASSIGNMENT. ITS STUPID. IM STUPID. WTF. 

​HOW DO I GET THE STOCK PRICE FOR MICROSOFT MSFT 5 YEARS AGO AT OPEN IN ONE CELL ONLY WITHOUT THE OBNOXIOUS ARRAY THATS A WASTE OF SPACE. ALL I CARE FOR IS OPEN OR CLOSE. ITS RIDICULOUS TO ME THAT ONE OF THE LARGEST STOCK MARKET CAPS ON EARTH ISNT USER FRIENDLY WHEN IT COMES TO SUCH A SIMPLE ASSIGNMENT. ITS STUPID. IM STUPID. WTF.   Read More

​

The old outlook would keep the folder label on email chain if someone replied to it and the new email was in your inbox. The new outlook only shows you the folder label when you search for an email. Is there away to get Outlook to show the folder label for emails that have been replied to? For example, someone emails be to pay an invoice. I pay the invoice, reply back that it is paid, and then move the email to my “Paid” folder. That person then replies to the email saying thank you. The new email is in my inbox but there is no folder label on it any more to show that the email chain had been filed already in the “Paid” folder. I have to look through the email chain, see that it has been paid, and then move it again to the “Paid” folder. 

When I search for an email, the folder label is there. I want the label to stay with an email chain even when there is a new email added and it is pulled into my inbox so I don’t have to figure out again which folder that email chain should be filed in. 

​The old outlook would keep the folder label on email chain if someone replied to it and the new email was in your inbox. The new outlook only shows you the folder label when you search for an email. Is there away to get Outlook to show the folder label for emails that have been replied to? For example, someone emails be to pay an invoice. I pay the invoice, reply back that it is paid, and then move the email to my “Paid” folder. That person then replies to the email saying thank you. The new email is in my inbox but there is no folder label on it any more to show that the email chain had been filed already in the “Paid” folder. I have to look through the email chain, see that it has been paid, and then move it again to the “Paid” folder.  When I search for an email, the folder label is there. I want the label to stay with an email chain even when there is a new email added and it is pulled into my inbox so I don’t have to figure out again which folder that email chain should be filed in.     Read More

​

So, I’ve been trying to troubleshoot an issue for a new Teams Phone deployment – where Teams phone ties into an on-prem exchange server via an MS365 Connector (which delivers the voicemails to their Email Security gateway, and then to the on-prem Exchange Server).

The issue was that transcripts for calls (and voicemails in general) weren’t showing up in the Voicemail tab for call history and voicemail notifications weren’t being received on their Yealink phones.

After diving into it I found that the content type of the Voicemail messages, at least on the Security Gateway side, was CA-Voice, and there had been some chatter online of the required Content-Type being something else. 

I then tested with my work Teams account – since I noticed that I wasn’t actually seeing voicemail transcripts since August 1st, and it looks like the same issue is occuring. Office and Teams are up to date and the issue occurs on both Desktop and web-based Office.

I’m thinking that this is just a case of Microsoft breaking something in an update but if anyone has any further insight, I’d appreciate that.

– JB

​So, I’ve been trying to troubleshoot an issue for a new Teams Phone deployment – where Teams phone ties into an on-prem exchange server via an MS365 Connector (which delivers the voicemails to their Email Security gateway, and then to the on-prem Exchange Server). The issue was that transcripts for calls (and voicemails in general) weren’t showing up in the Voicemail tab for call history and voicemail notifications weren’t being received on their Yealink phones. After diving into it I found that the content type of the Voicemail messages, at least on the Security Gateway side, was CA-Voice, and there had been some chatter online of the required Content-Type being something else.  I then tested with my work Teams account – since I noticed that I wasn’t actually seeing voicemail transcripts since August 1st, and it looks like the same issue is occuring. Office and Teams are up to date and the issue occurs on both Desktop and web-based Office. I’m thinking that this is just a case of Microsoft breaking something in an update but if anyone has any further insight, I’d appreciate that. – JB  Read More

​

I have a web app that imports a ms project .xml. Users of the web app can then change the following properties: Notes, Physical Percent Complete and Finish Date. The project .xml can then be exported with only the mentioned altered. When the updated xml is imported back into ms Project the 3 properties: Percentage Complete, Notes and Finish Date update fine, however the duration remains the same and thus the start date alters to accommodate. How can I lock the start date during the import and force the duration to dynamically change? Because I am altering only the Finish Date and nothing else time related, I was surprised that the import didn’t error in the first place (since there would be conflicts in my xml). I need to learn how importing an xml works, what are the limits.. how to change certain properties whilst maintaining others and letting ms Project do it magic where necessary. 

​I have a web app that imports a ms project .xml. Users of the web app can then change the following properties: Notes, Physical Percent Complete and Finish Date. The project .xml can then be exported with only the mentioned altered. When the updated xml is imported back into ms Project the 3 properties: Percentage Complete, Notes and Finish Date update fine, however the duration remains the same and thus the start date alters to accommodate. How can I lock the start date during the import and force the duration to dynamically change? Because I am altering only the Finish Date and nothing else time related, I was surprised that the import didn’t error in the first place (since there would be conflicts in my xml). I need to learn how importing an xml works, what are the limits.. how to change certain properties whilst maintaining others and letting ms Project do it magic where necessary.   Read More

​

I have a custom Intune role for our support staff. I want them to be able to run the Feature Update Device Readiness report. When they click on the Select target OS link, it shows “No data to display”, instead of the OS list. They are able to click on Select scope tag and see a list of scope tags.

Is there a permission they need that I’m missing? Here is what I have assigned for the custom role.

Audit dataReadCorporate device identifiers

Create

Delete

Read

Update

Device compliance policies

Read

View Reports

Device Configurations

Read

View Reports

Endpoint AnalyticsReadEndpoint protection reportsReadEnrollment programs

Create device

Delete device

Read device

Sync device

Assign Profile

Read Profile

Managed appsReadManaged devices

Delete

Read

Set Primary user

Update

View reports

Organizations

Read

Remote tasks

Clean PC

Collect diagnostics

Enable Windows IntuneAgent

Get Filevault key

Manage shared device users

Reboot now

Reset passcode

Retire

Set device name

Sync devices

Wipe

RolesRead

​I have a custom Intune role for our support staff. I want them to be able to run the Feature Update Device Readiness report. When they click on the Select target OS link, it shows “No data to display”, instead of the OS list. They are able to click on Select scope tag and see a list of scope tags.  Is there a permission they need that I’m missing? Here is what I have assigned for the custom role.Audit dataReadCorporate device identifiersCreateDeleteReadUpdateDevice compliance policiesReadView ReportsDevice ConfigurationsReadView ReportsEndpoint AnalyticsReadEndpoint protection reportsReadEnrollment programsCreate deviceDelete deviceRead deviceSync deviceAssign ProfileRead ProfileManaged appsReadManaged devicesDeleteReadSet Primary userUpdateView reportsOrganizationsReadRemote tasksClean PCCollect diagnosticsEnable Windows IntuneAgentGet Filevault keyManage shared device usersReboot nowReset passcodeRetireSet device nameSync devicesWipeRolesRead  Read More

​

Designed for business leaders, IT pros, and end users – this eBook covers insights on how to become an AI-powered organization by fully leveraging the capabilities of Copilot for Microsoft 365. Learn the art and science of prompting – along with a library of 300+ prompts.

Featured in this Ultimate Skilling Guide:

Introduction: Your AI Assistant for WorkEmbracing the Era of AI: The Generative AI RevolutionThe Business Imperative: Becoming an AI-powered OrganizationUnlocking AI Value with Copilot: Empowering every department & job roleA High-Level Overview: How does Copilot for Microsoft 365 workUtilizing the power of AI: The Art & Science of PromptingPrompting Best Practices & TipsThe secret to Copilot adoption: Building new work habitsRealize the value of CopilotCopilot Prompts Library:
– Copilot for Microsoft 365
– Copilot in Teams
– Copilot in Outlook
– Copilot in Word
– Copilot in Excel
– Copilot in PowerPoint
– Copilot in OneNote
– Copilot in SharePoint
– Copilot in OneDrive
– Copilot in Loop
– Copilot in Stream
– Copilot in Forms
– Copilot in Planner
– Copilot in Viva Engage
– Copilot in WhiteboardCopilot for Microsoft 365 Training Catalog

​Designed for business leaders, IT pros, and end users – this eBook covers insights on how to become an AI-powered organization by fully leveraging the capabilities of Copilot for Microsoft 365. Learn the art and science of prompting – along with a library of 300+ prompts.Featured in this Ultimate Skilling Guide: Introduction: Your AI Assistant for WorkEmbracing the Era of AI: The Generative AI RevolutionThe Business Imperative: Becoming an AI-powered OrganizationUnlocking AI Value with Copilot: Empowering every department & job roleA High-Level Overview: How does Copilot for Microsoft 365 workUtilizing the power of AI: The Art & Science of PromptingPrompting Best Practices & TipsThe secret to Copilot adoption: Building new work habitsRealize the value of CopilotCopilot Prompts Library:- Copilot for Microsoft 365- Copilot in Teams- Copilot in Outlook- Copilot in Word- Copilot in Excel- Copilot in PowerPoint- Copilot in OneNote- Copilot in SharePoint- Copilot in OneDrive- Copilot in Loop- Copilot in Stream- Copilot in Forms- Copilot in Planner- Copilot in Viva Engage- Copilot in WhiteboardCopilot for Microsoft 365 Training Catalog  Read More

​

If you’ve ever watched a video and thought, “I want to make something like that,” you’re already halfway there! Becoming a professional video editor isn’t just about learning software; it’s about turning your creativity and passion into something real. First, dive into the basics. Learn tools like Adobe Premiere Pro or Final Cut Pro. At first, it might feel overwhelming, but trust me, with practice, it clicks. Next, edit everything you can! The more you practice, the better you’ll get. Start with small projects, build a portfolio, and watch your skills grow. Finally, don’t forget to put yourself out there. Network, share your work, and say yes to opportunities. It can be nerve-wracking at first, but every project will build your confidence and get you closer to your dream career!

​If you’ve ever watched a video and thought, “I want to make something like that,” you’re already halfway there! Becoming a professional video editor isn’t just about learning software; it’s about turning your creativity and passion into something real. First, dive into the basics. Learn tools like Adobe Premiere Pro or Final Cut Pro. At first, it might feel overwhelming, but trust me, with practice, it clicks. Next, edit everything you can! The more you practice, the better you’ll get. Start with small projects, build a portfolio, and watch your skills grow. Finally, don’t forget to put yourself out there. Network, share your work, and say yes to opportunities. It can be nerve-wracking at first, but every project will build your confidence and get you closer to your dream career!  Read More

​

I am looking for a way to apply a template to a Sharepoint library that will create specific subfolders with predetermined user/group permissions for each subfolder.

This would be used to created seperate project libraries, each set up with identical sub-folders and permissions per sub folder.

What is the best method to create this?

​I am looking for a way to apply a template to a Sharepoint library that will create specific subfolders with predetermined user/group permissions for each subfolder. This would be used to created seperate project libraries, each set up with identical sub-folders and permissions per sub folder. What is the best method to create this?  Read More

​

In today’s fast-paced digital world, the sheer volume of emails and messages can overwhelm even the most organized professional – the typical Microsoft 365 power user receives, on average, upwards of 250 emails daily and juggles 150 chats daily. Many of us are no strangers to the overwhelm that comes with the digital hustle. But imagine if you alone didn’t have to bear the weight of these increasing workloads.

AI has proven to be a game-changer in productivity, augmenting human capability and accelerating everyone’s innate ingenuity. It doesn’t just make it easier to check off items on our to-do lists – it unlocks our creative potential, helping us overcome the drudgery of work to rediscover the joy in work. But like any new tool, it takes practice to master.

Copilot for Microsoft 365 is your AI assistant for work that supercharges productivity and creativity, re-engineers business processes, empowering you to securely transform into an AI-powered organization. Integrated into the apps millions use every day, it combines the power of the most advanced LLM’s with your data in the Microsoft Graph—your documents, presentations, email, files, meetings, chats, and more, plus the web to deliver accurate, relevant, and contextual responses all with natural language. Copilot also inherits your existing Microsoft 365 security, privacy, identity, and compliance policies—so you know it’s enterprise-grade.

Copilot has the potential to redefine the boundaries of what an organization can get done. Yet there is an art and science to successful adoption across an organization. To reap the benefits, you must first understand the process of integrating generative AI capabilities into your business operations and investing in the strategies, skills, and techniques needed to unlock the full value of Copilot.

Embracing the Era of AI: The Generative AI Revolution

Generative AI is a type of artificial intelligence that is trained on enormous amounts of data, enabling it to generate novel content, such as text, images, music, and code, in response to natural language requests.

Businesses can use generative AI to improve almost any process where people use or create information. This technology has the potential to transform business with the goal of automating routine tasks, spurring creativity, and empowering people to focus on high-value work. Scaling the personalization of customer interactions helps employees drive satisfaction and loyalty. It also reveals patterns in vast amounts of data to inform better decision-making.

Businesses and professionals around the world are embracing and leveraging GenAI-powered solutions at an exponential speed. For reference – ChatGPT reached a 100 million user base in just 3 months, an unprecedented milestone in the pace of adoption for any technological revolution.

The Business Imperative: Becoming an AI-powered Organization

Copilot represents a new way of delivering business value, employee engagement, and creativity in your organization. To get the most from these transformational AI capabilities, an investment must be made in the human side of change. Supporting your users in understanding these powerful tools will enable you to get the most from your investment and drive the positive transformation that AI capabilities can deliver.

The secret to Copilot adoption: Building new work habits through skilling

It’s not enough to activate Copilot – your people need guidance on how to build new skills.

Copilot isn’t designed to replace human capabilities – it’s designed to enhance them. Copilot for Microsoft 365 is an AI-powered assistant that’s built to enhance your experience with Microsoft 365 applications, including Word, Excel, PowerPoint, Outlook, and Teams. People engage with Copilot just like they would any other virtual assistant, using their native language to ask questions and make requests.

The difference is Copilot knows how to access and manage your content and data spread across Microsoft 365. Copilot for Microsoft 365 knows how to access information from your inbox. It can make some highly informed recommendations based on email threads and chats. It can quickly generate content based on information and ideas you share. It can perform complex or repetitive tasks with simple commands, among many other use cases. But Copilot isn’t a person. Your work output still requires professional judgment that only you can provide. To realize the full potential of generative AI, it’s important that your people understand how to use this technology to augment their own capabilities.

Realize the value of Copilot and unlock ROI

Build Copilot Product Knowledge & Scope of Usage

To use Copilot for Microsoft 365 effectively, team members must grasp the scope of usage of the solution, its capabilities as well as the origins, integrity, and bounds of the data it leverages to draw insights and suggestions. Copilot analyzes a wealth of organizational content within an organization’s Microsoft 365 tenant, including calendars, emails, chats, documents, meetings, contacts, and more – all from within the secure Microsoft 365 compliance boundary.

Engineer Effective and Impactful Prompts

The experience of crafting a prompt is similar to having a conversation in that you’d use plain but clear language to communicate something while providing the necessary context. While the experience seems simple enough, mastering the art of prompt engineering takes practice. To get the best results, employees need to learn how to structure their prompts – a skill your organization needs to hone over time. You need to drive continuous learning and experimentation and establish best practices to ensure the accuracy and appropriateness of AI-generated content.

Empower Your Employees with the Skills and Confidence to Lead the Era of AI

When deployed correctly, Copilot can transform each team member into a leader who is equipped to handle not just mundane tasks but also complex challenges. Beyond automating repetitive processes, employees can entrust Copilot with bigger responsibilities – ranging from research and analysis to creative ideation. However, to realize the fullest potential of Copilot, you’ll need to alter how employees think about work, adopting the qualities of an adept leader that can be helpful, such as delegation, communication, and analytical thinking.

How to get started?

Experts at NetCom Learning – a leading Microsoft Training Services Partner – have put together a comprehensive learning resource – Copilot for Microsoft 365: The Ultimate Skilling Guide – for business leaders, IT pros, and end users to get started with their skilling and adoption journey with Copilot for Microsoft 365.

It also deep dives into the art and science of prompting, along with expert-recommended best practices, tips, and an extensive curated collection of 300+ Copilot prompts to accelerate end-user adoption across the entire suite of Microsoft 365 apps – including:

Copilot for Microsoft 365Copilot in TeamsCopilot in OutlookCopilot in WordCopilot in ExcelCopilot in PowerPointCopilot in OneNoteCopilot in SharePointCopilot in OneDriveCopilot in LoopCopilot in StreamCopilot in FormsCopilot in PlannerCopilot in Viva EngageCopilot in Whiteboard

Embrace the future of work with your personalized AI assistant – Copilot for Microsoft 365!

​In today’s fast-paced digital world, the sheer volume of emails and messages can overwhelm even the most organized professional – the typical Microsoft 365 power user receives, on average, upwards of 250 emails daily and juggles 150 chats daily. Many of us are no strangers to the overwhelm that comes with the digital hustle. But imagine if you alone didn’t have to bear the weight of these increasing workloads. AI has proven to be a game-changer in productivity, augmenting human capability and accelerating everyone’s innate ingenuity. It doesn’t just make it easier to check off items on our to-do lists – it unlocks our creative potential, helping us overcome the drudgery of work to rediscover the joy in work. But like any new tool, it takes practice to master. Copilot for Microsoft 365 is your AI assistant for work that supercharges productivity and creativity, re-engineers business processes, empowering you to securely transform into an AI-powered organization. Integrated into the apps millions use every day, it combines the power of the most advanced LLM’s with your data in the Microsoft Graph—your documents, presentations, email, files, meetings, chats, and more, plus the web to deliver accurate, relevant, and contextual responses all with natural language. Copilot also inherits your existing Microsoft 365 security, privacy, identity, and compliance policies—so you know it’s enterprise-grade. Copilot has the potential to redefine the boundaries of what an organization can get done. Yet there is an art and science to successful adoption across an organization. To reap the benefits, you must first understand the process of integrating generative AI capabilities into your business operations and investing in the strategies, skills, and techniques needed to unlock the full value of Copilot.  Embracing the Era of AI: The Generative AI Revolution Generative AI is a type of artificial intelligence that is trained on enormous amounts of data, enabling it to generate novel content, such as text, images, music, and code, in response to natural language requests. Businesses can use generative AI to improve almost any process where people use or create information. This technology has the potential to transform business with the goal of automating routine tasks, spurring creativity, and empowering people to focus on high-value work. Scaling the personalization of customer interactions helps employees drive satisfaction and loyalty. It also reveals patterns in vast amounts of data to inform better decision-making. Businesses and professionals around the world are embracing and leveraging GenAI-powered solutions at an exponential speed. For reference – ChatGPT reached a 100 million user base in just 3 months, an unprecedented milestone in the pace of adoption for any technological revolution.   The Business Imperative: Becoming an AI-powered Organization Copilot represents a new way of delivering business value, employee engagement, and creativity in your organization. To get the most from these transformational AI capabilities, an investment must be made in the human side of change. Supporting your users in understanding these powerful tools will enable you to get the most from your investment and drive the positive transformation that AI capabilities can deliver.  The secret to Copilot adoption: Building new work habits through skilling It’s not enough to activate Copilot – your people need guidance on how to build new skills.  Copilot isn’t designed to replace human capabilities – it’s designed to enhance them. Copilot for Microsoft 365 is an AI-powered assistant that’s built to enhance your experience with Microsoft 365 applications, including Word, Excel, PowerPoint, Outlook, and Teams. People engage with Copilot just like they would any other virtual assistant, using their native language to ask questions and make requests. The difference is Copilot knows how to access and manage your content and data spread across Microsoft 365. Copilot for Microsoft 365 knows how to access information from your inbox. It can make some highly informed recommendations based on email threads and chats. It can quickly generate content based on information and ideas you share. It can perform complex or repetitive tasks with simple commands, among many other use cases. But Copilot isn’t a person. Your work output still requires professional judgment that only you can provide. To realize the full potential of generative AI, it’s important that your people understand how to use this technology to augment their own capabilities.    Realize the value of Copilot and unlock ROI Build Copilot Product Knowledge & Scope of UsageTo use Copilot for Microsoft 365 effectively, team members must grasp the scope of usage of the solution, its capabilities as well as the origins, integrity, and bounds of the data it leverages to draw insights and suggestions. Copilot analyzes a wealth of organizational content within an organization’s Microsoft 365 tenant, including calendars, emails, chats, documents, meetings, contacts, and more – all from within the secure Microsoft 365 compliance boundary.Engineer Effective and Impactful PromptsThe experience of crafting a prompt is similar to having a conversation in that you’d use plain but clear language to communicate something while providing the necessary context. While the experience seems simple enough, mastering the art of prompt engineering takes practice. To get the best results, employees need to learn how to structure their prompts – a skill your organization needs to hone over time. You need to drive continuous learning and experimentation and establish best practices to ensure the accuracy and appropriateness of AI-generated content.Empower Your Employees with the Skills and Confidence to Lead the Era of AIWhen deployed correctly, Copilot can transform each team member into a leader who is equipped to handle not just mundane tasks but also complex challenges. Beyond automating repetitive processes, employees can entrust Copilot with bigger responsibilities – ranging from research and analysis to creative ideation. However, to realize the fullest potential of Copilot, you’ll need to alter how employees think about work, adopting the qualities of an adept leader that can be helpful, such as delegation, communication, and analytical thinking.  How to get started? Experts at NetCom Learning – a leading Microsoft Training Services Partner – have put together a comprehensive learning resource – Copilot for Microsoft 365: The Ultimate Skilling Guide – for business leaders, IT pros, and end users to get started with their skilling and adoption journey with Copilot for Microsoft 365. It also deep dives into the art and science of prompting, along with expert-recommended best practices, tips, and an extensive curated collection of 300+ Copilot prompts to accelerate end-user adoption across the entire suite of Microsoft 365 apps – including:Copilot for Microsoft 365Copilot in TeamsCopilot in OutlookCopilot in WordCopilot in ExcelCopilot in PowerPointCopilot in OneNoteCopilot in SharePointCopilot in OneDriveCopilot in LoopCopilot in StreamCopilot in FormsCopilot in PlannerCopilot in Viva EngageCopilot in WhiteboardEmbrace the future of work with your personalized AI assistant – Copilot for Microsoft 365!   Read More

​

Trying to pull the Delivery # for all the Customers in the list in Column J

This formula doesnt appear to be working in any fashion, tried a few others and i’m not making any progress.

=UNIQUE(FILTER(‘OB Summary’!B:B,’OB Summary’!L:L=”DONALDSON”))

​Trying to pull the Delivery # for all the Customers in the list in Column J This formula doesnt appear to be working in any fashion, tried a few others and i’m not making any progress.=UNIQUE(FILTER(‘OB Summary’!B:B,’OB Summary’!L:L=”DONALDSON”))  Read More

​