|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/quick-guide-to-master-advance-excel/
课程评论：没有评论
课程名称: 快速掌握高级 Excel 指南 课程概述: 在数据获取的过程中，虽然看似简单，但真正的挑战在于如何分析这些数据。数据往往杂乱无章，以往排序、维护及分析数据是一项艰巨的任务，直到 Microsoft Excel 的出现，它使得存储、组织、排序、筛选甚至分析数据变得更加容易。本课程将全面介绍 Excel 2016，帮助您熟悉该程序及其强大的功能，并介绍 Excel 2013 与 2016 版本之间的差异，教授您 2016 版本的新特性。 Microsoft Excel 是一款互动表格软件，允许用户以表格形式组织、分析和存储数据。最初作为会计工作表的替代工具，Excel 现已发展成为一款更复杂的软件，帮助用户轻松记录和分析信息。Excel 在一系列编号的行和字母命名的列中提供了一个单元格网格，支持算术运算，同时也满足统计、工程和财务要求。Excel 2016 作为 Microsoft Office 2016 套件的一部分，它是 Excel 2013 的继任者，但许多功能与 Excel 2013 类似。 课程内容包括： - 使用基本公式：SUM、COUNT、MIN 和 MAX 函数 - 使用 SUMIF 进行选择性计数，利用 AVERAGEIF 计算选定单元格的平均值 - 多条件的 SUMIF、COUNTIF 和 AVERAGEIF 用法 - VLOOKUP 函数及其各种特性 - Sparkline 的定义及创建、设计修改、比较和移除 Sparkline 的方法 - 在工作表中使用时间进行计算 - 创建、编辑和移除大纲 - 创建和比较不同的情境 - 自定义视图的创建、编辑和删除方法 通过本课程，您将全面了解 Excel 2016 的各个方面。从简单的数据组织工具到能够进行简单计算、复杂函数处理、创建图表、表格和图形，Excel 将极大简化您的工作。立即报名，学习如何让 Excel 简化您的生活。
Getting the data is actually the easy part. Now that you have the data, the hard part is to analyze it. Data is often found in a mess and the job of sorting it and maintaining it, along with analyzing it was once a difficult task. This is before Microsoft Excel came along - making it easier to store, organize, sort, filter and even analyze the data.Our Excel 2016 course is a complete online tutorial designed to not only familiarize you with the Excel program, but to also teach you all the things that Excel is capable of performing. Our tutorial will also cover the differences between Excel 2013 and the latest version - the Excel 2016, teaching you all the new features that are available with the 2016 version.Microsoft Excel is an interactive spreadsheet that allows users to organize, analyze and store data in a tabular form. Originally designed as an alternative for accounting worksheets, Excel has since then evolved into a more complex piece of software. It has enabled users to easily record and analyze information and offers numerous tools to help along with this process. Excel comes in a grid of cells that are arranged in numbered rows and letter-named columns. It allows arithmetic operations and also caters to statistical, engineering and financial requirements. Excel 2016 is a part of the Microsoft Office 2016 suite is the successor to Excel 2013. However, many functions in Excel 2013 are similar to the functions found in Excel 2016.The course will cover topics such as If statements, Vlookup, Round functions, Time functions, Data lookups, Sparklines, Outlining and even Scenarios. From basic formulas and simple functions to complex statements and operators, this course includes it all. It breaks down all aspects of Excel 2016 to give you a complete understanding of this amazing and useful software. To give you an optimum learning experience, each section also comes with working files, practice exercises and even quiz questions and answers to help you along on your learning journey. In this course, you will learn: Learn how to use the basic formulas - SUM, COUNT, MIN, and MAX functionsUnderstand how to use the SUMIF function for selective counting, 'AVERAGEIF' for Mean of selected cells, Multiple Criteria Within 'SUMIF', 'COUNTIF', and 'AVERAGEIF'Learn how to use the 'VLOOKUP' function and its various featuresUnderstand what is Sparkline, how to create a sparkline, altering the design of Sparklines, comparing sparklines and removing sparklines.How to perform calculations using time in a worksheetHow to create, edit and remove an outlineUnderstand how to create and compare different scenariosWhat are Custom Views, how to create a Custom View and how to edit and delete a Custom View. There is so much more that you can do with your excel sheet. From simply a tool for organizing, excel can now help with simple calculations to performing complex functions, including creating charts, tables and graphs. Enroll now and learn how Excel can simplify your life.
