|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-ms-excel-complete-basic-to-advance-course-in-hindi/
课程评论：没有评论
**课程名称：** Learn Microsoft Excel in Hindi - MS Excel हिंदी में सीखें **课程概述：** 本课程旨在帮助学员掌握在职场中所需的Microsoft Excel所有实用技能。课程内容全面且结构清晰，涵盖了Excel的各项核心功能： * **入门介绍：** 讲解课程的整体结构和内容。 * **数学函数：** 学习SUM, AVERAGE, RAND, MIN & MAX, SUMPRODUCT等常用数学公式。 * **文本函数：** 掌握TRIM, CONCATENATE, SUBSTITUTE, UPPER & LOWER, LENGTH, LEFT, RIGHT & MID等文本处理函数。 * **逻辑函数：** 学习AND & OR, IF, COUNTIF, SUMIF等逻辑判断和计数求和函数。 * **日期时间函数：** 了解TODAY & NOW, DAY, MONTH & YEAR, DATEDIF & DAYS等日期时间相关函数。 * **查询函数：** 学习VLOOKUP, HLOOKUP, INDEX, MATCH等强大的查询匹配函数。 * **数据工具：** 掌握数据排序、筛选、数据验证、删除重复项、文本分列等数据处理工具。 * **数据和表格格式化：** 学习单元格颜色、字体、对齐方式以及表格边框、表头高亮、隔行变色等表格美化技巧。 * **数据透视表：** 全面深入地学习数据透视表的构建和应用。 * **图表：** 学习制作各种图表，包括条形/柱形图、折线图、散点图、饼图/甜甜圈图、柱状图、瀑布图以及迷你图。 * **Excel快捷键：** 介绍重要的Excel快捷键，并教授查找任意操作快捷键的方法。 * **Excel中的数据分析：** 学习Excel中的数据分析功能，如回归分析、线性规划问题（最小化或最大化问题）、假设分析（单变量求解和方案管理器）。 * **宏：** 学习宏的录制、运行以及创建按钮来运行宏。 * **奖励讲座：** 包含Excel 2016及之前版本中的瀑布图、信息图表1：酷炫图表、信息图表2：酷炫图表等额外内容。 **学习成果：** 完成本课程后，您将对Excel的使用充满信心，并能熟练运用Microsoft Excel进行学习或作为职业发展的机会。
This course covers everything you need to crack Excel in the professional work place.Below are the Excel course contents of this complete and concise course on Microsoft Excel:Introduction - In this video, the structure and contents of the course are discussed.Mathematical Functions - This lecture covers Mathematical formulas such as SUM, AVERAGE,RAND, MIN & MAX, SUMPRODUCT.Textual Formulas - This Excel lecture covers Textual formulas such as TRIM, CONCATENATE, SUBSTITUTE, UPPER & LOWER, LENGTH, LEFT, RIGHT & MIDLogical Formulas - This lecture covers Logical formulas such as AND & OR, IF, COUNTIF, SUMIFDate-time (Temporal) Formulas - This lecture covers Date-time related functions such as TODAY & NOW, DAY, MONTH & YEAR, DATEDIF & DAYSLookup Formulas - This Excel lecture covers Lookup formulas such as VLOOKUP, HLOOKUP, INDEX, MATCHData Tools - This lecture covers Data operating tools such as Data Sorting and Filtering, Data validation, Removing duplicates, Importing Data (Text-to-columns)Formatting data and tables - This Excel lecture covers data formatting options such as coloring, changing font, alignments and table formatting options such as adding borders, having highlighted table headers, banded rows etc.Pivot Tables - This Excel lecture covers Pivot tables end-to-end.Charts - This Excel lecture covers charts such as, Bar/ Column chart, Line Chart, Scatter Plot, Pie & Doughnut charts, Statistical Chart - Histogram, Waterfall, SparklinesExcel Shortcuts - This lecture will introduce you to some important shortcuts and teach you how to find out the shortcut for any particular excel operation.Analytics in Excel - This Excel lecture covers the data analytics options available in Excel such as Regression, Solving linear programming problem (Minimization or Maximization problems), What-if (Goal Seek and Scenario Manager)Macros - This lecture covers the process of recording a Macro, running a Macro and creating a button to run a Macro.Bonus Lectures - Waterfall chart in Excel 2016 and previous versions of Excel, Infographics 1: Cool charts, Infographics 2: Cool chartsAnd so much more!By the end of this course, your confidence in using Excel will soar. You'll have a thorough understanding of how to use Microsoft Excel for study or as a career opportunity.
