17 OCT 2024 - Welcome Back to TorrentFunk!
Get your pirate hat back out. Streaming is dying and torrents are the new trend.
Account Registration works again and so do Torrent Uploads.
We invite you all to start uploading torrents again!

TORRENT DETAILS

[FreeCourseWeb] Udemy - Microsoft Excel - Building Business Applications

TORRENT SUMMARY

	Status:	All the torrents in this section have been verified by our verification system
Category:	Other
Infohash	29e29e8b78b132a54e23f16484c3fd94c6ee62f3
Size:	961.4 MB in 42 files
Release Date(s):	Torrent Release: 16-02-2019 by user freecourseweb
Swarm:	0 Seeds & 1 Peers
Vote:	No votes yet.

DESCRIPTION

[FreeCourseWeb] Udemy - Microsoft Excel - Building Business Applications

MP4 | Video: AVC 1920x1080 | Audio: AAC 44KHz 2ch | Duration: 1.5 Hours | Lec: 22 | 961 MB Genre: eLearning | Language: English A Practical Guide to using Excel Functions to Build Realistic Business Applications 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. If you like this torrent then Please, we repeat, Please, Support Authors. They Deserve it [/b]

VISITOR COMMENTS (0

)

FILE LIST

Filename		Size
	01 Course Introduction/001 Introduction to A Practical Guide to Building Small Applications in Excel.mp4	170.7 MB
	01 Course Introduction/002 Review of the Essentials.mp4	30.2 MB
	02 IF Statements/003 Introduction to IF Statements.mp4	22.4 MB
	02 IF Statements/004 Nested IF Statements.mp4	29.8 MB
	02 IF Statements/attached files/003 Practice-Exercise-1.pdf	205.3 KB
	02 IF Statements/attached files/003 Solution-to-Practice-Exercise-1.xlsx	8.7 KB
	02 IF Statements/attached files/004 Practice-Exercise-2.pdf	216.9 KB
	02 IF Statements/attached files/004 Solution-to-Practice-Exercise-2.xlsx	9.1 KB
	03 Introduction to AND and OR Statements/005 Introduction to AND Statements.mp4	41.4 MB
	03 Introduction to AND and OR Statements/006 Combining IF and AND Statements.mp4	19.6 MB
	03 Introduction to AND and OR Statements/007 Introduction to OR Statements.mp4	19.7 MB
	03 Introduction to AND and OR Statements/attached files/006 Practice-Exercise-3.pdf	301.5 KB
	03 Introduction to AND and OR Statements/attached files/006 Solution-to-Practice-Exercise-3.xlsx	9.9 KB
	03 Introduction to AND and OR Statements/attached files/007 Practice-Exercise-4.pdf	303.9 KB
	03 Introduction to AND and OR Statements/attached files/007 Solution-to-Practice-Exercise-4.xlsx	9.9 KB
	04 A Business Example using Rules Tables/008 Applying Nested IFs to a Business Based Example.mp4	38.6 MB
	04 A Business Example using Rules Tables/009 Setting Up The Rules Table.mp4	32.7 MB
	04 A Business Example using Rules Tables/010 Using a Rules Table.mp4	26 MB
	04 A Business Example using Rules Tables/011 More Customers - Using Absolute References.mp4	17.1 MB
	04 A Business Example using Rules Tables/012 Moving the Rules Table.mp4	17.9 MB
	04 A Business Example using Rules Tables/attached files/008 Practice-Exercise-5.pdf	211.6 KB
	04 A Business Example using Rules Tables/attached files/008 Solution-to-Practice-Exercise-5.xlsx	9.1 KB
	05 The HelpLess Airlines Application/013 Introduction to the HelpLess Airlines Application.mp4	178 MB
	05 The HelpLess Airlines Application/014 Rule 1 - Age Discounts.mp4	32.2 MB
	05 The HelpLess Airlines Application/015 Rule 2 - Luggage Charges.mp4	17.6 MB
	05 The HelpLess Airlines Application/016 Rules 3 4 5 - Priority Booking Row Reservations and Value Added Tax.mp4	18 MB
	05 The HelpLess Airlines Application/attached files/013 HelpLess-Airlines-Template.xlsx	44.7 KB
	06 HelpLess Airlines Solutions/017 Rule 1 - Age Discount Solution.mp4	30.7 MB
	06 HelpLess Airlines Solutions/018 Rule 2 - Luggage Charge Solution.mp4	35.8 MB
	06 HelpLess Airlines Solutions/019 Rule 3 5 5 - Priority Row Reservation and VAT Solutions.mp4	34 MB
	06 HelpLess Airlines Solutions/attached files/017 Age-Rules-Solution.xlsx	46 KB
	06 HelpLess Airlines Solutions/attached files/018 Luggage-Rules-Solution.xlsx	47.7 KB
	06 HelpLess Airlines Solutions/attached files/019 Rules-3-4-5-Solution.xlsx	49 KB
	07 Validating and Protecting Your Data/020 Introduction to Data Validation.mp4	52 MB
	07 Validating and Protecting Your Data/021 Protecting Your Data.mp4	44.2 MB
	07 Validating and Protecting Your Data/attached files/020 Exercise-6-Resource-File.xlsx	50.7 KB
	07 Validating and Protecting Your Data/attached files/020 Exercise-6-Solution.xlsx	51.2 KB
	07 Validating and Protecting Your Data/attached files/020 Practice-Exercise-6.pdf	308.5 KB
	07 Validating and Protecting Your Data/attached files/021 Exercise-7-Resource-File.xlsx	51.4 KB
	07 Validating and Protecting Your Data/attached files/021 Exercise-7-Solution.xlsx	52.4 KB
	07 Validating and Protecting Your Data/attached files/021 Practice-Exercise-7.pdf	304.6 KB
	08 Course Conclusion and Bonus Lecture/022 Course Conclusion and Bonus Lecture.mp4	50.4 MB

RELATED DOWNLOADS

Torrent Name

Added

Size

Seeds

Peers

Uploader

Health