How do I convert an Excel spreadsheet into an app?

Asked by Last Modified  

1 Answer

+1 Microsoft Excel Training

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
Dislike Bookmark

Related Questions

I want to learn network simulator ns3 for my project.
Drop me message.. I have learn concepts of NS3. May be I can help you out.
Vineeth
1 0
8
Are there any excel and VBA coaching centres at As Rao Nagar?
nope
V
What is shortcut to rename the spreadsheet name?
Alt+H+O+R
Umang
How to use vlookup in excel?
Syntax for using vlookup function is =VLOOKUP(LOOKUP_VALUE,TABLE_ARRAY,COL_INDEX_NUMBER)
Ankita
0 0
7

Can you make a Software Base On Excel, that records Automatic Billing Information Just Like A POS System.

 

Suppose our Customer requires following:

An Excel Software for POS, with following functionalities:

  1. It should have an "Open List" for capturing product related information.
  2. It should have automatic bill numbering
  3. It should have Printable bill
  4. It should have a customer database form and recording
  5. It should take not more than 30 minutes of training to learn and operate

Can you make that?

How much time will it take to you to make it completely?
Maybe yes! I'll require a bit more information to deep dive in it.
Bikram Jeet
0 0
9

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

Ask a Question

Related Lessons

Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below Average Performers!
In the following, You would find lesser-known, unexplored yet Powerful Features of Filter. Please refer to sample dataset below: To do Data Analysis:Step 1) Apply Filter on the dataset.Step 2) In Sales...

Ankur Sharma

1 0
0
Agreements
A contract is a mutually binding agreement. It obligates the seller to provide the deliverables and the buyer to make the payment on delivery. It is a legal document recognised in the court of law The...

Venkataramiah S Annapragada

0 0
0
TODAY WE LEARN MIN FORMULA, HOW TO USE IT.
1 A B 2 NAME MARKS 3 Vinita 50 4 Anjali 34 5 Mahima 73 6 Kartrina 18 7 Mahender 65 8 Silver 48 =min(B3:B8) ANSWER 18 =MIN(number 1, {number 2},...)

Saurabh Sharma

0 0
0
Use of Indirect Function
I would like to share my experience of how Indirect formula helped me in my recent project. I was working with some report which was connected to a large database in excel, so whatever changes I made to...

Kaustubh Chavan

0 0
0
Computer Basic.
If you know the design of table. Then go to second steps: 1) If you type a long data in a single cell or some other data in next cell, problem arise that the first cell data is not showing clear. Then...

Deepak Kumar Jha

0 0
0

Recommended Articles

Top 5 Skills Every Software Developer Must have

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 >

Learn Microsoft Excel

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 >

Make a Career as a BPO Professional

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 >

Learn Hadoop and Big Data

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 >

Find MS Office Software Training near you
MS Office Software Training in Bangalore
MS Office Software Training in Delhi
MS Office Software Training in Hyderabad
MS Office Software Training in Mumbai
MS Office Software Training in Chennai
MS Office Software Training in Pune
MS Office Software Training in Kolkata
MS Office Software Training in Gurgaon
MS Office Software Training in Ahmedabad
MS Office Software Training in Noida

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