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

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

– 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 39 1 Excel Tricks 1 CTRL + E

Lecture 40 2 Excel Tricks 2 CTRL + E

Lecture 41 3 Excel Tricks 3 CTRL + ; & Ctrl + E

Lecture 42 4 Excel Tricks 4 Custom List for dragging down

Lecture 43 5 Excel Tricks 5 Select Multi Sheets and make your work

Lecture 44 6 Quick access analysis tool

Lecture 45 7 Filter – table

Lecture 46 8 Data Validation ( Drop down list data validation )

Lecture 47 9 Auto fit columns & Rows

Lecture 48 10 Transpose ( تقلب الصف عمود والعمود صف )

Lecture 49 11 Remove duplicates

Lecture 50 12 Goal Seek ( Data – what if – goal seek ) ( محتاج احقق قيمه معينه )

Lecture 51 13 Vlockup

Lecture 52 14 Paste Sepacial

Lecture 53 15 changing chart columns to pattern or picture

Lecture 54 16 IF Function

Lecture 55 17 Insert ScreenShot ( insert – illustration – screenshot )

Lecture 56 18 Absolute Cell Reference

Lecture 57 19 Show Formula ( CTRL + ˜ )

Lecture 58 20 Convert Text to columns

Lecture 59 21 Conditional formatting

Lecture 60 22 Power Pivot

Lecture 61 23 Freeze Panes

Lecture 62 24 CTRL Arrow key to select last cell

Lecture 63 25 3D reference (جمع نفس الخليه في كل الشيتات )

Lecture 64 26 forecast sheet

Lecture 65 27 SUMIFS ـجميع القيم التي امام قيم معينه ( اكثر من criteria )

Lecture 66 28 IF ERROR – Advanced Transpose ( Live Edit ) تحديث القيم بعد عمل transpose عند تغيير القيم الاصليه

Lecture 67 29 Slicers

Lecture 68 30 Scenario Manager

Lecture 69 31 Convert Function

Lecture 70 32 Convert Currency Live

Lecture 71 33 Hide Cells

Lecture 72 34 remove blanks

Lecture 73 35 track changes

Lecture 74 36 advanced filter

Lecture 75 How To use pivot table & Slicer

Lecture 76 How to learn excel in 40 min & pivot tables

Lecture 77 How to make report by excel

Lecture 78 Paste Link & Transpose & combination for both of them

Lecture 79 Excel Shortcuts

Lecture 80 Pivot table Secrets

80.01 use table ( to be able to add data )

80.02 show pivot table details ( Double click or – right click and show details )

80.03 delete data source ( bring it again with double click on total )

80.04 replace empty cells with any values – replace errors with any value

80.05 field setting – layout print – show with no data (( to show empty cells ))

80.06 Group for pivot table items

80.07 group numeric items

80.08 group dates and show by month or year

80.09 automatic refresh – options – data – automatic refresh

80.1 show filter – put item in filter area – options – show filter area (( will create new sheets with each item )

80.11 filter by label & by value

80.12 sort

80.13 move the items manually to sort it

80.14 change the layout – design – report layout

80.15 repeat labels – design – report layout – repeat item labels

80.16 turn off (Get pivot table data formula ) – from options in the left corner – choos to turn off get pivot table data formula

80.17 prevent column width from changing – right click – pivot table options – autofit columns – change on update ( tick )

80.18 calculated fields – analyze – fields – calculated fields – insert formula and add

80.19 creat pivot chart ( choos any chart and link with pivot table

80.2 add slicer

80.21 insert timeline

80.22 link slicer with other tables ( right click – report connection – choose the tables to link )

80.23 filter on top N

80.24 add multible subtotals – field setting – CTRL select – sum & averag ( but before this stage you have to choose alow multible subtotals from the pivot table options

80.25 show values as – field setting OR right click values – show valuse as

Lecture 81 Excel Power Query 1 ( Home Tap )

81.01 Refresh

81.02 Properties

81.03 Manage

81.04 Choose Columns

81.05 Remove columns

81.06 remove rows

81.07 keep rows

81.08 sort

81.09 Split columns

81.10 Data Type

81.11 Use first row as header

81.12 replace values

81.13 Merge Quaries

81.14 Append Quaries

81.15 Data Source Setting

81.16 New Source

Lecture 82 Excel Power Query 2 ( Transform Tap )

82.01 Transpose ( تقلب الصف عمود والعمود صف )

82.02 Reverse rows

82.03 Count rows

82.04 Replace Values & errors

82.05 Fill

82.06 Pivot Columns

82.07 Unpivot columns

82.08 move

82.09 convert to list

82.10 format

82.11 split columns

82.12 Extract

82.13 Statistics

82.14 Standard

82.15 Rounding

82.16 Information

82.17 Date & Time & Duration

Lecture 83 Excel Power Query 3 ( Add Columns & View Taps )

84.01 Columns from example

84.02 custom column

84.03 merge columns

84.04 format & extract & statistics & standard & date and time