Category: Microsoft
Category Archives: Microsoft
Hide blank cells
I am exporting information from excel into another program. I don’t want all the info. I used to be able to select the filter in at the top of a column and choose to hide blank cells. Then the info on the rows next to the blank cells would hide. When I copied the info out, I did not have all the extra info. This no longer works for me. How do I do this?
Person’s name time spent $
2 $10
1 $5
I want:
Person’s name time spent $
I am exporting information from excel into another program. I don’t want all the info. I used to be able to select the filter in at the top of a column and choose to hide blank cells. Then the info on the rows next to the blank cells would hide. When I copied the info out, I did not have all the extra info. This no longer works for me. How do I do this? Person’s name time spent $ 2 $10 1 $5 I want:Person’s name time spent $ Read More
Matching data
Hello – I am trying to check data across just 2 Tabs to see if the dates match but the problem I am running into is the report is the same but the entries are not lining up so I am getting all True results where they might not be as I’ve tested a few entries with different dates and the result does not change. There are 2 entries that are required to match, name and floor #, and I’ve been using: If(OR(CountIF(Criteria1), (Criteria2)),IF(CountIF(Matching Criteria, True, False), Error). Any help would be appreciated, thank you
Hello – I am trying to check data across just 2 Tabs to see if the dates match but the problem I am running into is the report is the same but the entries are not lining up so I am getting all True results where they might not be as I’ve tested a few entries with different dates and the result does not change. There are 2 entries that are required to match, name and floor #, and I’ve been using: If(OR(CountIF(Criteria1), (Criteria2)),IF(CountIF(Matching Criteria, True, False), Error). Any help would be appreciated, thank you Read More
List of figures
All,
I know that a list of figures can be created by using captions. However, I do not like the caption format. Can I mark my own text to serve as a caption and thus create a list of figures?
All, I know that a list of figures can be created by using captions. However, I do not like the caption format. Can I mark my own text to serve as a caption and thus create a list of figures? Read More
Protect an Excel worksheet using VBA but allow everyone to select slicers and sort columns
How can you in VBA protect an Excel worksheet while allowing users to select slicers and sort columns but keep the headers locked?
I have to set the Contents to False in the worksheet Protect method, so the users can select the slicers. However, this does not protect my headers. If I set Contents to True in the Protect method, the headers are locked, but you cannot select any slicers.
Any help will be greatly appreciated. Thank you!
How can you in VBA protect an Excel worksheet while allowing users to select slicers and sort columns but keep the headers locked? I have to set the Contents to False in the worksheet Protect method, so the users can select the slicers. However, this does not protect my headers. If I set Contents to True in the Protect method, the headers are locked, but you cannot select any slicers.Any help will be greatly appreciated. Thank you! Read More
Communications Site – sharing content externally
We are a small charity with a small team of volunteers and members.
I would like to setup a dedicated MS 365 Communication site to share content such as newsletters with our members. Members are external to our 365 environment, but are added as contacts – a distribution list has been created using the contacts.
I’ve looked at many sites, YouTube videos etc. but struggling to make this work in a safe way. I’m assuming a dedicated SharePoint comms site would be best for security reasons, perhaps allowing specific privileges, but any help appreciated?
We are a small charity with a small team of volunteers and members. I would like to setup a dedicated MS 365 Communication site to share content such as newsletters with our members. Members are external to our 365 environment, but are added as contacts – a distribution list has been created using the contacts. I’ve looked at many sites, YouTube videos etc. but struggling to make this work in a safe way. I’m assuming a dedicated SharePoint comms site would be best for security reasons, perhaps allowing specific privileges, but any help appreciated? Read More
Sincronización outlook
He instalado la app de outllook, en un galaxy S24, android. Tengo 3 cuentas configuardas, dos son IMAP y la otra no. En las dos cuentas IMAP tengo problemas con los emails porque llegan horas después de que han sido enviados, no llegan inmediatamente. El envio de emails funciona perfectamente. La cuenta que no es IMAP funciona perfectamente en el envío y la repeción de emails, estos llegan inmediatamente. El personal de Microsoft me ha derivado a este chat porque no saben como resolver el problema. Gracias
He instalado la app de outllook, en un galaxy S24, android. Tengo 3 cuentas configuardas, dos son IMAP y la otra no. En las dos cuentas IMAP tengo problemas con los emails porque llegan horas después de que han sido enviados, no llegan inmediatamente. El envio de emails funciona perfectamente. La cuenta que no es IMAP funciona perfectamente en el envío y la repeción de emails, estos llegan inmediatamente. El personal de Microsoft me ha derivado a este chat porque no saben como resolver el problema. Gracias Read More
How can I add the department to the evaluation of a Forms survey in Excel?
Hello,
I conducted a survey using Forms and generated a corresponding dataset.
For the evaluation, I also need the respective department of the participants as additional information for sorting in Excel.
How can this criterion be integrated into the evaluation?
Thank you and best regards.
Hello,I conducted a survey using Forms and generated a corresponding dataset.For the evaluation, I also need the respective department of the participants as additional information for sorting in Excel.How can this criterion be integrated into the evaluation?Thank you and best regards. Read More
Security review for Microsoft Edge version 126
We are pleased to announce the security review for Microsoft Edge, version 126!
We have reviewed the new settings in Microsoft Edge version 126 and determined that there are no additional security settings that require enforcement. The Microsoft Edge version 117 security baseline continues to be our recommended configuration which can be downloaded from the Microsoft Security Compliance Toolkit.
Microsoft Edge version 126 introduced 2 new computer settings and 2 new user settings. We have included a spreadsheet listing the new settings in the release to make it easier for you to find them.
One thing to note with this release we have added configurable settings for Copilot. Something to consider based on your organizations policy
As a friendly reminder, all available settings for Microsoft Edge are documented here, and all available settings for Microsoft Edge Update are documented here.
Please continue to give us feedback through the Security Baselines Discussion site or this post.
Microsoft Tech Community – Latest Blogs –Read More
Azure GenAI Application Deployment Strategy
Synopsis
The latest advancements in Artificial Intelligence (AI), particularly the emergence of Generative AI (GenAI) and its Large Language Models (LLM), have sparked a new wave of business opportunities across various industries. Business leaders are eager to harness this new AI wave to enhance, automate, and accelerate their operations for the benefit of their businesses. Applications driven by GenAI are helping businesses to not only monetise existing revenue streams but also to create new ones.
However, adopting new technologies always comes with challenges. A methodical and streamlined approach is essential for the successful adoption of these technologies; otherwise, there could be significant negative impacts on the technology onboarding process, the time required for adoption, learning to implement, selecting the appropriate LLM models, and integrating these technologies into the business. It also involves identifying suitable use cases, references, best practices, and frameworks, as well as considering trials of the technologies, such as running proof of concepts, building MVP (Minimum Viable Product), and productionising GenAI applications.
We have had numerous discussions with our customers about these ongoing challenges and offering guidance throughout constantly shifting AI landscape.
In this series, we will provide approach to adopt “GenAI Application Deployment Strategy” drawing from our accumulated knowledge and field expertise.
Series:
Topic 1: How to identify the most impactful GenAI use case
Topic 2: Potential Use cases for GenAI Application
Topic 3: The Evolution of GenAI Application Deployment Strategy: Building Custom Co-Pilot (PoC)
Topic 4: The Evolution of GenAI Application Deployment Strategy: From PoC to MVP
Topic 5: The Evolution of GenAI Application Deployment Strategy: From MVP to Production
Topic 6: Value Base Delivery (VBD) to accelerate GenAI use case implementation
@Paolo Colecchia @Taonga_Banda @StephenRhodes @renbafa Morgan Gladwell
Microsoft Tech Community – Latest Blogs –Read More
MVP’s Favorite Content: Visual Studio, “Recall,” AI, AKS
In this blog series dedicated to Microsoft’s technical articles, we’ll highlight our MVPs’ favorite article along with their personal insights.
Tomomitsu Kusaba, Developer Technologies MVP, Japan
“GitHub Copilot and GitHub Copilot Chat are now integrated as features in Visual Studio 2022. Previously, they were available as extensions through the Visual Studio Marketplace. This integration into the IDE is expected to further enhance quality, expand functionality, and improve the overall user experience.”
(In Japanese, Visual Studio 2022 で GitHub Copilot と GitHub Copilot Chat が Visual Studio の機能として統合されました。今までは、Visual Studio Marketplace 拡張機能として提供されていましたが IDE の機能として統合されたことでますます品質向上と機能拡充により体験向上が期待されます。)
Tomokazu Kizawa, Windows and Devices MVP, Japan
Retrace your steps with Recall – Microsoft Support
“The “Recall” feature utilizes the capabilities of Copilot+ PC to record PC operations as screen snapshots. These recorded snapshots can be searched using natural language for both text and images, thanks to multimodal AI capabilities. The text in the search results can be extracted through optical character recognition (OCR), allowing users to copy the text. Additionally, you can open the original application where the snapshot was taken. The Recall feature significantly enhances productivity by extracting necessary information from past operation records. This article clearly explains the overview and required resources for the Recall feature.”
(In Japanese, 「Recall 機能」はCopilot+ PC の機能を活用して、PC の操作を画面のスナップショットとして記録します。記録されたスナップショットは、マルチモーダルな AI の機能により、自然言語を使って文字や画像を検索できます。検索結果のスナップショットは、文字認識により文字を抽出でき、テキストをコピーすることもできます。また、スナップショットを作成した元のアプリケーションで開くこともできます。Recall 機能は過去の操作記録から必要な情報を抽出できるため、生産性を劇的に向上させる機能と言えるでしょう。この記事はRecall 機能の概要や必要なリソースについてわかりやすく記載されています。)
*Relevant Video: 第731回 パソコンが変わる。Surfaceが変える。Copilot+ PC・新型Surface Pro 11とSurface Laptop (2024/5/26) – YouTube
Komes Chandavimol, AI MVP, Thailand
Operationalize AI responsibly with Azure AI Studio (microsoft.com)
“This session focuses not only on using AI but also on building it responsibly. Microsoft emphasizes responsible AI from the start, incorporating responsible-by-design principles, built-in tools, and configurable controls for AI governance to help organizations mitigate potential risks. Several demos on risk mitigation are featured in this session, which you should not miss. Join us to learn from young students utilizing Microsoft’s multimodal technologies and explore how to build AI responsibly.”
(In Thai, หลายๆท่านคงกำลังสร้าง AI solutions และการเริ่มต้นออกแบบ ด้วย Responsible AI เป็นสิ่งสำคัญมาก ใน session Operationalize AI responsibly with Azure AI Studio จะช่วยอธิบายถีงการออกแบบ ai อย่างมีความรับผิดชอบ ตัวอย่าง และ demo เพื่อลดความเสี่ยงที่เกิดจากการนำ LLMs มาใช้สร้าง AI Solutions.)
Shunsuke Yoshikawa, Microsoft Azure MVP, Japan
AKS Automatic – AKS Engineering Blog (azure.github.io)
“This article introduces a new option for AKS announced at Microsoft Build 2024. AKS Automatic allows for easy provisioning of AKS with configurations aligned to best practices and numerous automated operations. It’s a highly attractive new feature.”
(In Japanese, Microsoft Build 2024 で発表された、AKS の新しいオプションの紹介記事です。AKS Automatic は、簡単に AKS をプロビジョニングできる機能です。ベストプラクティスに沿った設定がされており、多くの操作が自動化されています。非常に魅力的な新機能です。)
Microsoft Tech Community – Latest Blogs –Read More
Planner without Teams Access
I have been using Planner via Teams for a while. Teams is going to be inaccessible for a week in order for IT to conduct some security work. Will Planner still be access via web without Teams?
I have been using Planner via Teams for a while. Teams is going to be inaccessible for a week in order for IT to conduct some security work. Will Planner still be access via web without Teams? Read More
Guest access to Team sites created without MS 365 group
Hey All,
Could someone help me understand or explain to me where I’m in the wrong?
I recently created a new site collection (Team site template) without a MS 365 group.
Since our policy says that the Sharepoint owners group permissions needs to be changed to design, this was required. I can’t (as far as I know) change these permissions on a Team site that is connected to a MS 365 group.
The issue I then had was adding access to guest accounts. I created an entra ID security group and added all the guests to it. I then gave that group contribute permissions on the Sharepoint site itself.
This however, did not work as I expected. I read that, in order for the guest accounts to have access, I need to create a Team site that IS connected to a MS 365 group.
I created the site (with ms365 group), did not add any members to any groups, but took the previously created security group and added it to the site. This did worked as intended.
I’m a bit confused on what the best practise for this situation is. We don’t want the owner group to have full control permissions. But if we want to change this, we can’t create a site that allows guests?
By default, we use the owners group to assign a Sharepoint owner to each site. This person is then used to give approvals for changes.
I don’t want to create another security group “owners” for this, because we configure access reviews on all security groups and this would just add to the amount of access reviews that the owners need to perform.
I would love to get in touch with someone who is more knowledgeable on this subject to spar a bit. I’m here to try and learn more and improve my way of working or processes/policies where possible, so all input is welcome.
I try to respond within 24 hours!
KR,
MVN
Hey All, Could someone help me understand or explain to me where I’m in the wrong? I recently created a new site collection (Team site template) without a MS 365 group. Since our policy says that the Sharepoint owners group permissions needs to be changed to design, this was required. I can’t (as far as I know) change these permissions on a Team site that is connected to a MS 365 group. The issue I then had was adding access to guest accounts. I created an entra ID security group and added all the guests to it. I then gave that group contribute permissions on the Sharepoint site itself.This however, did not work as I expected. I read that, in order for the guest accounts to have access, I need to create a Team site that IS connected to a MS 365 group. I created the site (with ms365 group), did not add any members to any groups, but took the previously created security group and added it to the site. This did worked as intended. I’m a bit confused on what the best practise for this situation is. We don’t want the owner group to have full control permissions. But if we want to change this, we can’t create a site that allows guests?By default, we use the owners group to assign a Sharepoint owner to each site. This person is then used to give approvals for changes.I don’t want to create another security group “owners” for this, because we configure access reviews on all security groups and this would just add to the amount of access reviews that the owners need to perform. I would love to get in touch with someone who is more knowledgeable on this subject to spar a bit. I’m here to try and learn more and improve my way of working or processes/policies where possible, so all input is welcome. I try to respond within 24 hours! KR,MVN Read More
Modify the dropdown content in “Link type” for Work Items.
I open a Work Item, try to add a link of another Work Item to it. When we click on Add link, and then select Existing item, in the pop-up we see a drop-down called Link type.
In the drop-down, there is a section called Remote Work.
Is it possible to edit the dropdown contents? Can I remove the whole Remote Work section and the options under it? Or is it AzDO default and cannot be modified?
If it is possible, what special role do I need in AzDO to do this?
I open a Work Item, try to add a link of another Work Item to it. When we click on Add link, and then select Existing item, in the pop-up we see a drop-down called Link type. In the drop-down, there is a section called Remote Work. Is it possible to edit the dropdown contents? Can I remove the whole Remote Work section and the options under it? Or is it AzDO default and cannot be modified? If it is possible, what special role do I need in AzDO to do this? Read More
Defender cannot scan Manifest.list images
There are more and more images that utilize the “manifest list” image format.
This format is very handsome as it allows to put multiple images (or platforms) in a single manifest file, thus reducing the complexity of having so many image tags to maintain.
Unfortunately, Azure Defender Vulnerability Management cannot scan those images.
Wouldnt it be right about time to implement this ?
There are more and more images that utilize the “manifest list” image format.This format is very handsome as it allows to put multiple images (or platforms) in a single manifest file, thus reducing the complexity of having so many image tags to maintain.Unfortunately, Azure Defender Vulnerability Management cannot scan those images. Wouldnt it be right about time to implement this ? Read More
Can using Intune and Basic Mobility and Security
Our company have License M365-E3 and E1, Current we deploy intune for all user have license M365-E3. Now We want all users with license E1 using mobile device must enroll Company portal . So we can using both Intune and Basic Mobility and Security in the same tenant ?
Our company have License M365-E3 and E1, Current we deploy intune for all user have license M365-E3. Now We want all users with license E1 using mobile device must enroll Company portal . So we can using both Intune and Basic Mobility and Security in the same tenant ? Read More
Otimização de serviços Go no Kubernetes
As configurações do ambiente execução do Go podem impactar o comportamento de um serviço em determinado ambiente.
Entender quais configurações são necessárias é imprescindível quando se trata de garantir o máximo de eficiência e desempenho de um serviço escrito em Go.
A configuração GOMAXPROCS dita o comportamento do serviço em relação ao consumo de CPU.
GOMAXPROCS: Número de “threads” disponíveis para o processo. O valor padrão é o número de núcleos da CPU.
Neste artigo, vou descrever minha experiência em busca da configuração ideal para um serviço hospedado no Kubernetes.
GOMAXPROCS e goroutines
A documentação oficial do Go refere-se às goroutines como sendo um tipo de thread mais leve. Embora correta, essa afirmação pode gerar confusões.
Uma goroutine é uma estrutura usada pelo runtime da qual conterá uma pilha de execução, onde o próprio runtime pode gerenciar sua execução. Para gerenciar a execução das rotinas, o Go implementa três componentes principais, introduzidos por Dmitry Vyukov em seu trabalho Scalable Go Scheduler Design Doc.
De forma resumida, são eles:
G (Goroutine): Contem a pilha de execução e todos artefatos necessários para execução, descrito na documentação como um tipo de thread, porém muito mais leve.
M (Thread): M é a forma mais comum de referenciar uma thread do sistema operacional.
P (Processor): Processor é uma estrutura lógica introduzida por Dmitry Vyukov para minimizar o número de goroutines que ficam em estado de espera quando uma thread M realiza uma operação bloqueante, conhecida como sys-call. O Processor implementa uma série de algoritmos que controlam a distribuição das rotinas entre as threads disponíveis. Vale lembrar que existe uma relação íntima entre um Processor P e uma Thread M, porque o P é uma estrutura lógica e, no fim do dia, vai rodar no contexto de uma Thread M.
A variável de ambiente GOMAXPROCS controla o número máximo de Processors disponíveis para nossa aplicação. Para facilitar o entendimento deste ponto, o GOMAXPROCS não controla o número máximo de Threads M disponíveis para nossa aplicação. Em outras palavras, ela não inclui o número de threads bloqueadas, realizando uma chamada para o kernel do SO.
Em outras palavras, o GOMAXPROCS controla o número máximo de threads que podem ser processadas de forma concorrente pelo processador do sistema operacional. O valor padrão é o número de núcleos do processador do host da aplicação.
Definir um valor muito alto para o GOMAXPROCS pode gerar um grande número de trocas de contexto da CPU.
GOMAXPROCS no Kubernetes
O GOMAXPROCS ainda não tem uma integração nativa com os limites definidos para um pod do Kubernetes.
Por exemplo, um pod com limite de 1 núcleo de CPU, rodando em um node com 64 núcleos de CPU, vai acabar tendo o valor padrão GOMAXPROCS=64.
A empresa Uber realizou uma série de estudos em relação aos comportamentos desse desencontro de configurações no repositório do Github: uber-go/automaxprocs.
Configurar GOMAXPROCS na definição do contêiner
Para resolver esse problema, podemos configurar a variável nas especificações do contêiner da seguinte forma:
env:
– name: GOMAXPROCS
valueFrom:
resourceFieldRef:
resource: limits.cpu
Imagine uma imagem docker, contendo a seguinte aplicação:
package main
import (
“fmt”
“runtime”
“runtime/debug”)
func main() {
fmt.Printf(“GOMAXPROCS: %dn”, runtime.GOMAXPROCS(0))
}
Podemos aplicar a configuração mencionada anteriormente na definição de um contêiner, como no exemplo abaixo:
apiVersion: v1
kind: Pod
metadata:
name: app
spec:
containers:
– name: app
image: imagem-da-aplicação
resources:
limits:
cpu: 1500m
env:
– name: GOMAXPROCS
valueFrom:
resourceFieldRef:
resource: limits.cpu
O resultado que você terá, ao conferir os logs de execução deste pod é:
GOMAXPROCS: 2
Conclusão
Entender a relação entre o número de núcleos da CPU, threads e goroutines é essencial para elevar o nível de eficiência do seu serviço Go. Este artigo pode servir de base para que você realize e aprofunde seus estudos sobre o assunto proposto, para que possa ter uma grande consciência da estratégia que pretende utilizar, mudando ou não a configuração GOMAXPROCS.
Microsoft Tech Community – Latest Blogs –Read More
Soluções da Microsoft para as organizações sociais – via Techsoup
Olá Pessoal,
tenho o prazer em compartilhar a apresentação da Techsoup no evento AI for ChangeMakers.
Nela vocês encontrarão as principais informações sobre as soluções da Microsoft para as organizações sociais, através da Techsoup.
Olá Pessoal, tenho o prazer em compartilhar a apresentação da Techsoup no evento AI for ChangeMakers.Nela vocês encontrarão as principais informações sobre as soluções da Microsoft para as organizações sociais, através da Techsoup. Read More
Display negative value in a column if a condition is meet in another column
Hello all,
Can you please help me? I have 1 column named Sales Activity that has several selection options and the other column MF/Line (ALL). When the user select in the Sales Activiy the condition Disconnecion the value in M.fee tab to be negative.
Thank you!
Hello all, Can you please help me? I have 1 column named Sales Activity that has several selection options and the other column MF/Line (ALL). When the user select in the Sales Activiy the condition Disconnecion the value in M.fee tab to be negative. Thank you! Read More
Finding a date that is linked and adjacent to a number
I have a simple spreadsheet for which I need a formula in cell AT3 to identify a date that appears next to a corresponding number. For example cell M3 is where the highest number in the row (PeakNum) is found.
Cell N3 contains the corresponding date and it is this date I need the formula in AT3 to show.
Can anyone help please?
I attach the file
I have a simple spreadsheet for which I need a formula in cell AT3 to identify a date that appears next to a corresponding number. For example cell M3 is where the highest number in the row (PeakNum) is found.Cell N3 contains the corresponding date and it is this date I need the formula in AT3 to show.Can anyone help please?I attach the file Read More
What To Do When Getting Error 15225 In Q.B?
Struggling with Q.B Error 15225 how can I resolve this issue quickly? Looking for effective solutions and fixes to get my software back on track. Any tips or guidance would be greatly appreciated.
Struggling with Q.B Error 15225 how can I resolve this issue quickly? Looking for effective solutions and fixes to get my software back on track. Any tips or guidance would be greatly appreciated. Read More