الكورس مناسب لكل مستويات مستخدمي الاكسيل ( المبتديء والمحترف والمتوسط ) يشمل جميع اوامر ومعادلات الاكسيل - المعادلات البسيطه والبدائيه والمعادلات المعقده والتي يحتاجها المحترفين - يشمل ايضا العديد من تريكات الاكسيل التي يجهلها كثير من المستخدمين - اذا كنت لا تعلم في الاكسيل شيئا سوف
تخرج من الكورس بفضل الله محترف للاكسيل وعلي درايه تامه بكل تفاصيل الاكسيل .

- This course for all excel users levels ( primary and advanced levels ) including all excel details & functions & formulas .

.
.
Excel Part 1 Lecture 1

Why should I learn Excel

Excel Program interface

Excel Part 1 Lecture 2

Create New File

Create New Template

Close Workbook

Excel Part 1 Lecture 3

Create New Template

Excel Part 1 Lecture 4

Customize your own tab

Add new tab and new group

Excel Part 1 Lecture 5

Over Writing & Editing cell content

Editing formula & function

Using undo & Redo

Find & Replace

Goto

Excel Part 1 Lecture 6

Font

Alignment

Number

Excel Part 1 Lecture 7

Characteristics

Relative reference

Absolute reference

Excel Part 1 Lecture 8

From where I can get speak cell option

Speak cell ( by row and by column )

Speak cell when I press enter

Excel Part 1 Lecture 9

How to replace spaces to column

Excel Part 1 Lecture 10

Insert Comments

Edit Comment

Delete comment

Show all comments

Excel Part 1 Lecture 11

Copy & Paste

Paste special

Copying cells to one or many cells

Copying to different work sheets

using filling for quick copying

Excel Part 1 Lecture 12

Filling & Drag Numbers / Days / Months / years

Custom options

Fill down & Right

Excel Part 1 Lecture 13

Filling Series With Formatting

Filling Without formatting

Filling Aweek days

Filling Days

Excel Part 1 Lecture 14

Flash Fill CTRL + E

Excel Part 1 Lecture 15

Hide Column / Row

Freezing Panes

Splitting windows

Excel Part 1 Lecture 16

Create Custom Views

Displaying Custom Views

Deleting Custom Views

Excel Part 1 Lecture 17

Inserting / Deleting Cells

Inserting / Deleting Columns

Inserting / Deleting Rows

Resize Cells / Columns / Rows

Excel Part 1 Lecture 18

Insert & Delete & Rename Worksheet

Copying & Moving Worksheets

Hide & Unhide Worksheet

Changing Worksheet tab Colour

Format after Grouping

Comparing 2 Worksheets

Excel Part 1 Lecture 19

Revision

Case Study (Progress Report)

Case Study (Time Sheet)

Case Study (Products Coding)

Excel Part 1 Lecture 20

Logical Test

If Function

Advanced IF Function ( Nested IF )

Excel Part 1 Lecture 21

IF AND Function

IF error Function

Auditing Tools ( Displaying and removing dependent , precedent arrows )

Formula text ( To show the Cell formula as a text )

Excel Part 1 Lecture 22

Trim Function ( to remove extra spaces )

Proper Function ( first letter capital )

Upper function ( text change to upper cases )

lower function ( text change to lower cases )

len function ( to calculate length of the text including spaces )

Left & right & mid & concatenate functions ( To right appreviation )

find & search & replace & substitute functions ( to change some letters )

Date functions ( today & now & day & month & year & date )

Add days & months & years

networking days

net working days internationaly

changing date format to show only day ( custom format for the date )

Excel Part 1 Lecture 23

to calculate different in years between 2 dates ( =datedif(D1,D2,"Y")

to calculate different in months between 2 dates ( =datedif(D1,D2,"M")

to calculate different in days between 2 dates ( =datedif(D1,D2,"d")

define & Edit & Delete name range ( formula - name manager - new )

Examples for name range Usage

Excel Part 1 Lecture 24

add - subtract - divide - multiply

brackets usage

count - countA - count blank -count if

sumif - count if - avergaeif

sumifs - countifs - avergaeifs

Excel Part 1 Lecture 25

( Sumproduct - Floor - Ceiling ) Formulas

vlookup Formula

vlookup Formula with data validation

vlookup with Name range

vlookup with approximate match

vlookup with trim ( 2 cases )

Excel Part 1 Lecture 26

Hlookup Formula

Vlookup Formula rules ( unique & left to right & belong to 1st column )

Lookup Formula ( horizontal & vertical & approximate & result belong to last col & result vector )

Excel Part 1 Lecture 27

Index & Match formulas

lock & unlock cell

protect the sheet

Excel Part 1 Lecture 28

Protect Workbook

hyperlink to a sheet

hyperlink to a file

hyperlink to a web page

page setup for printing ( margins - orientation - print area - print size - page break - background - print titles )

Excel Part 1 Lecture 29

Header & footer ( page number & date & file name )

Data Sorting ( Numbers - Text - dates - Multicolumn sorting - color sorting )

advanced sort

advanced filter

advanced filter error

Excel Part 1 Lecture 30

check box - Data filtering - Number filtering - Text filter - Search - copy & paste filtered data

Create table - Sort - Sort by color - design tab - table style options

Excel Part 1 Lecture 31

Advanced table ( rename table - resize table - slicer for table - remove duplicates - convert table to range )

Subtotals ( subtotal option - hide all data except subtotal -

Excel Part 1 Lecture 32

Charts type ( column chart - Bar chart - Pie chart - X Y scatter chart - sparklines formatting )

Charts elements ( chart area - plat area - series - data labels - vertical and horizontal axes - gridlines - chart titles )

Chart format & Options

format chart ( Double click )

Excel Part 1 Lecture 33

Bar Chart

Pie Chart

Column Vs Line Chart

Excel Part 1 Lecture 34

Spark line chart

Pivot chart

Excel Part 1 Lecture 35 Revision 1

Create & Close Files

Create Template

Tabs & Groups

Editing Data

Formatting in Excel

characteristics of cells

Speak Cells

Excel Part 1 Lecture 36 Revision 2

Conditional formatting

format cell options

spelling check

Text to column

Comments

Copying and Filling

Advanced Filling

sheet protection

Work sheets Views

Comparing Files

Excel Part 1 Lecture 37 Revision 3

Logical test

IF function

Advanced if function

IF AND

IF ERROR

Auditing Tools

Formula text

Evaluate formula

Excel Part 1 Lecture 38 Revision 4

Trim Function ( to remove extra spaces )

Proper Function ( first letter capital )

Upper function ( text change to upper cases )

lower function ( text change to lower cases )

len function ( to calculate length of the text including spaces )

Left & right & mid & concatenate functions ( To right appreviation )

find & search & replace & substitute functions ( to change some letters )

Date functions ( today & now & day & month & year & date )

Add days & months & years

networking days

net working days internationaly

changing date format to show only day ( custom format for the date )

Header and Footer & Data sorting and advanced filtering

Data Filtering & Creating table

Table advanced option & Subtotal

Charts & Chart Format

Pivot Chart