Register now or log in to join your professional community.
List all the functions you use please.
Excel is excellent for manipulating data. The uses are as wide as the imagination. There are people who use it to track the standings in a bowling league, others for managing a local golf tournament. One can build a loan calculator, keep track of investments, create budgets etc. My wife uses it for scheduling her card clubs, I use it to get the cost basics of an investment and the capital gains I might incur. Excel is not for everyone but, MS Works includes a scaled down version which is excellent for home use. I would suggest visiting a library and pick up a beginners book on Excel.
I always use Vlookup to get the data from different sheet for analysis.
Excel is the best becase he Combines between math and text then u can use it to get for good way in your job and it's very easy to use and have alot of benifit things that u can use it
Because I create Payroll, statistical data, forms, receipt and anything that I use excel...
We use excel for making list of enquiries, leads, follow ups, databases, suppliers, estimations and so on its a amazing tool which can be used in various departments based on their needs.
In software Programming i am using to store the Database informatioms and also using to the bill section in different manner
No matter how many times you alter any values you type into a cell, if you use the right formula, using cell references, not the contents of the cell, the formula/result will always be correct. Most brilliant program out. And of course if you have loads and loads of figures and don't really understand how to read formulas, you convert figures into graphical representation for easier digestion, in other words a chart or graph.
Excel usually used for manipulating text and numbers in spreadsheets. Instead of doing arithmetic with a calculator or changing text cell by cell, you can type formulas and functions into the spreadsheet just once to perform calculations, conversions or checks on large amounts of text and numerical data. Also you can use it to perform pivot tables as you were interesting in criteria changing. And for too many reasons you can use it.
Excel is a Sea in a Computer,
Actualy we dont know how much it is usefull to us.
Every work can do with Excel. Its very amazing one.
Excel has its limits, but its flexibility and an incomparable ability to analyze and presenting data in one sheet makes it the most effective office tool. A few examples:
Analysis - for example, using database formulas like DSUM to analyse and combine data from different sources.
Reporting - like Business Scorecards, graphs and KPI's
Planning and monitoring - combining HR data with production capacity and sales forecast
Structurized input - like forms or timesheets, combined with import & export scripts and links with MS Word.
The Biggest use of excel in my point of view is the interpretation and analysis of statistical data and performing different calculations
