|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/introduction-to-microsoft-excel-365/
课程评论：没有评论
**课程名称：** Microsoft Excel 365 入门 **课程概述：** 本课程为期3.5小时，共5个章节，包含100多个简短、技巧性强的视频，旨在教授Microsoft Excel 365的基础知识。课程将引导学习者从Excel界面导航、数据输入和基本格式设置入手，逐步深入到函数与公式的应用、图表添加以及数据分析。内容特别适合大学生和专业人士，提供具体技能培训。 **课程章节内容：** 1. **Excel入门：** 熟悉Excel界面，学习工作簿导航，数据录入与简单格式设置。掌握图表基础、基本公式构建、函数、绝对与相对单元格引用（重点强调）。学会使用模板创建工作簿及管理多个工作簿。 2. **单元格格式设置：** 专注于单元格和单元格区域的操作，包括数据移动、单元格的插入、删除和合并。学习条件格式设置，提升工作簿的可读性。 3. **公式与函数使用：** 学习Excel内置函数，用于统计计算、日期处理、文本操作、逻辑判断、贷款计算和表格查找。此外，还将学习使用命名区域创建公式，并掌握必要的故障排除技巧。 4. **工作表格式设置与工作簿管理：** 学习管理工作表的组织结构和外观，优化屏幕显示和打印效果，以应对日益复杂Excel项目。 5. **图表添加与数据分析：** 引入数据分析概念，学习使用图表可视化数据。通过表格和数据透视表进行数据排序、筛选和汇总。掌握数据表和单变量求解进行“假设分析”。 **课程特色：** * 时长：3.5小时 * 章节：5个 * 视频数量：100+个（简短、技能导向） * 目标学员：大学生、职场人士 * 教学方法：逐步引导，技巧性强
Learn Microsoft Excel with this training course consisting of 3.5 hours, 5 chapters, and over 100 brief, skill specific videos.During this introductory course on using Microsoft Excel 365, we'll teach the basics of using Microsoft Excel.Your instructor will walk you through Excel's features, starting with the basics, then formatting cells, using functions and formulas, adding charts and analyzing data. The course contains over 100 brief and strategic videos that teach specific skills for college students and professionals.Chapters included with this course:Getting Started with ExcelThis chapter provides you with the basic skills necessary to start working with Excel. The first step is to become familiar with the Excel interface and learn how to navigate a workbook. Next, you'll learn to to enter data and apply simple formats. You'll learn about charts and the building blocks for basic formulas, functions, absolute and relative cell references. Pay close attention to the concept of relative and absolute cell references. To help you start using Excel for your own purposes, you will learn how to create a workbook from a template and manage multiple workbooks. Formatting CellsThis chapter focuses on skilling for working with cells and cell ranges. You will learn to move data - to insert, delete and merge cells. This chapter also covers conditional formatting to enhance a workbook and make the data easier to understand.Using Formulas and FunctionsIt's time to go beyond simple formulas. In this chapter you will learn to use functions built into Excel to compute statistics, insert dates, modify text, work with logical expressions, compute loan payments and perform table lookups. You will also create formulas that reference named ranges and learn essential troubleshooting skills.Formatting Worksheets and Managing the WorkbookAs Excel projects get bigger and more complicated, more formatting skills are required. In this chapter you will learn how to manage the organization and appearance of worksheets for optimal display on-screen and when printed.Adding Charts and Analyzing DataThis chapter introduces data analysis. You will learn to use charts to visualize data; to use tables and PivotTables to quickly sort, filter and summarize data. You will conduce what-if analysis using data tables and goal seek.
