Microsoft Excel - Building Business Applications
A Practical Guide to using Excel Functions to Build Realistic Business Applications
4.54 (28 reviews)
747
students
1.5 hours
content
Nov 2017
last update
$39.99
regular price
What you will learn
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
Screenshots
Related Topics
749990
udemy ID
2/2/2016
course created date
2/8/2020
course indexed date
Bot
course submited by