Category: Microsoft
Category Archives: Microsoft
adding large numbers of hours in escel
hi, i am trying to add a large amount of hours (19:245:40) in an excel file to get the total flight time of a pilot in his lifetime. The problem is the function SUM does not include the big number of the previous total (19245:40) even if the format of all the cells is [h]:mm.
Any idea about how I can fix the problem? Tks
hi, i am trying to add a large amount of hours (19:245:40) in an excel file to get the total flight time of a pilot in his lifetime. The problem is the function SUM does not include the big number of the previous total (19245:40) even if the format of all the cells is [h]:mm.Any idea about how I can fix the problem? Tks Read More
TOCOA AND TOROW FUNCTION
Hi,
TOCOA AND TOROW FUNCTION are not showing in my excel sheet. Please help me.
Thanks,
Hi, TOCOA AND TOROW FUNCTION are not showing in my excel sheet. Please help me. Thanks, Read More
Level Up Your Cloud Apps: Azure Container Apps & DevOps Masterclass
Elevate Your Cloud Applications: Azure Container Apps & DevOps Masterclass
Embark on a practical journey through Azure Container Apps and learn how to integrate them effortlessly with your DevOps processes. This event is tailored for both newcomers to container technology and experienced cloud professionals, aiming to enhance your productivity and equip you with a robust set of tools for modern application management.
Here’s what’s on the agenda:
Unraveling Azure Container Apps: An easy-to-understand guide to containerized applications and their transformative impact.
Streamlining DevOps: Experience how Azure DevOps streamlines the construction, deployment, and maintenance of your containerized processes.
Interactive Demonstrations: Join us as we navigate through actual use cases, demonstrating the capabilities of Azure Container Apps.
Q&A Session: Have your pressing questions addressed.d by our expert panel.
Elevate Your Cloud Applications: Azure Container Apps & DevOps MasterclassEmbark on a practical journey through Azure Container Apps and learn how to integrate them effortlessly with your DevOps processes. This event is tailored for both newcomers to container technology and experienced cloud professionals, aiming to enhance your productivity and equip you with a robust set of tools for modern application management. Here’s what’s on the agenda: Unraveling Azure Container Apps: An easy-to-understand guide to containerized applications and their transformative impact. Streamlining DevOps: Experience how Azure DevOps streamlines the construction, deployment, and maintenance of your containerized processes. Interactive Demonstrations: Join us as we navigate through actual use cases, demonstrating the capabilities of Azure Container Apps. Q&A Session: Have your pressing questions addressed.d by our expert panel. Read More
Participe do AI for ChangeMakers em 27/05
AI for ChangeMakers: um evento imperdível para quem quer usar a inteligência artificial para impacto social e ambiental
Confira a programação completa e saiba como participar desse encontro online e gratuito que reunirá especialistas, jornalistas e organizações sociais que estão usando a IA para transformar o mundo
O que é o AI for ChangeMakers?
O AI for ChangeMakers é um evento presencial com transmissão ao vivo, gratuito que acontecerá na segunda-feira, dia 27 de maio, das 9h às 18h, com o objetivo de mostrar como a inteligência artificial pode ser usada pleo terceiro setor. O evento é uma iniciativa da Microsoft, em parceria com o GIFE e a TechSoup.
Programação:
O evento terá como mestre de cerimônias o jornalista Pedro Doria.
Inicio
Fim
Tema
Speaker
9:00
9:30
Café da manhã de boas vindas
9:30
9:45
Boas Vindas
Lucia Rodrigues (Líder de Filantropia para Microsoft Brasil)
9:45
10:15
Impacto Social e Inteligencia Artificial
Pedro Doria
10:15
11:00
O que é IA Generativa?
Stéfany Mazon (Diretora de IA para Microsoft Brasil)
11:00
11:15
Intervalo
11:15
12:30
IA para Educação
Vera Cabral (Diretora de Educação Microsoft Latam)
Ana Ligia Scaccheti (Presidente da Nova Escola)
12:30
13:00
O uso ético e responsável da IA
Tatiana Aidar (Especialista de Dados e IA)
13:00
14:00
Almoço
14:00
14:30
IA na luta contra o desmatamento
Lucia Rodrigues (Líder de Filantropia para Microsoft Brasil)
14:30
15:00
Cases SLMIT de Impacto Social com IA
João Benito Savastano, Heber Lopes, Eston Santos
15:00
15:30
IA para Acessibilidade
Ricardo Wagner (Diretor de Modern Work na Microsoft)
15:30
16:00
Regulamentação e Políticas Públicas na Era da IA
Alessandra Del Debbio (Vice-Presidente de Assuntos Jurídicos e Corporativos LATAM)
16:00
16:45
IA para medir e ampliar o impacto do jornalismo independente
Marina Dias (Diretora de Comunicação da Publica Agencia de Jornalismo Investigativo)
Bate papo com Rachel Quintiliano (Gerente de Relações Institucionais do GIFE)
16:45
17:00
Intervalo
17:00
17:30
Aprenda a usar o Copilot
Milene Coelho (Executiva de Contas para Soluções de Publicidade)
17:30
17:45
Nonprofit Community Platform
Lucia Rodrigues (Líder de Filantropia para Microsoft Brasil)
17:45
18:00
Como acessar doações de software da Microsoft com a TechSoup
José Avando (Presidente da TechSoup Brasil)
18:00
19:00
Happy Hour na Microsoft
Como participar do evento?
Para participar do evento, basta se inscrever gratuitamente no site para receber o link de acesso por e-mail. O evento será transmitido ao vivo e os participantes poderão interagir com os convidados e fazer perguntas pelo chat.
Não perca essa oportunidade de aprender mais sobre a inteligência artificial e como ela pode ser usada para o impacto social e ambiental. Inscreva-se já e convide seus amigos para o AI for ChangeMakers!
AI for ChangeMakers: um evento imperdível para quem quer usar a inteligência artificial para impacto social e ambiental
Confira a programação completa e saiba como participar desse encontro online e gratuito que reunirá especialistas, jornalistas e organizações sociais que estão usando a IA para transformar o mundo
O que é o AI for ChangeMakers?
O AI for ChangeMakers é um evento presencial com transmissão ao vivo, gratuito que acontecerá na segunda-feira, dia 27 de maio, das 9h às 18h, com o objetivo de mostrar como a inteligência artificial pode ser usada pleo terceiro setor. O evento é uma iniciativa da Microsoft, em parceria com o GIFE e a TechSoup.
Programação:
O evento terá como mestre de cerimônias o jornalista Pedro Doria.
Inicio
Fim
Tema
Speaker
9:00
9:30
Café da manhã de boas vindas
9:30
9:45
Boas Vindas
Lucia Rodrigues (Líder de Filantropia para Microsoft Brasil)
9:45
10:15
Impacto Social e Inteligencia Artificial
Pedro Doria
10:15
11:00
O que é IA Generativa?
Stéfany Mazon (Diretora de IA para Microsoft Brasil)
11:00
11:15
Intervalo
11:15
12:30
IA para Educação
Vera Cabral (Diretora de Educação Microsoft Latam) Ana Ligia Scaccheti (Presidente da Nova Escola)
12:30
13:00
O uso ético e responsável da IA
Tatiana Aidar (Especialista de Dados e IA)
13:00
14:00
Almoço
14:00
14:30
IA na luta contra o desmatamento
Lucia Rodrigues (Líder de Filantropia para Microsoft Brasil)
14:30
15:00
Cases SLMIT de Impacto Social com IA
João Benito Savastano, Heber Lopes, Eston Santos
15:00
15:30
IA para Acessibilidade
Ricardo Wagner (Diretor de Modern Work na Microsoft)
15:30
16:00
Regulamentação e Políticas Públicas na Era da IA
Alessandra Del Debbio (Vice-Presidente de Assuntos Jurídicos e Corporativos LATAM)
16:00
16:45
IA para medir e ampliar o impacto do jornalismo independente
Marina Dias (Diretora de Comunicação da Publica Agencia de Jornalismo Investigativo) Bate papo com Rachel Quintiliano (Gerente de Relações Institucionais do GIFE)
16:45
17:00
Intervalo
17:00
17:30
Aprenda a usar o Copilot
Milene Coelho (Executiva de Contas para Soluções de Publicidade)
17:30
17:45
Nonprofit Community Platform
Lucia Rodrigues (Líder de Filantropia para Microsoft Brasil)
17:45
18:00
Como acessar doações de software da Microsoft com a TechSoup
José Avando (Presidente da TechSoup Brasil)
18:00
19:00
Happy Hour na Microsoft
Como participar do evento?
Para participar do evento, basta se inscrever gratuitamente no site para receber o link de acesso por e-mail. O evento será transmitido ao vivo e os participantes poderão interagir com os convidados e fazer perguntas pelo chat.
Não perca essa oportunidade de aprender mais sobre a inteligência artificial e como ela pode ser usada para o impacto social e ambiental. Inscreva-se já e convide seus amigos para o AI for ChangeMakers! Read More
Unable to access membership workspace
As soon as we started associating members profile to the partner center I am unable to see the learning profile and membership workspace.
Any idea?
As soon as we started associating members profile to the partner center I am unable to see the learning profile and membership workspace. Any idea? Read More
Creating a Sliding Commission Scale in Excel
Hi
I have a Sliding Scale Commission that I pay my staff.
They have to submit an invoice to me to show how much sales have been done and then how much I need to pay them in commission.
I would like to create a generic Excel spreadsheet that they complete the total sales amount and it works out their commission pay in another box.
The scale is:
£0-£2000 @ 15%
£2000-£3000 @ 16%
£3000-£4000 @ 17%
£4000+ @18%
So for example, if their sales is £2500:
they would get 15% of the £2000 = £300
then they would get 16% on the £500 = £80
so I would pay them £380
Is there a way to do this?
TIA
Hi I have a Sliding Scale Commission that I pay my staff. They have to submit an invoice to me to show how much sales have been done and then how much I need to pay them in commission. I would like to create a generic Excel spreadsheet that they complete the total sales amount and it works out their commission pay in another box. The scale is:£0-£2000 @ 15%£2000-£3000 @ 16%£3000-£4000 @ 17%£4000+ @18%So for example, if their sales is £2500:they would get 15% of the £2000 = £300then they would get 16% on the £500 = £80 so I would pay them £380 Is there a way to do this? TIA Read More
Adjusting URL column formula
Greetings,
In column D, I have a specific page number for websites.
I am trying to create a column E, which would have a clickable link for each page.
For example:
D1- 4321 E1- https://bobsmadeupsite.org/4321
D2- 4345 E2- https://bobsmadeupsite.org/4345
D3- 4598 E3- https://bobsmadeupsite.org/4598
Is there a simple formula to alter column E to add and adjust column D’s information?
Help would be appreciated. Thanks.
Greetings, In column D, I have a specific page number for websites. I am trying to create a column E, which would have a clickable link for each page. For example: D1- 4321 E1- https://bobsmadeupsite.org/4321 D2- 4345 E2- https://bobsmadeupsite.org/4345 D3- 4598 E3- https://bobsmadeupsite.org/4598 Is there a simple formula to alter column E to add and adjust column D’s information? Help would be appreciated. Thanks. Read More
Checking to see if a serial number follows a certain format
I am trying to check a cell to see if it has a correct formatting for a serial number. for example, if column b has serial numbers in it, I want to see if they follow a format of 2 letters and 6 numbers.
L=letters
N=numbers
LLNNNNNN
If not, I would like to either have it highlighted or I could put something in another column. Just something to catch my eye for corrections.
I’m not great with formulas and my work excel is, I believe, the 2016 version.
I am trying to check a cell to see if it has a correct formatting for a serial number. for example, if column b has serial numbers in it, I want to see if they follow a format of 2 letters and 6 numbers.L=lettersN=numbersLLNNNNNNIf not, I would like to either have it highlighted or I could put something in another column. Just something to catch my eye for corrections.I’m not great with formulas and my work excel is, I believe, the 2016 version. Read More
Convert Access query to Sql Server
I can’t get two Max(IIf statement form an Access query to work in a Sql Server view. I have tried everything that I can think of and can’t get it to work. Could someone help me out. The highlighted in green code is the Access code that needs to added to Sql Server or something like it. Bob
SQLServer Design for dbo.TemporaryTransactionsQuery3
Sql Server code that can be copied, pasted and edited.
SELECT TOP (100) PERCENT dbo.TemporaryTransactionsQuery2.Account, dbo.TemporaryTransactionsQuery2.ChkRef, dbo.TemporaryTransactionsQuery2.Debit, dbo.TemporaryTransactionsQuery2.Credit,
dbo.TemporaryTransactionsQuery2.Balance, dbo.TemporaryTransactionsQuery2.Date, dbo.TemporaryTransactionsQuery2.Description, dbo.TemporaryTransactionsQuery2.AccountName,
dbo.TemporaryTransactionsQuery2.Description16, dbo.TemporaryTransactionsQuery2.PayeePayor, dbo.TemporaryTransactionsQuery2.CombinedCategory, dbo.TemporaryTransactionsQuery2.Multiple,
dbo.TemporaryTransactionsQuery2.ID, dbo.tblTransactions.TranDate
FROM dbo.tblTemporaryTransactions INNER JOIN
dbo.TemporaryTransactionsQuery2 ON dbo.tblTemporaryTransactions.ID = dbo.TemporaryTransactionsQuery2.ID INNER JOIN
dbo.tblTransactions ON dbo.TemporaryTransactionsQuery2.AccountName = dbo.tblTransactions.Account
GROUP BY dbo.TemporaryTransactionsQuery2.Account, dbo.TemporaryTransactionsQuery2.ChkRef, dbo.TemporaryTransactionsQuery2.Debit, dbo.TemporaryTransactionsQuery2.Credit, dbo.TemporaryTransactionsQuery2.Balance,
dbo.TemporaryTransactionsQuery2.Date, dbo.TemporaryTransactionsQuery2.Description, dbo.TemporaryTransactionsQuery2.AccountName, dbo.TemporaryTransactionsQuery2.Description16,
dbo.TemporaryTransactionsQuery2.PayeePayor, dbo.TemporaryTransactionsQuery2.CombinedCategory, dbo.TemporaryTransactionsQuery2.ID, dbo.tblTransactions.TranDate, dbo.TemporaryTransactionsQuery2.Multiple
ORDER BY dbo.TemporaryTransactionsQuery2.Date DESC
MS Access Sql code
SELECT TemporaryTransactionsQuery2.Account, TemporaryTransactionsQuery2.ChkRef, TemporaryTransactionsQuery2.Debit, TemporaryTransactionsQuery2.Credit, TemporaryTransactionsQuery2.Balance, TemporaryTransactionsQuery2.Date, TemporaryTransactionsQuery2.Description, TemporaryTransactionsQuery2.AccountName, TemporaryTransactionsQuery2.Description16, TemporaryTransactionsQuery2.PayeePayor, TemporaryTransactionsQuery2.CombinedCategory, TemporaryTransactionsQuery2.Multiple, TemporaryTransactionsQuery2.ID, Max(IIf([tblTransactions].[Account]=[TemporaryTransactionsQuery2].[AccountName] And [tblTransactions].[PayeePayor]=[TemporaryTransactionsQuery2].[PayeePayor] And [tblTransactions].[ConbinedCategory]=[TemporaryTransactionsQuery2].[CombinedCategory] And [tblTemporaryTransactions].[Date]-10>=[tblTransactions].[TranDate],1,0)) AS Expr2, Max(IIf(IsNull([tblTemporaryTransactions].[PayeePayor])=True And IsNull([tblTemporaryTransactions].[CombinedCategory])=True,1,0)) AS Expr3, TemporaryTransactionsQuery2.Type, TemporaryTransactionsQuery2.Shares, TemporaryTransactionsQuery2.Price, TemporaryTransactionsQuery2.CommFees
FROM (TemporaryTransactionsQuery2 INNER JOIN tblTemporaryTransactions ON TemporaryTransactionsQuery2.ID = tblTemporaryTransactions.ID) INNER JOIN tblTransactions ON TemporaryTransactionsQuery2.AccountName = tblTransactions.Account
GROUP BY TemporaryTransactionsQuery2.Account, TemporaryTransactionsQuery2.ChkRef, TemporaryTransactionsQuery2.Debit, TemporaryTransactionsQuery2.Credit, TemporaryTransactionsQuery2.Balance, TemporaryTransactionsQuery2.Date, TemporaryTransactionsQuery2.Description, TemporaryTransactionsQuery2.AccountName, TemporaryTransactionsQuery2.Description16, TemporaryTransactionsQuery2.PayeePayor, TemporaryTransactionsQuery2.CombinedCategory, TemporaryTransactionsQuery2.Multiple, TemporaryTransactionsQuery2.ID, TemporaryTransactionsQuery2.Type, TemporaryTransactionsQuery2.Shares, TemporaryTransactionsQuery2.Price, TemporaryTransactionsQuery2.CommFees
HAVING (((Max(IIf(IsNull([tblTemporaryTransactions].[PayeePayor])=True And IsNull([tblTemporaryTransactions].[CombinedCategory])=True,1,0)))=1))
ORDER BY TemporaryTransactionsQuery2.Date DESC;
I can’t get two Max(IIf statement form an Access query to work in a Sql Server view. I have tried everything that I can think of and can’t get it to work. Could someone help me out. The highlighted in green code is the Access code that needs to added to Sql Server or something like it. BobSQLServer Design for dbo.TemporaryTransactionsQuery3 Sql Server code that can be copied, pasted and edited.SELECT TOP (100) PERCENT dbo.TemporaryTransactionsQuery2.Account, dbo.TemporaryTransactionsQuery2.ChkRef, dbo.TemporaryTransactionsQuery2.Debit, dbo.TemporaryTransactionsQuery2.Credit, dbo.TemporaryTransactionsQuery2.Balance, dbo.TemporaryTransactionsQuery2.Date, dbo.TemporaryTransactionsQuery2.Description, dbo.TemporaryTransactionsQuery2.AccountName, dbo.TemporaryTransactionsQuery2.Description16, dbo.TemporaryTransactionsQuery2.PayeePayor, dbo.TemporaryTransactionsQuery2.CombinedCategory, dbo.TemporaryTransactionsQuery2.Multiple, dbo.TemporaryTransactionsQuery2.ID, dbo.tblTransactions.TranDateFROM dbo.tblTemporaryTransactions INNER JOIN dbo.TemporaryTransactionsQuery2 ON dbo.tblTemporaryTransactions.ID = dbo.TemporaryTransactionsQuery2.ID INNER JOIN dbo.tblTransactions ON dbo.TemporaryTransactionsQuery2.AccountName = dbo.tblTransactions.AccountGROUP BY dbo.TemporaryTransactionsQuery2.Account, dbo.TemporaryTransactionsQuery2.ChkRef, dbo.TemporaryTransactionsQuery2.Debit, dbo.TemporaryTransactionsQuery2.Credit, dbo.TemporaryTransactionsQuery2.Balance, dbo.TemporaryTransactionsQuery2.Date, dbo.TemporaryTransactionsQuery2.Description, dbo.TemporaryTransactionsQuery2.AccountName, dbo.TemporaryTransactionsQuery2.Description16, dbo.TemporaryTransactionsQuery2.PayeePayor, dbo.TemporaryTransactionsQuery2.CombinedCategory, dbo.TemporaryTransactionsQuery2.ID, dbo.tblTransactions.TranDate, dbo.TemporaryTransactionsQuery2.MultipleORDER BY dbo.TemporaryTransactionsQuery2.Date DESCMS Access Sql codeSELECT TemporaryTransactionsQuery2.Account, TemporaryTransactionsQuery2.ChkRef, TemporaryTransactionsQuery2.Debit, TemporaryTransactionsQuery2.Credit, TemporaryTransactionsQuery2.Balance, TemporaryTransactionsQuery2.Date, TemporaryTransactionsQuery2.Description, TemporaryTransactionsQuery2.AccountName, TemporaryTransactionsQuery2.Description16, TemporaryTransactionsQuery2.PayeePayor, TemporaryTransactionsQuery2.CombinedCategory, TemporaryTransactionsQuery2.Multiple, TemporaryTransactionsQuery2.ID, Max(IIf([tblTransactions].[Account]=[TemporaryTransactionsQuery2].[AccountName] And [tblTransactions].[PayeePayor]=[TemporaryTransactionsQuery2].[PayeePayor] And [tblTransactions].[ConbinedCategory]=[TemporaryTransactionsQuery2].[CombinedCategory] And [tblTemporaryTransactions].[Date]-10>=[tblTransactions].[TranDate],1,0)) AS Expr2, Max(IIf(IsNull([tblTemporaryTransactions].[PayeePayor])=True And IsNull([tblTemporaryTransactions].[CombinedCategory])=True,1,0)) AS Expr3, TemporaryTransactionsQuery2.Type, TemporaryTransactionsQuery2.Shares, TemporaryTransactionsQuery2.Price, TemporaryTransactionsQuery2.CommFeesFROM (TemporaryTransactionsQuery2 INNER JOIN tblTemporaryTransactions ON TemporaryTransactionsQuery2.ID = tblTemporaryTransactions.ID) INNER JOIN tblTransactions ON TemporaryTransactionsQuery2.AccountName = tblTransactions.AccountGROUP BY TemporaryTransactionsQuery2.Account, TemporaryTransactionsQuery2.ChkRef, TemporaryTransactionsQuery2.Debit, TemporaryTransactionsQuery2.Credit, TemporaryTransactionsQuery2.Balance, TemporaryTransactionsQuery2.Date, TemporaryTransactionsQuery2.Description, TemporaryTransactionsQuery2.AccountName, TemporaryTransactionsQuery2.Description16, TemporaryTransactionsQuery2.PayeePayor, TemporaryTransactionsQuery2.CombinedCategory, TemporaryTransactionsQuery2.Multiple, TemporaryTransactionsQuery2.ID, TemporaryTransactionsQuery2.Type, TemporaryTransactionsQuery2.Shares, TemporaryTransactionsQuery2.Price, TemporaryTransactionsQuery2.CommFeesHAVING (((Max(IIf(IsNull([tblTemporaryTransactions].[PayeePayor])=True And IsNull([tblTemporaryTransactions].[CombinedCategory])=True,1,0)))=1))ORDER BY TemporaryTransactionsQuery2.Date DESC; Read More
MY PROFILE ON MICROSOFT OUTLOOK
Dear Friends and Cousins
My profile on Outlook.com email is going through a lot. I was trying to fix this. However. Women and their husbands/family got in my Account. These aliens DONT have genitals. They cant be horny. Iam afraid. Iam a Human and Newlywed. I have genitals just fine. I need my boyfriends. Fiancee. Family/Friends. Call me guys. However. Remove these aliens. Their from California who DONT HAVE GENITALY. I dont like California.
From JULIA R. 40 YEARS OLD
Dear Friends and Cousins My profile on Outlook.com email is going through a lot. I was trying to fix this. However. Women and their husbands/family got in my Account. These aliens DONT have genitals. They cant be horny. Iam afraid. Iam a Human and Newlywed. I have genitals just fine. I need my boyfriends. Fiancee. Family/Friends. Call me guys. However. Remove these aliens. Their from California who DONT HAVE GENITALY. I dont like California. From JULIA R. 40 YEARS OLD Read More
Powershell Script not running on Client
Hello,
I had created a powershell script in Endpoint Manager / Inutne.
But the script will not load and run a my Windows 10 test client. When I look on my test client i do not see the EnterpriseDesktopAppManagement CSP by Intune. I see only logs.
When I create a configuration policies it will push ( also apps) to the client.
What can I do to run ps scripts on the client via Intune?
Regards
Stefan
Hello,I had created a powershell script in Endpoint Manager / Inutne. But the script will not load and run a my Windows 10 test client. When I look on my test client i do not see the EnterpriseDesktopAppManagement CSP by Intune. I see only logs.When I create a configuration policies it will push ( also apps) to the client. What can I do to run ps scripts on the client via Intune? RegardsStefan Read More
SharePoint Doc link broken
One of my users links a URL to a SharePoint site, but this link gets encoded incorrectly, resulting in a broken link that removes some filters. The encoding for ‘%3F’ is being changed to ‘?’, which removes the filters from the link. Please guide me.
https://test1.constoso.com/[shortened]/list.do%3F
https://test1.constoso.com/[shortened]/list.do%?
One of my users links a URL to a SharePoint site, but this link gets encoded incorrectly, resulting in a broken link that removes some filters. The encoding for ‘%3F’ is being changed to ‘?’, which removes the filters from the link. Please guide me.https://test1.constoso.com/[shortened]/list.do%3Fhttps://test1.constoso.com/[shortened]/list.do%? Read More
Sum of subtotal cell from multiple workbooks
Hi Folks,
I do the invoicing for my wife’s physio business. I downloaded a simple invoice template and have been using this for the past few years.
On OneDrive, I have a directory with my wife’s business name and then sub-directories of years and within each year, months. So, for instance, a directory 2022, with all the months of the year Jan-Dec, and within each month a patient’s invoice for that month.
Each workbook contains a worksheet invoice with a cell in each worksheet containing the sum of the number of visits for that month in $. What I would like to do is add up all the subtotals for each patient for each month and a total for the year.
For example, 2022 would have directories of Jan to Dec, with a workbook containing an invoice worksheet for each patient. I would like to get a total of all the patients’ subtotals included in each monthly directory, and then a grand total for the year. So essentially, I am trying to sum one cell from one worksheet found in multiple workbooks.
I am not a power user so the easier the better even if it may not be the most efficient method. I just do not want to have to open up every workbook containing the invoice and manually add the subtotal of each patient’s charges.
Can this be done through a power query or macro. I am not very good with Excel but I am willing to give it a try.
Thanks!!
Best regards,
Rich
Hi Folks, I do the invoicing for my wife’s physio business. I downloaded a simple invoice template and have been using this for the past few years. On OneDrive, I have a directory with my wife’s business name and then sub-directories of years and within each year, months. So, for instance, a directory 2022, with all the months of the year Jan-Dec, and within each month a patient’s invoice for that month. Each workbook contains a worksheet invoice with a cell in each worksheet containing the sum of the number of visits for that month in $. What I would like to do is add up all the subtotals for each patient for each month and a total for the year. For example, 2022 would have directories of Jan to Dec, with a workbook containing an invoice worksheet for each patient. I would like to get a total of all the patients’ subtotals included in each monthly directory, and then a grand total for the year. So essentially, I am trying to sum one cell from one worksheet found in multiple workbooks. I am not a power user so the easier the better even if it may not be the most efficient method. I just do not want to have to open up every workbook containing the invoice and manually add the subtotal of each patient’s charges. Can this be done through a power query or macro. I am not very good with Excel but I am willing to give it a try. Thanks!! Best regards,Rich Read More
Captions in Word
I am trying to place a caption under Tables and Figures that include chapter numbers as follows: Figure 1.1, Figure 1.2, Figure 2.1. I follow all instructions but when I enter the caption it returns it as Figure 0.1, which means it is not picking up the chapter number. Since I am using custom headers that are not reflected in the Caption dialogue box, I go back and set up a new header style (Header 6) that is not used anywhere else in the document. Then when I apply that to the Chapter number header, it applies it to all section headers in the document. Anyone know what I am doing wrong?
I am trying to place a caption under Tables and Figures that include chapter numbers as follows: Figure 1.1, Figure 1.2, Figure 2.1. I follow all instructions but when I enter the caption it returns it as Figure 0.1, which means it is not picking up the chapter number. Since I am using custom headers that are not reflected in the Caption dialogue box, I go back and set up a new header style (Header 6) that is not used anywhere else in the document. Then when I apply that to the Chapter number header, it applies it to all section headers in the document. Anyone know what I am doing wrong? Read More
Laptop OneDrive files not visible on the desktop
I have one drive on my desktop, works fine. I have a laptop and it can see the OneDrive files from my desktop but when I add files from my laptop they show up in OneDrive on the laptop but are not visible from the desktop. I will quickly get my files out of sync at this rate. I want the files I modify or change on my laptop to be visible and up to date on my desktop. How do I fix this? Otherwise, I will need to move off OneDrive.
I have one drive on my desktop, works fine. I have a laptop and it can see the OneDrive files from my desktop but when I add files from my laptop they show up in OneDrive on the laptop but are not visible from the desktop. I will quickly get my files out of sync at this rate. I want the files I modify or change on my laptop to be visible and up to date on my desktop. How do I fix this? Otherwise, I will need to move off OneDrive. Read More
MY PROFILE ON OUTLOOK
Dear Friends and Cousins
My profile on Outlook.com email is going through a lot. I was trying to fix this. However. Women and their husbands/family got in my Account. These aliens DONT have **bleep** or Vegina. They cant be horny. Iam afraid. I have a Vegina just fine. I need my boyfriends. Fiancee. Family/Friends. Call me guys. However. Remove these aliens from California who DONT HAVE **bleep**/VEGINA.
From JULIA R. 40 YEARS OLD
Dear Friends and Cousins My profile on Outlook.com email is going through a lot. I was trying to fix this. However. Women and their husbands/family got in my Account. These aliens DONT have **bleep** or Vegina. They cant be horny. Iam afraid. I have a Vegina just fine. I need my boyfriends. Fiancee. Family/Friends. Call me guys. However. Remove these aliens from California who DONT HAVE **bleep**/VEGINA. From JULIA R. 40 YEARS OLD Read More
Scaling a Letter-size document to A4
I created a document using a tri-fold brochure template. Only when I printed did I realise it was a “Letter (8.5″ x 11” document) and I am printing on A4. When I change the page size to A4 it completely messes up my layouts and I spent hours trying to adjust them with no luck. It seems the template is made using multiple tables for the layout, as I couldn’t select the whole table to enlarge it. Is there an easy way to do this? Unfortunately I am printing wirelessly so I there’s nothing i can do in print settings
I created a document using a tri-fold brochure template. Only when I printed did I realise it was a “Letter (8.5″ x 11” document) and I am printing on A4. When I change the page size to A4 it completely messes up my layouts and I spent hours trying to adjust them with no luck. It seems the template is made using multiple tables for the layout, as I couldn’t select the whole table to enlarge it. Is there an easy way to do this? Unfortunately I am printing wirelessly so I there’s nothing i can do in print settings Read More
How to trim an mp3 file on Windows 11 in bulk?
Recently, I copied hundreds of songs in mp3 format from old CDs. Many of the mp3 files have very long duration and I am going to trim the mp3 file to get rip the useless prelude. I tried the Windows Media Player but it does not work. Hope someone could suggest a good way to bulk trim mp3 files on Windows 11?
Recently, I copied hundreds of songs in mp3 format from old CDs. Many of the mp3 files have very long duration and I am going to trim the mp3 file to get rip the useless prelude. I tried the Windows Media Player but it does not work. Hope someone could suggest a good way to bulk trim mp3 files on Windows 11? Read More
Best Way to bulk rename files on Windows 11?
When I transferred my photos on my Android phone to Windows 11, I found out the photos are named under the data plus a set of random digits. I NEED to bulk rename the files on Windows 11. Can the Photos app is able to rename files in bulk? It could be so boring to rename it one by one.
Thanks
When I transferred my photos on my Android phone to Windows 11, I found out the photos are named under the data plus a set of random digits. I NEED to bulk rename the files on Windows 11. Can the Photos app is able to rename files in bulk? It could be so boring to rename it one by one. Thanks Read More
Blue Screen w/no response from the settings menu, and all functionality not responding.
The systems been active for 2.5 hrs., when I selected “system” from the task bar, the display was blue textured with vertical lines, the entire display on Lenovo:
Edition Windows 11 Home
Version 23H2
Installed on 2/20/2024
OS build 22631.3593
Serial number PF22E7GD
Experience Windows Feature Experience Pack 1000.22700.1003.0
The systems been active for 2.5 hrs., when I selected “system” from the task bar, the display was blue textured with vertical lines, the entire display on Lenovo:Edition Windows 11 HomeVersion 23H2Installed on 2/20/2024OS build 22631.3593Serial number PF22E7GDExperience Windows Feature Experience Pack 1000.22700.1003.0 Read More
