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