Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.

Pin the apps you use most often to the Start menu. Here's how: Select Start from the taskbar, then find the app you want to pin in the list or search for it by typing the app name in the search box.

Try it! Universal search. Select Search on the taskbar or press Windows logo key + S, then type what you want to find.You'll get personalized search results for people, email, and files in local and shared sites, or from the web. Desktop groups

The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.

Using clipboard. When you copy content on your PC, it’s automatically copied to your clipboard for you to paste. You can paste multiple items from your clipboard history, and you can also pin the items you tend to use all the time and sync your clipboard history to the cloud.

Get productive quickly with Microsoft 365 videos and tutorials. Explore Microsoft 365 training guides and tips to collaborate with anyone, anywhere.

Microsoft Edge を使用すると、Web を参照するときにパスワードを簡単に保存できます。 デスクトップまたはモバイル デバイスの Edge ブラウザーで新しいパスワードを入力すると、ユーザー名とパスワードを記憶するかどうかを Microsoft Edge から確認するメッセージが表示されます。

Under Edit signature, compose your signature.You can change fonts, font colors, and sizes, as well as text alignment. If you want to create a more robust signature with bullets, tables, or borders, use Word to create and format your signature text, then copy and paste it into the Edit signature box.You can also use a pre-designed template to create your signature.

Sign in to a work/school account using a remote computer. Many apps allow you to authenticate by entering a code on another device such as a PC.

How do I add or subtract Times? You can add and subtract times in a few different ways. For example, to get the difference between 8:00 AM - 12:00 PM for payroll purposes you would use: =("12:00 PM"-"8:00 AM")*24, taking the end time minus the start time.Note that Excel calculates times as a fraction of a day, so you need to multiply by 24 to get the total hours.