Microsoft Excel كورس اكسيل من الصفر وحتي الاحتراف
What you'll learn
- تعلم الاكسل من الصفر حتي الاحتراف عن طريق 70 محاضره مفصله مع التدريب الشامل علي كل محتويات الاكسيل
Requirements
- No
Description
الكورس مناسب لكل مستويات مستخدمي الاكسيل ( المبتديء والمحترف والمتوسط ) يشمل جميع اوامر ومعادلات الاكسيل - المعادلات البسيطه والبدائيه والمعادلات المعقده والتي يحتاجها المحترفين - يشمل ايضا العديد من تريكات الاكسيل التي يجهلها كثير من المستخدمين - اذا كنت لا تعلم في الاكسيل شيئا سوف
تخرج من الكورس بفضل الله محترف للاكسيل وعلي درايه تامه بكل تفاصيل الاكسيل .
- This course for all excel users levels ( primary and advanced levels ) including all excel details & functions & formulas .
- Throw the 70 Lectures you will find all your answers for any question which may face you when you are using excel .
- You will find many advanced tools ( Pivot table - Pivot chart - Pie Chart - Advanced Tables - Advanced equations - Advanced formulas )
- All Formatting Options
- All Insert options & Data options
- LECTURE 1
Why should I learn Excel
Excel Program interface
LECTURE 2
Create New File
Create New Template
Close Workbook
LECTURE 3
Create New Template
LECTURE 4
Customize your own tab
Add new tab and new group
LECTURE 5
Over Writing & Editing cell content
Editing formula & function
Using undo & Redo
Find & Replace
Goto
LECTURE 6
Font
Alignment
Number
LECTURE 7
Characteristics
Relative reference
Absolute reference
LECTURE 8
From where I can get speak cell option
Speak cell ( by row and by column )
Speak cell when I press enter
LECTURE 9
How to replace spaces to column
LECTURE 10
Insert Comments
Edit Comment
Delete comment
Show all comments
LECTURE 11
Copy & Paste
Paste special
Copying cells to one or many cells
Copying to different work sheets
using filling for quick copying
LECTURE 12
Filling & Drag Numbers / Days / Months / years
Custom options
Fill down & Right
LECTURE 13
Filling Series With Formatting
Filling Without formatting
Filling Aweek days
Filling Days
LECTURE 14
Flash Fill CTRL + E
LECTURE 15
Hide Column / Row
Freezing Panes
Splitting windows
LECTURE 16
Create Custom Views
Displaying Custom Views
Deleting Custom Views
LECTURE 17
Inserting / Deleting Cells
Inserting / Deleting Columns
Inserting / Deleting Rows
Resize Cells / Columns / Rows
LECTURE 18
Insert & Delete & Rename Worksheet
Copying & Moving Worksheets
Hide & Unhide Worksheet
Changing Worksheet tab Colour
Format after Grouping
Comparing 2 Worksheets
LECTURE 19
Revision
Case Study (Progress Report)
Case Study (Time Sheet)
Case Study (Products Coding)
LECTURE 20
Logical Test
If Function
Advanced IF Function ( Nested IF )
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 )
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 )
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
LECTURE 24
add - subtract - divide - multiply
brackets usage
count - countA - count blank -count if
sumif - count if - avergaeif
sumifs - countifs - avergaeifs
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 )
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 )
LECTURE 27
Index & Match formulas
lock & unlock cell
protect the sheet
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 )
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
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
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 -
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 )
LECTURE 33
Bar Chart
Pie Chart
Column Vs Line Chart
LECTURE 34
Spark line chart
Pivot chart
LECTURE 35
Revision 1
Create & Close Files
Create Template
Tabs & Groups
Editing Data
Formatting in Excel
characteristics of cells
Speak Cells
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
LECTURE 37
Revision 3
Logical test
IF function
Advanced if function
IF AND
IF ERROR
Auditing Tools
Formula text
Evaluate formula
LECTURE 38
Revision 3
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
Lecture 39
Excel Tricks 1 CTRL + E
Lecture 40
Excel Tricks 2 CTRL + E
Lecture 41
Excel Tricks 3 CTRL + ; & Ctrl + E
Lecture 42
Excel Tricks 4 Custom List for dragging down
Lecture 43
Excel Tricks 5 Select Multi Sheets and make your work
Lecture 44
Quick access analysis tool
Lecture 45
Filter - table
Lecture 46
Data Validation ( Drop down list data validation )
Lecture 47
Auto fit columns & Rows
Lecture 48
Transpose ( تقلب الصف عمود والعمود صف )
Lecture 49
Remove duplicates
Lecture 50
Goal Seek ( Data - what if - goal seek ) ( محتاج احقق قيمه معينه )
Lecture 51
Vlockup
Lecture 52
Paste Sepacial
Lecture 53
changing chart columns to pattern or picture
Lecture 54
IF Function
Lecture 55
Insert ScreenShot ( insert - illustration - screenshot )
Lecture 56
Absolute Cell Reference
Lecture 57
Show Formula ( CTRL + ˜ )
Lecture 58
Convert Text to columns
Lecture 59
Conditional formatting
Lecture 60
Power Pivot
Lecture 61
Freeze Panes
Lecture 62
CTRL Arrow Ley to select last cell
Lecture 63
3D reference (جمع نفس الخليه في كل الشيتات )
Lecture 64
forecast sheet
Lecture 65
SUMIFS ـجميع القيم التي امام قيم معينه ( اكثر من criteria )
Lecture 66
IF ERROR - Advanced Transpose ( Live Edit ) تحديث القيم بعد عمل transpose عند تغيير القيم الاصليه
Lecture 67
Slicers
Lecture 68
Scenario Manager
Lecture 69
Convert Function
Lecture 70
Convert Currency Live
Who this course is for:
- Begineer on excel
Course content
- Preview12:19
- Preview03:09
- 04:10EXCEL COURSE LECTURE 3 Create Template
- 05:55EXCEL COURSE LECTURE 4 Tabs & Groups
- 11:59EXCEL COURSE LECTURE 5 Editing Data
- 09:42EXCEL COURSE LECTURE 6 Formatting in Excel
- 09:19EXCEL COURSE LECTURE 7 characteristics of cells كورس اكسيل محاضر 7 خصائص الخليه
- 07:23EXCEL COURSE LECTURE 8 Speak Cells ---- ( Speak Cell ) كورس اكسيل حلقه 8 خاصي
- 04:47EXCEL COURSE LECTURE 9 Text to column ---- كورس اكسيل حلقه 9
- 04:06EXCEL COURSE LECTURE 10 Comments ---- كورس اكسيل حلقه 10
- 10:17EXCEL COURSE LECTURE 11 Copying and Filling ---- كورس اكسيل حلقه 11
- 06:54EXCEL COURSE LECTURE 12 Advanced Filling ---- كورس اكسيل حلقه 12
- 06:20EXCEL COURSE LECTURE 13 Filling Without formatting ---- كورس اكسيل حلقه 13
- 04:22EXCEL COURSE LECTURE 14 Flash Fill ---- كورس اكسيل حلقه 14
- 13:38EXCEL COURSE LECTURE 15 Work sheets ---- كورس اكسيل حلقه 15
- 06:15EXCEL COURSE LECTURE 16 Work sheets Views ---- كورس اكسيل حلقه 16
- 10:54EXCEL COURSE LECTURE 17 Columns and Rows Size Adjusting ---- كورس اكسيل حلقه 17
- 18:05EXCEL COURSE LECTURE 18 Working With Worksheets & Comparing Files
- 38:35EXCEL COURSE LECTURE 19 Revision For Part 1 ( Lec 1 to 18 ) كورس اكسيل محاضره 1
- 15:58EXCEL COURSE Lecture 20 , Logical test & If Function
- Preview16:05
- 21:41EXCEL COURSE Lecture 22 , Text Function & Date Function
- 14:23EXCEL COURSE LECTURE 23 , Date Function & Name Range & Name range with formula
- 17:50EXCEL COURSE LECTURE 24 , Basic Formulas كورس اكسيل محاضره 24
- 16:37EXCEL COURSE LECTURE 25 , Vlockup Formula & More Formulas كورس اكسيل محاضره 25
- 13:29EXCEL COURSE LECTURE 26 , Hlockup & Loockup Formulas كورس اكسيل محاضره 26
- 10:26EXCEL COURSE LECTURE 27 , Index & Match formulas - Sheet protection
- 14:07EXCEL COURSE LECTURE 28 , Woorkbook protection
- 21:56EXCEL COURSE LECTURE 29 , Header and Footer & Data sorting and advanced filter
- 10:25EXCEL COURSE LECTURE 30
- 10:50EXCEL COURSE LECTURE 31 , Table advanced option & Subtotal
- 11:42EXCEL COURSE LECTURE 32
- 14:29EXCEL COURSE LECTURE 33
- 08:24EXCEL COURSE LECTURE 34 , spark line chart & Pivot chart
- 35:08EXCEL COURSE LECTURE 35 , Revision 1
- 30:28Excel Course Lecture 36 , Revision 2
- 36:03Excel Course Lecture 37 , Revision 3
- 34:33Excel Course Lecture 38 , Revision 4
Instructor
Iam Ahmed Samir , Civil Engineer with 8 years experience .
Iam Working in Dubai Civil Engineering , one of the leading construction companies in Dubai , i have worked in many project in Egypt and Dubai . I have a very good experience using most of computer programs & applications which i can share with my students .
I will follow my student even after the course is completed so i hope you join my courses and be sure that you will get huge experience in various fields .
i approximately have more than 4800 students registered in my courses .
أنا المهندس أحمد سمير - مهندس مدني عندي خبره 8 سنوات - اجيد استخدام العديد من برامج الحاسب الالي الخاصه بالهندسه وغيرها - اريد مشاركه هذه الخبره مع طلابي - سارع بالاشتراك في الدورات التدريبيه الخاصه بي وسوف تحصل علي العديد من المعلومات القيمه والمفيده .
لقد اشترك معنا ما يتعدي 4800 طالب احترفو برامج الاوفيس .
في انتظاركم في الكورسات التي نقدمها وتحياتي لكم .