Search
Close this search box.
Customer Satisfaction
2.2/10
2.2
User Experience
3.1/10
3.1
Functionality
1.0/10
1.0
Business Value
2.8/10
2.8

Microsoft Excel

What is Microsoft Excel?

Cloud-based and business user-oriented BI solution for creating dashboards, analyses and reports. Paginated reports available for print-oriented reporting. Also part of Microsoft Fabric.

BI, Analytics & CPM
● Reporting / Dashboards
●● Analysis
– Advanced Analytics
● Planning
– Financial Consolidation

= Function covered, ●● = Functional focus

= Function covered
●●
= Functional focus

About Microsoft Excel

Self-description of the vendor

No vendor self-description available

Microsoft Excel BARC Review & Rating

Provider and product description

Microsoft, the world’s largest software company, was founded in 1975 and has become a household name primarily due to its Windows operating system and Office suite. With its offerings, Microsoft wants to contribute to a modern workspace for its customers, whether they are private individuals or large enterprises. The vendor has a broad enterprise offering, ranging from cloud (Azure) to database to its ERP products.

Microsoft was among the first vendors to focus on providing cloud-based solutions for analytics, a path later followed by several competitors. Azure is used by numerous companies as a cloud computing platform and for storing substantial amounts of data, putting Microsoft in a good position to offer integrated analytics front ends. Indeed, the vendor has not only integrated Power BI, its core BI & analytics platform, with many Azure Services and Microsoft products but has also included it in various product packages. One of the most recent is Microsoft Fabric, designed as an integrated end-to-end data and analytics platform delivered as Software as a Service (SaaS). The package contains several Azure services such as Power BI, Azure Synapse Analytics, Azure Data Factory and many more. The core value proposition and advantage for customers is that the already stitched together services facilitate the building up of a SaaS environment consisting of data and analytics services. One of the additional benefits is the obligatory Data Lake ‘OneLake’, which is automatically connected with all other Fabric services and can be used by customers without extra configuration.

Microsoft Excel – part of the Microsoft 365 suite – provides a range of functions catering to the needs of business intelligence and analytics professionals. Among these, the Power Query integration enables users to import, transform and cleanse data from various sources. Power Pivot lets users create data models, establish relationships between tables and perform advanced calculations using Data Analysis Expressions (DAX). PivotTables and PivotCharts are available for data analysis, allowing users to summarize data and visualize trends. Excel also offers advanced analytical capabilities through Solver, which addresses complex optimization and simulation scenarios. Moreover, Excel’s graphical functionality supports the creation of dashboards. However, in practice, Excel is most commonly used for data management tasks, detailed analysis and reporting in pure Excel tables.

Microsoft was among the first vendors to focus on providing cloud-based solutions for analytics, a path later followed by several competitors. Nowadays, Microsoft 365 is used by numerous companies in the cloud.

This product review describes the analysis product Excel. Microsoft Power BI is covered separately in The BI & Analytics Survey 25.

Strengths and challenges of Microsoft Excel

BARC’s viewpoint on the product’s strengths and challenges.

Strengths
  • Excel is well known and widely used – probably more widely than any other BI tool
  • Users are (or become quickly) familiar with the GUI
  • Competencies and partners are available worldwide
  • Companies with existing enterprise agreements do not incur additional licensing fees
  • Easy collaboration through sending of Excel files and publishing them to other Microsoft products
  • Web and mobile clients with Office 365 available with improved co-working capabilities
Challenges
  • Integration with other Microsoft products is at data level only and lacks a central metadata repository
  • Limitations in terms of handling large data volumes
  • Due to its limited security functionality, the ease with which files can be sent by email or published in Sharepoint makes it very hard to govern the data
  • Ease of use often generates ‘data graveyards’
Need more help finding the right software?

Find out how our expertise can help you.

Microsoft Excel User Reviews & Experiences

The information contained in this section is based on user feedback and actual experience with Microsoft Excel.

The information and figures are largely drawn from BARC’s The BI & Analytics Survey, The Planning Survey, The Financial Consolidation Survey and The Data Management Survey. You can find out more about these surveys by clicking on the relevant links.

Who uses Microsoft Excel in a BI & analytics context and how

Why users buy Microsoft Excel and what problems they have using it

Premium content. Unlock with BARC+.
For just €79 per month (€948 per year) you can access all the paid content on www.barc.com.
Your benefits:

Full user reviews and KPI results for Microsoft Excel

All key figures for Microsoft Excel at a glance.

Premium content. Unlock with BARC+.
For just €79 per month (€948 per year) you can access all the paid content on www.barc.com.
Your benefits:

Individual user reviews for Microsoft Excel

Role
Head of business department
Number of employees
More than 2.500
Industry
Non-profit sector
Source
BARC Panel, The BI & Analytics Survey 25, 05/2024
What do you like best?

Einfach zu bedienen.

What do you like least/what could be improved?

Moderen oberfläche, schneller.

What key advice would you give to other companies looking to introduce/use the product?

Ist nur eine Notlösung.

How would you sum up your experience?

Begrenzt einsetzbar.

Role
Project manager for BI/analytics from IT
Number of employees
100 - 2.500
Industry
Manufacturing
Source
BARC Panel, The BI & Analytics Survey 25, 06/2024
What do you like best?

User familiarity, flexibility.

What do you like least/what could be improved?

Siloed data, redundancy, manual efforts for data preparation, limited capacity.

What key advice would you give to other companies looking to introduce/use the product?

Combine it with other platforms like Power BI/Fabric to get best of both worlds.

