|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-basic-to-advance-level-a/
课程评论：没有评论
课程名称：Microsoft Excel - 基础到高级水平 课程概述： 这个Microsoft Excel课程将您带入一个全面的世界，涵盖9个不同的模块，助您提升技能，创造更美好的明天。课程内容包括：1. Excel界面基础与自定义 - 日常时间节省技巧；2. 在Excel工作表中格式化数据；3. 在Excel工作表中插入图片和形状；4. 创建基本图表；5. 打印Excel工作表；6. 公式入门；7. 更多公式函数；8. 数据透视表、Power Pivot/Power Query与仪表板；9. 数据筛选/高级筛选/分组/小计。 通过参加这门课程，您将逐步掌握Excel的各项工具，从基础开始构建稳固的知识基础，逐渐深入到中级和高级主题。在课程结束时，您将自信地完成任何Excel任务，并有效率地使用Excel工具。您将学习到的技能包括：创建高效的电子表格、管理大量数据、掌握Excel的热门函数（如SUM、VLOOKUP、IF、AVERAGE、INDEX/MATCH等）、使用数据透视表生成动态报告、利用PowerPivot提高Excel的强大功能、审计Excel公式确保其正确性，并通过掌握宏和VBA自动化日常Excel任务。 现在就报名参加吧，迈出掌握Excel的下一步，从Excel新手变为专家！
Microsoft Excel Everything in one place for your better tomorrowThis Microsoft Excel course combines 9 different courses.1 Excel Screen Basics & Customization - Daily Time Saver2 Formatting Data in an Excel Worksheet.3 Inserting Images and Shapes into an Excel Worksheet.4 Creating Basic Charts in Excel.5 Printing an Excel Worksheet.6 Introduction to Formulas.7 More Formula Functions.8 PIVOT Table, Power Pivot/Power Query & Dashboard.9 Data Filter/Advanced Filter/Group/Subtotal.Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As your instructor, I will use my 20+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.As you participate in each of the 9 courses you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.At the completion of this course, you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:Creating effective spreadsheetsManaging large sets of dataMastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH, and many more...)Create a dynamic report with Excel PivotTablesUnlock the power and versatility of Microsoft Excel's AddIn, PowerPivotAudit Excel Worksheet formulas to ensure clean formulasAutomate your day to day Excel tasks by mastering the power of Macros and VBASo, what are you waiting for, enroll now, and take the next step in mastering Excel and go from Excel New?
