Download our Formulas tutorial workbook. We've put together a Get started with Formulas workbook that you can download. If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour.

If you can’t locate a lost file from your backup, then you can use Windows File Recovery, which is a command line app available from the Microsoft Store.Use this app to try to recover lost files that have been deleted from your local storage device (including internal drives, external drives, and USB devices) and can’t be restored from the Recycle Bin.

If you've recently installed a Windows update and you are having a problem, here's how to uninstall the update to try to resolve the issue: Select the Start button, then select Settings > Update & Security > Windows Update > View update history > Uninstall updates. View update history settings

Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function.Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not be available in future versions of Excel.

Learn how to troubleshoot File Explorer problems in Windows. To open File Explorer in Windows 10, select its icon on the taskbar, press the Windows logo key + E on your keyboard, or select Start > Documents (directly beneath your user icon).. Here are some things to try if File Explorer won't open.

Import a text file by opening it in Excel. You can open a text file that you created in another program as an Excel workbook by using the Open command. Opening a text file in Excel does not change the format of the file — you can see this in the Excel title bar, where the name of the file retains the text file name extension (for example, .txt or .csv).

Both options allow essentially the same thing—you can access files on your local computer in File Explorer or Finder. However, adding OneDrive shortcuts allows content to be accessed on all devices, whereas sync is related to a specific device.

If you can't find a file on your computer or you accidently modified or deleted a file, you can restore it from a backup (if you're using Windows backup) or you can try to restore it from a previous version.Previous versions are copies of files and folders that Windows automatically saves as part of a restore point.

Important: Before trying any of the solutions below, make sure you back up your personal files. You can back up your Windows PC, or insert a USB drive and use File Explorer to drag and copy important files to the USB drive.If you’re signing into Windows with a Microsoft account, your system settings will be automatically restored after updating, once you’re connected to the internet.

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.