Habib's ICT Tutorials

@UCBfGJLMmTIA3ESh9DFYWLIg - 3.8K subscribers

Hello there 🖐 My name is Habib Ali and I'm an ICT tutor from the UK. I have created this channel and uploaded my first video in June 2020, during the covid19 lock-down. My channel's sole purpose is to help and educate all my subscribers, fans and visitors with all my knowledge I have acquired as a passionate graduate in the ICT field and with my academic qualifications as an ICT tutor. Here are some of the contents my channel's videos will be about: Free series of ICT Courses on Microsoft Office. - FREE Excel Course - FREE Advanced Excel Course - FREE Excel formulas & functions Course * many more courses and lessons are being created every week Video tutorials will be available on: - FREE Microsoft Word Course - FREE Microsoft PowerPoint Course - FREE Microsoft Access Course - FREE Microsoft Publisher Course - FREE Microsoft Windows Course * courses on many other Microsoft Office applications too Video tutorials on the following platforms: - Youtube - Facebook - WordPress

Home Videos Live Playlists

Tutorial 67: Lookup a full record using COLUMN function within VLOOKUP in Excel | FREE Excel Course

Tutorial 67: Lookup a full record using COLUMN function within VLOOKUP in Excel | FREE Excel Course Habib's ICT Tutorials

1.5K views - 4 years ago

Tutorial 66: IFERROR function with VLOOKUP in Excel | Remove ERROR messages | FREE Excel Course

Tutorial 66: IFERROR function with VLOOKUP in Excel | Remove ERROR messages | FREE Excel Course Habib's ICT Tutorials

4K views - 4 years ago

Tutorial 65: VLOOKUP function in Excel | FREE Excel Course

Tutorial 65: VLOOKUP function in Excel | FREE Excel Course Habib's ICT Tutorials

1.9K views - 4 years ago

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

Lesson 64: Create Drop-down lists in Excel | Input message to a drop-down list | FREE Excel Course Habib's ICT Tutorials

1.9K views - 5 years ago

Lesson 63: Create a table in Excel | Convert data to Excel table | Benefits of tables in Excel

Lesson 63: Create a table in Excel | Convert data to Excel table | Benefits of tables in Excel Habib's ICT Tutorials

1.9K views - 5 years ago

How to Host a Zoom meeting | Zoom for Teachers and Trainers | Comprehensive Zoom meeting tutorial

How to Host a Zoom meeting | Zoom for Teachers and Trainers | Comprehensive Zoom meeting tutorial Habib's ICT Tutorials

1.8K views - 5 years ago

How to join a Zoom meeting through a Web Browser | Join Zoom without downloading or installing it!

How to join a Zoom meeting through a Web Browser | Join Zoom without downloading or installing it! Habib's ICT Tutorials

33.4K views - 5 years ago

How to get Microsoft Office 365 for FREE 2021 Legally | Word | Excel | PowerPoint | OneDrive

How to get Microsoft Office 365 for FREE 2021 Legally | Word | Excel | PowerPoint | OneDrive Habib's ICT Tutorials

6.5K views - 5 years ago

SUM function in Excel | #shorts | Understand it in 60 seconds

SUM function in Excel | #shorts | Understand it in 60 seconds Habib's ICT Tutorials

788 views - 5 years ago

Lesson 13: Format Cells as Currency, Date, Percentages & Decimal Places in Excel | FREE Excel Course

Lesson 13: Format Cells as Currency, Date, Percentages & Decimal Places in Excel | FREE Excel Course Habib's ICT Tutorials

2.7K views - 5 years ago

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

Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit | FREE Excel Course Habib's ICT Tutorials

3.2K views - 5 years ago

Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells | FREE Excel Course

Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells | FREE Excel Course Habib's ICT Tutorials

2.1K views - 5 years ago

Lesson 10: How to use the INSERT FUNCTION command in Excel | FREE Excel Course

Lesson 10: How to use the INSERT FUNCTION command in Excel | FREE Excel Course Habib's ICT Tutorials

3.2K views - 5 years ago

Lesson 9: Subtraction Formula in Excel | FREE Excel Course

Lesson 9: Subtraction Formula in Excel | FREE Excel Course Habib's ICT Tutorials

1.9K views - 5 years ago

Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells with TEXT data in Excel

Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells with TEXT data in Excel Habib's ICT Tutorials

2.8K views - 5 years ago

Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel

Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel Habib's ICT Tutorials

2.4K views - 5 years ago

Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel

Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel Habib's ICT Tutorials

3.5K views - 5 years ago

Lesson 5: Average Function in Excel | What does Average mean | FREE Excel Course

Lesson 5: Average Function in Excel | What does Average mean | FREE Excel Course Habib's ICT Tutorials

3.5K views - 5 years ago

Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel | FREE Excel Course

Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel | FREE Excel Course Habib's ICT Tutorials

3.6K views - 5 years ago

Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look attractive | FREE Excel Course

Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look attractive | FREE Excel Course Habib's ICT Tutorials

