Microsoft Excel Features

Microsoft Excel

Spreadsheet software

4.77/5 (13,984 reviews)

Microsoft Excel Feature Summary

  • Chart formatting controls
  • Easy reformation and rearrangement of data
  • Quick complex analyses with Pivot Table
  • Variety of charts to illustrate data better

Competitor Feature Comparison

Ad hoc Analysis
Charting
Collaboration Tools
Collaborative Workspace
Commenting
Custom Charts
Customizable Templates
Data Filtering
Data Import/Export
Data Transformation
Data Visualization
Document Management
Document Templates
Drag & Drop Interface
Forecasting
Geographic Maps
Offline Access
Project Templates
Projections
Real Time Analytics
Real Time Updates
Template Management
Learn moreCompare App
Ad hoc Analysis
Charting
Collaboration Tools
Collaborative Workspace
Commenting
Custom Charts
Customizable Templates
Data Filtering
Data Import/Export
Data Transformation
Data Visualization
Document Management
Document Templates
Drag & Drop Interface
Forecasting
Geographic Maps
Offline Access
Project Templates
Projections
Real Time Analytics
Real Time Updates
Template Management
Visit WebsiteCompare App
Ad hoc Analysis
Charting
Collaboration Tools
Collaborative Workspace
Commenting
Custom Charts
Customizable Templates
Data Filtering
Data Import/Export
Data Transformation
Data Visualization
Document Management
Document Templates
Drag & Drop Interface
Forecasting
Geographic Maps
Offline Access
Project Templates
Projections
Real Time Analytics
Real Time Updates
Template Management
Learn moreCompare App

Mobile apps

iOS App


491,541 reviews

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

Android App


2,599,423 reviews

Microsoft Excel Feature Reviews

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

Pavi Ranjan

Excel is the best for business analysis and management reporting

2018-09-22

I liked this product a lot and it helped me in various reporting activities

Pros

This tool has inherent capabilities and formulas to be utilized for business analysis

Cons

This tool is the best in performing analysis and management reporting

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
Keith Gibbs

Excel sometimes Excels ...

2019-04-12

I use for all projects, all metrics.

Pros

I use excel to build custom Project Management tools and reports.

Cons

I wish there were drag and drop formulas.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

7/10
Source: Capterra
Helpful?   Yes   No
Read more
Naveed Aslam

Necessity for a business

2019-12-12

We use this software to manage and track day to day functions of business, e.g. tax returns trackers, funding management, performance measurement etc.

Pros

Lot of good functionalities, Problem solver, easy to use, time saver, calculates IRRs and help with basic reporting.

Cons

It has less kind of dashboards for summary purposes.

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
Brooke Haggerty

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
Carson Tsang

Standard spreadsheet management tool - useful for daily operations

2020-02-18

very easy to use for simple document management.

Pros

Can add up items and hide many items as needed, with simple search and replace.

Cons

sorting of some things should be easier, this programs should allow to have custom sorting in very specific ways.

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
Stephen Manktelow

We always end up coming back to Excel for features that other platforms claim to provide

2019-11-19

We use it for project management, basic CRM-type tracking for smaller sales activities, etc

Pros

Reliable and consistent over the years - Excel is a standard tool in industry for a reason!

Cons

The learning curve for new features can be steep - it requires ongoing training to make the most out of it

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
Joshua Daum

Excel is an industry standard with tried and true features

2019-11-13

With that being said, the customizable menus available in MS Office are fantastic, and something that I miss.

Pros

Excel is incredibly versatile, combining basic arithmetic features with advanced data management tools.

Cons

Using it collaboratively is clunkier than Google Sheets, and connecting it with other apps has a larger barrier to entry than the G Suite products.

Rating breakdown

Ease of use
Features

Time used: 1-2 years

Frequency of use: Occasionally

Likelihood to recommend

7/10
Source: Capterra
Helpful?   Yes   No
Read more
Soran Singh

Excel is most helpful and wonderful application developed by Microsoft

2020-08-16

Employee management, Inventory management, Branch wise MIS, maintain of cash and bank transactions, Maintain and Prepare Financials statement, reconciliation reports and MIS for management presentation, everything is done through Ms excel and Thanks a lot.

Pros

Excel is one of the most helpful software to manage all my office activity in one spread sheet with automatic updation features, merge button and very helpful working the vlookup formula in this software to generate a excellent MIS for managment review.

Cons

every thing is fine in this software as per end user requirement. but may be more improvement required in using hyperlink tab and customer support for using unknown features.

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
SHREYAS KASTURI

Microsoft Excel

2020-06-30

Effective, simple to use and small leaning curve for data modelling and organization.

Pros

Use it on a daily basis for design history file management and documentation

Cons

Tracking and review changes feature is not effective and consistent.

Rating breakdown

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
Anonymous
(Cosmetics company, 1-10 employees)

Easy to manage the information.

2020-02-28

