|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-basic-easy/
课程评论：没有评论
**Excel基础入门课程总结** 本课程由AulaGEO提供，旨在帮助学员掌握Microsoft Excel的基础操作和核心功能。课程内容循序渐进，从基本概念到高级应用，涵盖了电子表格的创建、数据管理、图表制作以及打印设置等方面。 **第一单元：基础概念** 本单元将介绍Excel的核心术语，帮助学员建立对电子表格软件的初步认识。学员将学习如何创建、保存和检索Excel文件，并熟悉Excel界面的不同选项卡和功能区（Ribbon）的配置和使用。 **第二单元：数据管理** 本单元是课程的核心部分，学员将学会如何在电子表格中输入和管理数据。课程将详细讲解Excel的各个选项卡中的菜单功能，特别是“文件”选项卡、“开始”选项卡下的“剪贴板”、“字体”、“对齐方式”工具组，以及“数字”、“单元格”和“编辑”工具组的各项功能。学员将学习如何预设单元格格式以适应不同类型的数据输入，如何插入和格式化行、列和工作表，以及如何使用求和、平均值、最大值、最小值等常用函数，并创建数字和日期序列。 **第三单元：图像和图形管理** 本单元将重点介绍Excel的“插入”选项卡中的各项功能。学员将学习如何插入和操作表格、插图（如图片、形状、SmartArt）以及不同类型的图表和迷你图，并了解如何根据软件提供的选项来自定义图表。 **第四单元：页面准备与演示** 本单元将教授学员如何为打印和演示优化Excel工作表。学员将学习“页面布局”选项卡下的各项功能，包括主题设置、页面配置（如页边距、方向、纸张大小）等，以确保打印效果符合要求。此外，课程还将介绍如何使用“审阅”和“视图”选项卡中的拼写检查和插入批注功能，提升工作表的可读性和协作性。 **最终项目** 课程的最后将有一个最终项目，让学员有机会运用所学知识，完成一项综合性的Excel任务。 通过本课程的学习，学员将能够熟练运用Excel进行数据录入、处理、分析，并能制作出专业、美观的图表和报表。
Course Definition:This is an introductory course in the Microsoft Office Excel program.The functionality of electronic sheets is explained step by step.#AulaGEOWhat will the user learn?Unit 1: BASIC CONCEPTSConceptualization of the basic terms to start the course.Episode 2:We started with the creation of a book, how to save and retrieve it, strengthening the knowledge of file management.Chapter 3We will describe the different tabs and what they consist of, as well as the handling and configuration of the ribbon.PRACTICE 1Unit 2: DATA MANAGEMENTStart working with Excel by entering Information into the spreadsheet and describing each of the menu functions within the program tabs.Chapter 4Description of the file tab or menu.Chapter 5: Tab or menu "start"From this point on, we will describe the contents of the "start" tab and each of the groups of tools."Clipboard" tool group:Chapter 6Tool group "Source":Chapter 7Aligment tool group:PRACTICE 2Chapter 8Explanation of how we can pre-configure cells to receive numerical information in pre-established formats according to user needs.Chapter 8 part 1: "Number" tool group:Chapter 8 part 2: "Number" tool group:Chapter 9Here we will see how to insert rows, columns and sheets as well as how to format each of these.Cells tool group:Chapter 10In this chapter we will know the handling of functions such as sum, average, high value, low and how we can elaborate series of numbers of numerical or chronological type.Chapter 10 part 1: "Editing" tool groupChapter 10 part 2: "Editing" tool groupPRACTICE 3Unit 3: MANAGEMENT OF IMAGES AND GRAPHICSThe commands of the "insert" tab and the commands of tool groups will be explained, likewise, an explanation of the handling of the different types of graphics that the program has, as well as how they can be customized according to the options provided by the software.Chapter 11:Chapter 11 Part 1: "Table" and "Illustrations" ToolkitChapter 11 Part 2: "Graphics" and "Mini Graphics" ToolkitUnit 4: PREPARATION OF PAGES FOR PRINTING AND PRESENTATION.Chapter 12We will see in this chapter everything related to preparing the files for printing and personalizing the presentation of the spreadsheets in the "page layout" tab.Chapter 12 part 1 "themes" and "configure page" toolkitChapter 12 part 2 "configure page" toolkitPRACTICE 4Chapter 13In this chapter we will see the spelling check with the office applications and how to insert comments in the "Check" and "View" tool group:FINAL PROJECT
