|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-course-part-1/
课程评论：没有评论
课程名称：Microsoft Excel 课程第一部分 课程概述： 本课程适合所有水平的Excel用户，包括初学者和高级用户。涵盖了Excel的所有命令和公式，包括基本的和复杂的公式，适用于专业人士。此外，还包含许多常被用户忽视的Excel技巧。如果你对Excel一无所知，完成本课程后你将能够熟练掌握Excel的所有细节。 课程内容： - Excel基础知识，如程序界面、创建新文件和模板、关闭工作簿等。 - 单元格内容的编辑、查找与替换，以及重做和撤销操作。 - 字体、对齐和数值格式的设置。 - 值的相对和绝对引用，以及单元格的说话功能。 - 各种复制与粘贴技巧，包括特殊粘贴和使用填充功能快速复制。 - 自定义视图的创建与管理。 - 编辑和删除单元格、行、列，调整它们的大小。 - 工作表的插入、复制、移动和删除。 - 逻辑测试及IF函数的使用，嵌套IF函数和错误处理工具。 - 多种文本处理函数，包括去除多余空格、首字母大写、文本长度计算等。 - 日期计算及格式转换。 - 常用的数学函数和条件求和、计数函数的应用。 - 查找和引用功能的深入探讨，包括VLOOKUP和HLOOKUP。 - 数据排序与过滤，高级表格功能与图表创建。 课程还包含多次复习和案例研究，包括进度报告、时间表及产品编码等，帮助学员巩固所学内容。 通过本课程，学员将全面了解Excel，提升数据处理能力，掌握实用的Excel技巧，成为Excel的专业用户。
الكورس مناسب لكل مستويات مستخدمي الاكسيل ( المبتديء والمحترف والمتوسط ) يشمل جميع اوامر ومعادلات الاكسيل - المعادلات البسيطه والبدائيه والمعادلات المعقده والتي يحتاجها المحترفين - يشمل ايضا العديد من تريكات الاكسيل التي يجهلها كثير من المستخدمين - اذا كنت لا تعلم في الاكسيل شيئا سوف تخرج من الكورس بفضل الله محترف للاكسيل وعلي درايه تامه بكل تفاصيل الاكسيل.- 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
