|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-2019-beginner-to-expert-step-by-step-course/
课程评论：没有评论
**课程名称：Microsoft Excel 初学者入门班** **课程概述：** 本课程旨在帮助零基础学员全面掌握 Microsoft Excel 的各项功能，从入门到精通。课程涵盖 Excel 2007 至 2019 及 Office 365 的所有版本，但课程内容主要以 Excel 2019 版本录制。 **课程内容：** * **Excel 基础知识：** * 了解 Excel 的启动屏幕和模板。 * 熟悉 Excel 的界面组成部分。 * 学习简单的函数应用。 * 掌握工作表主题、Excel 模板的使用。 * 学习工作表的编组、页面布局和自定义视图。 * 数据格式化和自动填充功能。 * 各种打印选项的设置，确保打印输出的完美呈现。 * **实践练习：** * **A. 创建工作簿：** 学习关闭现有工作簿、创建新工作簿、保存工作簿以及为文件添加属性标签（如 exceptions, regional, percentage, performance）和自定义属性（如 Performance）。 * **B. 修改工作簿：** 学习在工作表中插入新列和新行，清除格式，隐藏列，删除单元格（并移动其他单元格），插入单元格（并移动其他单元格）以及移动单元格区域。 * **C. 合并和拆分单元格：** 学习合并单元格（包括跨列合并和居中），以及拆分已合并的单元格。 * **D. 自定义 Excel 2019 应用窗口：** 学习将按钮添加到快速访问工具栏，调整功能区选项卡的顺序，创建自定义功能区选项卡和组，并将常用功能（如“拼写检查”、“样式”和“数字”组）添加到自定义选项卡或组中，最后保存自定义设置。 本课程将引导您一步步学习这个市场上最受欢迎的电子表格工具，让您从 Excel 的初学者成长为高效使用者。
Excel Complete A to Z Microsoft Excel Course. Excel 2007, 2010, 2013, 2016, 2019 and Office 365. Become 0 to hero!!Microsoft Excel Step by Step Complete Course.Material recorded with Excel 2019 but works in 2007, 2010, 2013, 2016, (Office 365)Enroll now to go through a step by step of the most popular spreadsheet tool on the market, Microsoft Excel.This section of the course start with the fundamentals, the absolute basics.Getting in and understanding what excel is all about. Its interface, understanding the different parts of Microsoft Excel 2019.We will talk about Start Screen and Templates from scratch. Discuss Simple Functions. Learn about Worksheet Themes and Excel Templates.Grouping worksheets. Page layout and custom views. Formatting data, Auto-fill function. Looking into various Printing options found in Microsoft Excel 2019.Making sure your final product what you print out from excel looks perfect.PRACTICE TASKS==============================A. Create workbooksOpen the Create Workbooks workbook in Excel, and then perform the following tasks:1. Close the Create Workbooks file, and then create a new, blank workbook.2. Save the new workbook as Exceptions2018.3. Add the following tags to the file's properties: exceptions, regional, and percentage.4. Add a tag to the Category property called performance.5. Create a custom property called Performance, leave the value of the Type field as Text, and assign the new property the value Exceptions.6. Save your work=====================================B. Modify workbooksOpen the Modify Workbooks workbook in Excel, and then perform the following tasks:1. On the May 12 worksheet, insert a new column A and a new row 1.2. After you insert the new row 1, click the Insert Options button, and then click Clear Formatting.3. Hide column E.4. On the May 13 worksheet, delete cell B6, shifting the remaining cells up.5. Click cell C6, and then insert a cell, shifting the other cells down. Enter the value 4499 in the new cell C6.6. Select cells E13:F13 and move them to cells B13:C13====================================================C. Merge and unmerge cellsOpen the Merge Cells workbook in Excel, and then perform the following tasks:1. Merge cells B2:D2.2. Merge and center cells B3:F3.3. Merge the cell range B5:E8 by using Merge Across.4. Unmerge cell B2.======================================================D. Customize the Excel 2019 app windowOpen the Customize Ribbon Tabs workbook in Excel, and then perform the following tasks:1. Add the Spelling button to the Quick Access Toolbar.2. Move the Review ribbon tab so it is positioned between the Insert and Page Layout tabs.3. Create a new ribbon tab named My Commands.4. Rename the New Group (Custom) group to Formatting.5. In the list on the left side of the Excel Options dialog box, display the main tabs.6. From the buttons on the Home tab, add the Styles group to the My Commands ribbon tab you created earlier.7. Again using the buttons available on the Home tab, add the Number group to the Formatting group on your custom ribbon tab.8. Save your ribbon changes and click the My Commands tab on the ribbon
