Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence CBT
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Marketing Strategy Google Ads (AdWords) Certification Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Startup Business Plan Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-02-14 18:38:52
30-Day Money-Back Guarantee
Finance & Accounting Finance Excel

Microsoft Excel كورس اكسيل من الصفر وحتي الاحتراف

كورس اكسيل من الصفر وحتي الاحتراف - 70 محاضره تشمل جميع اوامر ومعادلات واستخدامات الاكسيل
Rating: 4.6 out of 54.6 (112 ratings)
4,507 students
Created by Ahmed Samir Elsayed Abd Al Galil
Last updated 2/2021
Arabic
30-Day Money-Back Guarantee

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

2 sections • 74 lectures • 10h 45m total length

  • Preview12:19
  • Preview03:09
  • EXCEL COURSE LECTURE 3 Create Template
    04:10
  • EXCEL COURSE LECTURE 4 Tabs & Groups
    05:55
  • EXCEL COURSE LECTURE 5 Editing Data
    11:59
  • EXCEL COURSE LECTURE 6 Formatting in Excel
    09:42
  • EXCEL COURSE LECTURE 7 characteristics of cells كورس اكسيل محاضر 7 خصائص الخليه
    09:19
  • EXCEL COURSE LECTURE 8 Speak Cells ---- ( Speak Cell ) كورس اكسيل حلقه 8 خاصي
    07:23
  • EXCEL COURSE LECTURE 9 Text to column ---- كورس اكسيل حلقه 9
    04:47
  • EXCEL COURSE LECTURE 10 Comments ---- كورس اكسيل حلقه 10
    04:06
  • EXCEL COURSE LECTURE 11 Copying and Filling ---- كورس اكسيل حلقه 11
    10:17
  • EXCEL COURSE LECTURE 12 Advanced Filling ---- كورس اكسيل حلقه 12
    06:54
  • EXCEL COURSE LECTURE 13 Filling Without formatting ---- كورس اكسيل حلقه 13
    06:20
  • EXCEL COURSE LECTURE 14 Flash Fill ---- كورس اكسيل حلقه 14
    04:22
  • EXCEL COURSE LECTURE 15 Work sheets ---- كورس اكسيل حلقه 15
    13:38
  • EXCEL COURSE LECTURE 16 Work sheets Views ---- كورس اكسيل حلقه 16
    06:15
  • EXCEL COURSE LECTURE 17 Columns and Rows Size Adjusting ---- كورس اكسيل حلقه 17
    10:54
  • EXCEL COURSE LECTURE 18 Working With Worksheets & Comparing Files
    18:05
  • EXCEL COURSE LECTURE 19 Revision For Part 1 ( Lec 1 to 18 ) كورس اكسيل محاضره 1
    38:35
  • EXCEL COURSE Lecture 20 , Logical test & If Function
    15:58
  • Preview16:05
  • EXCEL COURSE Lecture 22 , Text Function & Date Function
    21:41
  • EXCEL COURSE LECTURE 23 , Date Function & Name Range & Name range with formula
    14:23
  • EXCEL COURSE LECTURE 24 , Basic Formulas كورس اكسيل محاضره 24
    17:50
  • EXCEL COURSE LECTURE 25 , Vlockup Formula & More Formulas كورس اكسيل محاضره 25
    16:37
  • EXCEL COURSE LECTURE 26 , Hlockup & Loockup Formulas كورس اكسيل محاضره 26
    13:29
  • EXCEL COURSE LECTURE 27 , Index & Match formulas - Sheet protection
    10:26
  • EXCEL COURSE LECTURE 28 , Woorkbook protection
    14:07
  • EXCEL COURSE LECTURE 29 , Header and Footer & Data sorting and advanced filter
    21:56
  • EXCEL COURSE LECTURE 30
    10:25
  • EXCEL COURSE LECTURE 31 , Table advanced option & Subtotal
    10:50
  • EXCEL COURSE LECTURE 32
    11:42
  • EXCEL COURSE LECTURE 33
    14:29
  • EXCEL COURSE LECTURE 34 , spark line chart & Pivot chart
    08:24
  • EXCEL COURSE LECTURE 35 , Revision 1
    35:08
  • Excel Course Lecture 36 , Revision 2
    30:28
  • Excel Course Lecture 37 , Revision 3
    36:03
  • Excel Course Lecture 38 , Revision 4
    34:33

  • Excel Trick 1
    03:34
  • Excel Trick 2
    01:57
  • Excel Tricks 3
    05:29
  • Excel Tricks 4
    03:52
  • Excel Tricks 5
    02:42
  • Excel Tricks 6
    02:56
  • Excel Tricks 7
    04:17
  • Excel Tricks 8
    05:13
  • Excel Tricks 9
    02:08
  • Excel Tricks 10
    01:29
  • Excel Tricks 11
    01:19
  • Excel Tricks 12
    04:00
  • Excel Tricks 13
    06:16
  • Excel Tricks 14
    02:39
  • Excel Tricks 15
    01:34
  • Excel Tricks 16
    03:22
  • Excel Tricks 17
    01:11
  • Excel Trick 18
    02:22
  • Excel Trick 19
    01:29
  • Excel Trick 20
    02:05
  • Excel Trick 21
    05:25
  • Excel Trick 22
    01:38
  • Excel Trick 23
    03:24
  • Excel Trick 24
    01:25
  • Excel Trick 25
    01:42
  • Excel Trick 26
    00:58
  • Excel Trick 27
    02:31
  • Excel Trick 28
    04:19
  • Excel Trick 29
    02:48
  • Excel Trick 30
    03:46
  • Excel Trick 31
    01:41
  • Excel Trick 32
    03:26
  • Excel Trick 33
    01:19
  • Excel Trick 34
    01:42
  • Excel Trick 35
    04:47
  • Excel Trick 36
    02:12

Instructor

Ahmed Samir Elsayed Abd Al Galil
Civil Engineer At Dubai Civil Engineering
Ahmed Samir Elsayed Abd Al Galil
  • 4.6 Instructor Rating
  • 133 Reviews
  • 4,700 Students
  • 5 Courses

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 طالب احترفو برامج الاوفيس .


في انتظاركم في الكورسات التي نقدمها وتحياتي لكم .

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.