Excel Custom Number Formats

Excel Custom Number Formats

Use Excel’s Custom Number Formats to Display Numbers with their Units of Measurement Alongside… e.g 50 Kg If you have a column of data that you want to show as a measurement unit such as Km, Kg, Lbs and so on, you can set up a custom format so that you...
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...
Setup a Microsoft Teams Meeting with External Users

Setup a Microsoft Teams Meeting with External Users

  Setup a Microsoft Teams Meeting with External Users Microsoft Teams is a great platform for working collaboratively but did you know that if you want to invite people outside of your organisation that this option has to be turned on? Read on for more … To...

How to Setup Microsoft Project

  Setup and Configure Microsoft Project like a Pro One of the most important factors in Microsoft Project is ensuring the configuration is correct right at the very start. This article shares some ideas on Project setup to ensure your favourite settings are saved and...
Create an Outlook Distribution List from Excel

Create an Outlook Distribution List from Excel

  STOP PRESS - it's business as usual at Trainers Direct as we GO LIVE... Amidst COVID-19 Trainers Direct has moved to online delivery. Motivate learners with virtual instructor led training that goes beyond just a lecture style environment. 1 on 1 or small groups....
Create an Outlook Distribution List from Excel

Our Top 10 Most Frequently asked Questions

Our Top 10 Most Frequently asked Questions Welcome to our Top 10 list of FAQs which I've compiled from recent training courses.  It's great to be able to demonstrate quick and easy ways to accomplish common tasks and troubleshoot using popular programs such as Excel...
Excel Convert Text to Numbers and Dates

Excel Convert Text to Numbers and Dates

  Excel - Convert Text to Numbers, Dates and More... Sometimes when data is imported into Excel from another system it can be problematic. A common example is where imported data is stored as text rather than a number or a date for instance. This causes problems when...