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...
Our Top 10 Most Frequently asked Questions

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...
Conditional Formatting Dates in Excel

Conditional Formatting Dates in Excel

  Conditional Format Dates in Excel If you want to create a system in your spreadsheet to flag dates automatically when they become due you can do this by using conditional formatting. There is a built in option to do this which can be found under Home, Conditional...