|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-advanced/
课程评论：没有评论
**课程名称：Microsoft Excel 高级：高级数据分析工具** **课程概述：** 本课程旨在帮助学员利用Excel进行高效的数据分析，通过电子表格以全新的方式解释、阐明和展示数据。学员将学习What-If Scenarios（假设分析）、Pivot Tables（数据透视表）、HLOOKUP和VLOOKUP函数（包括入门和高级应用），并初步了解Macros（宏）、基础VBA和UDFs（用户定义函数）。 课程还包含“专业级Excel课程”内容，增加额外价值。每门ZandaX Microsoft课程都提供可下载的工作簿和练习，包括“跟随式练习”（Lesson 1.1, Lesson 1.2等）和“技能巩固练习”（Skill Sharpeners），后者旨在强化学习效果。 授课 instructors 均为经验丰富的商业及教学领域的Microsoft专家。课程内容精炼，以易于理解的视频形式呈现，直击要点，优化学习时间。 **核心学习内容：** * **基础入门及进阶：** * Grouping（分组）、Outlining（大纲）和Subtotals（分类汇总） * What-If Analysis（假设分析）、Pivot Tables（数据透视表）和Pivot Charts（数据透视图） * HLOOKUP 和 VLOOKUP 函数 * Macros（宏）导论，提升电子表格效率 * **专业级进阶内容：** * Conditional Formatting（条件格式）、LOOKUPs（查找函数）、Pivot Tables（数据透视表）的高级应用 * 高级函数，如Error Function（错误函数）、Logical Functions（逻辑函数）和Array Formulas（数组公式） * VBA（Visual Basic for Applications）基础及User Defined Functions（用户定义函数, UDFs）的入门，提供实用知识而不过于复杂。 **学习成果：** 学员将能够创建不仅能展示数据，更能进行数据分析和灵活处理数据的电子表格。 **学习模式：** 每节讲座内容独立，方便学员根据需要选择学习。课程提供的工作簿和练习是深化学习的关键，鼓励学员下载并积极实践。本课程不止是视频讲解，通过配套的实践材料，提供极高的学习价值。
Are you looking to use Excel to analyze your data?With this course you'll enter the world of analyzing your data, using your spreadsheets to interpret, illuminate and present your data in a whole new way. And we show you how yo use What-If Scenarios, Pivot Tables, HLOOKUPs, VLOOKUPs at introductory and advanced levels. There are even introductions to Macros, basic VBA & UDFs.We have now included our Professional level Excel course to add even more value (the price is the same!)With every ZandaX Microsoft course, you get a workbook and exercises (downloadable from the "Introduction" module at the start of each course). There are two types of exercises: first of all, exercises to match the lessons (called Lesson 1.1, Lesson 1.2, etc) where you can "follow along" with the instructor or the workbook, and also Skill Sharpeners, where you are given exercises that will reinforce your learning. These all correspond exactly to the manual. So remember to download them, and the manual, from the "Introduction" module at the start of the course. People tell us that the Skill Sharpeners are a real bonus!Our Microsoft instructors are seasoned professionals - they don't just know the software: they've used it commercially and taught it in a classroom environment for years. You won't be in better hands!And we don't waffle! Do you want to sit through hours of over-explaining before you get the knowledge you need? We doubt it! So we make sure that everything is covered in easy-to-follow video lessons, and we get to the point so you make the best use of your time.You learn about Grouping, Outlining and Subtotals, and how to use What-If Analysis, Pivot Tables and Pivot Charts. Then we introduce you to HLOOKUPS and VLOOKUPS, and finish with an introduction to Macros which will make your spreadsheets FLY!The Professional level course takes you higher, with advanced treatment of Conditional Formatting, LOOKUPs, Pivot Tables, as well as how to use advanced functions like Error Function, Logical Functions and Array Formulas. Finally, we introduce you to the basics of VBA and User Defined Functions (UDFs) to give you a good working knowledge without getting too complex.You will now be able to produce spreadsheets that not only display your data, but analyze and play tricks with it too...Each lecture is self-contained, so you don't need to sit through them all: once you're at a comfortable level, you'll be able to use this as your reference library, where you can select what you want to view.We'll say it again: don't forget the course workbooks and exercises - downloadable with the first "Introduction" module in each course - which really enhance and deepen your learning. Remember that practice makes perfect!So this course is genuinely much more than just a set of talk-through videos. We don't think you'll find better value...
