|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-training-course-2021/
课程评论：没有评论
**课程名称：** MS Excel 从基础到高级的完整培训课程 **课程概述：** 本课程为希望学习Microsoft Excel并提升数据分析技能的初学者或进阶者量身打造。讲师结合其15年的金融和项目管理经验，以及作为Excel MVP积累的实用技巧，精心设计了本课程。课程内容涵盖从数据输入、导航到高级的自动化数据分析，旨在帮助学员高效、轻松地处理和分析数据。 **核心内容：** * **Excel基础：** 掌握数据输入、表格导航等核心操作。 * **效率提升：** 学习Excel中的“黑科技”技巧，加快工作效率。 * **常用函数与公式：** 深入学习VLOOKUP、IF、ROUND、SUMIFS、嵌套IF等关键函数，实现数据自动化分析。 * **隐藏功能应用：** 掌握Excel的隐藏功能，将杂乱数据转化为清晰的洞察。 * **数据整理与可视化：** 学习组织、清洗、管理大数据，并根据设计原则创建吸引人的Excel报告。 * **图表制作：** 将杂乱数据转化为有用的图表。 * **交互式报告：** 学习使用数据透视表、数据透视图、切片器和时间线创建交互式报告。 * **数据导入与转换：** 掌握使用Get & Transform (Power Query)等工具导入和转换数据。 * **进阶主题：** 涵盖条件格式、Excel表格以及Power Query等进阶内容。 **学习方式：** * 课程贯穿实际操作示例，加深对每个函数和功能的理解。 * 提供实践挑战和考试，检验学习成果。 * 提供PDF格式的课程笔记，方便复习和查阅。 **学习目标：** 完成课程后，学员将能够自信地在工作中运用新的Excel技能，包括： * 熟练输入数据和导航大型表格。 * 运用Excel技巧快速高效地完成工作。 * 选择合适的Excel公式自动分析数据。 * 利用Excel的隐藏特性整理数据，提取关键信息。 * 从数据中获取有价值的答案。 * 组织、清洗和管理大数据。 * 创建专业、美观的Excel报告和可视化图表。 * 利用数据透视表等工具创建交互式仪表板。 * 使用Power Query高效地导入和处理数据。
Want to learn Microsoft Excel and improve your data analysis skills, but don't know where to start?OR Have you been using Microsoft Excel for a while but don't feel 100% secure?There is so much information out there. What do you need to be successful at work?I've selected the basic Excel skills data analyzers need and combined them in a structured course.In fact, I've put together the most common Excel problems my clients face. I am adding to my 15 years of experience in finance and project management. I've included all the hidden tips and tricks I learned from Excel as an MVP and included EVERYTHING in THIS course. I've also made sure that it really covers Excel beginners.This practical example will help you understand the full potential of each function. You'll learn how to use Excel for fast and painless data analysis.There are many useful and time-saving formulas and functions in Excel. We tend to forget what they are when we don't use them. This Microsoft Excel Essentials course will give you the practice you need to best implement the solutions to your assignments. That way, you can achieve more in less time.By the end of the course, you can be sure that you will showcase your new Excel skills on the job. So you can:Enter data and navigate large tablesApply hacks in Excel to get work done fasterChoose the right Excel formula to automate your data analysis (Excel VLOOKUP, IF function, ROUND, etc.).Use Excel's hidden features to turn cluttered data into precise notesGet answers from your dataOrganize, clean and manage big dataCreate attractive Excel reports following a number of spreadsheet design principlesTurn cluttered data into useful chartsCreate interactive reports with Excel pivot tables, pivot charts, slicers, and timelinesImport and transform data using tools like Get & Transform (Power Query).We'll start with the basics of Microsoft Excel to make sure we have the basics right. We move on to advanced topics like conditional formatting, Excel spreadsheets, and Power Query. We cover important formulas like VLOOKUP, SUMIFS, and nested IF functions.As well as discussing the purpose of a feature or formula, I'll also cover how you can use it with practical examples.There are challenges and exams along the way to test your new Excel skills.Your Excel course download notes are available as PDF files. They discuss the most important points. Have it ready and refer to it when you need it.
