Microsoft Excel - Building Business Applications

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

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.

Who this course is for:

  • This course is suitable for any student who has a basic knowledge of Microsoft Excel
  • The course is aimed at students who wish to advance their knowledge of using particular Excel functions and how to apply them in practice
  • Suitable for students who need to be able to manage and manipulate data in Excel
  • Students who need to use Microsoft Excel more efficiently
  • It is not suitable for an absolute beginner

Course content

8 sections • 22 lectures • 1h 24m total length
  • Review of the Essentials
    04:36

Expected Outcomes

  1. Develop a small business application which utilises Key Excel business functions Develop complex formulas in Microsoft Excel using IF, Nested IF, AND and OR statements and combinations of these functions in the development of a small business application Understand and be able to create Rules Tables to manage business rules in Microsoft Excel applications Link data spreadsheets among multiple spreadsheets in order to develop user friendly interfaces Know how to use validation techniques in their developed applications in order to ensure the integrity of their data Understand the importance of, and be capable of, properly testing developed formulas Know how to selectively protect their Excel applications at workbook, worksheet and cell levels so as to ensure that users cannot accidentally erase or modify important information in applications Requirements Students should be aware that the exercises are challenging and to get the best out of the materials a reasonable effort is required on the part of the individual student to complete the exercises provided Students are provided with exercises as downloadable resources Solutions for all of the exercises are provided in both video and Microsoft Excel templates The course has been developed using Microsoft Excel 2016, however, previous versions from Excel 2010 onward will be suitable Description 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. Who this course is for: This course is suitable for any student who has a basic knowledge of Microsoft Excel The course is aimed at students who wish to advance their knowledge of using particular Excel functions and how to apply them in practice Suitable for students who need to be able to manage and manipulate data in Excel Students who need to use Microsoft Excel more efficiently It is not suitable for an absolute beginner Show more Show less Course content 8 sections • 22 lectures • 1h 24m total length Expand all sections Course Introduction 2 lectures • 8min Introduction to A Practical Guide to Building Small Applications in Excel Preview 03:48 Review of the Essentials 04:36 IF Statements 2 lectures • 10min Introduction to IF Statements Preview 05:08 Nested IF Statements 04:58 Introduction to AND and OR Statements 3 lectures • 10min Introduction to AND Statements 04:51 Combining IF and AND Statements 03:14 Introduction to OR Statements 01:50 A Business Example using Rules Tables 5 lectures • 20min Applying Nested IFs to a Business Based Example 05:28 Setting Up The Rules Table 04:58 Using a Rules Table 04:33 More Customers - Using Absolute References 02:39 Moving the Rules Table 02:19 The HelpLess Airlines Application 4 lectures • 10min Introduction to the HelpLess Airlines Application 04:09 Rule 1 - Age Discounts 02:59 Rule 2 - Luggage Charges 01:34 Rules 3, 4 & 5 - Priority Booking, Row Reservations and Value Added Tax 01:41 HelpLess Airlines Solutions 3 lectures • 13min Rule 1 - Age Discount Solution Preview 04:13 Rule 2 - Luggage Charge Solution 04:44 Rule 3, 5 & 5 - Priority, Row Reservation and VAT Solutions 04:22 Validating and Protecting Your Data 2 lectures • 11min Introduction to Data Validation Preview 05:34 Protecting Your Data 05:17 Course Conclusion and Bonus Lecture 1 lecture • 1min Course Conclusion and Bonus Lecture 01:17 Instructor Dave Murphy University Lecturer 4.5 Instructor Rating 2,987 Reviews 11,888 Students 18 Courses With over twenty years experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the worlds largest companies, Dave Murphy changed career track in 2000 and has been a professional university educator for over eighteen years. His main interests are in Microsoft Certifications, Project Management and Business Process Analysis. Dave has a B.Sc (Hons) from Trinity College Dublin and an M.Sc Degree in Computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in Managing Projects with Microsoft Project, is a MOS Master and a MOS examiner. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781a68a4b0353d3',m:'a42ee38c36ecb84e2937575e6f1977d6cf925b68-1627848005-1800-AWiHIZziIwYNPaLhckPM3YaJEx5A014quVFLDrc/9qO/R1LL4wu9eFa60rwOdPq6EGpV/J3uBnr56MXw7DDkec7H7ZZwhrcXCHZmVlgc2nii/zVSPIsRWHroxSk/0PkPN2FtPqmVg2QKIdssJ8cjivlR3uMSLQopMdozGs0s5kga',s:[0xbc2e598cb7,0x319e7887f1],}})();
  2. Develop complex formulas in Microsoft Excel using IF, Nested IF, AND and OR statements and combinations of these functions in the development of a small business application Understand and be able to create Rules Tables to manage business rules in Microsoft Excel applications Link data spreadsheets among multiple spreadsheets in order to develop user friendly interfaces Know how to use validation techniques in their developed applications in order to ensure the integrity of their data Understand the importance of, and be capable of, properly testing developed formulas Know how to selectively protect their Excel applications at workbook, worksheet and cell levels so as to ensure that users cannot accidentally erase or modify important information in applications Requirements Students should be aware that the exercises are challenging and to get the best out of the materials a reasonable effort is required on the part of the individual student to complete the exercises provided Students are provided with exercises as downloadable resources Solutions for all of the exercises are provided in both video and Microsoft Excel templates The course has been developed using Microsoft Excel 2016, however, previous versions from Excel 2010 onward will be suitable Description 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. Who this course is for: This course is suitable for any student who has a basic knowledge of Microsoft Excel The course is aimed at students who wish to advance their knowledge of using particular Excel functions and how to apply them in practice Suitable for students who need to be able to manage and manipulate data in Excel Students who need to use Microsoft Excel more efficiently It is not suitable for an absolute beginner Show more Show less Course content 8 sections • 22 lectures • 1h 24m total length Expand all sections Course Introduction 2 lectures • 8min Introduction to A Practical Guide to Building Small Applications in Excel Preview 03:48 Review of the Essentials 04:36 IF Statements 2 lectures • 10min Introduction to IF Statements Preview 05:08 Nested IF Statements 04:58 Introduction to AND and OR Statements 3 lectures • 10min Introduction to AND Statements 04:51 Combining IF and AND Statements 03:14 Introduction to OR Statements 01:50 A Business Example using Rules Tables 5 lectures • 20min Applying Nested IFs to a Business Based Example 05:28 Setting Up The Rules Table 04:58 Using a Rules Table 04:33 More Customers - Using Absolute References 02:39 Moving the Rules Table 02:19 The HelpLess Airlines Application 4 lectures • 10min Introduction to the HelpLess Airlines Application 04:09 Rule 1 - Age Discounts 02:59 Rule 2 - Luggage Charges 01:34 Rules 3, 4 & 5 - Priority Booking, Row Reservations and Value Added Tax 01:41 HelpLess Airlines Solutions 3 lectures • 13min Rule 1 - Age Discount Solution Preview 04:13 Rule 2 - Luggage Charge Solution 04:44 Rule 3, 5 & 5 - Priority, Row Reservation and VAT Solutions 04:22 Validating and Protecting Your Data 2 lectures • 11min Introduction to Data Validation Preview 05:34 Protecting Your Data 05:17 Course Conclusion and Bonus Lecture 1 lecture • 1min Course Conclusion and Bonus Lecture 01:17 Instructor Dave Murphy University Lecturer 4.5 Instructor Rating 2,987 Reviews 11,888 Students 18 Courses With over twenty years experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the worlds largest companies, Dave Murphy changed career track in 2000 and has been a professional university educator for over eighteen years. His main interests are in Microsoft Certifications, Project Management and Business Process Analysis. Dave has a B.Sc (Hons) from Trinity College Dublin and an M.Sc Degree in Computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in Managing Projects with Microsoft Project, is a MOS Master and a MOS examiner. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781a68a4b0353d3',m:'a42ee38c36ecb84e2937575e6f1977d6cf925b68-1627848005-1800-AWiHIZziIwYNPaLhckPM3YaJEx5A014quVFLDrc/9qO/R1LL4wu9eFa60rwOdPq6EGpV/J3uBnr56MXw7DDkec7H7ZZwhrcXCHZmVlgc2nii/zVSPIsRWHroxSk/0PkPN2FtPqmVg2QKIdssJ8cjivlR3uMSLQopMdozGs0s5kga',s:[0xbc2e598cb7,0x319e7887f1],}})();
  3. Understand and be able to create Rules Tables to manage business rules in Microsoft Excel applications Link data spreadsheets among multiple spreadsheets in order to develop user friendly interfaces Know how to use validation techniques in their developed applications in order to ensure the integrity of their data Understand the importance of, and be capable of, properly testing developed formulas Know how to selectively protect their Excel applications at workbook, worksheet and cell levels so as to ensure that users cannot accidentally erase or modify important information in applications Requirements Students should be aware that the exercises are challenging and to get the best out of the materials a reasonable effort is required on the part of the individual student to complete the exercises provided Students are provided with exercises as downloadable resources Solutions for all of the exercises are provided in both video and Microsoft Excel templates The course has been developed using Microsoft Excel 2016, however, previous versions from Excel 2010 onward will be suitable Description 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. Who this course is for: This course is suitable for any student who has a basic knowledge of Microsoft Excel The course is aimed at students who wish to advance their knowledge of using particular Excel functions and how to apply them in practice Suitable for students who need to be able to manage and manipulate data in Excel Students who need to use Microsoft Excel more efficiently It is not suitable for an absolute beginner Show more Show less Course content 8 sections • 22 lectures • 1h 24m total length Expand all sections Course Introduction 2 lectures • 8min Introduction to A Practical Guide to Building Small Applications in Excel Preview 03:48 Review of the Essentials 04:36 IF Statements 2 lectures • 10min Introduction to IF Statements Preview 05:08 Nested IF Statements 04:58 Introduction to AND and OR Statements 3 lectures • 10min Introduction to AND Statements 04:51 Combining IF and AND Statements 03:14 Introduction to OR Statements 01:50 A Business Example using Rules Tables 5 lectures • 20min Applying Nested IFs to a Business Based Example 05:28 Setting Up The Rules Table 04:58 Using a Rules Table 04:33 More Customers - Using Absolute References 02:39 Moving the Rules Table 02:19 The HelpLess Airlines Application 4 lectures • 10min Introduction to the HelpLess Airlines Application 04:09 Rule 1 - Age Discounts 02:59 Rule 2 - Luggage Charges 01:34 Rules 3, 4 & 5 - Priority Booking, Row Reservations and Value Added Tax 01:41 HelpLess Airlines Solutions 3 lectures • 13min Rule 1 - Age Discount Solution Preview 04:13 Rule 2 - Luggage Charge Solution 04:44 Rule 3, 5 & 5 - Priority, Row Reservation and VAT Solutions 04:22 Validating and Protecting Your Data 2 lectures • 11min Introduction to Data Validation Preview 05:34 Protecting Your Data 05:17 Course Conclusion and Bonus Lecture 1 lecture • 1min Course Conclusion and Bonus Lecture 01:17 Instructor Dave Murphy University Lecturer 4.5 Instructor Rating 2,987 Reviews 11,888 Students 18 Courses With over twenty years experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the worlds largest companies, Dave Murphy changed career track in 2000 and has been a professional university educator for over eighteen years. His main interests are in Microsoft Certifications, Project Management and Business Process Analysis. Dave has a B.Sc (Hons) from Trinity College Dublin and an M.Sc Degree in Computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in Managing Projects with Microsoft Project, is a MOS Master and a MOS examiner. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781a68a4b0353d3',m:'a42ee38c36ecb84e2937575e6f1977d6cf925b68-1627848005-1800-AWiHIZziIwYNPaLhckPM3YaJEx5A014quVFLDrc/9qO/R1LL4wu9eFa60rwOdPq6EGpV/J3uBnr56MXw7DDkec7H7ZZwhrcXCHZmVlgc2nii/zVSPIsRWHroxSk/0PkPN2FtPqmVg2QKIdssJ8cjivlR3uMSLQopMdozGs0s5kga',s:[0xbc2e598cb7,0x319e7887f1],}})();
  4. Link data spreadsheets among multiple spreadsheets in order to develop user friendly interfaces Know how to use validation techniques in their developed applications in order to ensure the integrity of their data Understand the importance of, and be capable of, properly testing developed formulas Know how to selectively protect their Excel applications at workbook, worksheet and cell levels so as to ensure that users cannot accidentally erase or modify important information in applications Requirements Students should be aware that the exercises are challenging and to get the best out of the materials a reasonable effort is required on the part of the individual student to complete the exercises provided Students are provided with exercises as downloadable resources Solutions for all of the exercises are provided in both video and Microsoft Excel templates The course has been developed using Microsoft Excel 2016, however, previous versions from Excel 2010 onward will be suitable Description 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. Who this course is for: This course is suitable for any student who has a basic knowledge of Microsoft Excel The course is aimed at students who wish to advance their knowledge of using particular Excel functions and how to apply them in practice Suitable for students who need to be able to manage and manipulate data in Excel Students who need to use Microsoft Excel more efficiently It is not suitable for an absolute beginner Show more Show less Course content 8 sections • 22 lectures • 1h 24m total length Expand all sections Course Introduction 2 lectures • 8min Introduction to A Practical Guide to Building Small Applications in Excel Preview 03:48 Review of the Essentials 04:36 IF Statements 2 lectures • 10min Introduction to IF Statements Preview 05:08 Nested IF Statements 04:58 Introduction to AND and OR Statements 3 lectures • 10min Introduction to AND Statements 04:51 Combining IF and AND Statements 03:14 Introduction to OR Statements 01:50 A Business Example using Rules Tables 5 lectures • 20min Applying Nested IFs to a Business Based Example 05:28 Setting Up The Rules Table 04:58 Using a Rules Table 04:33 More Customers - Using Absolute References 02:39 Moving the Rules Table 02:19 The HelpLess Airlines Application 4 lectures • 10min Introduction to the HelpLess Airlines Application 04:09 Rule 1 - Age Discounts 02:59 Rule 2 - Luggage Charges 01:34 Rules 3, 4 & 5 - Priority Booking, Row Reservations and Value Added Tax 01:41 HelpLess Airlines Solutions 3 lectures • 13min Rule 1 - Age Discount Solution Preview 04:13 Rule 2 - Luggage Charge Solution 04:44 Rule 3, 5 & 5 - Priority, Row Reservation and VAT Solutions 04:22 Validating and Protecting Your Data 2 lectures • 11min Introduction to Data Validation Preview 05:34 Protecting Your Data 05:17 Course Conclusion and Bonus Lecture 1 lecture • 1min Course Conclusion and Bonus Lecture 01:17 Instructor Dave Murphy University Lecturer 4.5 Instructor Rating 2,987 Reviews 11,888 Students 18 Courses With over twenty years experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the worlds largest companies, Dave Murphy changed career track in 2000 and has been a professional university educator for over eighteen years. His main interests are in Microsoft Certifications, Project Management and Business Process Analysis. Dave has a B.Sc (Hons) from Trinity College Dublin and an M.Sc Degree in Computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in Managing Projects with Microsoft Project, is a MOS Master and a MOS examiner. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781a68a4b0353d3',m:'a42ee38c36ecb84e2937575e6f1977d6cf925b68-1627848005-1800-AWiHIZziIwYNPaLhckPM3YaJEx5A014quVFLDrc/9qO/R1LL4wu9eFa60rwOdPq6EGpV/J3uBnr56MXw7DDkec7H7ZZwhrcXCHZmVlgc2nii/zVSPIsRWHroxSk/0PkPN2FtPqmVg2QKIdssJ8cjivlR3uMSLQopMdozGs0s5kga',s:[0xbc2e598cb7,0x319e7887f1],}})();
  5. Know how to use validation techniques in their developed applications in order to ensure the integrity of their data Understand the importance of, and be capable of, properly testing developed formulas Know how to selectively protect their Excel applications at workbook, worksheet and cell levels so as to ensure that users cannot accidentally erase or modify important information in applications Requirements Students should be aware that the exercises are challenging and to get the best out of the materials a reasonable effort is required on the part of the individual student to complete the exercises provided Students are provided with exercises as downloadable resources Solutions for all of the exercises are provided in both video and Microsoft Excel templates The course has been developed using Microsoft Excel 2016, however, previous versions from Excel 2010 onward will be suitable Description 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. Who this course is for: This course is suitable for any student who has a basic knowledge of Microsoft Excel The course is aimed at students who wish to advance their knowledge of using particular Excel functions and how to apply them in practice Suitable for students who need to be able to manage and manipulate data in Excel Students who need to use Microsoft Excel more efficiently It is not suitable for an absolute beginner Show more Show less Course content 8 sections • 22 lectures • 1h 24m total length Expand all sections Course Introduction 2 lectures • 8min Introduction to A Practical Guide to Building Small Applications in Excel Preview 03:48 Review of the Essentials 04:36 IF Statements 2 lectures • 10min Introduction to IF Statements Preview 05:08 Nested IF Statements 04:58 Introduction to AND and OR Statements 3 lectures • 10min Introduction to AND Statements 04:51 Combining IF and AND Statements 03:14 Introduction to OR Statements 01:50 A Business Example using Rules Tables 5 lectures • 20min Applying Nested IFs to a Business Based Example 05:28 Setting Up The Rules Table 04:58 Using a Rules Table 04:33 More Customers - Using Absolute References 02:39 Moving the Rules Table 02:19 The HelpLess Airlines Application 4 lectures • 10min Introduction to the HelpLess Airlines Application 04:09 Rule 1 - Age Discounts 02:59 Rule 2 - Luggage Charges 01:34 Rules 3, 4 & 5 - Priority Booking, Row Reservations and Value Added Tax 01:41 HelpLess Airlines Solutions 3 lectures • 13min Rule 1 - Age Discount Solution Preview 04:13 Rule 2 - Luggage Charge Solution 04:44 Rule 3, 5 & 5 - Priority, Row Reservation and VAT Solutions 04:22 Validating and Protecting Your Data 2 lectures • 11min Introduction to Data Validation Preview 05:34 Protecting Your Data 05:17 Course Conclusion and Bonus Lecture 1 lecture • 1min Course Conclusion and Bonus Lecture 01:17 Instructor Dave Murphy University Lecturer 4.5 Instructor Rating 2,987 Reviews 11,888 Students 18 Courses With over twenty years experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the worlds largest companies, Dave Murphy changed career track in 2000 and has been a professional university educator for over eighteen years. His main interests are in Microsoft Certifications, Project Management and Business Process Analysis. Dave has a B.Sc (Hons) from Trinity College Dublin and an M.Sc Degree in Computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in Managing Projects with Microsoft Project, is a MOS Master and a MOS examiner. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781a68a4b0353d3',m:'a42ee38c36ecb84e2937575e6f1977d6cf925b68-1627848005-1800-AWiHIZziIwYNPaLhckPM3YaJEx5A014quVFLDrc/9qO/R1LL4wu9eFa60rwOdPq6EGpV/J3uBnr56MXw7DDkec7H7ZZwhrcXCHZmVlgc2nii/zVSPIsRWHroxSk/0PkPN2FtPqmVg2QKIdssJ8cjivlR3uMSLQopMdozGs0s5kga',s:[0xbc2e598cb7,0x319e7887f1],}})();
  6. Understand the importance of, and be capable of, properly testing developed formulas Know how to selectively protect their Excel applications at workbook, worksheet and cell levels so as to ensure that users cannot accidentally erase or modify important information in applications Requirements Students should be aware that the exercises are challenging and to get the best out of the materials a reasonable effort is required on the part of the individual student to complete the exercises provided Students are provided with exercises as downloadable resources Solutions for all of the exercises are provided in both video and Microsoft Excel templates The course has been developed using Microsoft Excel 2016, however, previous versions from Excel 2010 onward will be suitable Description 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. Who this course is for: This course is suitable for any student who has a basic knowledge of Microsoft Excel The course is aimed at students who wish to advance their knowledge of using particular Excel functions and how to apply them in practice Suitable for students who need to be able to manage and manipulate data in Excel Students who need to use Microsoft Excel more efficiently It is not suitable for an absolute beginner Show more Show less Course content 8 sections • 22 lectures • 1h 24m total length Expand all sections Course Introduction 2 lectures • 8min Introduction to A Practical Guide to Building Small Applications in Excel Preview 03:48 Review of the Essentials 04:36 IF Statements 2 lectures • 10min Introduction to IF Statements Preview 05:08 Nested IF Statements 04:58 Introduction to AND and OR Statements 3 lectures • 10min Introduction to AND Statements 04:51 Combining IF and AND Statements 03:14 Introduction to OR Statements 01:50 A Business Example using Rules Tables 5 lectures • 20min Applying Nested IFs to a Business Based Example 05:28 Setting Up The Rules Table 04:58 Using a Rules Table 04:33 More Customers - Using Absolute References 02:39 Moving the Rules Table 02:19 The HelpLess Airlines Application 4 lectures • 10min Introduction to the HelpLess Airlines Application 04:09 Rule 1 - Age Discounts 02:59 Rule 2 - Luggage Charges 01:34 Rules 3, 4 & 5 - Priority Booking, Row Reservations and Value Added Tax 01:41 HelpLess Airlines Solutions 3 lectures • 13min Rule 1 - Age Discount Solution Preview 04:13 Rule 2 - Luggage Charge Solution 04:44 Rule 3, 5 & 5 - Priority, Row Reservation and VAT Solutions 04:22 Validating and Protecting Your Data 2 lectures • 11min Introduction to Data Validation Preview 05:34 Protecting Your Data 05:17 Course Conclusion and Bonus Lecture 1 lecture • 1min Course Conclusion and Bonus Lecture 01:17 Instructor Dave Murphy University Lecturer 4.5 Instructor Rating 2,987 Reviews 11,888 Students 18 Courses With over twenty years experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the worlds largest companies, Dave Murphy changed career track in 2000 and has been a professional university educator for over eighteen years. His main interests are in Microsoft Certifications, Project Management and Business Process Analysis. Dave has a B.Sc (Hons) from Trinity College Dublin and an M.Sc Degree in Computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in Managing Projects with Microsoft Project, is a MOS Master and a MOS examiner. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781a68a4b0353d3',m:'a42ee38c36ecb84e2937575e6f1977d6cf925b68-1627848005-1800-AWiHIZziIwYNPaLhckPM3YaJEx5A014quVFLDrc/9qO/R1LL4wu9eFa60rwOdPq6EGpV/J3uBnr56MXw7DDkec7H7ZZwhrcXCHZmVlgc2nii/zVSPIsRWHroxSk/0PkPN2FtPqmVg2QKIdssJ8cjivlR3uMSLQopMdozGs0s5kga',s:[0xbc2e598cb7,0x319e7887f1],}})();
  7. Know how to selectively protect their Excel applications at workbook, worksheet and cell levels so as to ensure that users cannot accidentally erase or modify important information in applications Requirements Students should be aware that the exercises are challenging and to get the best out of the materials a reasonable effort is required on the part of the individual student to complete the exercises provided Students are provided with exercises as downloadable resources Solutions for all of the exercises are provided in both video and Microsoft Excel templates The course has been developed using Microsoft Excel 2016, however, previous versions from Excel 2010 onward will be suitable Description 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. Who this course is for: This course is suitable for any student who has a basic knowledge of Microsoft Excel The course is aimed at students who wish to advance their knowledge of using particular Excel functions and how to apply them in practice Suitable for students who need to be able to manage and manipulate data in Excel Students who need to use Microsoft Excel more efficiently It is not suitable for an absolute beginner Show more Show less Course content 8 sections • 22 lectures • 1h 24m total length Expand all sections Course Introduction 2 lectures • 8min Introduction to A Practical Guide to Building Small Applications in Excel Preview 03:48 Review of the Essentials 04:36 IF Statements 2 lectures • 10min Introduction to IF Statements Preview 05:08 Nested IF Statements 04:58 Introduction to AND and OR Statements 3 lectures • 10min Introduction to AND Statements 04:51 Combining IF and AND Statements 03:14 Introduction to OR Statements 01:50 A Business Example using Rules Tables 5 lectures • 20min Applying Nested IFs to a Business Based Example 05:28 Setting Up The Rules Table 04:58 Using a Rules Table 04:33 More Customers - Using Absolute References 02:39 Moving the Rules Table 02:19 The HelpLess Airlines Application 4 lectures • 10min Introduction to the HelpLess Airlines Application 04:09 Rule 1 - Age Discounts 02:59 Rule 2 - Luggage Charges 01:34 Rules 3, 4 & 5 - Priority Booking, Row Reservations and Value Added Tax 01:41 HelpLess Airlines Solutions 3 lectures • 13min Rule 1 - Age Discount Solution Preview 04:13 Rule 2 - Luggage Charge Solution 04:44 Rule 3, 5 & 5 - Priority, Row Reservation and VAT Solutions 04:22 Validating and Protecting Your Data 2 lectures • 11min Introduction to Data Validation Preview 05:34 Protecting Your Data 05:17 Course Conclusion and Bonus Lecture 1 lecture • 1min Course Conclusion and Bonus Lecture 01:17 Instructor Dave Murphy University Lecturer 4.5 Instructor Rating 2,987 Reviews 11,888 Students 18 Courses With over twenty years experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the worlds largest companies, Dave Murphy changed career track in 2000 and has been a professional university educator for over eighteen years. His main interests are in Microsoft Certifications, Project Management and Business Process Analysis. Dave has a B.Sc (Hons) from Trinity College Dublin and an M.Sc Degree in Computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in Managing Projects with Microsoft Project, is a MOS Master and a MOS examiner. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781a68a4b0353d3',m:'a42ee38c36ecb84e2937575e6f1977d6cf925b68-1627848005-1800-AWiHIZziIwYNPaLhckPM3YaJEx5A014quVFLDrc/9qO/R1LL4wu9eFa60rwOdPq6EGpV/J3uBnr56MXw7DDkec7H7ZZwhrcXCHZmVlgc2nii/zVSPIsRWHroxSk/0PkPN2FtPqmVg2QKIdssJ8cjivlR3uMSLQopMdozGs0s5kga',s:[0xbc2e598cb7,0x319e7887f1],}})();