|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-ms-excel/
课程评论：没有评论
课程名称：掌握 MS Excel 概述：掌握 MS Excel 课程旨在帮助学习者从零基础提升至高级水平，适用于 MS Excel 2010 至 2016 版本。课程视频基于 MS Excel 2016，使用 Windows 电脑制作。无须先前的 Excel 知识，本课程专注于日常工作中重要的相关技能，帮助您充分利用 Excel。中级用户也会受益于课程中深入探讨的复杂图表、数据透视表、数据透视图和交互式仪表盘等主题。该课程适合寻求在现代职场中掌握 Excel 技能的求职者，同时也能帮助现有员工利用新技能给同事和经理留下深刻印象。 课程大纲： 第1章 介绍工作表、工作簿、单元格等重要术语的定义，并讲解如何启动 MS Excel 和窗口布局（包括功能区菜单）。 第2章 探讨文本编辑，包括字体大小、类型、颜色、文本对齐、文本换行、合并单元格、边框和阴影。 第3章 讲解单元格格式，包括小数、货币、百分比及日期时间格式。 第4章 介绍条件格式，让您开启令人惊艳的新机会。 第5章 教您如何迅速移动数据，提升工作效率。 第6章 学习复制、剪切、粘贴和移动数据。 第7章 是课程中最长的一章，深入探讨 Excel 强大的公式功能，包括 If函数、嵌套 If、计数函数、字符串函数、日期时间函数和随机数生成函数。 第8章 深入了解 VLookUp 函数，让您惊叹于它的强大。 第9章 以更温和的节奏介绍数据的排序和过滤。 第10章 展示图表的制作，从简单图表到复杂图表，带您领略 Excel 的魅力。 第11章 讲解数据透视表这一强大的数据分析工具。 第12章 进一步深入数据透视图和切片器，以及如何创建交互式仪表盘。 第13章 通过将数据格式化为表来简化工作。 第14章 学习宏的使用，使重复性任务变得简单。 第15章 介绍去除重复数据、定义命名范围、创建数据验证的选择列表、保护工作表和工作簿、插入精美图形，以及创建目录页等激动人心的概念。 请注意，本课程不涉及 VBA 编程，所有内容均不需要编程知识。祝您在学习中取得成功。
The Mastering MS Excel is aimed at MS Excel 2010 to 2016. The course videos are based on MS Excel 2016, used on a Windows computer. No prior knowledge of MS Excel is required. The course will take you from the beginner level to the advanced level. The course focuses on those aspects that are important in everyday working life and helps you get the most out of MS Excel. Intermediate users will also benefit from this course as it covers the in-depth topics of Complex Charts, PivotTables, PivotCharts and Interactive Dashboards. The course is aimed at job seekers trying to gain MS Excel Skills for todays job market. It will also help existing workers, who use MS Excel, to fascinate and astound their colleagues and managers with their newly gained skills. Course Breakdown: Chapter 1 covers important definitions of the terms: spreadsheet, workbook, worksheet and cell. It also covers how to start MS Excel, and the layout of the window, including the ribbon menu. Chapter 2 is editing and looks at font sizes, types, colors, text alignment, text wrap, merging cells, borders and shading. Chapter 3 looks at formatting cells as decimals, currency, percent and date & time. Chapter 4 opens up new opportunities for you to dazzle people. We discuss conditional formatting. Chapter 5 looks at how you can move easily and quickly around a worksheet containing data. You will be impressed. Chapter 6 covers copying, cutting, pasting and moving data Chapter 7 is the longest chapter and looks at the most powerful feature of excel that sets it apart from other applications. You will learn about formulas and cover functions such as If, Nested Ifs, Count functions, String functions, DateTime functions, Random number generator functions and more. Chapter 8 delves into the powerful VLookUp function. You'll wonder how you ever managed without it. Chapter 9 slows down to a more gentle pace, giving your tired brain a rest, by covering sorting and filtering data. Chapter 10 will dazzle you with creating Graphs, or Charts, as it is called in Excel. We'll start with simple graphs and end with some complex ones that very few people know how to create. Chapter 11 teaches you about a tool that makes data analysis easy-pezee. It's the awesome Pivot table. Chapter 12 takes this one step further with the power of pivot charts and slicers. We'll also show you how to create an INTERACTIVE dashboard. Chapter 13 shows you how to make your life easier by formatting your data as tables. Chapter 14 covers Macros. This makes repetitive tasks easy-peeze. Chapter 15 covers the remaining exciting concepts of: Removing duplicate data rows, defining named ranges, creating a pick list using data validation, protecting your sheet and workbook, inserting fancy graphics. And finally creating a Contents sheet. Be rest assured that this course does not cover VBA programming. All that you learn is done without any programming. Best of luck in your future endeavours.
