|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-for-data-business-analytics/
课程评论：没有评论
**Microsoft Excel for Data & Business Analytics** 课程概述： 本课程旨在帮助您从零基础到精通 Excel，自信地将“高级 Excel 技能”添加到您的简历中，或快速掌握新工作的要求。无论您是 Excel 初学者，还是希望夯实技能的进阶用户，本课程都能满足您的需求。 **课程亮点：** * **从入门到精通：** 涵盖 Excel 基础知识、关键公式和函数、图表与可视化、数据分析，以及 Pivot Table、Power Query 和 DAX 等高级主题。 * **现代 Excel 功能：** 学习 Excel 2021/Office 365 的新功能，包括 XLOOKUP、FILTER、SORT、SORTBY 和 UNIQUE 函数。 * **深度实用性：** 提供丰富的场景示例、 exclusivo 模板以及仪表板报告技巧，帮助您在实际工作中脱颖而出。 * **Python 集成：** 新增 Python 模块，拓展您的数据分析能力。 * **广泛适用性：** 课程内容几乎适用于所有 Excel 版本（2010 及以上）。 **课程内容模块：** * A - Excel 基础（适合初学者） * B - Excel 核心 * C - Excel 公式与函数 * D - 数据分析 * E - Excel 图表与可视化 * F - Pivot Table * G - 现代 Excel - DAX 和 Power Query * H - 附加学习 1 - Excel 仪表板报告与技巧 * I - 附加学习 2 - 高级 Excel - 更多场景示例 * J - 独家模板 * K - 15 个 Excel 函数复习 本课程不仅为初学者打下坚实基础，还为中高级用户填补知识空缺，包含许多数据分析师都不知道的 Excel 技巧和隐藏功能。
Introduction:Are you ready to take your Excel skills to the next level?Do you want to pursue a career in Excel related work?Are you finding that employers these days want 'Advanced Excel Skills'?Or maybe you've started a new job that requires more advanced Excel skills.Do you struggle with Excel?Not sure which formula to use for your situation?Are you tired spending hours online trying to get "RIGHT" help?When asked to make a dashboard or report, not sure where to start?Module K - 15 Excel Functions Refresher, Module J - Exclusive Templates, Module I - Additional Learning 2 - Advanced Excel - More Scenario Examples, Module H - Additional Learning 1 - Dashboard Reporting in Excel with Tips, Module G - Modern Excel - DAX and Power Query, Module F - Pivot Table, Module E - Excel Charts and Visualizations, Module D - Data Analysis, Module C - Excel Formulas and Functions, Module B - Excel Essentials, Module A - Excel Basics (for Beginners)Our Excel course is designed to take you from zero to hero so you can confidently list 'Advanced Excel Skills' on your resume/CV, or quickly get to grips with the requirements of a new job.I have used the Excel 2021 / Office 365 to record these videos. Almost everything covered in this course will work for all the Excel versions (2010, 2013, 2016, 2019 & Office 365).IS THIS ONLINE EXCEL COURSE FOR BEGINNERS ONLY?This Complete Excel Course is for two types of people:Excel beginners, i.e. anyone looking to learn Excel from scratchExcel intermediate and Excel advanced users who want to make sure their skills cover all the essentials. This includes many Excel tricks and hidden features few data analysts know of.The Excel Essentials for the Real World Course covers ALL the fundamentals an Excel beginner needs to know. BUT it also fills in the gaps for Excel Intermediate and Advanced users. It's for corporate professionals who feel comfortable with Excel but not 100% confident.This is more than an Excel Basics Course. It starts off easy and adds in tips and tricks many Excel advanced users don't know of.COURSE UPDATED to Include the BRAND NEW Excel Functions available in Microsoft 365 such as:Excel's new XLOOKUP functionNew FILTER function in ExcelSORT, SORTBY & UNIQUE functionsPYTHON Module is added
