|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-excel-fundamentals-everything-beginner/
课程评论：没有评论
**课程摘要：掌握 Excel 基础 - Excel 入门课程** 本课程由 Excel 专家 Michael Bouwer 教授，旨在帮助 Excel 新手用户从最基础的原理开始，逐步掌握创建功能性公式和引用的工作表。课程内容涵盖了许多对所有用户而言并非显而易见的常见知识点，完全无需任何 Excel 基础。 Michael Bouwer 强调，大量用户由于不了解本课程涵盖的核心原则，而错失了 Excel 的许多强大功能。本课程强烈推荐给希望精通 Excel 或成为优秀 Excel 使用者的学习者。 **课程主要内容包括：** * Excel 界面布局和菜单的理解 * 简单的数据录入技巧 * 公式创建和常用函数 * 格式化工具和工作表操作 * 打印设置 * 图表的创建、编辑及其元素 * 视图调整，以及多工作表和工作簿的协同工作 * 高级函数，如 IF、VLOOKUP 和 COUNTIF 系列函数 * 工作表和工作簿的保护方法 * 数据管理的实用工具 * 数据分析工具 * 专门的 PivotTable 模块，涵盖创建、操作和图表分析 * 宏的入门介绍 所有课程资源文件均可免费下载。
Excel expert Michael Bouwer helps new users of Microsoft Excel from the most fundamental and basic principles all the way to creating their own worksheets with functioning formulas and references.This course guides you through some of the most common knowledges, that is not so common to all. No prior knowledge of Excel required.Michael have experienced thousands of users that simply don't know about the essential principles covered in this course, and so miss out on a multitude of Excel functionality.If you want to become proficient or even just a great user of Microsoft Excel, then this course comes highly recommended.Topics include:Understanding the Excel Layout and Screen with MenusSimple Data Entry TechniquesCreating Formulas and Common FunctionsUnderstanding Formatting Tools and Worksheet ManipulationPrintingCreating and Editing Charts and its elementsAdjusting your View as well as working with Multiple Worksheets and WorkbooksSome Advanced Functions, such as IF, VLOOKUP and COUNTIF Family of FunctionsHow to Protect your Worksheets and WorkbooksFeatures to do Proper Data ManagementTools for Data AnalysisEntire Module Dedicated to PivotTables, from Creation to Manipulation to ChartingAn Introduction to MacrosAll the Resource Files are provided which can be downloaded for free.
