Excel From Zero To Expert part 1أكسيل من الصفر للاحتراف

create forms and solving formulas

Created byShady Younes

Last updated 12/2020

Arabic

What you'll learn

students will learn every thing about how to use Microsoft excel professionally
solving any formula
outbox ideas to create perfect worksheets
multi exercises of formulas or worksheets forms

Course content

1 section • 27 lectures • 4h 21m total length

excel user interface,selection,movement ,13:27
excel name box11:54
excel mouse pointer shapes ,auto fill cells5:10
fill series14:30
elements of cells7:19
format border and color and number and date10:09
format cells time and text and9:00
protection10:50
paste special6:38
format painter and table style format number6:54
conditional formatting 118:52
conditional formatting 211:34
insert and delete and format menu14:48
custom lists & Sort16:34
filter and advanced filter26:35
data validation 118:12
data validation 210:30
remove duplicate and group4:39
flash fill and text to column6:37
concalidate3:42
scenario8:43
goal seek 24:56
data table3:27
subtotals11:36
Evaluate Formula5:18
trace precedents and trace dependents4:46
watch window4:24

Requirements

just setup Microsoft Excel

Description

how do you can use excel in multiple ways to be a professional excel user,

in these fields (database, accounting, mathematics, applications, games)

this course will learn you how to be able to convert the real-life applications as formulas in excel and how to solve them and create a form for each real-life applications

Who this course is for:

which his/her career is (database,accounting,math,writing,inventory ,engineering..)
any one wants to decrease his/her efforts when he work on computer