|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-microsoft-excel-formulas-and-functions-with-examples/
课程评论：没有评论
课程名称：Excel公式与函数：制作基础与高级公式 课程概述： 本课程共包含11个关于Excel和数据分析的课程！每月有超过25,000名访客访问我的博客ExcelDemy，自2015年11月以来，已有超过15,000名学生成功完成我的在线课程，并获得375条总评价！课程于2016年11月01日更新。Excel的公式和函数是Microsoft Excel电子表格的核心，是操作数据和提取Excel工作簿有用信息的基础。如果没有Excel的公式和函数，Excel电子表格将只是一个华丽的文字处理文档。欢迎参加我的Excel公式与函数课程，让我们来看看您将从中学到什么。 您将学习的内容包括： - 运算符及其优先级：课程将从基础开始讲解Excel公式中运用的运算符和优先级，使您能够解码复杂的Excel公式。 - 如何使用内置的Excel函数：学习如何通过插入函数和函数参数对话框将内置函数应用于Excel公式。 - 小计函数：详细讲解小计函数的多种用法，尤其适用于财务相关工作。 - 相对、绝对和混合单元格引用：这三种概念将在您构建Excel公式时频繁使用，因此会在课程中详细讲解。 - 与表格的公式：理解Excel表格中的公式工作方式至关重要，课程将通过两节讲座进行讲解。 - 如何处理循环引用、功能名称及范围与Excel公式的结合等。 同时，您将学习一些重要的数学函数，如SUM、AVERAGE、MAX、MIN、INT等，以及计数相关的Excel函数。课程还包括3-D引用和高级Excel公式，比如IF、IFERROR、日期相关函数及文本处理函数。 您将有一个专门的部分学习如何使用Excel函数进行文本操作。您还会学习VLOOKUP、INDEX和数组公式。课程最后，您将构建一个专业的Excel模板，学习如何使用Excel函数构建复杂的Excel公式。 课程内容不仅限于此，未来我还将持续添加新的讲座，帮助您应对现实生活中的问题，利用Excel公式和函数。如果您希望通过真实项目学习高级Excel公式和函数，那么这个课程非常适合您。感谢您的阅读，祝您学习愉快！
Teaching 11 Courses on Excel and Data Analysis! OVER 25,000 visitors visit my blog ExcelDemy dot com every month!! OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!! Course Updated: Nov 01. 2016 Excel formulas and functions are the heart of Microsoft Excel spreadsheet. They are essential to manipulating data and obtaining useful information from your Excel workbooks. Without Excel formulas and functions, Excel spreadsheet would simply be a fancy word-processing document. Welcome to my Excel Formulas and Functions course. Let's discuss now what you will learn from this course. Operators and Precedence of Operators: I will start from zero and if you don't know about the operators and precedence of operators that Excel uses in its formulas, then it will be tough for you to decode complex Excel formulas. So I have covered them in very details.How to use built-in Excel functions: Then you will learn how to use built-in excel functions into the Excel formulas using the Insert Function and Function Arguments dialog box. Subtotal Function: You will find many uses of Subtotal function if you are using Excel with your finance related jobs. So this function is covered in details at the start of the course.Relative, Absolute and Mixed Cell References: You will work with these three concepts time to time when you will build excel formulas. So, they have got a good time in the course.Formulas with Tables: Understanding how formulas work with Excel tables is very important. I have used two lectures to cover Excel formulas with tables. In the second lecture, structured referencing with Excel tables has been discussed. Then you will learn how to handle circular references with Excel formulas, how named cells and ranges work with Excel formulas, and so on.Mathematical functions are very important in your daily work with finance or any kind of jobs. In this course, you will learn about SUM, AVERAGE, MAX, MIN, INT, MOD, ROUND, RAND, and RANDBETWEEN Excel functions. Counting related excel functions are also covered in this course. Then you will work with 3-D Referencing with Excel Formulas.In Advanced Excel formulas, you will learn: IF, IFERROR, DATE related functions, Text manipulating functions, and many more.Manipulating Text using Excel Functions: There is a section where you will learn how to manipulate text using Excel formulas and functions.Then you have worked with VLOOKUP, INDEX, and Array formulas.And at the end of the course, you will build a professional Excel template where you will learn how to make complex Excel formulas using Excel functions.Here is not the end of the course. Time to time, I shall add more lectures to the course that will teach you how to face real life problems using Excel formulas and functions. So, if you are interested to learn advanced Excel formulas and functions with a real life project, then this course is for you. Thanks for reading. Enjoy the course!
