Macros and scripts are very powerful tools for automating Excel, just like pivot tables, which allow you to analyze data quickly. Additionally, Excel allows you, through Power Query, to integrate data from practically any source with a very agile user experience. Without a doubt, the cost of Excel, compared to its benefits, makes it extremely worthwhile to have it. I have also noticed that in recent years the performance of the tool has improved more and more; it doesn't crash as much as it used to. Review collected by and hosted on G2.com.

When you add VBA macros to your files, it becomes very difficult to share the documents with other people. Sometimes it is difficult for them to be compatible or for the macros to run smoothly for other users. Review collected by and hosted on G2.com.

The power of PivotTables and VLOOKUP (or XLOOKUP now) feels unmatched when it comes to handling large datasets and building financial models. I also really appreciate how quickly I can turn numbers into clear visuals with charts, especially when I’m preparing presentations for stakeholders. Review collected by and hosted on G2.com.

The learning curve for some of the more advanced “Power Pivot” features can be pretty steep. Also, when I’m working with extremely large files (millions of rows), the software can sometimes lag or even crash, especially if I’m not using a high-spec machine. Review collected by and hosted on G2.com.

I love how Excel makes managing benefits data so much easier. Whether I’m tracking enrollments or comparing plan costs, it lets me organize complex information into clear, easy-to-read reports that leadership can actually understand. Pivot tables and charts save me a lot of time and make it simple to spot trends, which is a huge win for me in HR. Review collected by and hosted on G2.com.

For HR benefits work, Excel can sometimes feel overly manual. While it’s a powerful tool, building complex formulas and keeping large spreadsheets updated can take a lot of time, and even a small mistake can throw off an entire report. Review collected by and hosted on G2.com.

What I like most about Microsoft Excel is how flexible it is for pretty much anything related to data. Whether it’s simple tracking or more detailed analysis, Excel handles it well.

Being in a payroll profession, I cant imagine my day without excel.In my day-to-day work, formulas and functions save a lot of time, especially things like VLOOKUP/XLOOKUP, pivot tables, and basic calculations.

And nowadays I am using Macro a lot,Instead of doing things manually, I can just set it up once and reuse it. Review collected by and hosted on G2.com.

One thing I don’t like about Microsoft Excel is that it can get really slow when you’re working with large datasets. Once the file becomes heavy with too many formulas, pivot tables, or multiple sheets, it tends to lag or even crash sometimes.

Also, managing complex formulas can be a bit frustrating. If someone else created the file, it takes time to understand what’s going on, especially if it’s not well structured Review collected by and hosted on G2.com.

What I like best about Microsoft Excel is its power and flexibility for complex data analysis. It offers advanced formulas, pivot tables, and strong performance when working with large datasets. Excel is also highly customizable, allowing some automation. Overall, it’s a very robust tool for deep analytical and financial work. Review collected by and hosted on G2.com.

Collaboration in Microsoft Excel can be limited and often leads to version conflicts when multiple people edit files. It’s not as convenient for real-time teamwork compared to cloud-native tools. Managing large shared files can also become messy and hard to track. Additionally, setup and access across teams is less seamless than in fully integrated platforms like Google Workspace. Review collected by and hosted on G2.com.

I mainly use Excel to organize and clean data, and it does the job without much hassle. Sorting, filtering, and basic formulas help me quickly make sense of messy data but now woth the help of AI Introduction, the work has become effortless.

The interface is familiar and easy to navigate once you’ve used it a bit. Performance is mostly smooth, even with larger files, though it can slow down sometimes.

It also integrates well with other Microsoft tools, which helps in day-to-day work.

It’s not perfect, but it’s reliable and gets the job done without overcomplicating things.

I don't beleive anyone needs any support for using sheets. Review collected by and hosted on G2.com.

One issue I face is performance -- Excel tends to slow down when working with large files or heavy formulas, which can be frustrating during time-sensitive work.

The UI is familiar but can feel a bit cluttered at times, especially when you’re trying to find less-used features. Also, collaboration isn’t always smooth compared to other tools -- sometimes version conflicts or sync delays happen.

It integrates well with Microsoft tools, but outside that ecosystem, things can feel a bit limited. Overall, it works, but there’s definitely room for improvement. Review collected by and hosted on G2.com.

What I like best about Microsoft Excel is its power to organize, analyze, and visualize data in one place.

It makes handling large amounts of data easy through formulas, pivot tables, charts, filters, and conditional formatting, which saves a lot of time and improves accuracy. I especially like how it can turn raw numbers into meaningful insights and reports quickly. For professional work, features like XLOOKUP, dynamic formulas, and dashboards are absolute game changers, i use it daily for my work.

Easly implemented for all my needs, Even we are integrating this with our database to automate our data.

Customer support also good. Review collected by and hosted on G2.com.

It is also prone to human error—a small mistake in a formula, wrong cell reference, or accidental overwrite can impact the entire sheet. Review collected by and hosted on G2.com.

I use Excel for everything. It’s open on my desktop all the time and I rely on it throughout the day for everything from taking notes to running calculations, data analysis, and data simulations. I use Excel extensively, and the performance is always great, even when I’m working with large datasets. The UI is well laid out, and there are endless integration options. The price is reasonable, and the support system is robust. Review collected by and hosted on G2.com.

The ribbon has changed over the years and isn’t as customizable as it once was; it would be nice to have those customization options back. Also, I haven’t really gotten into the AI side of it yet, so I can’t speak to that very much. Review collected by and hosted on G2.com.

Everything like rules, making report, importing data, making tracker Review collected by and hosted on G2.com.

To automate something we need to know VBA tool and as a BPS employee its not necessary for me to know vba tool. Review collected by and hosted on G2.com.

I love that Excel acts as the ultimate universal translator between my messy experimental brainstorming and the rigid requirements of the Tecan Fluent. When I’m calculating media volumes or cell seeding densities, I can visually map out my plate layouts, which gives me a level of intuitive control that a raw text editor just can’t provide. The magic happens during that final conversion to CSV; I can strip away all the complex formulas and color-coding to hand the Fluent a perfectly clean, flat file for its liquid handling instructions. It serves as my primary safety checkpoint, allowing me to catch a decimal point error in a volume column before a single pipette tip ever touches a reagent. Ultimately, it’s the reliability of that workflow—turning biological logic into digital commands—that makes it my most essential tool in the lab. Review collected by and hosted on G2.com.

I often struggle with Excel’s habit of "helpfully" auto-formatting my reagent IDs into dates, which immediately crashes my Tecan Fluent import. I also find the lack of version control risky, as a single accidental keystroke in a volume cell can go unnoticed until a pipette tip crashes or a well overflows. When I save my layouts as CSVs, I lose all my safety formulas and color-coding, meaning any last-minute tweaks require a complete and tedious rebuild of the file. Ultimately, it’s a constant battle to ensure that what I see on my screen perfectly matches the rigid data structure the liquid handler demands. Review collected by and hosted on G2.com.