What is Power Automate?

What is 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...
XLOOKUP in Excel

XLOOKUP in 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...
VLOOKUP in Excel

VLOOKUP in 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...
How to Create a Drop Down List in Excel

How to Create a Drop Down List in 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...