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
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
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
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
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
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
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
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
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
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
