|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ms-excel-manage-and-report-with-microsoft-excel-basic/
课程评论：没有评论
**课程名称：** MS Excel：使用 Microsoft Excel 进行管理和报告（基础） **课程概述：** 在当今数据爆炸的时代，企业和非营利组织需要跟踪、管理、分析和解读海量数据。Microsoft Excel 作为一款广泛使用的工具，能够灵活应对这些需求，无需重复创建数据。本课程由 LinCademy 提供，旨在通过 26 个循序渐进的实用教程，帮助您掌握 Microsoft Excel 的基础知识，从而创建有价值的文档和知识，辅助您和您的同事做出更明智的决策。 **课程将帮助您：** * **理解 MS Excel 界面：** 熟悉 Excel 的整体布局和操作环境。 * **掌握常用菜单功能：** * **文件菜单（File Menu）：** 学习文件的创建、保存、打开等基本操作。 * **开始菜单（Home Menu）：** 掌握文本格式化、单元格样式、排序和筛选等常用编辑功能。 * **插入菜单（Insert Menu）：** 学习插入图表、表格、图片、形状等元素。 * **页面布局菜单（Layout Menu）：** 了解如何设置页面边距、方向、纸张大小等，以适应打印需求。 * **公式菜单（Formulas Menu）：** 学习使用各种内置函数进行计算，例如 SUM、AVERAGE、IF 等。 * **数据菜单（Data Menu）：** 掌握数据排序、筛选、数据透视表、数据验证等数据处理工具。 * **审阅菜单（Review Menu）：** 学习拼写检查、批注、保护工作表等功能。 * **视图菜单（View Menu）：** 了解如何调整显示方式、冻结窗格、拆分窗口等。 * **熟练处理数据：** * **使用 Excel 模板：** 学习利用预设模板快速创建专业文档。 * **日期处理：** 掌握 Excel 中日期数据的输入、格式化和运算。 * **数字处理：** 学习数字格式、数值计算和数据分析。 * **文本处理：** 掌握文本的输入、编辑、查找和替换，以及文本函数的应用。 * **计算应用：** 深入理解如何在 Excel 中进行各种复杂的计算。 * **优化打印设置：** 学习如何设置页面和配置打印选项，确保报告和文档的完整和美观。 通过本课程，您将全面掌握 Microsoft Excel 的基础操作和核心应用，为您的工作和学习带来高效和便利。
There's now an explosion of data and statistics that businesses and non-profits need to track, manage, analyze, and interpret. To handle this, you'd need a flexible tool you can use for each instance without having to recreate the data over and over again. Fortunately, Microsoft has created its widely used tool - Excel. Excel allows you to be able to display calculations and analysis that you determine are necessary. It will also help you create sensible documents and knowledge.This step-by-step, practical course from LinCademy will provide you with all what it takes to master the basics of using Microsoft Excel that will help you to create sensible documents and knowledge. And you can use these documents to create knowledge for yourself and others you work with. Developing the skill of using Excel will also help you create data on demand to create good decisions.Throughout 26 tutorials, you will practically learn the basics of Microsoft Excel. You will understand how to deal with its interface and use its basic elements and menus such as File Menu, Home menu, Insert menu, Layout menu, Formulas menu, Data menu, Review menu, and View menu. You will also learn the needed elements to help you enter and manipulate data such as using Excel templates, and calculations, etc.By taking this concise course, you will master the following:Understanding MS Excel InterfaceWorking with the File and Home menusWorking with the Insert and Page Layout menusWorking with the Formulas and Data menusWorking with the Review and View menusWorking with Excel templatesWorking with dates in ExcelWorking with numbers in ExcelWorking with text in ExcelWorking with calculations in Excel Understanding how to set up pages in ExcelUnderstanding how to configure print settings in ExcelAnd much more...So, grab this great opportunity and start the course now.
