Microsoft Excel

By Microsoft

4.7/5(3,189)
4.7 out of 5 stars

How would you rate your experience with Microsoft Excel?

Microsoft Excel Pros and Cons: Top 5 Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Generated from real user reviews

Users find Microsoft Excel to have an easy-to-use interface, making data management and manipulation efficient and straightforward. (134 mentions)
Users value Excel's flexibility in data analysis, enabling powerful insights through advanced functions and easy data manipulation. (89 mentions)
Users appreciate the flexibility and powerful formulas of Microsoft Excel, enabling efficient data analysis and task automation. (76 mentions)
Users value the data manipulation capabilities of Microsoft Excel, enhancing organization and analysis for various tasks. (52 mentions)
Users appreciate the versatile features of Microsoft Excel, finding it intuitive for data analysis and reporting tasks. (38 mentions)
Users find that Excel's formula complexity can make it confusing and challenging, especially with large datasets. (47 mentions)
Users struggle with a steep learning curve, often needing videos to navigate features and understand formula errors. (46 mentions)
Users often experience slow performance in Excel with large datasets, leading to frustration and potential data loss. (43 mentions)
Users find collaboration limited in Excel, often facing version conflicts and difficulties when sharing workbooks with others. (25 mentions)
Users experience slow processing with large datasets or complex formulas, impacting performance and stability significantly. (23 mentions)

5 Pros or Advantages of Microsoft Excel

5 Cons or Disadvantages of Microsoft Excel

Microsoft Excel Reviews (3,189)

View 1 Video Reviews
Reviews

Microsoft Excel Reviews (3,189)

View 1 Video Reviews
4.7
3,189 reviews
Search reviews
Filter Reviews
Clear Results
G2 reviews are authentic and verified.
Verified User in Renewables & Environment
UR
Verified User in Renewables & Environment
Mid-Market (51-1000 emp.)
"Powerful Data Analysis and Dashboards with Microsoft Excel"
5/5
What do you like best about Microsoft Excel?

Microsoft excel is very powerful in managing, analyzing large data with it various functions, formulas, etc. Excel Dashboard gives quick insights for any large and complex data using various features. Data visualization is easy with graphs, pivot tables. Solar power plant Daily generation report , cleaning schedule , and other files updating is easy with microsoft excel. Review collected by and hosted on G2.com.

What do you dislike about Microsoft Excel?

Advanced features like complex formula's, pivot tables difficult to use without proper knowledge and training. Review collected by and hosted on G2.com.

rahul m.
RM
rahul m.
Business Leader- Operations and Sales
Enterprise (> 1000 emp.)
"Scalable, Comprehensive, and Constantly Improving with Great Power BI Integration"
4.5/5
What do you like best about Microsoft Excel?

It is scalable, comprehensive, and can be integrated with various other platforms like Power BI. It also keeps updating itself, so it continues to improve over time and become a better version. Review collected by and hosted on G2.com.

What do you dislike about Microsoft Excel?

It uses a lot of RAM and makes my system a bit slow. Also, the online Excel experience feels cumbersome and not very smooth to use. Review collected by and hosted on G2.com.

Vikas  S.
VS
Vikas S.
Trainer
Mid-Market (51-1000 emp.)
"Transforms Raw Data into Actionable Insights Effortlessly"
4.5/5
What do you like best about Microsoft Excel?

I like Microsoft Excel because it efficiently converts raw data into structured, computable formats. It performs calculations with high accuracy, supports large datasets, automates repetitive tasks through formulas and macros, and enables logical decision-making through analysis and visualization. It reduces human error and optimizes time, resources, and output. Review collected by and hosted on G2.com.

What do you dislike about Microsoft Excel?

I dislike Microsoft Excel because it is highly dependent on manual input, which increases the risk of data inconsistency. Performance degrades with very large datasets, complex formulas are difficult to audit, and version control is limited in collaborative environments. Errors can propagate silently if not detected. Review collected by and hosted on G2.com.

Anna Mharie B.
AB
Anna Mharie B.
Senior Sales Administrator
Mid-Market (51-1000 emp.)
"Powerful Formulas for Experts"
5/5
What do you like best about Microsoft Excel?

I like the formulas, and if you’re an expert, you can use them effectively. Review collected by and hosted on G2.com.

What do you dislike about Microsoft Excel?

Even as an advanced user, you still need to know, study, or otherwise figure out the proper way to use formulas like XLOOKUP. Review collected by and hosted on G2.com.

