TrustRadius: an HG Insights company
Back to Overview
Microsoft Excel Logo

Microsoft Excel Reviews and Ratings

Rating: 8.7 out of 10
Score
8.7 out of 10

Reviews

74 Reviews

Microsoft Excel - Tool for small business management and Complex statistical analysis

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

in our org, we use Microsoft Excel to register day-to-day data. We do not have a official data warehouse or something, and we use Microsoft Excel to store any additional data external from our systems. We also use it to make diverse caculations, specifically to run some financial simulations and to programatically manipulate data using built-in power query

Pros

  • Automations
  • Built-in Power Query
  • Advanced math calculations
  • Wide range of formulas

Cons

  • Memory Usage
  • Multiple Spreadsheet Conections
  • Binding Data to Charts
  • Chart customization

Likelihood to Recommend

Well, Microsoft Excel is perfect for small business scenarios. for example, They can easily create a spreadsheet to log daily sales, use formulas to calculate monthly totals, and generate simple charts to visualize sales trends. This allows them to quickly identify top-selling products and areas where they can cut costs. Financial modeling for ad-hoc is also a thing, although I don't usually use it this way now, when the small business grows, it can be tricky to manage large volumes of data. Starting on a few thousand rows, Microsoft Excel starts to get slower, until it reaches a point where you can't even use it. Then you'll want to migrate your data over to a Database or a data warehouse

MV
Marcos Vinícius Costa de Carvalho
Business Analytics Analist in Human Resources at ACE (51-200 employees)
Vetted Review
Microsoft Excel
6 years of experience
Verified on LinkedIn

Excel a Great Versatile Program

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

We use Excel for our price books, keeping track of issues with inventory, quick look bank register, tracking information, and list for mail merges, to name just some of the ways we use Microsoft Excel.

Pros

  • Sorting
  • Table Creation
  • Summing and Formulus
  • Linking Excel spreadsheets to other Excel Spreadsheets

Cons

  • Header and Footer - adding graphics and appearing on different locations on odd and even pages
  • Changing page number in the Footer
  • Sorting data
  • Finding the correct formula to use

Likelihood to Recommend

Excel is easy to use for the most part. The majority of the businesses use it. It's relatively easy to create a new spreadsheet. Once you start using it, creating a new spreadsheet becomes second nature.

EB
Ed Bremer II
Controller in Finance and Accounting at Weckesser Brick Co., Inc. (11-50 employees)
Vetted Review
Microsoft Excel
36 years of experience

Microsoft Excel

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

Spreadsheets are essential to so many things we do. Organizing product details, department goals, schedules, etc. With tens of thousands of products from various categories at various stages of production, Excel allows us to house all that data and track important information that’s relevant to almost all our teams. The formulas and the sorting functionalities are really where it shines, I can’t imagine work without spreadsheets.

Pros

  • Summing sales data
  • Calculating percentages
  • Working collaboratively

Cons

  • Dragging and dropping
  • Easy automation
  • Aesthetic improvements

Likelihood to Recommend

Microsoft Excel is best for sorting large amounts of data points. Think of client databases, where you might have separate fields for first name, last name, phone number, company, address, sales rep, product interest, etc it’s easy to store those data points together or sort by them. Same for product info, like price, release schedule, product category etc. my preference will always be Google Sheets however, as the interface in Sheets is faster, smoother, and more aesthetically pleasing.

MR
Mitchell Resk
Marketing Associate in Marketing at WizKids (51-200 employees)
Vetted Review
Microsoft Excel
15 years of experience
View profile

A Multifunctional Tool for Organizing Data

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

I mostly use Excel for reporting and exporting data from Qualtrics or other survey services. I also use Excel for categorizing and auditing webpages and contact information sheets, sorting member lists by various cells and converting worksheets into PDFs to share with clients. I also use Excel to create budget sheets for our projects and am learning to do more extensive types of formulas to create advanced budgets. Many of our staff use Excel to create and sort mailing lists for use with our newsletter, as well.

Pros

  • Sort mailing and contact lists
  • Financial jobs such as budgets
  • Store data with the ability to sort
  • Help manage projects
  • Track expenses for business functions
  • Organize event needs

Cons

  • I'm still struggling with learning pivot tables
  • There are a lot of formulas to learn so would be good to have more examples
  • More templates for other types of projects and uncommon uses would be helpful
  • Work well off mobile

Likelihood to Recommend

I don't really know another program as powerful as Excel. I've used Google Doc programs but do not feel they come close. So far, anytime I've needed a table of some sort for data, whether it's budget oriented or information off a survey, the best system has been Excel. We do web audits on occasion and we create an Excel worksheet featuring every URL of the pages we're auditing, notes, data about the content, information about files attached to the page and other information to help us determine what pages need updating, deleting or otherwise. We also use Excel primarily to export our Google Analytics to in order for us to create reports for clients that need to see specific information about their traffic.

VU
Verified User
Employee (501-1000 employees)
Vetted Review
Microsoft Excel
15 years of experience

Microsoft Excel - Perfect For Your Data Needs!

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

My company uses Microsoft Excel for myriad reports, and it is the default format for any accounting or financial spreadsheet. Microsoft Excel allows us to arrange and prioritize data, and sort over various or multiple branches, regions or units. For Credit, we use it extensively, creating ad hoc reports on demand, focusing on specific aging buckets and types of invoices. Very useful and flexible.

Pros

  • Columnar and cell-specific formatting
  • Ease of analyzing trends and information
  • Easy creation of graphic representation of results, in varying styles
  • Downloading into Microsoft Excel is very easy, and updating the data also

