I particularly like Excel's Copilot integration, which can generate formulas, summarize data, identify trends, and create charts using natural language, making data analysis much faster. The improved Python in Excel support is another standout feature, allowing advanced data analysis and automation without leaving Excel. I also appreciate the enhancements to dynamic arrays, Power Query, and collaborative editing, which make it much easier to clean, transform, analyze, and share large datasets with the team. Review collected by and hosted on G2.com.

The row limits hit us hard when analysing large test execution logs. Collaborative editing is also painful when multiple people are using the same file. Review collected by and hosted on G2.com.

Query and Pivot features are exceptional

Excel is also helpful to show data very effectively to the customers

Keyboard navigation is easy Review collected by and hosted on G2.com.

Multi user collaboration can be made much better

Also the history of version has to be well managed Review collected by and hosted on G2.com.

What I like most about Excel (windows app and web) is that it meets me where I am. On my laptop, the desktop app is fast and familiar: I can build a model, crunch through lots of rows, and drop in pivot tables, charts, and advanced formulas without having to think too hard. It handles the heavy lifting—big files and more complex work—plus macros and add-ins when I need them. I can also clean data with Power Query and get it into shape quickly. Day to day, it just feels like home: open, type, calculate, done.

The web app inside SharePoint really shines for teamwork. We share the same sheet across the team, and everyone can jump in. Co-authoring is smooth, and autosave plus version history keep us safe when someone edits the wrong cell. Comments and @mentions make reviews easy, and permissions stay in place so the right people see the right tabs. It’s lighter, yes, but for status trackers, lists, and simple analysis it’s perfect—no local files to pass around and no “final_final_v3.xlsx” drama.

Setup and integration are straightforward. I sign into Microsoft 365 and both apps pick up my files from OneDrive/SharePoint; links and permissions carry over, and I can drop a table into Teams or a deck without jumping through hoops. Search and filters in the web app help me find the document quickly, and on desktop I rely on named ranges, dynamic arrays, and XLOOKUP to keep formulas clean. I use Excel basically every workday on Windows, and a few times a week in the browser with the team. Support-wise, the help pages and community answers usually get me unstuck, and recent updates have added useful features without breaking my muscle memory too much. Review collected by and hosted on G2.com.

What I dislike about Excel mostly comes down to edge cases. The web app can feel limited with larger models: heavy formulas and more complex chart formatting don’t always behave as expected, and macros are a no-go there, so I end up bouncing back to the desktop version. Sometimes co-authoring also gets into a weird state—someone’s edit won’t show up until a refresh or reopen, or a sheet lock lingers longer than it should—and that slows us down a bit. On Windows, very large files or too many volatile calculations can make a workbook feel sluggish, and I’ll have to save, close, and reopen it to clear things up. None of this is a dealbreaker, but it’s the kind of small friction I notice most when deadlines are tight. Review collected by and hosted on G2.com.

Excel’s greatest strength is versatility. It manages simple lists and complex data with ease. Powerful formulas, PivotTables, and charts turn numbers into insights. Automation through VBA saves time, while accessibility ensures collaboration. Its balance of simplicity and depth makes Excel timeless, useful for beginners and advanced professionals alike. Review collected by and hosted on G2.com.

Excel can be frustrating when spreadsheets grow too complex, making errors harder to detect and fix. Collaboration is limited compared to cloud tools, and large datasets often slow performance. Charts are basic, and formulas can be error-prone. Overall, Excel struggles with scale, teamwork, and advanced visualization needs. Review collected by and hosted on G2.com.

The best thing about Excel is its unmatched power for data analysis. Features like PivotTables and XLOOKUP make it incredibly easy to organize thousands of rows of data. It’s the industry standard for a reason—it can handle complex financial modeling that other spreadsheet tools just can't touch.

I love how flexible Excel is. I use it for everything from simple checklists to complex project trackers. The conditional formatting and automation help me visualize trends quickly, and since almost every business uses it, sharing files with clients is always seamless and headache-free.

Excel is a huge time-saver. Once you learn a few key formulas or set up Power Query, you can automate repetitive tasks that used to take hours. It's reliable, fast, and the integration with the rest of Microsoft 365 makes my workflow much smoother. Review collected by and hosted on G2.com.

The learning curve can be pretty steep. While basic tasks are easy, the more advanced features—like Power Pivot or complex nesting formulas—aren’t very intuitive for a beginner. You often have to spend a lot of time on YouTube or forums just to figure out how to do one specific thing.

It can get sluggish or even crash when you're working with massive datasets or too many formulas. If a file gets over 50MB, you start to see 'Not Responding' messages, which is frustrating when you're in the middle of a big project. It still feels a bit 'heavy' compared to lighter web-based tools.

Collaborating in real-time is better than it used to be, but it's still not as smooth as Google Sheets. Sometimes you get 'versioning' errors or sync conflicts when multiple people are editing a workbook at once, which can lead to data being overwritten or lost if you aren't careful. Review collected by and hosted on G2.com.

Microsoft Excel is its versatility and reliability across both industry and academic use cases. With over three years of experience in software testing and three years as a CSE researcher, I have consistently used Excel for test case management, defect tracking, data validation, and reporting, as well as for research data analysis, preprocessing, and visualization.

Excel’s powerful features such as pivot tables, advanced formulas, conditional formatting, and data validation make it extremely effective for analyzing large datasets and identifying patterns or anomalies. From a testing perspective, it helps in maintaining structured test documentation and generating clear reports for stakeholders. From a research standpoint, it serves as a quick and efficient tool for exploratory data analysis before moving to advanced tools.

Overall, Excel strikes a perfect balance between ease of use and analytical power, making it an indispensable tool for professionals across domains. Review collected by and hosted on G2.com.

One limitation of Microsoft Excel is that it can become slow and less efficient when handling very large datasets, and it lacks advanced automation and version control features compared to specialized data analysis tools. Review collected by and hosted on G2.com.

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.

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.

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.

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

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.

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.

Excel has a low learning curve for everyday user, while also incorporates specailized tools for advanced users. It is universally accepted and used across all the fields. Review collected by and hosted on G2.com.

Formatting is rigid and incorrect format or hard coded numbers inside formula may generate error. A single wrong cell reference can corrupt the whole result and copy-paste errors are quite common. Review collected by and hosted on G2.com.