Tutorial 67: COLUMN & IFERROR function within VLOOKUP function in Excel | FREE Excel Course

In this tutorial, I’m going to be showing you how to: Use the VLOOKUP function Use the COLUMN function to replace the COLUMN INDEX within VLOOKUP Use the IFERROR function with VLOOKUP to remove error messages Habib’s FREE Microsoft Excel Course: 👉 CLICK HERE Download the Excel file below, and save it onto your computer. … Read more

Tutorial 66: How to use IFERROR function with VLOOKUP in Excel | FREE Excel Course

In this tutorial, I’m going to be showing you how to: Understand the purpose and when to use the IFERROR function Use the IFERROR function with VLOOKUP Use the IFERROR function with Multiplication formula Habib’s FREE Microsoft Excel Course: 👉 CLICK HERE Download the Excel file below, and save it onto your computer. So you … Read more

Tutorial 65: VLOOKUP function in Excel | FREE Excel Course

In this tutorial, I’m going to be showing you how to: Understand the purpose of the VLOOKUP function Use the VLOOKUP function Why using Tables is effective for VLOOKUP Habib’s FREE Microsoft Excel Course: 👉 CLICK HERE Download the Excel file below, and save it onto your computer. So you can complete this lesson with … Read more

Lesson 64: Create Drop-down lists in Excel | Input message to a drop-down list | FREE Excel Course

In this lesson, I’m going to be showing you how to: What is a Drop-down list? Create a drop-down list Add an input message to a drop-down list Habib’s FREE Microsoft Excel Course: 👉 CLICK HERE Download the Excel file below, and save it onto your computer. So you can complete this lesson with me. … Read more

Lesson 63: Create a table in Excel | Convert data range into a table in Excel | FREE Excel Course

In this lesson, I’m going to be showing you how to: Convert a range of cells of data into an Excel table Understand the benefits of an Excel table Habib’s FREE Microsoft Excel Course: 👉 CLICK HERE Download the Excel file below, and save it onto your computer. So you can complete this lesson with … Read more

How to Host a Zoom meeting | Comprehensive Zoom meeting tutorial | Habib’s ICT Tutorials

In this tutorial, I’m going to be showing you how to: Host a zoom meeting Join & download zoom Invite participants Mute/unmute mic Stop/start video Share screens & use whiteboard Chat (text form) Share files Record the zoom session Settings to manage all participants Go ahead, open the video below and watch the tutorial at … Read more

How to join a Zoom meeting through a Web Browser | No download required | No installation required

In this tutorial, I’m going to be showing you how to: Join a Zoom meeting through a Web Browser No download required! No installation required! Go ahead, open the video below and watch the tutorial at your own pace: If I have not covered everything in this tutorial, please leave a comment or your question … Read more

How to get Microsoft Office for FREE legally | Word | Excel | PowerPoint | OneDrive

In this tutorial, I’m going to be showing you how to: Get Microsoft Office for FREE Word, Excel, PowerPoint, OneNote, OneDrive and many more for FREE Go ahead, open the video below and watch the tutorial at your own pace: If I have not covered everything in this tutorial, please leave a comment or your … Read more

Lesson 13: How to Format cells as Currency, Date, Percentages and apply Decimal Places to numbers in Excel

In this lesson, I’m going to be showing you how to: Format cells as Currency (£) in Excel Format cells as Accountancy (£) in Excel Format cells as Percentages in Excel Format cells as Dates in Excel Apply Decimal places to numbers in Excel Download the Excel file below, and save it onto your computer. … Read more

Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit

In this lesson, I’m going to be showing you how to: Understand what the Wrap Text feature does in Excel Wrap Text manually and automatically, to fit the contents within the cell on multiple lines Create manual line breaks by using the keyboard shortcut – Alt and Enter Shrink to Fit – so text will … Read more