Description
كورس برامج الاوفيس من الصفر وحتي الاحتراف يشمل اكثر من 90 محاضره تعليميه لبرامج الاوفيس ( الاكسيل - الوورد - الباور بوينت ).الكورس مصمم من الصفر اذا لم يكن عندك معرفه مسبقه بالبرامج وايضا به المستوي المحترف للمحترفين.الكورس الاقوي علي الاطلاق. اقرا المحتوي الذي تم وضعه وسوف تشارك معنا في الكورسات كما شارك اكثر من 4800 طالب في كورس الاكسيل..الان سوف تحصل علي كورس الاكسيل بالاضافه الي كورس وورد + كورس باور بوينت.محتوي الكورس قوي جدا مقارنه بالسعر - ولن تندم ان شاء الله 1 - Excel Course Content:......................................................- LECTURE 1Why should I learn ExcelExcel Program interface.. LECTURE 2Create New FileCreate New TemplateClose Workbook.. LECTURE 3Create New Template.. LECTURE 4Customize your own tabAdd new tab and new group.. LECTURE 5Over Writing & Editing cell contentEditing formula & functionUsing undo & RedoFind & ReplaceGoto.. LECTURE 6FontAlignmentNumber.. LECTURE 7CharacteristicsRelative referenceAbsolute reference.. LECTURE 8From where I can get speak cell optionSpeak cell ( by row and by column )Speak cell when I press enter.. LECTURE 9How to replace spaces to column.. LECTURE 10Insert CommentsEdit CommentDelete commentShow all comments.. LECTURE 11Copy & PastePaste specialCopying cells to one or many cellsCopying to different work sheetsusing filling for quick copying.. LECTURE 12Filling & Drag Numbers / Days / Months / yearsCustom optionsFill down & RightLECTURE 13Filling Series With FormattingFilling Without formattingFilling Aweek daysFilling Days.. LECTURE 14Flash Fill CTRL + E.. LECTURE 15Hide Column / RowFreezing PanesSplitting windows.. LECTURE 16Create Custom ViewsDisplaying Custom ViewsDeleting Custom Views.. LECTURE 17Inserting / Deleting CellsInserting / Deleting ColumnsInserting / Deleting RowsResize Cells / Columns / Rows.. LECTURE 18Insert & Delete & Rename WorksheetCopying & Moving WorksheetsHide & Unhide WorksheetChanging Worksheet tab ColourFormat after GroupingComparing 2 Worksheets.. LECTURE 19RevisionCase Study (Progress Report)Case Study (Time Sheet)Case Study (Products Coding).. LECTURE 20Logical TestIf FunctionAdvanced IF Function ( Nested IF ).. LECTURE 21IF AND FunctionIF error FunctionAuditing Tools ( Displaying and removing dependent , precedent arrows )Formula text ( To show the Cell formula as a text ).. 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 ).. 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 Usage.. LECTURE 24add - subtract - divide - multiplybrackets usagecount - countA - count blank -count ifsumif - count if - avergaeifsumifs - countifs - avergaeifs.. LECTURE 25( Sumproduct - Floor - Ceiling ) Formulasvlookup Formulavlookup Formula with data validationvlookup with Name rangevlookup with approximate matchvlookup with trim ( 2 cases ).. 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 ).. LECTURE 27Index & Match formulaslock & unlock cellprotect the sheet.. 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 ).. LECTURE 29Header & footer ( page number & date & file name )Data Sorting ( Numbers - Text - dates - Multicolumn sorting - color sorting )advanced sortadvanced filteradvanced filter error.. LECTURE 30check box - Data filtering - Number filtering - Text filter - Search - copy & paste filtered dataCreate table - Sort - Sort by color - design tab - table style options.. LECTURE 31Advanced table ( rename table - resize table - slicer for table - remove duplicates - convert table to range )Subtotals ( subtotal option - hide all data except subtotal -.. 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 ).. LECTURE 33Bar ChartPie ChartColumn Vs Line Chart.. LECTURE 34Spark line chartPivot chart.. LECTURE 35Revision 1Create & Close FilesCreate TemplateTabs & GroupsEditing DataFormatting in Excelcharacteristics of cellsSpeak Cells.. LECTURE 36Revision 2Conditional formattingformat cell optionsspelling checkText to columnCommentsCopying and FillingAdvanced Fillingsheet protectionWork sheets ViewsComparing Files.. LECTURE 37Revision 3Logical testIF functionAdvanced if functionIF ANDIF ERRORAuditing ToolsFormula textEvaluate formula.. LECTURE 38Revision 3Trim 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.. Lecture 39Excel Tricks 1 CTRL + E.. Lecture 40Excel Tricks 2 CTRL + E.. Lecture 41Excel Tricks 3 CTRL + ; & Ctrl + E.. Lecture 42Excel Tricks 4 Custom List for dragging down.. Lecture 43Excel Tricks 5 Select Multi Sheets and make your work.. Lecture 44Quick access analysis tool.. Lecture 45Filter - table.. Lecture 46Data Validation ( Drop down list data validation ).. Lecture 47Auto fit columns & Rows.. Lecture 48Transpose ( تقلب الصف عمود والعمود صف ).. Lecture 49Remove duplicates.. Lecture 50Goal Seek ( Data - what if - goal seek ) ( محتاج احقق قيمه معينه ).. Lecture 51Vlockup.. Lecture 52Paste Sepacial.. Lecture 53changing chart columns to pattern or picture.. Lecture 54IF Function.. Lecture 55Insert ScreenShot ( insert - illustration - screenshot ).. Lecture 56Absolute Cell Reference.. Lecture 57Show Formula ( CTRL + ˜ ).. Lecture 58Convert Text to columns.. Lecture 59Conditional formatting.. Lecture 60Power Pivot.. Lecture 61Freeze Panes.. Lecture 62CTRL Arrow Ley to select last cell.. Lecture 633D reference (جمع نفس الخليه في كل الشيتات ).. Lecture 64forecast sheet.. Lecture 65SUMIFS ـجميع القيم التي امام قيم معينه ( اكثر من criteria ).. Lecture 66IF ERROR - Advanced Transpose ( Live Edit ) تحديث القيم بعد عمل transpose عند تغيير القيم الاصليه.. Lecture 67Slicers.. Lecture 68Scenario Manager.. Lecture 69Convert Function.. Lecture 71Hide Cells.. Lecture 72remove blanks.. Lecture 73track changes.. Lecture 74advanced filter.. Lecture 75How to use pivot table & slicersLecture 76How to learn Excel in 40 minutes & Pivot table.. Lecture 77How to make report by excel.. Lecture 78Paste Link & Transpose & combination for both of them.. Lecture 79Excel Shortcuts.. Lecture 80Pivot Table Secrets.. Lecture 81Excel Power Query 1.. Lecture 82Excel Power Query 22- Power Point Course Content:..................................................................... Lecture 2Interface , quick access tool bar , tabs types , show and hide ribbonscustom ribbon , Zoom options , Notes boxmake new sheet , open new file CTRL+NSaving a file , Save As , save as pdfclosing the file with keeping the application openclipboard copy and paste ( 24 items capacity )clipboard copy and paste between office programsstart typing in MS power pointcreat new slide - choose the layoutrest layouthow to add sectionremove & rename sectionsStart a text Or insert a table or graph or photoHow to edit & format text in power pointshortcuts for increase & decrease size of fontBold & Italic & decrease space between words ( Font format )alignmentspace between linesText format.. Lecture 3view - window - arrange allCascademove split ( use up and down arrow key to change the window size )New window ( create duplicate window only to compare slides )Switch windowWorking with slidesAdd new slide ( New Slide OR CTRL +M)Copy SlideDuplicate for slides ( CTRL + D )Drag and Drop Slides - Rearrange slidesDelete SlidesPrint optionsPrint to a PDFprint out llines - print 6 slides / paperConvert slides to a videohow to add sound to slidesSave as pdf & power point show ( not editable power point )convert power point file to image fileconvert power point file to pdf file.. Lecture 4Hyperlinkinsert - shape - Action Buttons - action on click or mouse over.. Lecture 5Smart ArtLayoutSmart Art StyleResetCreate GraphicShapeShape styleWord Art StyleArrangeSizeTables.. Lecture 6Table style optionsTable stylesWord Art Styles optionsDraw Borders - Erase cellsRow, Columns, Table ( Delete & Add rows and columns and tables )Merge and splitCell Size , AlignementTable size , ArrangeHyperlink to a new file CTRL+KHyperlink to an existing fileHyperlink to a webpage / WebsiteRemove hyperlinkHyperlink to a shape or pictureEdit Screen tiphyperlink to a slide.. Lecture 7Header & Footer.. Lecture 8Print OptionsHide & Show SlideExport Options.. Lecture 9insert video - play or bass the file ( Alt + p ) - From first ( Alt Q )right click on the screen then help - will show all shortcutsVideo Formatinsert more than 1 video and work it same time.. Lecture 10Edit Videotrim video.. Lecture 11Slide Show ( current - from beginning )Setup Slide ShowHide & Unhide Slidesetup slide show ( All Slide Show Options )record slide show.. Lecture 12sllide show then CTRL + P will start marking on the slidesCTRL E EraserE remove all modificationsctrl + L laser pointer.. Lecture 13Photo AlbumCaption imagesCharts..2 - Word Course Content:............................................................. Lecture 1. Lecture 2. Lecture 3. Lecture 4.
