jsinfor - Microsoft Office

JS Infor

MICROSOFT OFICE LTSC Profissional PLUS 2021

https://www.youtube.com/watch?v=oX-ZQi3ycSo

Metedo 1
Link per scaricare l'odt che installa office: https://www.microsoft.com/en-us/downl...

Link per creare il file di configurazione: https://config.office.com/

Link con i codici MAK: https://docs.microsoft.com/en-us/Depl...

C:\WINDOWS\system32>cd c:\office2021

CMD Administrator

c:\OFFICE2021>setup.exe /configure configuração.xml
+-+-+-+-+-+-+-++--+-+
# ON ERRO ACTIVATION#
"OSPPREARM" Boton right run administrator

If the error in the account is not yet activated:
1º Run CMD as Administrator
2º C:\Program Files or Program Files(x86)\Microsoft Office\Office16>cscript ospp.vbs /sethst:kms.03k.org
---Processing---
3º C:\Program Files or Program Files(x86)\Microsoft Office\Office16>cscript ospp.vbs /act
---Processing---
<Producr activation successful>

Or
Metedo2

Free Product key for Microsoft office 2021

KDNJ9-G2MPB-HWJB4-DC6C2-DDCWD
NMMKJ-6RK4F-KMJVX-8D9MJ–6MWKP

Other Office 2021 activation keys:

KJH3GF-NBV4GT-GFX4BN-JH8BVC
BVC1FD-JHGV2C-JHB8VC-KJH9GF
ZXC2V-JHGF7E-ASDF5G-LKJH3GK
PIU4YT-HG7FD-EW6QP-HGFD8QA

How to activate the Microsoft office 2021 product key?

Step 1:

First of all, download ms office 2021 setup and install it.

Step 2:

Next, open any office application like word, excel, PowerPoint, etc.

Step 3:

Now, navigate to file >> Account.

Step 4:

Here, you can see the product’s activation status if it says that it is activated when you are done. But if it says product activation required, enter the product key given above and validate it.

Activate MS Office 2021 Using CMD [Free Method]

1. Run Command Prompt (CMD) as Administrator

After installing MS Office 2021, go to search bar and type cmd. Right click on it and select “run as administrator”. A dialogue box will appear to ask your permission click on “Yes”.

Activate MS Office 2021 using cmd

2. Now, you have to specify the Office 2021 install location. You can enter below code for 32-bit and 64-bit version.

cd /d %ProgramFiles%\Microsoft Office\Office16 cd /d %ProgramFiles(x86)%\Microsoft Office\Office16

Microsoft Office 2021 installation location

3. Now you have to convert MS Office 2021 retail license to volume license. Use below code to covert.

for /f %x in ('dir /b ..\root\Licenses16\ProPlus2021VL_KMS*.xrm-ms') do cscript ospp.vbs /inslic:"..\root\Licenses16\%x"

Press Enter.

4. Enter following command, before that make sure your system is connected to Internet.

cscript ospp.vbs /inpkey:FXYTK-NJJ8C-GB6DW-3DYQT-6F7TH cscript ospp.vbs /unpkey:BTDRB >nul cscript ospp.vbs /unpkey:KHGM9 >nul cscript ospp.vbs /unpkey:CPQVG >nul cscript ospp.vbs /sethst:s8.uk.to cscript ospp.vbs /setprt:1688 cscript ospp.vbs /act

Then press Enter.

OUTLOOK

Change the font or font size in the message list

Outlook for Office 365 Outlook 2019 Outlook 2016 Outlook 2013 Outlook 2010 More...

To scan through your Inbox more quickly, you may want to enlarge the text in the subject lines and column header, or change their font so they’re easier to read.

Newer versions Office 2007

Illustration of increasing font size in the message list

Click Mail.
Click View > View Settings.
Click Other Settings.
To change the font or font size for the column headers in your Inbox (like “From” and “Subject”), click Column Font, and then make the desired adjustment.
To change the font or font size of the message subject lines in your Inbox, click Row Font, and then make the desired adjustment.

