Microsoft Excel Features

Microsoft Excel

Spreadsheet software

4.77/5 (16,269 reviews)

Competitor Feature Comparison

Ad hoc Analysis
Calculators
Charting
Collaboration Tools
Commenting/Notes
Customizable Templates
Customization
Data Import/Export
Data Transformation
Data Visualization
Document Management
Document Templates
Drag & Drop
Forecasting
Geographic Maps
Multi-User Collaboration
Offline Access
Project Templates
Projections
Real Time Analytics
Real-time Updates
Search/Filter
Template Management
Templates
Learn moreCompare App
Ad hoc Analysis
Calculators
Charting
Collaboration Tools
Commenting/Notes
Customizable Templates
Customization
Data Import/Export
Data Transformation
Data Visualization
Document Management
Document Templates
Drag & Drop
Forecasting
Geographic Maps
Multi-User Collaboration
Offline Access
Project Templates
Projections
Real Time Analytics
Real-time Updates
Search/Filter
Template Management
Templates
Visit WebsiteCompare App
Ad hoc Analysis
Calculators
Charting
Collaboration Tools
Commenting/Notes
Customizable Templates
Customization
Data Import/Export
Data Transformation
Data Visualization
Document Management
Document Templates
Drag & Drop
Forecasting
Geographic Maps
Multi-User Collaboration
Offline Access
Project Templates
Projections
Real Time Analytics
Real-time Updates
Search/Filter
Template Management
Templates
Learn moreCompare App

Mobile apps

iOS App


659,560 reviews

Requires iOS 13.0 or later. Compatible with iPhone, iPad, and iPod touch.

Android App


3,099,507 reviews

Microsoft Excel Feature Reviews

25 reviewers had the following to say about Microsoft Excel's features:

Anonymous
(Automotive company, 1001-5000 employees)

The famous spreadsheet software so far

2020-12-07

Starting to use as a beginner or student free version is also available other spreadsheet software can still not reach the power of microsoft excel

Pros

You can convert your data into meaningful form by applying filters and other data management tools, can perform calculations and manipulate data using formula bar.

Cons

Not good for handling large amount of data we have data base management systems for that, visual enhancement increases file size dramatically

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Tabish S.

Best for data management and data preparation tool.

2021-01-14

Excel cloud version is best collaboration working.

Pros

Excel data connectivity is too good its help me to to data data from other sources like SQL server, Oracle etc it provide many connection like JDBC and ODBC.

Cons

Microsoft Excel is the 1st tool introduce for data management in rows wise.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Ayan S.

Best for data recording, management & reporting & Also use for Business intelligence integration

2021-02-09

And also we collect feedback data from customer via webform in excel file. compare our data and analyzing our data trend.

Pros

In excel the good feature is, it can integrate with database servers so we can get data directly into excel file from database servers.

Cons

Every thing is prefect in Microsoft Excel regarding it features list of data recording, data management and report.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Cássia Aparecida A.

Excellent spreadsheet!

2021-01-14

Another advantage is that since the financial management software is used only by me, the possibility of importing the file into excel is advantageous because I can delegate to someone else to prepare the spreadsheet for later I export.

Pros

For the company, it is also valid because some software accepts the export of the information to the system in excel format that is what I like in the tool versatility the possibility of integrating with various software.

Cons

I don’t have what I like least about the tool. It’s simple to use, all of my team use it daily, the tool perfectly meets the needs of my company.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Health, Wellness and Fitness company, 10001+ employees)

Microsoft Excel Review

2021-06-12

I find it a lot easier to use and intuitive when compared to Access.

Pros

This is a much needed back up for getting subsets of larger data and to rapidly find inconsistent or missing entries in a dataset. 3) How easy Excel datasets are to manipulate and import into other data analysis software such as SAS or STATA. 4)That excel documents can be password protected.

Cons

Excel is limited somewhat in how advanced of data analysis you can perform.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Wojciech K.

Data analysis in business

2019-01-11

I use MS Excel to create dashboards and reports.

Pros

As MindManager user I like cooperation between these applications to present live data from Excel in mindmapping document.

Cons

I would love to see more elements which support visual management - without programming knowledge.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Anthony B.

