What You Will Learn!
- الشاشه الافتتاحيه للاكسيل وكيفيه انشاء ملف جديد واعداد الاكسيل للعمل
- Power Query - Pivot table - Pivot charts - Slicers - Vlockup - HLockup - X Lockup - Filtering options - Advanced filtering - Copy & paste special
- جميع المعادلات البدائيه والمتقدمه للاكسيل
- كيفيه عمل جداول وربطها ببعضها البعض
- كيفيه عمل تقارير مفصله باستخدام الاكسيل
- لو لم يكن عندك خبره بالاكسيل مسبقه سوف تخرج من هذا الكورس محترف للاكسيل بمعني الكلمه
- الكورس في حاله زياده دائمه بمعني انك سوف تستفيد المحاضرات الاضافيه التي نرفعها باستمرار لان هدفنا ان يكون اقوي كورس اكسيل اونلاين
Description
الكورس مناسب لكل مستويات مستخدمي الاكسيل ( المبتديء والمحترف والمتوسط ) يشمل جميع اوامر ومعادلات الاكسيل - المعادلات البسيطه والبدائيه والمعادلات المعقده والتي يحتاجها المحترفين - يشمل ايضا العديد من تريكات الاكسيل التي يجهلها كثير من المستخدمين - اذا كنت لا تعلم في الاكسيل شيئا سوف
تخرج من الكورس بفضل الله محترف للاكسيل وعلي درايه تامه بكل تفاصيل الاكسيل .
- 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
Who Should Attend!
- Engineers - Accountants - Students - Any one using Excel in his work
