by admin | May 26, 2020 | microsoft flow, Power automate
Power Automate We’re loving Power Automate at Trainers Direct! Power Automate (otherwise known as Microsoft Flow) is probably one of the most unknown tools that you already have… Login to your Office365 portal and you’ll find that this tool is included in your Office...
by admin | May 11, 2020 | Excel
What is XLOOKUP in Excel? WATCH THE video. XLOOKUP is the newest member of the Excel lookup function family and is availabile in the new Office 365 Excel versions. You may already be familiar with VLOOKUP, and other functions such as HLOOKUP, INDEX and MATCH. XLOOKUP...
by admin | May 7, 2020 | Excel
What is VLOOKUP in Excel? The VLOOKUP function in Excel is used when you need to find things in a table or a range by row. For example, you might need to look up a price using a part number, or find an employee name based on their employee code. In the following...
by admin | May 4, 2020 | Excel
How to Create a Drop Down List in Excel 1. Create a Simple Down List Manual data entry into Excel can lead to many errors. Imagine for instance, users having the ability to manually enter a country name into a column, UK, United Kingdom, U.K. England, well there's...
Recent Comments