Never stop talking " STOP the Gaza Genocide "

Excel for Finance & Accounting | Habib's ICT Tutorials

Habib's ICT Tutorials

Habib's ICT Tutorials

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 Microso

Course Details

Course Lessons

  1. 1 | Lesson 1: Introduction to Microsoft Excel Excel Interface FREE Excel Course 00:18:02
  2. 2 | Lesson 2: SUM function in Excel Entering Text & Numbers FREE Excel Course 00:16:03
  3. 3 | Lesson 3: Formatting Cells in Excel Make a Spreadsheet look attractive FREE Excel Course 00:20:21
  4. 4 | Lesson 4: Multiplication Formula in Excel Replicate or Copy Formulas in Excel FREE Excel Course 00:12:09
  5. 5 | Lesson 5: Average Function in Excel What does Average mean FREE Excel Course 00:14:55
  6. 6 | Lesson 6: MIN & MAX function in Excel Find the Minimum and Maximum value within a range in Excel 00:14:56
  7. 7 | Lesson 7: Count & CountA function in Excel Difference between Count and CountA function in Excel 00:10:12
  8. 8 | Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells with TEXT data in Excel 00:11:08
  9. 9 | Lesson 9: Subtraction Formula in Excel FREE Excel Course 00:08:14
  10. 10 | Lesson 10: How to use the INSERT FUNCTION command in Excel FREE Excel Course 00:17:53
  11. 11 | Lesson 11: Merge & Center in Excel Merge Across Merge Cells FREE Excel Course 00:11:37
  12. 12 | Lesson 12: Wrap Text in Excel Break Text to Multiple Lines Shrink to Fit FREE Excel Course 00:10:26
  13. 13 | Lesson 13: Format Cells as Currency, Date, Percentages & Decimal Places in Excel FREE Excel Course 00:22:15
  14. 14 | Lesson 14: How to insert a HEADER in Excel Insert an AUTOMATIC FILENAME in the header in Excel 00:11:09
  15. 15 | Lesson 15: Format the Font Color in Excel Shade or Fill Color cells in Excel FREE Excel Course 00:05:26
  16. 16 | Lesson 16: What is Page Orientation in Excel Change Portrait orientation to Landscape in Excel 00:05:52
  17. 17 | Lesson 17: How to PRINT spreadsheet SHOWING the formulas and functions in Excel FREE Excel Course 00:05:19
  18. 18 | Lesson 18: What is a Formula and Function in Excel Difference between Formula & Function in Excel 00:12:47
  19. 19 | Lesson 19: What is a Workbook & Worksheet in Excel Difference between Workbook & Worksheet 00:07:09
  20. 20 | Lesson 20: How to select multiple NON-ADJACENT cells in Excel FREE Excel Course 00:07:32
  21. 21 | Lesson 21: How to COPY cells from one spreadsheet to another spreadsheet in Excel 00:07:57
  22. 22 | Lesson 22 - How to RENAME a worksheet in Excel FREE Excel Course 00:02:35
  23. 23 | Lesson 23: Best techniques to widen columns & adjust the height of rows in Excel FREE Excel Course 00:10:56
  24. 24 | Lesson 24 - How to SORT data in ASCENDING order in Excel FREE Excel Course 00:10:16
  25. 25 | Lesson 25 - Everything you need to know about FREEZING PANES (rows & columns) in Excel 00:16:54
  26. 26 | Lesson 26 - Use the AUTOSUM button to quickly ADD up cells in Excel What is the Autosum Button? 00:07:55
  27. 27 | Lesson 27 - What is the thousand separator in Excel How to use the thousand separator in Excel 00:07:14
  28. 28 | Lesson 28 - A simple DIVISION formula in Excel FREE Series of Microsoft Excel Lessons 00:06:02
  29. 29 | Lesson 29 - Everything you need to know about ABSOLUTE cell references before replicating in Excel 00:13:56
  30. 30 | Lesson 30 - Format numbers to display as PERCENTAGES in Excel FREE Series of MS Excel Lessons 00:05:42
  31. 31 | Lesson 31 - Relative OR Absolute references in Excel Everything explained Confusion solved! 00:22:33
  32. 32 | Lesson 32 - What is Scale to Fit in Excel How to use Scale to Fit (shrink pages) in Excel 00:14:02
  33. 33 | Lesson 33 - How to insert an Embedded Clustered Column Chart in Excel What is a Clustered Chart? 00:10:14
  34. 34 | Lesson 34 - What is the PLOT & CHART AREA on a chart in Excel How to SHADE the plot area in Excel 00:08:22
  35. 35 | Lesson 35 - How to insert a NEW worksheet in-between 2 worksheets in Excel Rearrange worksheets 00:06:37
  36. 36 | Lesson 36 - Best method to COPY a CHART to a new worksheet in Excel Making sure data is LINKED! 00:09:48
  37. 37 | Lesson 37 - How to CHANGE the CHART from one TYPE to another in Excel Column chart to Pie chart 00:03:46
  38. 38 | Lesson 38 - How to add DATA LABELS to charts in Excel Change colour of pie-chart segments in Excel 00:16:57
  39. 39 | Lesson 39 - How to insert a LINE chart with MARKERS in Excel Select non-adjacent data in Excel 00:05:34
  40. 40 | Lesson 40 - How to MOVE a chart to a new worksheet in Excel Rename a worksheet FREE Excel Lesson 00:05:41
  41. 41 | Lesson 41 - How to display and print GRIDLINES and ROW & COLUMN HEADINGS in Excel 00:07:33
  42. 42 | Lesson 42 - How to set and print rows & titles automatically at the top of each page in Excel 00:07:56
  43. 43 | Lesson 43 - How to change a DATE to different FORMATS in Excel FREE Series Microsoft Excel Lessons 00:05:55
  44. 44 | Lesson 44 - Use the IF function to work out if you are over BUDGET in Excel FREE Excel Lessons 00:13:24
  45. 45 | Lesson 45 - How to apply borders around and in-between cells in Excel FREE Microsoft Excel Lessons 00:07:30
  46. 46 | Lesson 46 - Find & Replace in Excel Match Case & Match Entire Cell Contents Explained thoroughly 00:22:24
  47. 47 | Lesson 47 - How to Hide & Unhide Multiple Rows & Columns in Excel FREE Series of MS Excel Lessons 00:11:56
  48. 48 | Lesson 48: Hide & Unhide Worksheets in Excel Hide Worksheets, so it CANNOT be unhidden easily! 00:14:06
  49. 49 | Lesson 49: How to LINK data and ADD up cells from MULTIPLE different worksheets in Excel 00:21:03
  50. 50 | Lesson 50: How to LINK data and ADD up cells from a DIFFERENT WORKBOOK in Excel 00:28:11
  51. 51 | Lesson 51: How to use FILTER DATA in Excel Number Filters: Greater Than Or Equal To Less Than 00:14:05
  52. 52 | Lesson 52: COUNTIF function in Excel FREE Series of Microsoft Excel Lessons 00:16:12
  53. 53 | Lesson 53: COUNTIF function used to COUNT MULTIPLE different items in a column in Excel 00:17:19
  54. 54 | Lesson 54: COUNTIFS function in Excel How to use Data Filter in Excel FREE MS Excel Lessons 00:20:59
  55. 55 | Lesson 55: COUNT function in Excel COUNTA function in Excel COUNTBLANK function in Excel 00:09:19
  56. 56 | Lesson 56: SUMIF function in Excel FREE Series of Microsoft Excel Lessons 00:15:47
  57. 57 | Lesson 57: SUMIF function used to ADD MULTIPLE different items in one column in Excel SUMIF+SUMIF 00:22:14
  58. 58 | Lesson 58: SUMIFS function in Excel to ADD multiple CRITERIONS from different columns 00:23:54
  59. 59 | Lesson 59: FORMULATEXT function in Excel Display formulas or functions of individual cells only 00:07:14
  60. 60 | Lesson 60: The AVERAGEIF function in Excel FREE Series of Microsoft Excel Lessons 00:19:56
  61. 61 | Lesson 61: AVERAGEIFS function in Excel Find the average value by using many criterias in excel 00:14:51
  62. 62 | Lesson 62: The AverageA function in Excel FREE Series of Microsoft Excel Lessons 00:11:56
  63. 63 | Lesson 63: Create a table in Excel Convert data to Excel table Benefits of tables in Excel 00:27:50
  64. 64 | Lesson 64: Create Drop-down lists in Excel Input message to a drop-down list FREE Excel Course 00:13:28
  65. 65 | Tutorial 65: VLOOKUP function in Excel FREE Excel Course 00:16:34
  66. 66 | Tutorial 66: IFERROR function with VLOOKUP in Excel Remove ERROR messages FREE Excel Course 00:14:52
  67. 67 | Tutorial 67: Lookup a full record using COLUMN function within VLOOKUP in Excel FREE Excel Course 00:24:19
    Student Reviews

    ( 5 Of 5 )

    1 review
    5 Stars
    100%
    4 Stars
    0%
    3 Stars
    0%
    2 Stars
    0%
    1 Star
    0%
    Y
    Youtube

    29-07-2024
    Microsoft Excel Course - 65+ lessons

    These video tutorials will cover all the learning aspects of Excel, including formulas, functions, graphs and charts.
    I will also teach how to format data, setup the sheets, and many other features of Excel.
    If you do manage to complete ALL the Excel lessons here on this playlist, then you will have a very comprehensive knowledge of this amazing software.
    All the best
    Habib (ICT tutor)