|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-microsoft-excel-basics-fast/
课程评论：没有评论
课程名称：快速学习微软Excel基础 课程概述： 学习微软Office的原因是什么？根据academyoflearning的统计，几乎全球的每家公司都在使用微软Office，特别是在加拿大有超过97139用户。这一广泛使用意味着其在许多岗位中都变得至关重要，是一项极佳的技能。同时，绝大多数组织在管理、项目和沟通中使用微软Office，因此求职时几乎所有职位都要求掌握微软Office技能。通过获取特定Office程序的微软Office认证（MOS），您可以证明您具备所需的Office技能。此外，您还可以获得SVBook微软Office高级证书或SVBook微软Office及数据分析高级证书。 本课程旨在快速帮助您学习微软Excel基础知识。学习前需具备一定的计算机知识。课程内容包括： - 下载数据集 - 文本格式设置（加粗、斜体、下划线、字体颜色更改） - 单元格边框及颜色设置 - 行样式和颜色设置 - 自动调节、文本对齐（左对齐、居中对齐、右对齐） - 合并与居中、单元格格式及条件格式 - 表格样式的修改与对比 - 函数应用（求和、平均值、最小值、最大值、相关性、方差、标准差、峰度、偏度、VLOOKUP、COUNTIF、IF函数等） - 数据查找与替换、排序、过滤 - 插入不同类型的图表（线形图、条形图、饼图、散点图、组合图） - 创建及使用数据透视表和数据透视图 本课程可通过EMHAcademy进行考试，获得SVBook微软Office高级证书及数据分析与Excel基础的证书。
Why Study Microsoft Office?According to academyoflearning1. Almost Every Company Worldwide Uses Microsoft OfficeMicrosoft office has users worldwide, wit hover 97139in Canada. Its widespread means it is important in many roles and makes it the best skill. 2. Helps You Step Up Your Game in Job HuntingAlmost all organizations use Microsoft Office, they use it for administration, projects, and communications. Thus, most jobs will require you ti know Microsoft Office. 3. Industry-Recognized Microsoft Office Certification Will Help Advance Your CareerYou can demonstrate that you have the skills needed for Microsoft Office by earning Microsoft Office Certifications (MOS) in a specific office program. You can also get certified with SVBook Advanced Certificate in Microsoft Office or SVBook Advanced Certificate in Microsoft Office and Data Analysis using Excel. This is the bite-size course to learn Microsoft Excel fast. You will need to know some computer knowledge before learning this course. You can take the course as follows, and you can take an exam at EMHAcademy to get SVBook Advance Certificate in Microsoft Office: - Learn Microsoft Word Basics Fast- Learn Microsoft Powerpoint Basics Fast- Learn Microsoft Excel Basics FastYou can take the course as following and you can take an exam at EMHAcademy to get SVBook Advance Certificate in Microsoft Office and Data Analysis with Excel: - Learn Microsoft Word Basics Fast- Learn Microsoft Powerpoint Basics Fast- Learn Microsoft Excel Basics Fast- Learn Data analysis using Microsoft Excel Basics Fast. ContentGetting StartedDownload Data setRead CSVBoldItalicsUnderlineText ColorChange FontBorderCells ColorLine StylesLine COlorsAutosizeLeft AlignCenter AlignRight AlignMerge and CenterFormat CellsConditional FormattingFormat as TablesChange Cell StylesFormat as Tables vs Change Cell StylesSum FunctionAverage FunctionMin FunctionMax FunctionCorrelationVarianceStandard DeviationKurtosisSKewnessVLOOKUPCOUNTIFIF FUnctionMore FunctionsFind and ReplaceSort DataFilter DataInsert Line ChartInsert Bar ChartInsert Pie ChartInsert ScatterplotInsert COmbo CHartInsert Pivot TableInsert Pivot Tables and Pivot Charts
