What general tasks can be done with MS Excel?

Asked by Last Modified  

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

How can I create a letter head on excel?
Select a cell for typing the Title, change the font size in Formatting tool bar, merge cells in formatting tool bar depending on the length of title.
Jitendra
What are the benefits of using Excel in business?
Excel is mostly and widely used tool of Microsoft for business purposes, to maintain data, to maintain records as well as to have efficient result through calculations. Excel provides a bunch of formulas...
Vijay
0 0
8
Linear Programming in Excel ?? Can someone can solve just 1 question of Linear Programming in Excel ?? I am ready to pay. Thanks
Hi Gary I might be able to help you please share your question with me and hopefully would be able to help you on the same.
Garry
0 0
5
How can I create an organization chart in MS Excel?
Best option would be smart art tools for creating an organisational chart.
Poojashree
0 0
5

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

Ask a Question

Related Lessons

Datedif() Function
Purpose: This function calculates difference between two dates. it can show the result in days, months and years. Syntax: =datedif(start_date,end_date,"unit") start_date This is earliest...

What Is Power Query?
Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft...

VBA Tip: Repeating Emp Names N number of times using 4 different loops
Hi All,This is a requirement from one of our student and here we are posting the question along with solution (this can be achieved using 4 different loops). In Column “J” there are few employee...

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

Excel Tip: Conditional Formatting To Highlight First Value Among Duplicates.
In Column “C”, I have product list and some of them are duplicates. My requirement is to format with background color of green for 1st found value among the duplicates. To solve this, I used...

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