Overview

الكورس مناسب لكل مستويات مستخدمي الاكسيل ( المبتديء والمحترف والمتوسط ) يشمل جميع اوامر ومعادلات الاكسيل - المعادلات البسيطه والبدائيه والمعادلات المعقده والتي يحتاجها المحترفين - يشمل ايضا العديد من تريكات الاكسيل التي يجهلها كثير من المستخدمين - اذا كنت لا تعلم في الاكسيل شيئا سوف تخرج من الكورس بفضل الله محترف للاكسيل وعلي درايه تامه بكل تفاصيل الاكسيل.- 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 ExcelExcel Program interfaceExcel Part 1 Lecture 2Create New FileCreate New TemplateClose WorkbookExcel Part 1 Lecture 3Create New TemplateExcel Part 1 Lecture 4Customize your own tabAdd new tab and new groupExcel Part 1 Lecture 5Over Writing & Editing cell contentEditing formula & functionUsing undo & RedoFind & ReplaceGotoExcel Part 1 Lecture 6FontAlignmentNumberExcel Part 1 Lecture 7CharacteristicsRelative referenceAbsolute referenceExcel Part 1 Lecture 8From where I can get speak cell optionSpeak cell ( by row and by column )Speak cell when I press enterExcel Part 1 Lecture 9How to replace spaces to columnExcel Part 1 Lecture 10Insert CommentsEdit CommentDelete commentShow all commentsExcel Part 1 Lecture 11Copy & PastePaste specialCopying cells to one or many cellsCopying to different work sheetsusing filling for quick copyingExcel Part 1 Lecture 12Filling & Drag Numbers / Days / Months / yearsCustom optionsFill down & RightExcel Part 1 Lecture 13Filling Series With FormattingFilling Without formattingFilling Aweek daysFilling DaysExcel Part 1 Lecture 14Flash Fill CTRL + EExcel Part 1 Lecture 15Hide Column / RowFreezing PanesSplitting windowsExcel Part 1 Lecture 16Create Custom ViewsDisplaying Custom ViewsDeleting Custom ViewsExcel Part 1 Lecture 17Inserting / Deleting CellsInserting / Deleting ColumnsInserting / Deleting RowsResize Cells / Columns / RowsExcel Part 1 Lecture 18Insert & Delete & Rename WorksheetCopying & Moving WorksheetsHide & Unhide WorksheetChanging Worksheet tab ColourFormat after GroupingComparing 2 WorksheetsExcel Part 1 Lecture 19RevisionCase Study (Progress Report)Case Study (Time Sheet)Case Study (Products Coding)Excel Part 1 Lecture 20Logical TestIf FunctionAdvanced IF Function ( Nested IF )Excel Part 1 Lecture 21IF AND FunctionIF error FunctionAuditing Tools ( Displaying and removing dependent , precedent arrows )Formula text ( To show the Cell formula as a text )Excel Part 1 Lecture 22Trim 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 & yearsnetworking daysnet working days internationalychanging date format to show only day ( custom format for the date )Excel Part 1 Lecture 23to 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 UsageExcel Part 1 Lecture 24add - subtract - divide - multiplybrackets usagecount - countA - count blank -count ifsumif - count if - avergaeifsumifs - countifs - avergaeifsExcel Part 1 Lecture 25( Sumproduct - Floor - Ceiling ) Formulasvlookup Formulavlookup Formula with data validationvlookup with Name rangevlookup with approximate matchvlookup with trim ( 2 cases )Excel Part 1 Lecture 26Hlookup FormulaVlookup 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 27Index & Match formulaslock & unlock cellprotect the sheetExcel Part 1 Lecture 28Protect Workbookhyperlink to a sheethyperlink to a filehyperlink to a web pagepage setup for printing ( margins - orientation - print area - print size - page break - background - print titles )Excel Part 1 Lecture 29Header & footer ( page number & date & file name )Data Sorting ( Numbers - Text - dates - Multicolumn sorting - color sorting )advanced sortadvanced filteradvanced filter errorExcel Part 1 Lecture 30check box - Data filtering - Number filtering - Text filter - Search - copy & paste filtered dataCreate table - Sort - Sort by color - design tab - table style optionsExcel Part 1 Lecture 31Advanced 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 32Charts 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 & Optionsformat chart ( Double click )Excel Part 1 Lecture 33Bar ChartPie ChartColumn Vs Line ChartExcel Part 1 Lecture 34Spark line chartPivot chartExcel Part 1 Lecture 35 Revision 1Create & Close FilesCreate TemplateTabs & GroupsEditing DataFormatting in Excelcharacteristics of cellsSpeak CellsExcel Part 1 Lecture 36 Revision 2Conditional formattingformat cell optionsspelling checkText to columnCommentsCopying and FillingAdvanced Fillingsheet protectionWork sheets ViewsComparing FilesExcel Part 1 Lecture 37 Revision 3Logical testIF functionAdvanced if functionIF ANDIF ERRORAuditing ToolsFormula textEvaluate formulaExcel Part 1 Lecture 38 Revision 4Trim 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 & yearsnetworking daysnet working days internationalychanging date format to show only day ( custom format for the date )Header and Footer & Data sorting and advanced filteringData Filtering & Creating tableTable advanced option & SubtotalCharts & Chart FormatPivot Chart

Skills

Reviews