Cons

  • User templates could be easier to create
  • Further automation of pivot tables

Likelihood to Recommend

I've used Microsoft Excel extensively for creation of graphs showing, for instance, the increase of collections over time, growth in sales, comparison between various dimensions of data, and so forth. Microsoft Excel handles conversion of date into easily readable and comprehensible visual data. The variety and options for displaying graphical information is excellent, and can be easily made more granular at need. This is one of the most useful, and usable, aspects of the software.

FS
F Scott Wilson
Credit Manager, North America in Finance and Accounting at BrandSafway (10,001+ employees)
Vetted Review
Microsoft Excel
30 years of experience
View profile

The easy choice

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

We use Microsoft Excel for all spreadsheet needs. Beyond typical spreadsheet program use cases, we find that it is great for keeping track of projects and tasks, as well as opening exports from other platforms. We are able to use Microsoft Excel as a single point to pull data from multiple sources and get a central view on what is going on.

Pros

  • Managing lists of data
  • Breaking out data in detailed outputs with pivots
  • Generation of simple graphics from data sets, like pie charts

Cons

  • Built in tutorials
  • User interface could be more intuitive
  • Better integrated graphics options

Likelihood to Recommend

Microsoft Excel is well suited to all day-to-day data management needs. It allows you to pull data from multiple sources as it works with a lot of different data formats, and allows you to centralize data into a single document. It is good, but not the best choice, for those looking to turn data into infographics.

VU
Verified User
Manager in Professional Services (11-50 employees)
Vetted Review
Microsoft Excel
10 years of experience

Microsoft Excel supports my needs with large volume data

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

As a manufacturing company, we deal with large volumes of part numbers that require filtering, manipulation, and comparison with other documents or values. Microsoft Excel allows me to manage these large volumes easily. What I find useful most the the automated suggestions Microsoft Excel provides to complete actions you have done to one value for the rest of your set.

Pros

  • Data Filtering
  • Formulas
  • Presentation of Data

Cons

  • AI automated suggestions
  • Instructions built into Microsoft Excel on complex formulas

Likelihood to Recommend

Microsoft Excel is the best software option to deal with organization of large data sets, especially with ease of integrating these into other Microsoft programs such as Word and Outlook.

VU
Verified User
Employee in Quality Assurance (10,001+ employees)
Vetted Review
Microsoft Excel
10 years of experience

Has a lot of capabilities if you put the time in!

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

I do survey analysis and some data cleanup using Microsoft Excel. I also use it to analyze row level data for survey responses we receive. I use it mainly for initial analyses using pivot tables, but will also use power queries to transform data as needed. I also use it to create some basic charts to use in PowerPoints and other presentation tools.

Pros

  • Column filtering
  • pivot tables

Cons

  • putting more than one pivot table on a single sheet
  • Let me filter by or jump to duplicate values instead of only highlighting them
  • Make it easy to reverse the order of a chart instead of me having to manually change the order myself

Likelihood to Recommend

It's good for the basics - initial cleaning, simple tables, concatenating, randomizing, and quick fixes. It can be difficult to de-dupe, since it only highlights and does not allow you to easily view/filter by duplicated values.

VU
Verified User
Analyst (10,001+ employees)
Vetted Review
Microsoft Excel
4 years of experience

Microsoft Excel: In my opinion, Powerful but Bloated – Is It Still the Best Tool for the Job?

Rating: 6 out of 10
Incentivized

Use Cases and Deployment Scope

Microsoft Excel is widely used across multiple applications in my organization, including technical specifications, planning, and general team management. It is a highly flexible software that enables seamless database integration with other tools, making it one of its most powerful features. Additionally, Microsoft Excel facilitates the easy management and consultation of small to mid-sized databases.

Pros

  • Creation and management of small to mid databases
  • Data analysis and visualization (charts, tables, etc)
  • Database exporting, importing and migration
  • Project Management and task control

Cons

  • The online version has really low performance
  • Lacks a simplified UI for most use cases (as Google Sheets do)
  • Poor performance on collaboration and multiple users
  • Lacks useful, online integrated tools (as translation, stock prices, etc)

Likelihood to Recommend

Microsoft Excel is still a very useful tool, undisputed on "harder" environments where VBA and heavy automations are required. It also is suited for most regular applications, but as a productiveness application, currently is losing from many competitors that are committed to keep it simple. That being said, today I recommend for most "regular" users (that includes myself) to use its competitors.

LF
Lucas Fernandes Ferreira
Onboard User Experience Strategy in Information Technology at Stellantis (10,001+ employees)
Vetted Review
Microsoft Excel
10 years of experience
Verified on LinkedIn

Microsoft Excel The Great

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

I have been using Microsoft Excel for creating configuration workbooks, for data retrieve, data analysis, creating workflows and forms, creating test scripts, creating reports using BI, tracking progress, creating charts.

Pros

  • calculation,
  • filtering data
  • creating pivot tables
  • removing duplicates
  • drag and drop to whole columns
  • creating different formulas

Cons

  • Microsoft Excel starts lagging when using large data
  • problem inserting image for each rows
  • merge cells cannot be applied to all rows

Likelihood to Recommend

Microsoft Excel is best when we use for data anlaysis, report creating, appyling formulas and calculatios. But Microsoft Excel fails when there is large data sets, with multiple tabs. Its not that good for project managment.

VU
Verified User
Analyst in Engineering (10,001+ employees)
Vetted Review
Microsoft Excel
8 years of experience