Office cheat sheets - Microsoft Support
Training: Get up to speed in minutes, quickly refer to things you’ve learned, and master keyboard shortcuts with these handy cheat sheets for Microsoft Office.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 for home, Office for business, Office 365 Small Business
LOOKUP function - Microsoft Support
Vector form. The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range.. Syntax. LOOKUP(lookup_value, lookup_vector, [result_vector]) The LOOKUP function vector form syntax has the following arguments:. lookup_value Required.A value that LOOKUP searches for in the first vector.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Import data from data sources (Power Query) - Microsoft Support
By default, the Encrypt connection check box is selected to signify that Power Query connects to your database using an encrypted connection. If you do not want to connect using an encrypted connection, clear this check box, and then click Connect.. If a connection to your SQL Server is not established using an encrypted connection, Power Query prompts you to connect using an unencrypted ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Get updates for apps and games in Microsoft Store
Learn more. Fix problems with apps from Microsoft Store. Manage your purchases from the Microsoft Store. Need more help? Contact Support. For technical support, go to Contact Microsoft Support, enter your problem and select Get Help.If you still need help, select Contact Support to be routed to the best support option.
Change the refresh rate on your monitor in Windows
Battery Life: Lowering your refresh rate can save battery power by reducing the amount of energy your display consumes.This can be useful when you are using a laptop or tablet and want to extend your battery life.
Find out how much storage your PC has - Microsoft Support
Learn how to check your PC's storage capacity and manage it effectively with Microsoft Support's guidance.
Business Assist for Microsoft 365 - Microsoft Support
Get the most out of your subscription with expert advice and support from small business advisors. Business Assist for Microsoft 365 is designed for small businesses to give you and your employees around-the-clock access to small business advisors as you grow your business, from onboarding to everyday use.
Applies To: Microsoft 365 Apps for business, Microsoft 365 Business Premium
Upload and save files and folders to OneDrive - Microsoft Support
Upload files or folders to OneDrive. You can store over 300 types of files on OneDrive. With Microsoft Edge or Google Chrome: Select Add new > Files upload or Folder upload > Folder.
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Manage audio settings in Microsoft Teams meetings
Audio source. When you choose this... Computer audio Your computer's default speaker and mic will be used during the meeting. To adjust your PC mic and speaker settings, select Open device settings .. In Audio settings, select the audio devices you want to use from the Speaker and Microphone dropdown menus.You can alsoturn on spatial audio and adjust noise suppression.
Applies To: Microsoft Teams
What is: Multifactor Authentication - Microsoft Support
How does multifactor authentication work? Let's say you're going to sign into your Microsoft account or work or school account, and you enter your username and password.If that's all you need then anybody who knows your username and password can sign in as you from anywhere in the world!