Overview

الكورس مناسب لكل مستويات مستخدمي الاكسيل ( المبتديء والمحترف والمتوسط ) يشمل جميع اوامر ومعادلات الاكسيل - المعادلات البسيطه والبدائيه والمعادلات المعقده والتي يحتاجها المحترفين - يشمل ايضا العديد من تريكات الاكسيل التي يجهلها كثير من المستخدمين - اذا كنت لا تعلم في الاكسيل شيئا سوف تخرج من الكورس بفضل الله محترف للاكسيل وعلي درايه تامه بكل تفاصيل الاكسيل.- 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 + ELecture 40 2 Excel Tricks 2 CTRL + ELecture 41 3 Excel Tricks 3 CTRL + ; & Ctrl + ELecture 42 4 Excel Tricks 4 Custom List for dragging downLecture 43 5 Excel Tricks 5 Select Multi Sheets and make your workLecture 44 6 Quick access analysis toolLecture 45 7 Filter - tableLecture 46 8 Data Validation ( Drop down list data validation )Lecture 47 9 Auto fit columns & RowsLecture 48 10 Transpose ( تقلب الصف عمود والعمود صف )Lecture 49 11 Remove duplicatesLecture 50 12 Goal Seek ( Data - what if - goal seek ) ( محتاج احقق قيمه معينه )Lecture 51 13 VlockupLecture 52 14 Paste SepacialLecture 53 15 changing chart columns to pattern or pictureLecture 54 16 IF FunctionLecture 55 17 Insert ScreenShot ( insert - illustration - screenshot )Lecture 56 18 Absolute Cell ReferenceLecture 57 19 Show Formula ( CTRL + ˜ )Lecture 58 20 Convert Text to columnsLecture 59 21 Conditional formattingLecture 60 22 Power PivotLecture 61 23 Freeze PanesLecture 62 24 CTRL Arrow key to select last cellLecture 63 25 3D reference (جمع نفس الخليه في كل الشيتات )Lecture 64 26 forecast sheetLecture 65 27 SUMIFS ـجميع القيم التي امام قيم معينه ( اكثر من criteria )Lecture 66 28 IF ERROR - Advanced Transpose ( Live Edit ) تحديث القيم بعد عمل transpose عند تغيير القيم الاصليهLecture 67 29 SlicersLecture 68 30 Scenario ManagerLecture 69 31 Convert FunctionLecture 70 32 Convert Currency LiveLecture 71 33 Hide CellsLecture 72 34 remove blanksLecture 73 35 track changesLecture 74 36 advanced filterLecture 75 How To use pivot table & SlicerLecture 76 How to learn excel in 40 min & pivot tablesLecture 77 How to make report by excelLecture 78 Paste Link & Transpose & combination for both of themLecture 79 Excel ShortcutsLecture 80 Pivot table Secrets80.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 value80.05 field setting - layout print - show with no data (( to show empty cells ))80.06 Group for pivot table items80.07 group numeric items80.08 group dates and show by month or year80.09 automatic refresh - options - data - automatic refresh80.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 value80.12 sort80.13 move the items manually to sort it80.14 change the layout - design - report layout80.15 repeat labels - design - report layout - repeat item labels80.16 turn off (Get pivot table data formula ) - from options in the left corner - choos to turn off get pivot table data formula80.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 add80.19 creat pivot chart ( choos any chart and link with pivot table80.2 add slicer80.21 insert timeline80.22 link slicer with other tables ( right click - report connection - choose the tables to link )80.23 filter on top N80.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 options80.25 show values as - field setting OR right click values - show valuse asLecture 81 Excel Power Query 1 ( Home Tap )81.01 Refresh81.02 Properties81.03 Manage81.04 Choose Columns81.05 Remove columns81.06 remove rows81.07 keep rows81.08 sort81.09 Split columns81.10 Data Type81.11 Use first row as header81.12 replace values81.13 Merge Quaries81.14 Append Quaries81.15 Data Source Setting81.16 New SourceLecture 82 Excel Power Query 2 ( Transform Tap )82.01 Transpose ( تقلب الصف عمود والعمود صف )82.02 Reverse rows82.03 Count rows82.04 Replace Values & errors82.05 Fill82.06 Pivot Columns82.07 Unpivot columns82.08 move82.09 convert to list82.10 format82.11 split columns82.12 Extract82.13 Statistics82.14 Standard82.15 Rounding82.16 Information82.17 Date & Time & DurationLecture 83 Excel Power Query 3 ( Add Columns & View Taps )84.01 Columns from example84.02 custom column84.03 merge columns84.04 format & extract & statistics & standard & date and time

Skills

Reviews