4.3K views - 5 years ago

Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Excel Course

Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Excel Course Habib's ICT Tutorials

5.4K views - 5 years ago

Introduction to my YouTube channel | Introduction to Habib's ICT Tutorials

Introduction to my YouTube channel | Introduction to Habib's ICT Tutorials Habib's ICT Tutorials

2.2K views - 5 years ago

Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Excel Course

Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Excel Course Habib's ICT Tutorials

16.6K views - 5 years ago

Lesson 62: The AverageA function in Excel | FREE Series of Microsoft Excel Lessons

Lesson 62: The AverageA function in Excel | FREE Series of Microsoft Excel Lessons Habib's ICT Tutorials

2.1K views - 5 years ago

Lesson 61: AVERAGEIFS function in Excel | Find the average value by using many criterias in excel

Lesson 61: AVERAGEIFS function in Excel | Find the average value by using many criterias in excel Habib's ICT Tutorials

2.1K views - 5 years ago

Lesson 60: The AVERAGEIF function in Excel | FREE Series of Microsoft Excel Lessons

Lesson 60: The AVERAGEIF function in Excel | FREE Series of Microsoft Excel Lessons Habib's ICT Tutorials

2.4K views - 5 years ago

Lesson 59: FORMULATEXT function in Excel | Display formulas or functions of individual cells only

Lesson 59: FORMULATEXT function in Excel | Display formulas or functions of individual cells only Habib's ICT Tutorials

1.7K views - 5 years ago

Lesson 58: SUMIFS function in Excel to ADD multiple CRITERIONS from different columns

Lesson 58: SUMIFS function in Excel to ADD multiple CRITERIONS from different columns Habib's ICT Tutorials

2.3K views - 5 years ago

Lesson 57: SUMIF function used to ADD MULTIPLE different items in one column in Excel | SUMIF+SUMIF

Lesson 57: SUMIF function used to ADD MULTIPLE different items in one column in Excel | SUMIF+SUMIF Habib's ICT Tutorials

1.9K views - 5 years ago

Lesson 56: SUMIF function in Excel | FREE Series of Microsoft Excel Lessons

Lesson 56: SUMIF function in Excel | FREE Series of Microsoft Excel Lessons Habib's ICT Tutorials

1.9K views - 5 years ago

Lesson 55: COUNT function in Excel | COUNTA function in Excel | COUNTBLANK function in Excel

Lesson 55: COUNT function in Excel | COUNTA function in Excel | COUNTBLANK function in Excel Habib's ICT Tutorials

1.8K views - 5 years ago

Lesson 54: COUNTIFS function in Excel | How to use Data Filter in Excel | FREE MS Excel Lessons

Lesson 54: COUNTIFS function in Excel | How to use Data Filter in Excel | FREE MS Excel Lessons Habib's ICT Tutorials

2K views - 5 years ago

Lesson 53: COUNTIF function used to COUNT MULTIPLE different items in a column in Excel

Lesson 53: COUNTIF function used to COUNT MULTIPLE different items in a column in Excel Habib's ICT Tutorials

2.5K views - 5 years ago

Lesson 52: COUNTIF function in Excel | FREE Series of Microsoft Excel Lessons

Lesson 52: COUNTIF function in Excel | FREE Series of Microsoft Excel Lessons Habib's ICT Tutorials

2K views - 5 years ago

Lesson 51: How to use FILTER DATA in Excel | Number Filters: Greater Than Or Equal To | Less Than

Lesson 51: How to use FILTER DATA in Excel | Number Filters: Greater Than Or Equal To | Less Than Habib's ICT Tutorials

7.1K views - 5 years ago

Lesson 50: How to LINK data and ADD up cells from a DIFFERENT WORKBOOK in Excel

Lesson 50: How to LINK data and ADD up cells from a DIFFERENT WORKBOOK in Excel Habib's ICT Tutorials

1.8K views - 5 years ago

Lesson 49: How to LINK data and ADD up cells from MULTIPLE different worksheets in Excel

Lesson 49: How to LINK data and ADD up cells from MULTIPLE different worksheets in Excel Habib's ICT Tutorials

1.7K views - 5 years ago

Lesson 48: Hide & Unhide Worksheets in Excel | Hide Worksheets, so it CANNOT be unhidden easily!

Lesson 48: Hide & Unhide Worksheets in Excel | Hide Worksheets, so it CANNOT be unhidden easily! Habib's ICT Tutorials

1.2K views - 5 years ago

Lesson 47 - How to Hide & Unhide Multiple Rows & Columns in Excel | FREE Series of MS Excel Lessons

Lesson 47 - How to Hide & Unhide Multiple Rows & Columns in Excel | FREE Series of MS Excel Lessons Habib's ICT Tutorials

1.3K views - 5 years ago

Lesson 46 - Find & Replace in Excel | Match Case & Match Entire Cell Contents | Explained thoroughly

