|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-excel-with-practice/
课程评论：没有评论
课程名称：Microsoft Excel - 建立商业应用 课程概述：该课程将提升您使用Microsoft Excel作为商业工具的能力，并不仅仅是将其视为一个优秀的软件。课程适合具备基本Excel知识的学生，旨在教授更高级的技巧，使学生成为Excel在商业应用方面的专家。课程通过循序渐进的步骤构建关键Excel公式的技能，每个阶段均提供实践练习和解决方案。完成课程后，学生将精通使用IF、AND和OR构建复杂商业规则，并能够验证数据，选择性地保护工作簿、工作表和单元格。同时，学生将开发一个小型商业应用，展示如何以实用的方式使用这些公式。 课程内容和概述：适合任何具备Excel基本知识的人，课程开头将回顾Excel的基本知识，特别是绝对引用的使用，帮助熟悉Excel的学员重新理清关键技巧。接着，我们将介绍条件逻辑函数（如IF、AND和OR函数），并探讨如何将它们结合在一起构造复杂的语句，实现复杂的商业规则。随后，我们将学习如何构建描述商业规则的商业规则表，并将其与复杂的条件逻辑公式结合起来，搭建灵活且强大的小型商业应用。整个课程通过一个示范应用程序来说明所涉及的技巧。课程结束时，您将对自己作为小型商业应用开发的Excel有效用户充满信心，并参与一系列全面的练习和解决方案。 此课程的目标是为学生提供实际的、结构化的Excel开发方法，使他们能够在商业环境中熟练地应用Excel，掌握关键技能。课程由经验丰富的讲师授课，曾成功为大量大学生传授此材料。
This course will transform your ability to use Microsoft Excel as a business tool - not just as a great piece of software! It is aimed at students who have a basic knowledge of Microsoft Excel and who want to learn more advanced techniques in order to become expert in the key skills for using Excel as a business application. The course builds your skills in the use of key Excel formulas in a step-by-step manner, with practical exercises and solutions provided at each stage. On completion students will be expert in the use of IF, AND and OR to build complex business rules, will be able to Validate their data and will be able to selectively protect their application at the workbook, worksheet and cell level. They will have developed a small business application which will illustrate how to use these formulas in a practical and useful manner. Build a strong foundation in Advanced Excel for Building Small Business Applications Recap Excel Fundamentals Learn how to use Business Rules Tables in Excel Apply Conditional Functions to Business Applications Step by Step Learning Approach Comprehensive Examples Comprehensive Exercises and solutions Critical Skill for Business People Excel is one of the most widely used software applications on the planet. Many people take courses in Excel but never really learn how to apply it in practice in business situations. It is true that it is a complex piece of software with many, many functions to choose from in order to build applications. The problem for many people however, is that they don't have a structured approach to the development of business applications with Excel. You don't have to be an expert in order to learn how to use a small number of key techniques which will make you proficient in making Excel work for your business. That's what this course will do for you. Learn from an experienced instructor who has delivered this material to many hundreds of university level students with great success. Learn how to apply your Excel knowledge with a practical and well defined development approach. Content and Overview Suitable for anyone who has a basic understanding of Excel, this course starts with a recap on the fundamentals of Excel, and in particular, on the use of Absolute Referencing. So if it has been a while since you've used Excel your memory will be refreshed on the key techniques required. then we move into the use of Conditional Logic functions such as IF, AND and OR functions, and how you can combine them to construct complex statements which allow you to implement complicated business rules. Next we look at how you can construct Business Rules Tables which describe the rules which apply to a business. These are then combined with the complex conditional logic formulas to build flexible and powerful small business applications. Throughout the course we use a sample application to illustrate all of the techniques involved. By the end of the course you will be confident in your ability to be an effective user of Excel for small business application development. The course includes a comprehensive series of exercises and solutions.
