Quick tutorials, how-tos, articles, guides and resources on everything Microsoft Office 365, Word, Excel, PowerPoint, Outlook and more!
You can create your own text custom watermark in Microsoft Word. After creating the watermark, you can move it anywhere on your Word document.
QuickStarter in PowerPoint is a fast way to build an outline and suggested sections, talking points, and properly attributed Creative Commons images.
When you type in numbers in Excel, the leading zero will get dropped. Use the Text function in Excel to add back the leading zeros.
If you need to select an entire row using two conditions with Conditional Formatting in Excel, you need to write a formula using the AND function.
You can make a drop down list so only correct data is entered. If bad data is entered, sorting, filtering, pivottables, and other stuff will be incorrect.
If you need a cell to stay constant, you can make it an absolute reference cell to stay constant. Press the F4 function key to create an absolute reference.
Excel already has built-in custom lists for sorting, but you can create your own custom sort list in case you don't want to sort alphabetically or A to Z.
In a long Word document, it is often desirable to have Heading 1 styles show at the top of a new page and never have two headings 1 on the same page.
When you click Send on an email, it is typically sent immediately, but you can have it sent at a later time by using delayed delivery in Outlook.
Do find yourself typing the same message over and over in Microsoft Outlook? You can use Quick Parts in Outlook to create canned responses to emails.
If you are trying to chart values in Excel that are far apart numerically, you need to create a combo chart in Excel. It is very easy in Excel 2016.
Need to calculate the weighted average in Excel? It is very easy if you use the sumproduct function in Excel. This is useful for school or work.
