|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-365-essentials/
课程评论：没有评论
**课程名称：Microsoft Excel 365 基础** **课程概述：** 本课程作为Microsoft Excel 365的入门教程，旨在帮助学员高效、有效地掌握Excel的基本操作和核心功能。课程从Excel界面概览开始，让学员熟悉功能区、光标选项以及基础数据输入技巧。 **核心学习内容：** * **数据格式化：** 学习美化数字、样式和表格，提升数据可视化效果和可读性。 * **公式与引用：** 掌握相对引用和绝对引用在公式中的应用，并学习使用自动填充及自定义列表加速工作。 * **条件格式：** 利用图标和色阶突出显示重要数据。 * **数据管理与分析：** 学习使用排序和筛选功能有效组织和分析大型数据集。 * **工作簿管理：** 掌握冻结窗格、拆分窗口和打印选项等工具，高效管理大型工作簿。 * **图表制作与应用：** 学习创建和格式化各类图表（如柱形图、饼图），并将图表插入PowerPoint进行演示。 **课程亮点：** * 提供可下载的课程讲义和练习文件，方便学员随堂练习。 * 包含3小时以上的视频教程，共41个视频讲座。 * 通过实践练习巩固所学知识，确保学员能将技能应用于实际工作中。 * 适合Excel初学者及需要复习巩固Excel技能的学习者。 **课程目标：** 完成本课程后，学员将具备扎实的Excel 365基础，能够自信地处理各种数据相关的任务。 **课程包含：** * 3小时+视频教程 * 41个视频讲座 * 课程及练习文件 * 结业证书
**This course includes downloadable course instructor files and exercise files to work with and follow along.**This Microsoft Excel 365 Essentials course will teach you the fundamental skills to use Excel efficiently and effectively. Starting with an overview of Excel, you will get comfortable with the ribbon, cursor options, and basic data entry techniques. This course is designed to help you master Excel's powerful formatting features, formulas, and data management.You will discover how to format numbers, styles, and tables to make your data visually appealing and easy to read. The course will introduce you to essential formulas, including how to use relative and absolute references. You will also learn about AutoFill and creating custom lists to speed up your work.Conditional formatting will teach you to highlight important data using icons and color scales. Sorting and filtering techniques will help you organize and analyze large datasets effectively. You will also learn to manage large workbooks with tools like freeze panes, splitting, and printing options.Charts are a vital part of data presentation, and you will learn how to create and format different types of charts, including column and pie charts. Additionally, you will practice inserting charts into PowerPoint for professional presentations.By the end of this course, you should have a solid foundation in Excel 365, enabling you to handle various data-related tasks confidently. Each section includes practical exercises to reinforce your learning and ensure you can apply what you've learned. This course is perfect for beginners and those looking to refresh their Excel skills.In this course, you will learn how to:Navigate the Excel ribbon and cursor options.Enter and format data effectively.Apply number and style formatting to tables.Use formulas with relative and absolute references.Utilize AutoFill and create custom lists.Implement conditional formatting based on cell content.Sort and filter data for better analysis.Create and format various types of charts.This course includes:3+ hours of video tutorials41 individual video lecturesCourse and exercise files to follow alongCertificate of completion
