|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-365-beginner-guide/
课程评论：没有评论
**课程名称：**Microsoft Excel 365：终极入门指南 **课程概述：** 本课程旨在帮助初学者掌握Microsoft Excel 365的核心功能，从基础操作到数据处理、图表制作及协作分享，助力您成为Excel达人。课程包含可下载的练习文件，方便学习者实践跟练。 **您将学到：** * **Excel基础：** 熟悉Excel 365界面，了解工作簿、工作表，掌握数据输入、格式设置和基本导航。 * **公式与函数：** 理解运算顺序，学习使用Excel“Big 6”基础函数进行计算，掌握相对引用、绝对引用和命名区域。 * **数据格式与条件格式：** 应用数字格式、单元格格式，使用格式刷复制格式，并探索条件格式的强大功能。 * **查找与逻辑：** 学习使用VLOOKUP和XLOOKUP进行数据查找，并应用逻辑函数做出更明智的决策。 * **数据管理与可视化：** 创建Excel表格，学会数据排序和筛选，制作各类图表（包括迷你图）以直观展示数据。 * **页面设置与打印：** 掌握冻结窗格、页面设置、页眉页脚和分页符的运用。 * **数据安全与分享：** 学习保护单元格、工作表和工作簿，了解不同文件格式的保存，以及在Excel Online、Microsoft Teams中进行实时协作和文件分享。 **课程特色：** * 10+小时视频教程 * 100+个独立视频讲座 * 提供配套的课程和练习文件 * 完成课程可获得结业证书
**This course includes downloadable instructor files to work with and follow along.Are you ready to conquer Excel 365 like a pro? Look no further. Our Microsoft Excel 365 Ultimate Beginner Guide is the perfect starting point for students and anyone eager to dive into the world of number-crunching, data organizing, and chart making. Need to know your cells from your columns? No worries, as we'll guide you through Excel's interface, introducing you to the world of workbooks and worksheets. Learn to navigate like a champ. Say goodbye to manual calculations and discover how to enter data efficiently, format numbers, and work with basic formulas and functions. Make graphs your secret weapon. Uncover the power of Excel's charting tools. We'll teach you how to create eye-catching visuals to impress your colleagues and managers. Data can be messy, but not for you. We'll explore how to sort, filter, and manage data effectively. Learn to share your work, collaborate with peers, and ensure your Excel skills shine in group projects. We'll cover sharing options and tips for stress-free teamwork. Become an Excel efficiency expert and discover shortcuts, hidden gems, and tips that will save you time and frustration. You can be an Excel guru in no time. By the end of this course, you should be able to confidently tackle Excel spreadsheets and impress your professors or future employers. So, what are you waiting for? Let's embark on this Excel adventure together. In this course, you will learn how to:Access the Microsoft 365 online portal, launch Excel desktop, navigate the interface, and improve efficiency with keyboard shortcuts. Understand the order of operations and the BODMAS rule and use the 'Big 6' basic Excel functions to create formulas. Know the difference between absolute and relative referencing, create named ranges, and use named ranges in formulas. Apply number formatting, format cells, rows, and columns, copy formatting with Format Painter, and work with conditional formatting.Perform lookups with VLOOKUP and XLOOKUP and use logical functions to make better decisions. Create and use Excel tables, sort and filter list data, present data with charts, and insert in-cell charts like sparklines. Freeze and unfreeze panes, adjust page setup options, and insert headers, footers, and page breaks. Protect cells, worksheets, and workbooks from editing and save the workbook in different file formats. Work with files in Excel Online, co-author spreadsheets with others in real time, and share workbooks with others. Add an Excel workbook to a Teams channel and share in a Teams meeting. This course includes:10+ hours of video tutorials100+ individual video lecturesCourse and exercise files to follow alongCertificate of completion
