Microsoft Office ( Excel – Word – Power Point ) ICDL | Microsoft Online Course by Udemy

Office Productivity Online Course by Udemy, On Sale Here

4500

An excellent training about Microsoft

Microsoft Office ( Excel – Word – Power Point ) ICDL

90 ( ) 70 – 4700 – LECTURE 1Why should I learn ExcelExcel Program interfaceLECTURE 2Create New FileCreate New TemplateClose WorkbookLECTURE 3Create New TemplateLECTURE 4Customize your own tabAdd new tab and new groupLECTURE 5Over Writing & Editing cell contentEditing formula & functionUsing undo & RedoFind & ReplaceGotoLECTURE 6FontAlignmentNumberLECTURE 7CharacteristicsRelative referenceAbsolute referenceLECTURE 8From where I can get speak cell optionSpeak cell ( by row and by column )Speak cell when I press enterLECTURE 9How to replace spaces to columnLECTURE 10Insert CommentsEdit CommentDelete commentShow all commentsLECTURE 11Copy & PastePaste specialCopying cells to one or many cellsCopying to different work sheetsusing filling for quick copyingLECTURE 12Filling & Drag Numbers / Days / Months / yearsCustom optionsFill down & RightLECTURE 13Filling Series With FormattingFilling Without formattingFilling Aweek daysFilling DaysLECTURE 14Flash Fill CTRL + ELECTURE 15Hide Column / RowFreezing PanesSplitting windowsLECTURE 16Create Custom ViewsDisplaying Custom ViewsDeleting Custom ViewsLECTURE 17Inserting / Deleting CellsInserting / Deleting ColumnsInserting / Deleting RowsResize Cells / Columns / RowsLECTURE 18Insert & Delete & Rename WorksheetCopying & Moving WorksheetsHide & Unhide WorksheetChanging Worksheet tab ColourFormat after GroupingComparing 2 WorksheetsLECTURE 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 UsageLECTURE 24add – subtract – divide – multiplybrackets usagecount – countA – count blank -count ifsumif – count if – avergaeifsumifs – countifs – avergaeifsLECTURE 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 sheetLECTURE 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 errorLECTURE 30check box – Data filtering – Number filtering – Text filter – Search – copy & paste filtered dataCreate table – Sort – Sort by color – design tab – table style optionsLECTURE 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 ChartLECTURE 34Spark line chartPivot chartLECTURE 35Revision 1Create & Close FilesCreate TemplateTabs & GroupsEditing DataFormatting in Excelcharacteristics of cellsSpeak CellsLECTURE 36Revision 2Conditional formattingformat cell optionsspelling checkText to columnCommentsCopying and FillingAdvanced Fillingsheet protectionWork sheets ViewsComparing FilesLECTURE 37Revision 3Logical testIF functionAdvanced if functionIF ANDIF ERRORAuditing ToolsFormula textEvaluate formulaLECTURE 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 apprev

Udemy is the leading global marketplace for learning and instruction

By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.

Study anytime, anywhere.

START HERE