What general tasks can be done with MS Excel?

Asked by Last Modified  

3 Answers

+1

Follow 3
Answer

Please enter your answer

Vba developer, web scraping, data automation, advanced excel

Basically, Excel created for large and complex calculations. Moreover, many features have been added time to time and are getting upgraded. now you can share the file online and track real-time. VBA is also a part of excel you can do a lot of automation works, schedulings, daily tasks, scraping data...
read more
Basically, Excel created for large and complex calculations. Moreover, many features have been added time to time and are getting upgraded. now you can share the file online and track real-time. VBA is also a part of excel you can do a lot of automation works, schedulings, daily tasks, scraping data from websites sending emails, working with files and folders, creating or renaming files or folders lot of works even you can convert the image into text using VBA scripts. Apart from that you will be having addins where you can get special accessibility of the excel like you don't have formulas like regular expressions. With the help of addins you will get regex functions and formulas in excel. Excel also have a userforms where you can create an application and create nice dashboards and software also. You can connect or integrate data from websites or other data bases its updates on real-time in excel sheets. read less
Comments

Tutor

As a general task you can create the data which requires table and some formulas as well. E.g. you can create Marksheet, Stock Statement etc..
Comments

Tutor

As a general task you can create the data which requires table and some formulas as well. E.g. you can create Marksheet, Stock Statement etc..
Comments

View 1 more Answers

Related Questions

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...
Profile Photo
Aditi
0 0
View Comments7
What is exact number of days required to learn basic & advanced excel?
10-15 days sufficient but you need practice on that.
Profile Photo
Anusha
How to write macros in excel?
1) you record a macro 2) macro programming:- macro is type of a sub procedure to perform some task. sub is a keyword. the set of program statements you have to write between the two lines syntax:- sub macroname statements ----------- end sub
Profile Photo
Vidyarajeev

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 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...
Profile Photo

Shortcut for adding big data or Columns in MS excel
1. Simply click on the next cell of column where you want the sum. 2. Press Alt and = keys together. 3. It will show the sum and range of sum. 4 Click Enter key and you will get sum of the column.
Profile Photo


VLOOKUP and LIST Creation Explained
.) This table is in the range A1:D4. You want to find the salary of employee with ID 102. Excel =VLOOKUP(102, A1:D4, 4, FALSE) 102: The Employee ID (your lookup_value). A1:D4: The table containing...
D

Deleted U.

0 0
View Comments0

Pivot table - Transform numbers in calculated field
How to convert the absolute numbers in pivot table into Lakhs, Millions, Trillions without adding a spare column in the data source. Name the field in the Calculated field and apply the formula by Double-clicking...
Profile Photo

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 >

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

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