It is best for data management with fast and easy interface.

Pros

The user interface is easy and the feature are powerful to manage any number or data list.

Cons

The basic knowledge is required to use the tool and features there are many tools to manage for starter it is hard to use.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 1-2 years

Frequency of use: Daily

Likelihood to recommend

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

Earth's best speadsheet

2019-03-10

From record management to data visualization.

Pros

I like the most on this software is the marco and VBA integration. This spreadsheet has an ability to automate task and pull data from remote databases directly.

Cons

I don't like on this software is the search capability. it is too slow.

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
(Education Management company, 1001-5000 employees)

Complex but helpful for reporting purposes

2020-03-30

I can easily calculate, summarize, visualize and keep track of the metrics that I need for our marketing activities.

Pros

I can also easily create charts based on the results for the purpose of sharing with management.

Cons

However, complexity also allows for a lot of features that make reporting easier in the long run once you get the hang of it

Rating breakdown

Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

7/10
Source: Capterra
Helpful?   Yes   No
Read more
VISAKH K

I like all excel function. Also easy solve a big problem. I expert now .

2018-12-09

We use MS Excel for manage My staff salary details, attendance detils, and our daily business reports . It is easy to create monthly report, and yearly statements etc.

Pros

The main future of excel is we can easy solve big Mathematical problems.

Cons

But it's not used a database management front end application

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

6/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Financial Services company, 10001+ employees)

Excel Review

2020-05-28

My overall experience with excel and creating reports in it has been very satisfactory.

Pros

Create instant calculations is very easy Awesome interface to work on tables and edit them Efficient and organized Offers third party support

Cons

The formulas are not that easy to remember and it takes time to get used to them Some file extensions may be incompatible Is somewhat on the expensive side of the scale

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
Adriana Cruz Costa

Perfect to eveything

2020-02-05

Essencial to my day, way of work and team management.

Pros

Perfect to reports, management, dashboards, team governance, meetings.

Cons

It get the reports slower and not usable to work.

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
Wojciech Korsak

Data analysis in business

2019-01-11

I use MS Excel to create dashboards and reports.

Pros

I use typical elements as functions & chart, but MS Excel offers elements to be free to find creative way to present data as: - contextual chart - external visual files - external data in their context in sheet.

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
Danny Young

Microsoft Excel - Great tool for small businesses

2019-10-30

Budget management, timesheet and time tracking, capturing event signups, tracking private lessons and so much more.

Pros

I manage my business budget, timesheets, aging reports and financial reports all in Excel.

Cons

When you add the add ons with the already robust basic functionality, there really is nothing you cannot do.

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
Awais Ali

Spreadsheet covered by Excel

2020-04-15

Pros

Really great tool for data, management, organizing, reporting.

Cons

Everything seems fine here no complaints at all.

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
Levi Spitz

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
Bernardo Kalsing

Excellent.

2020-02-25

Overall experience is great, works very well on a day-to-day work basis. Reports made it easier.

Pros

Amazing tool mainly used for analysis, customer and management reports.

Cons

It can run very slow and have some lags when too many tabs are opened or when the big amount of data or formulas entered.

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
Neal Idnani

Great tool for building reports

2019-08-02

Pros

Excel is highly customizable to build reports.

Cons

Using excel beyond very basic functionality requires a good deal of technological fluency.

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
Romario García

A great analysis tool

2019-10-03

However, when it comes to collaboration, it falls pretty quickly.

Pros

Furthermore, the plotting capabilities it has are great for creating quick dashboards prototypes or final products.

Cons

What I dislike most about Excel is the lack of powerful collaborative tools between my team.

Rating breakdown

Ease of use
Features

Time used: 2+ years

Frequency of use: Weekly

Likelihood to recommend

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

Excel is essential.

2018-08-28

We assemble documents for reporting leasing data and logging maintenance orders on a consistent basis.

Pros

Excel allows for an easy synthesis of data between our information system and our accounting, leasing, and management info.

Cons

Sometimes the highly technical capabilities make is challenging to learn the software. I recommend a more intuitive help intro when the software is downloaded and installed.

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
(Information Technology and Services company, 501-1000 employees)

Undoubtedly the best tool on market

2019-10-31

I use excel in various activities, since my time control and task process reports, when developing solutions for clients.

Pros

The integrated VBA editor increases usability, making office activities even easier.

Cons

However given the amount of functionality present in it, the value is justified.

Rating breakdown

Value for money
Ease of use
Features

Time used: 1-2 years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Food & Beverages company, 1-10 employees)

Multifunctional Tool with Many Applications

2020-04-16

It is a tool that allows us to easily manage our inventory and other operations for our ecommerce and wholesale business.

Pros

We use Excel for a variety of operations within the business such as inventory management, analytics, marketing activity tracking, wholesale orders and more.

Cons

Large Excel files slow down the computer a lot and requires very powerful computer.

Rating breakdown

Value for money
Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

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