|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-pivot-tables-with-excel-2016/
课程评论：没有评论
课程名称：Excel 2016 的数据透视表：从基础到 PowerPivot 课程概述：欢迎参加由 Kawser Ahmed 讲授的 Excel 数据透视表课程。本课程将带您从零基础到高级水平学习 Excel 数据透视表，同时介绍 Power Pivot 和 DAX 语言。自 2015 年 11 月以来，已有超过 15,000 名学生成功完成我的在线课程。 在本课程结束时，您将能够： - 从超过一百万行的事务数据中创建汇总报告 - 通过将字段从报告的一个区域移动到另一个区域，动态改变分析 - 使 Excel 数据透视表报告具备独特外观 - 为您的数据透视表报告添加新字段或项目 - 通过 Excel PivotChart 对报告进行可视化 - 从 Microsoft Access、文本文件、SQL Server 等其他来源分析数据 - 使用 PowerPivot 和 DAX 语言处理大数据 课程内容包括： - 数据透视表基础知识：何时使用数据透视表、数据透视表的组成及其局限性。 - 创建基本数据透视表：准备数据集、创建数据透视表及使用切片器工具。 - 自定义数据透视表：如何修改外观、布局更改、计算修改以及使用不同的排名选项。 - 数据透视表字段的分组、排序和过滤。 - 在数据透视表中执行计算：计算字段和项目的规则及维护方法。 - 使用数据透视表分析不同数据源：多重合并范围的使用及构建外部数据源的数据透视表。 最后，课程将介绍 PowerPivot 和 DAX 语言，帮助用户以闪电般的速度处理大量数据。本课程适合希望提高办事效率的日常 Excel 用户，尤其是那些每天制作出色动态报告的专业人士。如果您已经了解数据透视表但希望熟悉 Excel 2016 的新功能，本课程同样适合您。 欢迎查看课程的免费预览。我相信这门课程将改变您对 Excel 数据透视表的看法。享受课程，感谢您的阅读。
Teaching 11 Courses on Excel and Data Analysis! OVER 25,000 visitors visit my blog ExcelDemy dot com every month!! OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!! Course Updated: Nov 01. 2016Welcome to my course on Excel Pivot Table with Excel 2016. In this course, you will learn Excel Pivot Tables from Scratch to Advanced Level with introduction to Power Pivot & DAX Language. I am Kawser Ahmed, your instructor with this course. I am a full time Excel, Excel VBA and Data Analytics blogger. And I am a corporate Excel trainer in my own country. Monthly around 15,000 Excel users come to my Excel blog ExcelDemy dot com and read my Excel and data analysis related articles and tutorials. At the end of this course, you will be able to: Create a summary report from 1 million rows of transactional data or moreChange your analysis on the fly by simply moving fields from one area of a report to anotherGive a standalone look to your Excel Pivot Table ReportAdd new fields or items to your pivot table reportMake visualizations of your report through Excel PivotChartAnalyze data from Microsoft Access, Text files, SQL Server and other sourcesAnd you will be able to handle big data using PowerPivot and DAX language. Let me give you an idea what exact topics I am going to teach you in this course. I will start with Pivot Table Fundamentals. Topics covered in this section are:Why and when you will use Excel Pivot Table,Anatomy of a pivot table,And limitations of Pivot Table Reports.In the Create Basic Pivot Table section, topics covered are:Prepare a data set for Excel Pivot Table,Create a basic pivot table from that data,And slicer tool.In the Customize a Pivot Table section, I will cover the following topics:Make common cosmetic and major changes to your Pivot Table Report,Make layout changes,Customize the pivot table appearance with Styles and Themes,Change summary calculations,Add and remove subtotals,And how to use Running Total, % Of, and other Rank Options.In the Grouping, Sorting and Filtering Pivot Data section, I will teach you these topics:Group pivot fields,And sort and filter a pivot table.In the Performing Calculations within Pivot Tables section: I will introduce you with:Calculated Fields and Items,Their rules and shortcomings,And how to manage and maintain pivot table calculations.In the Analyze Disparate Data Sources with Pivot Tables section, I will show you:How to use multiple consolidation ranges,And how to build pivot table using external data sources.And at the end of the course, I will introduce you with PowerPivot and DAX Language. Using PowerPivot, you can handle millions of rows data in lightning speed. I have designed this course for regular Excel users who want to boost up their office productivity, especially for professionals who make stunning and dynamic reports every day. But if you are already known with Excel Pivot table but want to get used to with Excel 2016 Pivot table features, then this course is also for you. This course will give you a simple but powerful introduction to the most powerful tool in Excel. Feel free to take a look at the free previews of this course. I hope this course will change your view about Excel Pivot Table. Enjoy the course and thanks for reading.