Invaluable product that is well worth the money

2019-03-22

I use Microsoft Excel to query data downloaded from our hosted data management system, and make queries and analyze the data.

Pros

They let me query data across multiple criteria and make quick statistical analysis like averages and totals for my queries, and do it in a more visual way than table queries.

Cons

I'd like to see the multi-user access facilities for files stored on a shared drive to be improved a little, in the same way that the cloud-based Office 365 sharing performs these tasks.

Rating breakdown

Value for money
Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Computer Software company, 10001+ employees)

Excel is a powerful tool

2019-03-13

Overall I feel Execl is the best in the market, every one should have this utility. it really help to organised the data in a tabular manner with all computation and UI feature.

Pros

Data conversion and apply filter and freeze pan and many more.

Cons

Implementation of the formula in the cell should have been made more to drag and drop or UI based option type rather then typing manually like for nested if condition.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Brooke H.

Excel Review

2019-12-09

I've used excel for everything from financial management and budget tracking to program management to donor management.

Pros

I love Excel. I've grown up with it, so I think for that reason I'll always prefer it to Google Sheets. Formulas and formatting are just more intuitive to me. And I love that you can indent easily, unlike in Google Sheets (little things like that). I have also utilized many of Excel's templates.

Cons

Google Sheets has them beat when it comes to web-based team collaboration. With Sheets, people can comment and make or suggest changes, whereas with Excel it's a back and forth email chain.

Rating breakdown

Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Levi S.

Great tool for any professional

2019-01-29

At work - for plans management, reports of different kinds, calculation and data analysis.

Pros

Low experience use starts from simple calculation of budgets, party invitation lists reports from banks and insurance.

Cons

Relatively high price, lack of good Microsoft tutorials, complexity of most enhanced capabilities.

Rating breakdown

Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Rodrigo R.

The most powerful spreadsheet system I'm aware of

2020-04-03

Excel is an amazing option for data manipulation, calculations and chart creation.

Pros

Excel is widely recognized as a powerful and considerably easy to use solution for spreadsheets and data management, sometimes used as a file database system.

Cons

The regular version of Excel does not have multi-user collaboration features built in, as expected for a physical file based system.

Rating breakdown

Value for money
Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Geoffrey R.

Excelling with Excellence with Excel

2020-12-01

Over the years of using Excel it has always been an intricate part of work flow management/creating reports as well as personally creating my own spreadsheet to manage my personal budget.

Pros

It's easy to import from other data bases into Excel and create an optimal report.

Cons

It's been the leading software of choice to organize and create reports from data that has been uploaded.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Patrizia I.

Useful tool for data manipulation and complex calculation

2019-01-16

Data manipulation has never been so easy thanks to spreadsheet tool like Excel.

Pros

All the collected data, or only a bunch of them, could be easily turned into graphs and table just using the insert drop-down menu.

Cons

So, if you have a big business and you have to analyze a large amount of data, for example the number of visitors of your site or your paying customers, you might need to create more than one sheet to do a specific check or comparison Sometimes it could be difficult to share information from different departments using a unique Excel file.

Rating breakdown

Value for money
Ease of use
Features

Time used: 2+ years

Frequency of use: Monthly

Likelihood to recommend

7/10
Source: Capterra
Helpful?   Yes   No
Read more
Uzair R.

Excel (complete solution for data management and data analysis)

2021-08-07

Further it's also have feature to analyze all your data and help you in decisions making process driving through data analysis.

Pros

The most I like about this software that I can manage all data in any form in excel sheets by start from simple data entry to maintain big personnel record of employees, create different dashboard and analysis report and prepare financial models and automation form for business decision purpose.

Cons

In excel it is nothing which I least like because they are updating this software time to time which address user query. However I recommend they have to simplify more thier formulas and describe how different formulas can collaborate by navigating and proper guiding this help alot user to get maximize benefits from this software

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Higher Education company, 201-500 employees)

Gold standard for spreadsheets

2019-11-30

I use Excel on a daily basis to support a wide variety of functions: From user databases, through team product development management, to data visualisation and presentation.

Pros

The fact that Office 365 now provides a web version really delivers the last piece of functionality that had always been lacking.

