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