|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-2016-complete-beginner-to-advanced-excel-course/
课程评论：没有评论
**课程名称：** Excel 精通全攻略：从入门到高级 **课程概述：** 本课程是目前为止最全面、最深入的Microsoft Excel学习体验。Excel是当今职场中最不可或缺的技能之一。熟练掌握Excel能够显著提升您的工作表现，为您争取加薪、晋升或获得心仪新工作的机会。 无论您是Excel新手还是希望提升技能的专业人士，本课程都将引导您从最基础的操作（如打开和保存工作簿）一路学习到专业级的进阶技巧，例如数据透视表和宏。 本课程旨在赋予您获得加薪、晋升或新工作所需的Excel技能。课程内容基于Excel 2016制作，但同样适用于Office 365、Excel 2019、2013和2010版本。课程主要针对PC用户，Mac用户也能从中受益，但可能不包含Mac特有的快捷键和界面操作。 您将从零开始，学习Excel的基本操作，了解各项工具的功能，并掌握所有您需要知道的Excel技巧。课程将教授您如何输入和格式化数据，创建图表、表格和数据透视表以组织和分析数据。您还将学习神奇的键盘快捷键，提高工作效率，并掌握如何录制宏，通过一个按钮执行一系列复杂的操作。 学完本课程，您将比大多数日常使用Excel的职场人士掌握更多技能。 **您将学习到的部分内容包括：** * 在Excel中创建电子表格 * 安全地保存您的工作 * 处理多个工作簿 * 数据格式化和打印 * 从CSV文件、Access数据库和网页导入数据 * 创建和使用各类公式和函数，如VLOOKUP、INDEX/MATCH、IF函数等 * 创建多种图表，包括条形图、折线图、柱形图、饼图等 * 创建和使用表格 * 数据排序和筛选 * 创建数据透视表 * 从数据透视表中创建数据透视图 * Excel中的新功能 * 提高工作速度的键盘快捷键 * 录制基本宏以自动执行重复性任务 * 以及更多高级技能。 本课程提供结业证书，并享有30天全额退款保证。如遇问题，讲师随时可以解答疑问或提供额外资源。 感谢您关注我的Excel课程！期待在课程中与您相见！
Welcome to my BIGGEST, most complete, Microsoft Excel course ever!Excel is one of the most important skills in today's job market. Having a solid working knowledge of Excel can improve your job performance, help you qualify for raises and promotions, or even help you land that new job that you deserve.If you need to know Excel, you're in the right place. This course walks you through Excel from the very basics of opening Excel all the way to advanced Excel skills used by the pros, like pivot tables and macros.My goal with this course is to give you the skills you need to get that raise, promotion, or new job you deserve.This course was created using Excel 2016, but it is good for versions 365, 2019, 2013 and 2010, as well. It was created for use with a PC (personal computer). Mac (Macintosh) users can still benefit from this course, but the course doesn't cover Mac-specific keyboard shortcuts and interface.We'll start at the very beginning, with opening and saving a worksheet in Excel. I'll show you what all the tools do and walk you through each Excel skill that you need to know.I'll show you how to enter and format your data and how to create charts, tables and pivot tables so you can organize and analyze your data. I'll teach you amazing keyboard shortcuts to make your work faster and more productive. You'll learn how to record macros so you can do a whole series of actions with the just click of a button.We'll keep going until you're a pro at Excel. When you finish this course, you'll know more than most people who use Excel at their job every day.Here's some of what you'll learn.Creating spreadsheets in ExcelSaving your work where you can find itWorking with multiple workbooks in ExcelFormatting and printingImporting data from CSV files, Access and the webCreating and using formulas and functions like: Vlookup, Index/Match, If statements and dozens of othersCreating charts including: Bar charts, Line charts, Column charts, Pie charts and moreCreating tablesSorting and filtering your dataCreating pivot tablesCreating pivot charts from your pivot tablesFun New features for ExcelKeyboard shortcuts to make your work go fasterHow to record basic macros to automate repetitive tasksA whole lot moreThe course comes with a certificate of completion, a full 30-day money back guarantee, and I'm always available to answer questions or share additional resources if you get stuck.Thanks for checking out my biggest Excel course ever!I'll see you in there!
