|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-formulas-learn-them-by-solving-problems/
课程评论：没有评论
课程名称：Microsoft Excel 公式 [通过解决问题学习] 课程概述：您是否想学习如何使用Excel公式，但觉得有些困难？您是否需要Excel来在工作中取得成功，却不知道从何入手？如果您的答案是“是”，那么本课程将通过小案例研究教您30多种Excel公式，旨在消除困惑。我有信心，此课程将提升您对Excel公式的理解和效率，因此我向您保证！本模块专注于所有类型的Excel公式，包括数学公式、逻辑公式、查找公式、文本公式及日期时间公式。在您进入下一个模块之前，这个模块将让您对公式有一个扎实的掌握。 为什么要选择本课程？ 1. 掌握Excel的基础从学习公式开始，掌握30多种公式后，您将成为Excel的高手，能够进一步深入学习。 2. 学习Excel可以轻松做到，但将其应用于数据集以解决商业问题时，您才会真正清晰理解概念。我保证您在课程结束时会对所有30多种公式有全面而扎实的理解。 课程内容： - 如何使用MIN、MAX、AVERAGE、SUM、LARGE、RAND BETWEEN、ROUND、SUBTOTAL、SUM PRODUCT及LARGE公式。 - 如何使用VLOOKUP、HLOOKUP、MATCH、INDEX及INDEX与MATCH的组合。 - 如何使用CONCATENATE、LOWER CASE、UPPER CASE、PROPER、LEFT及RIGHT。 - 如何使用DATE、NOW、TODAY及WEEKDAY。 - 如何使用OR、AND、IF、SUMIF、SUMIFS、COUNTIF、COUNTIFS公式。 每个公式的使用方法及应用场景会有完整的演示。感谢您花时间查看我的课程，我迫不及待想帮助您提升Excel公式的水平！请记住，如果您在注册后的30天内对所学内容不满意，或者在工作中没有看到成效，可以获得全额退款。如果您准备好了，请点击“参加此课程”按钮，几个小时后您会惊讶于自己能用Excel完成的事情。 适合人群： 本课程适合从初学到高级的Excel用户，但主要针对初级和中级学习者。如果您希望更清楚地理解如何使用Excel公式、它们的来源以及一些技巧来简化公式的使用，那么这门课程适合您。
Do you want to learn how to use Excel Formulas but find it all a bit Difficult?Do you need Excel to succeed at work, but wonder where to even start?If your Answer is YES, in this course we will teach you 30+ Excel Formulas without any confusion by applying them on small Case Studies.I'm so confident that this course will increase your efficiency and understanding of Excel formulas that I guarantee it!This Module completely focuses on Excel Formulas from all categories Namely Mathematical, Logical, Look Up, Text & Date and Time. This Module will give you a firm grip on the formulas before you start with the next Modules.Why should you take this course?1. To Have a Mastery on Excel one should always start with the Basic things like learning the formulas, by mastering all the 30+ Formulas you can be a PRO in basic excel and move on to the next steps in learning Excel2. Learning Excel anyone can do, but applying them on data sets with a business question, that's when your concepts get cleared.I guarantee you will have a complete & a sound understanding of all the 30 + Formulas by the end of this course.I get right to the point in every lecture. I know you're busy so I don't waste a lot of time on tangents, personal stories or filler like many instructors do. If the lecture is about VLOOKUP, I'm going to get straight to teaching you how to use VLOOKUP so you can put it to use right away.Who is this course for?This course is designed for All Phases of Excel learners who are new to using formulas to make calculations in Excel. It is also appropriate for anyone who wants to learn to use formulas but feels intimidated or overwhelmed.What's included in the course:1. How to use the MIN, MAX, AVERAGE, SUM, LARGE, RAND BETWEEN, ROUND, SUBTOTAL, SUM PRODUCT & LARGE.How to use VLOOK UP, HLOOK UP, MATCH , INDEX & COMBINATION OF BOTH INDEX & MATCH.How to use CONCATENATE, LOWER CASE, UPPER CASE, PROPER, LEFT & RIGHT.How to use DATE, NOW, TODAY & WEEKDAY.How to use OR, AND, IF, SUMIF, SUMIFS, COUNTIF, COUNTIFS.A complete demonstration of how to use each formula and what to use if for.Thanks for taking the time to check out my course. I can't wait to help you take your Excel Formulas to the next level!Remember, If you aren't 100% satisfied with ANYTHING that you've learned or you don't see the results in your work within 30 days of signing up, get a FULL REFUND.If you're ready to get started, click on the "Take This Course" button and in just a couple of hours you'll be amazed at what you can do with Excel.Who this course is for:· This course is suitable for any level of Excel user from beginning to advance but it is mostly geared toward beginning and intermediate level learners.· This course is for you if you are looking for a clearer understanding of how to use Excel Formulas where to find them and some tips and tricks to make your work with formulas easier.