Verified User in Financial Services
UF
Verified User in Financial Services
Small-Business (50 or fewer emp.)
"Excel’s Adaptability Makes Data Import/Export Effortless"
5/5
What do you like best about Microsoft Excel?

I love Excel for its adaptability. I’m able to export and import data to and from other software, since many platforms integrate with Excel. Review collected by and hosted on G2.com.

What do you dislike about Microsoft Excel?

I know how to use formulas, but I don’t know how to use macros. I wish there were an easier way to learn macros in a way that’s clear and understandable. Review collected by and hosted on G2.com.

Manish J.
MJ
Manish J.
Management Information System Executive
Environmental Services
Mid-Market (51-1000 emp.)
"Incredible Automations & Macro Tools — A Game-Changer"
4.5/5
What do you like best about Microsoft Excel?

The automations and macro tools are incredible. Review collected by and hosted on G2.com.

What do you dislike about Microsoft Excel?

Sometimes, when I load large amounts of data, it glitches and shuts down. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Verified User in Information Technology and Services
Enterprise (> 1000 emp.)
"Excel’s Flexibility and Pivot Tables Make Reporting Fast"
5/5
What do you like best about Microsoft Excel?

I’ve been using Excel for a long time now, and it’s honestly one of those tools I just automatically open when I need to sort something out. Sometimes it’s just a basic list, sometimes it’s proper reports with formulas. Once I understood pivot tables and a few core formulas, it made a big difference in how fast I could finish tasks. It’s flexible, which I really like. Review collected by and hosted on G2.com.

What do you dislike about Microsoft Excel?

It’s not beginner-friendly at all. When I first started, I had no idea what half the buttons did. Also, if you overuse formulas or link too many sheets, things can slow down. I’ve definitely messed up sheets before and had to redo parts of them. Review collected by and hosted on G2.com.

Karim S.
KS
Karim S.
Finance Specialist
Consulting
Small-Business (50 or fewer emp.)
"An Ocean of Knowledge with Everything You Need"
5/5
What do you like best about Microsoft Excel?

It feels like the ocean of knowledge, whenever you think you mastered a lot you find yourself in the middle of open waters.

And it has everything in it you need to use espically if you work in finance and accounting it will be your companinon Review collected by and hosted on G2.com.

What do you dislike about Microsoft Excel?

Sometimes i have to do some tasks manually and they usually are very exhausting, but the Ai bot claude is making it a lot easier now Review collected by and hosted on G2.com.

dilawer h.
DH
dilawer h.
Route to Market Manager
Mid-Market (51-1000 emp.)
"Powerful Data Analysis and Visualization in One Platform"
4/5
What do you like best about Microsoft Excel?

Microsoft Excel is an excellent application where calculations and data analysis, data transformations and dashboard visualizations are done on single platform. It has robust bank for formulas and tools that are easy to use. My favorite formulas are xlookup, sumifs, countifs, Filter function, index, match, Byrow, Bycol, Tocol, torow, lambda functions and many more. It has powerful languages and scripts like VBA, Python, Power Query M Code, DAX. Review collected by and hosted on G2.com.

What do you dislike about Microsoft Excel?

Excel is slow when data is large like 3 to 4 lac rows. Review collected by and hosted on G2.com.

Prashant S.
PS
Prashant S.
Associate Software Developer (ML)
Small-Business (50 or fewer emp.)
"Unmatched Versatility and Collaboration with Excel"
5/5
What do you like best about Microsoft Excel?

What I like the most about Microsoft Excel is how versatile it is. You can use it for basic tasks like maintaining lists, creating schedules, or simple budgets, and also for advanced work such as formulas, pivot tables, and automation using macros. Excel makes it easy to structure data, filter values, and visualize information through charts and graphs. It is also widely used across teams, so sharing and collaborating becomes smooth without needing much explanation. Review collected by and hosted on G2.com.

What do you dislike about Microsoft Excel?

The biggest challenge I find is when large files become slow or take time to load, especially when they include a lot of formulas, images, or multiple sheets. Also, some advanced functions require prior knowledge, and beginners may take time to learn them. Real-time multi-user collaboration is possible, but not always seamless like cloud-native tools. Apart from that, I don’t see major issues. Review collected by and hosted on G2.com.

Product Avatar Image
Microsoft Excel
4.7/5(3,189)