How would you sum up your experience?

Great general purpose tool. Vastly imperfect analytics tool.

Role
CIO
Number of employees
Less than 100
Industry
Insurance
Source
BARC Panel, The BI & Analytics Survey 25, 06/2024
What do you like best?

Users are already familiar with the tool, so onboarding is easy. Quick performance.

What do you like least/what could be improved?

Unresolved bugs, and it's hard to report those bugs.

What key advice would you give to other companies looking to introduce/use the product?

Consider Power BI.

How would you sum up your experience?

Mostly positive, but bugs should be addressed quickly.

Role
Consultant
Number of employees
Less than 100
Industry
Education
Source
BARC Panel, The BI & Analytics Survey 25, 04/2024
What do you like best?

Power Pivot seamlessly integrates with Excel, providing users with familiar tools and interfaces for data analysis and visualization. This integration makes it easy for Excel users to leverage the advanced data modeling and analysis capabilities of Power Pivot without having to learn new software.

What do you like least/what could be improved?

While Excel provides various charting and visualization tools, some users may find the built-in options limited compared to dedicated data visualization software. Enhancing Excel's visualization capabilities, particularly for creating interactive and advanced visualizations, could improve its utility for data analysis and presentation.

What key advice would you give to other companies looking to introduce/use the product?

Keep an eye on the performance and scalability of Excel, especially when working with large datasets or complex Power Pivot models. Monitor system resources, such as memory and processing power, and optimize models and calculations as needed to ensure smooth performance.

How would you sum up your experience?

My general opinion of Microsoft Excel, including Power Pivot, is quite positive. Excel has long been a staple tool for data analysis, spreadsheet management, and visualization, and its versatility makes it suitable for a wide range of users, from individuals to large organizations.

Role
Head of business department
Number of employees
Less than 100
Industry
Education
Source
BARC Panel, The BI & Analytics Survey 25, 05/2024
What do you like best?

Ease of use and flexibility.

What do you like least/what could be improved?

Lacking standard automated tools and options.

What key advice would you give to other companies looking to introduce/use the product?

Make sure users are well versed in Excel and it's use.

How would you sum up your experience?

Very good product with a lot of flexibility, sometimes a bit hard to get things done fast.

Role
Head of business department
Number of employees
More than 2.500
Industry
Banking and finance
Source
BARC Panel, The BI & Analytics Survey 25, 05/2024
What do you like best?

Flexibilität.

What do you like least/what could be improved?

Datenhaltung wenig brauchbar.

What key advice would you give to other companies looking to introduce/use the product?

Einige weinige Personen als Experten ausbilden.

How would you sum up your experience?

Schnell umsetzbar.

Role
Project manager for BI/analytics from business department
Number of employees
100 - 2.500
Industry
Social
Source
Invited by the vendor, The BI & Analytics Survey 25, 04/2024
What do you like best?

Est aujourd'hui la clé de nos métiers. Sans Microsoft Excel, nous ne pourrions pas accomplir la moitié de notre activité dans notre direction.

What do you like least/what could be improved?

Il s'agit d'une solution qui s'est imposée dans le monde de l'entreprise. Il existe pourtant d'autres solutions tout aussi viable et multi-tâches. Les mises à jour apportent des modifications qu'il faudrait mieux présenter pour guider les utilisateurs (une option peut être déplacer dans un autre menu ou être remplacée).

What key advice would you give to other companies looking to introduce/use the product?

Outils primordial pour la gestion des données et pour pouvoir les retravailler.

How would you sum up your experience?

Bonne opinion, c'est un produit qui s'adapte à beaucoup de situations.

Role
Project manager for BI/analytics from IT
Number of employees
100 - 2.500
Industry
Transportation and logistics
Source
Invited by the vendor, The BI & Analytics Survey 25, 05/2024
What do you like best?

Everyone knows how to use it, easy and available. Gets basic reporting and data manipulation done.

What do you like least/what could be improved?

Lacking visualization capabilities and taking things to next level.

What key advice would you give to other companies looking to introduce/use the product?

Look at more advanced systems. We have Targit but people still default to Excel.

How would you sum up your experience?

Good not great.

Role
Employee of a cross-departmental BI/analytics team
Number of employees
100 - 2.500
Industry
Manufacturing
Source
Invited by the vendor, The BI & Analytics Survey 25, 05/2024
What do you like best?

The extreme flexibility, the price point, the availability, the connectors and the constant product development. Widely known product with a large community and user base - always possible to find information and solutions to problems online.

What do you like least/what could be improved?

The flexibility of the product is both good and bad - traditional BI systems like PowerBI, Targit, Qlick etc. is a more locked environment, so when you release reports, dashboards or analysis to users, there is a smaller risk of the users breaking it. Interactive dashboards does not work very well in Excel.

What key advice would you give to other companies looking to introduce/use the product?

Do it. Excel is a must have for business users. The flexibility in Excel can overcome the limitations of other BI softwares, but the flexibility also comes with a price. Try to centralize the creation of reports and avoid to many customized and personal reports.

How would you sum up your experience?

Very positive. And it seems like Excel 365 is even better, so we look forward to being upgraded to this version.

Survey Information
Number of reviews for Microsoft Excel
61
Reviewed versions
3% version 2010, 3% version 2013, 13% version 2016, 10% version 2019, 8% version 2021, 64% version Excel 365
Peer groups in the survey
Midsize/Departmental Implementations, Analysis Focus, International BI Giants
Check out the world´s most comprehensive guide to the Power BI ecosystem.