How do I convert an Excel spreadsheet into an app?

Asked by Last Modified  

1 Answer

+1

Follow 1
Answer

Please enter your answer

Initially, you should have a spreadsheet that does something useful and secondly that this use is not just for a small set of people who can use it through a spreadsheet. Let's take an example, imagine a worksheet has a great facility of being able to receive a number and then return the double, i.e.,...
read more
Initially, you should have a spreadsheet that does something useful and secondly that this use is not just for a small set of people who can use it through a spreadsheet. Let's take an example, imagine a worksheet has a great facility of being able to receive a number and then return the double, i.e., the input number multiplied by 2. It is evident that the spreadsheet has much more functionality, but we have to start somewhere, and this simplified example has all the basics. It accepts the input, computes badly then has a useful output. So basically your app should be based on an input-process-output formula. As in: You must accept input data You must check the input data for correctness, i.e. that you have received a number when you are expecting a number, a date when you expect such etc. You must perform your computations or transformations of that data into something that the user finds useful You might want to validate your results on some criteria You want to return that result or set of results to the user so that he/she might use them. Along the way, you need to make certain decisions as well. How many people are going to use the app? What are the demographics? How good should the app interface be? Where are these people located? Will they pay for this app? Etc. Etc. Once you have sorted these kinds of questions, then you can decide whether what you are set to do is viable. All the Best read less
Comments

Related Questions

Excel formulas in advance level?
In excel we have lot of staff and formulas, we can learn based on your requirement, in excel vlookup, hlookup, pivot table if condition, sumif ifs, countA, if ifs, data validation, etc. and we have to...
ManojGS
How many days it will take to complete advance excel course?
The duration to complete any kind, of course, depends on your grasping power and the ability to learn the concepts quickly. Having said that, it usually takes about three to four weeks to learn the topics...
Amit
Is it necessary to have the knowledge of VB script for Excel Macro Training?
Please make a correction, its not VB Script but Excel VBA that you need to learn. VB Script is different form Excel VBA even though they both are subset of VB (the same parent), Please google to know more....
Suma K V
Is Advanced Excel Training necessary?
Yes, now days excel is very well accepted by most of the users from corporate, offices and even college students. They are learning excel. Excel can increase your work effectiveness. There are many functions...
Aditi
0 0
7
Can a person learn advanced level MS Excel through YouTube videos?
You can learn MS Excel on Youtube. Whether you are a complete beginner or advanced user of Excel, there are several video tutorials available at every skill level. They teach you everything by making you...
Ramkumar
0 0
7

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

What is Microsoft Access?
Microsoft Access has been around for some time, yet people often still ask me what is Microsoft Access and what does it do? Microsoft Access is a part of the Microsoft Office Suite. It does not come with...

What Are Macros?
i. Macros are little programs that run within Excel and help automate common repetitive tasks. Macros are one of Excel's most powerful, yet underutilized feature. Using macros, you can save hours and boost...

Power View
Power View is now a feature of Microsoft Excel 2013, and is part of the Microsoft SQL Server 2012 Reporting Services add-in for Microsoft SharePoint Server 2010 and 2013 Enterprise Editions. Power View...

INITIAL STEP FOR EXCEL
IT BECOME ITSELF LOOK LIKE A TABLE, THERE HAVE MANY CELL IN ROWWISE OR COLUMNWISE. FIRST YOU THOUGHT THAT WHAT TYPE OF DATA IS AND HOW YOU DESIGN.

Concatenate Function
Concatenate , one of the text functions, to join two or more text strings into one string. The Excel Concatenate function joins together a series of supplied text strings or other values, into one combined...

Recommended Articles

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Looking for MS Office Software Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you