|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-365-microsoft-office-beginner-course/
课程评论：没有评论
**《Microsoft Excel 365 入门课程》内容摘要** 本课程是 Microsoft Excel 365 深度入门系列的第一部分，旨在帮助您掌握 Excel 365 的基本使用和操作。课程由拥有丰富行业经验和教育背景的微软认证专家教授。 **课程涵盖以下核心内容：** * **Excel 365 新特性：** 了解 Excel 365 相较于旧版本的异同，以及新功能的更新机制。 * **Excel 启动与界面：** 熟悉 Excel 的各项界面元素，包括工作簿、工作表、单元格、功能区及其自定义，以及常用快捷操作（查找替换、复制粘贴、撤销重做等）。 * **创建新工作簿：** 学习输入和编辑文本、数字、日期，进行单元格格式化，以及条件格式化、边框和背景的应用。 * **组织工作表：** 掌握冻结窗格、拆分窗格、创建、重命名、隐藏和取消隐藏工作表/行/列。此外，还将学习使用格式刷、设置对齐方式和文本换行，数字和日期的格式化，以及数据的复制和粘贴（包括选择性粘贴）。 * **基本公式与函数：** 学习创建和应用基础公式，如求和、自动求和，以及公式的复制。您还将了解公式语法、插入函数、自动计算以及加减乘除等基本运算。 * **使用模板：** 学习如何创建和使用Excel模板，并应用样式和主题来美化您的工作表。 课程最后提供可下载的测试测验及答案，帮助您巩固所学知识。
Learn how to use and work with Excel 365 from Microsoft Office. This is a in-depth beginner class and part one of 3 courses Beginner, Intermediate and Advanced. This course covers new features of Excel 365, Starting up and working with Excel, Creating new workbooks, Organizing your worksheet, Basic formulas, Using templates and themes, and a downloadable Test Quiz is included with enclosed answer key. This Excel 365 class is taught by a Microsoft Certified Professional and Comptia A+ Computer expert. He has been the President and owner of a computer repair, networking and software company for the past 20 years. He has 3 college degrees in computers which include computer science, programming, networking and GIS. He has programmed, designed, and created professional software programs. He has helped and taught over 3,000 clients how to use Microsoft computer software, hardware and peripherals.In this beginner course we will go over the following: Chapter 1: New Features for 365OverviewHow Excel is different from older versionsWhat is new in Excel 365How new features are added365 using Office and Excel365 in the CloudExample of a Excel wookbook/worksheetChapter 2: Starting up ExcelOverviewOpening up a workbook and worksheetThe Excel ScreenDifference between a workbook, worksheet and spreadsheetcells, gridlines, entering data, sheet tabsThe Title bar, Quick access tool bar and nameboxFile tab, backstage minitool barCustomizing and using the Ribbon and KeyTipsFinding and replacing data, undo/redo, copy and paste, selecting cellsscrolling, adjusting columns, rowsinserting and deleting rows and columns, adjusting cellsUsing AutofillUsing CommentsThe file, view tab, workbook window, status barzoom sliderfont styles and effectsChapter 3: Creating new workbooksOverviewEntering text, numbers and datesEditing dataMore on Editing dataDesigning borders and backgroundsopening and saving workbooksexcel file formatsusing conditional formattingChapter 4: Organizing your worksheetOverviewFreeze panesSplit panescreating, renaming hiding, unhiding worksheetsFormat PainterAlignment and wrap textFormatting numbers and datescopying and moving worksheetshiding and unhiding rows and columnscopying and pasting data numbers, using paste specialChapter 5: Basic FormulasOverviewFormulas and functionsCreating basic formulasSum a column of numbers, autosumcopying a formula to other cellssimple formula syntaxinserting functionsauto calculateadd, subtract, multiply and divide cellsediting a range of cellsChapter 6: Using a TemplateOverviewCreating and using templatesApplying styles and themesConclusionDownloadable Test Quiz is included with answer key.