Lesson 46 - Find & Replace in Excel | Match Case & Match Entire Cell Contents | Explained thoroughly Habib's ICT Tutorials

2.7K views - 5 years ago

Lesson 45 - How to apply borders around and in-between cells in Excel | FREE Microsoft Excel Lessons

Lesson 45 - How to apply borders around and in-between cells in Excel | FREE Microsoft Excel Lessons Habib's ICT Tutorials

1.1K views - 5 years ago

Lesson 44 - Use the IF function to work out if you are over BUDGET in Excel | FREE Excel Lessons

Lesson 44 - Use the IF function to work out if you are over BUDGET in Excel | FREE Excel Lessons Habib's ICT Tutorials

2.9K views - 5 years ago

Lesson 43 - How to change a DATE to different FORMATS in Excel | FREE Series Microsoft Excel Lessons

Lesson 43 - How to change a DATE to different FORMATS in Excel | FREE Series Microsoft Excel Lessons Habib's ICT Tutorials

1K views - 5 years ago

Lesson 42 - How to set and print rows & titles automatically at the top of each page in Excel

Lesson 42 - How to set and print rows & titles automatically at the top of each page in Excel Habib's ICT Tutorials

1.1K views - 5 years ago

Lesson 41 - How to display and print GRIDLINES and ROW & COLUMN HEADINGS in Excel

Lesson 41 - How to display and print GRIDLINES and ROW & COLUMN HEADINGS in Excel Habib's ICT Tutorials

1.8K views - 5 years ago

Lesson 40 - How to MOVE a chart to a new worksheet in Excel | Rename a worksheet | FREE Excel Lesson

Lesson 40 - How to MOVE a chart to a new worksheet in Excel | Rename a worksheet | FREE Excel Lesson Habib's ICT Tutorials

1.3K views - 5 years ago

Lesson 39 - How to insert a LINE chart with MARKERS in Excel | Select non-adjacent data in Excel

Lesson 39 - How to insert a LINE chart with MARKERS in Excel | Select non-adjacent data in Excel Habib's ICT Tutorials

2.4K views - 5 years ago

Lesson 38 - How to add DATA LABELS to charts in Excel | Change colour of pie-chart segments in Excel

Lesson 38 - How to add DATA LABELS to charts in Excel | Change colour of pie-chart segments in Excel Habib's ICT Tutorials

1.6K views - 5 years ago

Lesson 37 - How to CHANGE the CHART from one TYPE to another in Excel | Column chart to Pie chart

Lesson 37 - How to CHANGE the CHART from one TYPE to another in Excel | Column chart to Pie chart Habib's ICT Tutorials

1.3K views - 5 years ago

Lesson 36 - Best method to COPY a CHART to a new worksheet in Excel | Making sure data is LINKED!

Lesson 36 - Best method to COPY a CHART to a new worksheet in Excel | Making sure data is LINKED! Habib's ICT Tutorials

3.2K views - 5 years ago

Lesson 35 - How to insert a NEW worksheet in-between 2 worksheets in Excel | Rearrange worksheets

Lesson 35 - How to insert a NEW worksheet in-between 2 worksheets in Excel | Rearrange worksheets Habib's ICT Tutorials

1.4K views - 5 years ago

Lesson 34 - What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in Excel

Lesson 34 - What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in Excel Habib's ICT Tutorials

2.9K views - 5 years ago

Lesson 33 - How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart?

Lesson 33 - How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart? Habib's ICT Tutorials

1.8K views - 5 years ago

Lesson 32 - What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel

Lesson 32 - What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel Habib's ICT Tutorials

2.1K views - 5 years ago

Lesson 31 - Relative OR Absolute references in Excel | Everything explained | Confusion solved!

Lesson 31 - Relative OR Absolute references in Excel | Everything explained | Confusion solved! Habib's ICT Tutorials

1.5K views - 5 years ago

Lesson 30 - Format numbers to display as PERCENTAGES in Excel | FREE Series of MS Excel Lessons

Lesson 30 - Format numbers to display as PERCENTAGES in Excel | FREE Series of MS Excel Lessons Habib's ICT Tutorials

1.2K views - 5 years ago

Lesson 29 - Everything you need to know about ABSOLUTE cell references before replicating in Excel

Lesson 29 - Everything you need to know about ABSOLUTE cell references before replicating in Excel Habib's ICT Tutorials

1.3K views - 5 years ago

Lesson 28 - A simple DIVISION formula in Excel | FREE Series of Microsoft Excel Lessons

Lesson 28 - A simple DIVISION formula in Excel | FREE Series of Microsoft Excel Lessons Habib's ICT Tutorials

1.5K views - 5 years ago

Lesson 27 - What is the thousand separator in Excel | How to use the thousand separator in Excel

Lesson 27 - What is the thousand separator in Excel | How to use the thousand separator in Excel Habib's ICT Tutorials

5.7K views - 5 years ago

Lesson 26 - Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button?

Lesson 26 - Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button? Habib's ICT Tutorials

1.4K views - 5 years ago