Practical tutorials, companion guides, and downloadable resources to help you get more done with Microsoft Office and other software.
Find Tutorials by Software
New & Updated Tutorials
- How to Use XLOOKUP for Multi Criteria Searches in Excel
Learn how to look up data based on criteria in multiple columns using XLOOKUP. For this example, I’m working with a spreadsheet of Portlandia TV series data and I want to add the title of the episode to the list of characters based on season and episode numbers which are stored on another sheet in my workbook. To do this, I have to tell Excel to combine the season and episode numbers, then use the XLOOKUP function to pull the corresponding episode title based upon season and episode numbers. - 2 Ways to Insert Filler Text in Microsoft Word
Learn two ways to insert filler text in Microsoft Word: lorem ipsum text or coherent English random text. - How to Set Up a Gmail Account in the New Outlook
Learn how to set up a Gmail account in the new Outlook. When looking through the apps on your computer, it will be listed as “Outlook (new).”
About the Site
This site complements my YouTube channel by providing written guides, downloadable practice files, and additional explanations.
Simple Software Tutorials 