Cons

The past few iterations have really improved on what was an outdated design and clunky interface to make it a top-level, highly recommended tool.

Rating breakdown

Value for money
Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Management Consulting company, 11-50 employees)

Essential software for all users

2019-01-25

Shortcuts and the ability to run macros also helped us speed up regular tasks. Truly a useful- I would say necessary- tool for all companies.

Pros

It seems like such a simple software on the surface, but you can really do so much to manipulate and analyze your data. And obviously, Excel is so commonly used and integrated that it's a very important software to learn.

Cons

There are obviously some tasks beyond the capability of Excel, such as data management, but Excel excels at what it's meant for, .

Rating breakdown

Value for money
Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Josh Y.

Great but over used

2020-05-24

I use it daily and am constantly pushing the envelope on what it can do.

Pros

I love digging into data and developing complex logical functions.

Cons

The program also doesn't scale when developing organizational dashboards with a growing number of functions.

Rating breakdown

Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Andrew R.

Software's Swiss Army Knife

2018-12-08

Excel is so powerful and is the gateway for many people into harnessing the power of large data. It is indispensable for most office workers and individuals who need to input, track, manage and manipulate data in an increasingly complex world.

Pros

Over time, the interface and functionality has got smarter and recent versions of the software seem to anticipate your needs and offer the correct options and functions based on the context of your current actions.

Cons

My criticisms may be due to lack of knowledge, but, I really struggled with collaboration and version control when working with an outside organization.

Rating breakdown

Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Brice P.

A workhorse for data management and analysis

2019-02-12

Pros

Excel also serves as a way-station in bridging data between systems that are not integrated (CSV export/import).

Cons

Easy enough to use for basic tasks - sorting, adding, de-duplication - but more advanced functions can take time and research to figure out.

Rating breakdown

Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Nicholas S.

Still a standard for business use

2020-01-03

It's also useful for maintaining project details and budget details for ad hoc collaboration.

Pros

It's great to use for also troubleshooting smaller datasets and flat files.

Cons

The import from text on Mac isn't the greatest and doesn't allow for wide scrolling across multiple delimited columns to select column type.

Rating breakdown

Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Muhammad A.

Excel makes life easy

2018-12-06

a very happy and satisfied user of MS Excel. can give me ease to use formual's and functions as per my requirements and make reports with both numerical and graphical representations.

Pros

Microsoft Excel is a very good feature of MS Office, provides me to make my life easy as i am a person who creates actionable visibility towards my management and for stakeholders, Excel helps me to put numbers in graphs and make tables in a way to have easy understanding to wards viewers.

Cons

too large data not supported by excel for that we need to use MS Access.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Sam A.

Go-to choice for powerful data management spreadsheets

2018-12-17

I use it for workflow management of professional projects and creating surveys that are used all over the world.

Pros

It is familiar. This is the spreadsheet software that I've used for twenty years, having improved my skills as the software has got more advanced.

Cons

The toolbars feel cluttered and there is an unnecessary array of options for my regular tasks. I also do not like the new Office file management menu on MacOS: it is unintuitive and slow to open files from my Mac.

Rating breakdown

Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Amit G.

Microsoft Excel is best spreadsheet software

2019-02-26

Managing customer information, Creating invoices, Task management, Expenses Management any many more things and overall experience is continuously awesome.

Pros

Microsoft excel usage is endless....it is really wonderful software which organize data in efficient manner.

Cons

Some time referencing between different sheets creates problem in using Microsoft excel. if someone is putting huge data in worksheets, it takes higher time to save and while reopen it.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Syed Ali H.

Excel features

2021-08-03

I m using this software since more than 10 years and I believe that this is a best software for data management and data analysis.

Pros

Excel is a great software for creating data base and analysis.

Cons

I recommend that hey should have to more simplify thier formula driving, formula functioning and collaboration of different formulas for better and quick understanding of user.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Sandeep R.

The best application available in this segment

2020-10-29

It has many important and interesting features such as data filter, graph analysis, formula suggestions, password protection etc. which makes it using easy and hassle-free.

Pros

It's data filter feature is just top notch.

Cons

Formatting might get messed up when opened in its mobile application.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more