|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-zero-to-hero/
课程评论：没有评论
课程名称：Excel从零到英雄：学习初学者的智能Excel技巧 课程概述：如果你希望成为Excel高手并提升自己的技能，这个全面的课程将是你的理想选择。在这个课程中，你将学习从基本的格式和公式到创建数据透视表和图表、使用文本函数以及审计电子表格等高级技巧。无论你是初学者，还是想要提高现有技能，这个课程旨在帮助你从基础水平提升到Excel的高级水平。 课程内容将从格式化的基础知识开始，包括如何格式化字体、数字、单元格，冻结行和列，以及有效使用文本到列功能。接着，我们将深入学习重要的Excel函数，如SUM、SUMPRODUCT、CONCATENATE、VLOOKUP、HLOOKUP、COUNT、COUNTA、COUNTIF、SUMIF、AVERAGE、MAX、MIN等。 学完基础后，你将学习如何创建数据透视表和图表，使用最新的文本函数，如TEXTBEFORE、TEXTAFTER、TEXTSPLIT等。此外，你也会掌握Excel的财务函数，如NPV、XNPV、IRR、XIRR、MIRR等，保护和解除保护工作表的技巧，以及如何应对忘记密码的问题。 课程还将介绍各种令人惊叹的复制和粘贴选项，例如粘贴数学运算、粘贴列宽、粘贴可见单元格和粘贴注释。你将学习如何管理外部链接、打印Excel工作簿，并使用ROUND等函数进行数字处理。 此外，我们会涵盖从单元格提取数据的函数，包括LEFT、MID、RIGHT以及改变游戏规则的Flash Fill。你将学会使用TRANSPOSE函数转换行和列，并有效运用XLOOKUP。同时，还会学习如何转换文本的大小写及去除多余的空格。 课程结束后，你将全面掌握Excel，能够自信地分析数据、创建报告并做出明智的决策。这将使你在职业生涯中脱颖而出，成为Excel专家。那么，你还在等什么？今天就报名参加这个Excel在线课程，开启你的Excel高手之旅吧！
If you're looking to become an Excel pro and level up your skills, you've come to the right place. In this comprehensive course, you will learn everything from the basics of formatting and formulas to advanced techniques such as creating pivot tables and charts, working with text functions, and auditing your spreadsheets. Whether you're a beginner or looking to brush up on your skills, this course is designed to take you from a basic level to an advanced level of proficiency in Excel.We will start with the basics of formatting, including how to format fonts, numbers, cells, freeze rows and columns, and use the Text-to-Columns feature effectively. Then, we will dive into essential Excel functions such as SUM, SUMPRODUCT, CONCATENATE, VLOOKUP, HLOOKUP, COUNT, COUNTA, COUNTIF, SUMIF, AVERAGE, MAX, MIN, and many more. You will learn how to create pivot tables and charts, and use the latest text functions such as TEXTBEFORE, TEXTAFTER, TEXTSPLIT, VSTACK, HSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, CHOOSECOLS, CHOOSEROWS, TAKE, DROP.Moving on, you will learn about Excel finance functions such as NPV, XNPV, IRR, XIRR, MIRR, RATE, NPER, PV, PMT, IPMT, FV, FVSCHEDULE, and EFFECT. Additionally, you will learn how to protect and unprotect sheets and break the password if you forget it. You will also explore amazing copy and paste options such as paste math operations, paste column widths, paste visible cells, and paste comments. You will learn how to manage external links, print an Excel workbook, and round numbers using functions such as ROUND, ROUNDDOWN, ROUNDUP, TRUNC, INT, MROUND, CEILING, FLOOR, EVEN, ODD.We will then cover functions to extract data from cells, including LEFT, MID, RIGHT, and the game-changing Flash Fill. You will learn how to switch rows and columns using the TRANSPOSE function, and how to use XLOOKUP effectively. Additionally, you will learn how to change the case of text and remove unnecessary spaces.By the end of this course, you will have a comprehensive understanding of Excel, and be able to confidently use it to analyze data, create reports, and make informed decisions. You will have the skills to take your career to the next level, and stand out as an Excel expert.So, what are you waiting for? Sign up for this Excel online course today and start your journey to becoming an Excel pro!