Temporarily enlarge an email in the Reading Pane

In the Reading Pane, you can also make the contents of an email larger, so it’s easier to read.

However, increasing the size of the text in the Reading Pane only works on the email you are currently looking at. When you click on another email, the body text will return to the default font size.

Click once on the message you want to preview in the Reading Pane.
In the bottom right corner of the Outlook window, drag the zoom bar right (for larger text).

Move the bar right to zoom in.

RULES and ALERTS

SEND and ALERTS

Send After 1 Minutes

ACCESS

DoCmd.RunCommand acCmdWorkgroupAdministrator

Ctrl+G

How To Hide Contact Photos In Emails In Outlook?

In Outlook 2010 and 2013, contact pictures will display at the message header automatically if we have added pictures for the message senders or recipients. However, In Outlook 2013 even there are no contact pictures for associated senders or recipients, it also displays a blank picture placeholder. Some user may think the blank placeholder inconvenient. In this article, I will show you how to hide the contact photos in emails in Outlook.

Office Tab - Enable Tabbed Editing and Browsing in Office, and Make Work Much Easier...

Read More... Download...

Kutools for Outlook - Brings 100 Powerful Advanced Features to Microsoft Outlook

Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by rules; Auto Reply without exchange server, and more automatic features...
BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
Reply (All) With All Attachments in the mail conversation; Reply Many Emails at once; Auto Add Greeting when reply; Auto Add Date&Time into subject...
Attachment Tools: Auto Detach, Compress All, Rename All, Auto Save All... Quick Report, Count Selected Mails, Remove Duplicate Mails and Contacts...
More than 100 advanced features will solve most of your problems in Outlook 2010-2019 and 365. Full features 60-day free trial.

To hide contact photos in email messages in Microsoft Outlook 2010 and 2013, you can do as following:

Step 1: Click the File > Options to open the Outlook Options dialog box.

Step 2: In the Outlook Options dialog box, click the People (or Contacts) in the left bar, then uncheck the option of Show user photographs when available in the Online status and photographs section.

Step 3: Click the OK to close the Outlook Options dialog box.

Step 4: Restart your Microsoft Outlook.

From now on, you will see all contact pictures/photos are hidden from the email messages, and you will not view the blank photo placeholder either.

Notes:

(1) Because we have hidden the contact pictures from the email headers, it remains the blank picture placeholders in the People Pane. You can turn off the People Pane with clicking the People Pane > Off on the View tab.

(2) Although we can add photos for contacts in Outlook 2007, the contacts’ photos don’t display in associated email messages.

EXCEL

Formulas

Como refazer numa coluna nova, retirando o que se pretende.
Ex.: g_meh400memmh400dirMRW

h400dirMRW ( formula ) =RIGHT(A2;LEN(A2)-12)
Descrição direita |A2=coluna*| ; |LEN=posição(A2)* !-12=posição

Quando se pretende calcular valores de pesquisa de testo de diferentes registos

=SUMIF(calculo!$J$2:$J$1474;"nome*";calculo!$Q$2:$Q$1474) + SUMIF(calculo!$J$2:$J$1474;"xpto*";calculo!$Q$2:$Q$1474)

SUMIF >NOTA: em código simples só é permitido uma formula mas com + ja funciona

=SUMIFS(Main!$O$2:$O$1860;Main!$U$2:$U$1860;"bounty*";Main!$V$2:$V$1860;">="&$A$2;Main!$V$2:$V$1860;"<="&$B$2)+SUMIFS(Main!$O$2:$O$1860;Main!$U$2:$U$1860;"mission*";Main!$V$2:$V$1860;">="&$A$2;Main!$V$2:$V$1860;"<="&$B$2)

SUMIFS >NOTA: permite concatenar / encadear conforme formula e valores

Copyright © 2011, JS-Infor. All Rights Reserved.

Este sitio web fue creado de forma gratuita con PaginaWebGratis.es. ¿Quieres también tu sitio web propio?

Registrarse gratis