Import data from database using native database query. Use multiple tables to create a PivotTable. Import data from a database in Excel for Mac. Getting data. Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.

Select Review > Translate. Select your language to see the translation. Select Insert. The translated text will replace the text you highlighted in step 1. Note: In Excel, there is no Insert button, you'll have to copy/paste the text you highlighted in step1. You might see a list of several translations.

Windows 10. Optimizing your drives can help your PC run smoother and boot up faster. To optimize them: Select the search bar on the taskbar and enter defrag. Select Defragment and Optimize Drives. Select the disk drive you want to optimize. Select the Optimize button.

To get support in Outlook.com, click here or select Help on the menu bar and enter your query. If the self-help doesn't solve your problem, scroll down to Still need help? and select Yes. To contact us in Outlook.com, you'll need to sign in. If you can't sign in, click here .

OneDrive desktop app. To access your OneDrive settings, click or tap the OneDrive icon in the taskbar or notification area. If you don't see the OneDrive icon, OneDrive might not be running. On a PC, go to Start, type OneDrive in the search box, and then click OneDrive in the search results. You might need to click the Show hidden icons arrow ...

If you want to change multiple aspects of the taskbar at one time, use Taskbar settings. Press and hold (or right-click) any empty space on the taskbar, and then select Taskbar settings. In the Taskbar settings, scroll to see the options for customizing, choosing icons, and much more. Note: The Taskbar settings allow you to align taskbar icons ...

There are several ways you can find what you need. Select Start , select All apps, and then scroll through the alphabetical list on the left. Tip: To reduce scrolling you can select any letter in the list, then in the alphabet links that display, select a letter to jump down to that section. For example, select "T" if you're looking for the ...

If the AutoRecover option is turned on, you can automatically save versions of your file while you’re working on it. How you recover something depends on when you saved it. If you’ve saved the file. Open the file you were working on.

Tap the Windows Start button and type BitLocker. Select the Manage BitLocker Control Panel app from the list of search results. In the BitLocker app select Back up your recovery key. Select where you want the key backed up. Save to your Microsoft Account - This will save the key in the Recovery Keys library of your Microsoft Account where you ...

To sign in to your Microsoft personal account, go to account.microsoft.com or select Sign in below. Sign in. Tip: If you don't have a Microsoft account, you can select " No account? Create one! Enter your email, phone number, or Skype sign-in that you use for other services (Outlook, Excel, etc.), then select Next.