|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-masterclass-beginer-to-advanced-level/
课程评论：没有评论
**课程名称：** Microsoft Excel 精通大师班 - 从入门到高级 **课程概述：** 本课程旨在帮助学员从Excel初学者成长为精通用户，掌握创建各类报表、图表和仪表板的技巧。Excel在数据分析和报告制作领域应用广泛，是处理数据的首选工具。本课程将教授简单高效的方法，只需短时间即可创建精美的Excel报告。 **您将学到：** * Excel报告的简便制作方法 * 关键快捷键的应用 * 常用公式和函数 * 报表保护技巧 * Subtotal、排序、筛选和高级筛选 * 数据链接和快速格式化 * 创建快速报告的高级技能 * 数据汇总、合并与整合技术 * 数据透视表和数据透视表图的应用 * VLOOKUP、XLOOKUP及其他高级功能 * 宏（Macros）与VBA编程入门 * Excel实用技巧与窍门 * 数据验证 * 快速创建报告和图表的方法 **先修知识：** * 基本的计算机知识 * 初级Excel技能 * 已安装Microsoft Office（推荐Office 365或Office 2016及以上版本），仅支持Windows系统。 **适合人群：** * 财务经理 * 学生 * 销售经理 * 培训经理 * 行政管理人员 * 人力资源经理 * 分析师 * 行政人员 * 数据分析师 * 教师 * 研究人员 * Excel爱好者 * 首席财务官（CFO） **教学目标：** 激发学习热情，教授Excel核心技能，使学员能够独立、高效地完成各类数据处理和报告制作任务。
A good teacher can inspire hope, ignite the imagination, and instill a love of learning~Bred Henery~MS Excel is the first choice for any report. Data analysis is an exciting field to get into and the career prospects are amazing. You don't need to be a math/computer science/coding whiz to land a job in data analysis.Data Analysis in demand and we normally use Excel to create beautiful Charts and Graphs to show the results. MS Excel is the ultimate choice and widely used to prepare quick Reports and Dashboards and easy to understand that is the reason it has become the first choice of a Data Analysis.In this Course I will teach you to create some beautiful Excel based Reports by simple techniques in quick time.WHAT YOU WILL LEARNSimple methods to Excel ReportsUsing key ShortcutsFormulas and FunctionsProtect your ReportsSubtotals, Sorting, FilterAdvanced Filter, Linking of Data and quick FormattingAdvanced Skills to create quick ReportsConsolidation of Data, Combining and Merging TechniquesPivot Tables & Pivot ChartsVlookup, Xlookup, Advanced FeaturesMacros and VBAExcel Tricks and TechniquesData ValidationQuick way to create Reports and ChartsPREREQUISITESBasic Computer knowledgeBasic level Excel skillsMS office installed (better office 365 or office 2016 and above) on Windows based (but not Mac)WHO THIS COURSE IS FOR?Finance ManagerStudentsSales ManagerTraining ManagerExecutivesHR ManagersAnalystAdminData AnalystTeacherResearcherExcel LoverCFOHappy Learning!Thanks & RegardsAsif Hafeez
