Microsoft Excel Reviews

Pros

I have been using the excel for the past 20 years and the most excel features i use on my daily routine are the pivot table, vlook functions, graphs, calculations and it keeps on going. all the monthly salary calculations, deductions, are all compiled into one sheet and its very easy to share the files with password protection facility. i have purchased both home office 365 and for business. very compatible with the microsoft teams. Another feature of excel is the low

Cons

everything in excel is very easy to learn, but only while using Macro and Micro features, i had found a little bit of difficulties. but using the help button itself, the same can be resolved within few minutes. the total features in excel in overwhelming and i feel like that i have been using only less than 20% of the total features of excel.

Alternatives Considered

Zoho Sheet

Reasons for Switching to Microsoft Excel

Excel is more user friendly. Excel can be accessed across all my devices and also on all platforms. by purchasing, one license, i received 5 extra licenses which i could share with my family. The onedrive feature attached with excel helped me in solving the storage issues too.

Pros

Excel is a versatile tool that can be used for a variety of tasks.Excel has a user-friendly interface and features such as auto-fill, cell formatting, and formula autocomplete, making it easy to navigate and use for beginners.Excel allows for the organization of large amounts of data, making it easier to sort, filter, and analyze.Excel's powerful calculation engine allows users to perform complex calculations and analysis with ease.Excel provides tools to create visually appealing and informative charts and graphs to display data.Excel is a versatile tool that allows multiple users to collaborate on the same document simultaneously and integrates with other Microsoft Office tools, making it a powerful tool for any workflow.

Cons

Excel requires a lot of time and effort to master its advanced features, making it intimidating for beginners.Excel documents can be shared and accessed by multiple users, increasing the risk of data breaches and unintentional data sharing.Excel may not be the most efficient tool for large-scale collaboration projects due to its lack of real-time collaboration features.Users may need to convert Excel files before sharing them.High processing demands can slow down computer performance, especially when working on time-sensitive projects.

Pros

I find it very easy to input the numbers I've gathered throughout the year using this software, and it's a great reference for keeping my records organized.

Cons

It's natural to find some of the commands in Excel confusing, and it can take some time to get used to them and make tasks easier

Pros

Microsoft Excel is a widely used spreadsheet software that offers a range of tools and features to help users manage and analyze data effectively. One of the primary benefits of Excel is its versatility - it can be used for a variety of purposes, including budgeting, data analysis, project management, and more.Excel's user interface is straightforward and easy to use, with a range of formatting options and functions available to users. The software also offers a wide variety of chart types, which can help users to visualize their data in a meaningful way. Additionally, Excel's ability to handle large amounts of data makes it an ideal tool for businesses and other organizations.Overall, Microsoft Excel is a reliable and powerful tool that offers many benefits to users who need to manage and analyze data. While there may be a learning curve for some users, the software's versatility and range of features make it a valuable addition to any data management toolkit.

Cons

While Microsoft Excel is a widely used and versatile software for data management, it also has some cons that users should be aware of.One of the primary cons of using Excel is its limited capacity for handling very large datasets. When dealing with extremely large files, Excel can become slow and unresponsive, which can impact productivity and efficiency. Users who need to work with large datasets may need to consider alternative software or tools that can handle more significant amounts of data.Another drawback of using Excel is its lack of security features. Excel files can be easily shared and accessed by others, which can pose a security risk for sensitive or confidential data. Users need to take additional steps to protect their data, such as password-protecting files or using encryption software.Excel can also be challenging to use for users who are not familiar with the software. While Excel has a straightforward user interface, the software's more advanced features may be challenging to navigate for users without significant experience with the software. This can result in errors or inefficient use of the software.Finally, Excel is a paid software, and users need to purchase a license to use it. This cost can be a significant drawback for individuals or organizations on a tight budget. Competing software such as Apple's Numbers is free of charge.

Pros

I find Excel's extensive online community and forums incredibly helpful in overcoming any obstacles I encounter while using the tool. Moreover, Excel offers me a wide range of options to protect and encrypt the data in my spreadsheets, and its Macro features allow me to automate routine tasks, thereby increasing my productivity and efficiency.

Cons

The basic functions of Microsoft Excel are straightforward and easy to use. However, mastering the advanced tools and formulas often requires additional training. Over the past decade, I've had to continually update my knowledge of Excel to use it seamlessly. While I appreciate the powerful capabilities of Excel, my only concern is the constant need to learn new skills to keep up with its evolving features.

Pros

Enter and analyze data with automatic commands, create pivot tables, graphs, and insert logos or page headers. Microsoft Excel is excellent for performing calculations of high complexity and providing perfectly detailed and accurate results.

Cons

Microsoft Excel is perfect, it fills every point complete in terms of functionality.

Pros

Excel is a fantastic resource for handling statistics. For manipulating and analyzing data, it offers a broad range of tools and functions, from straightforward mathematical formulas to intricate statistical analyses. Excel is made to be simple to use and understand, despite the fact that new users may find it intimidating. Excel is also very customizable, enabling it to be tailored to each user's unique requirements.

Cons

Its complexity is one of Excel's major drawbacks. Excel may lag and become unstable as files grow bigger and more complicated. Users who deal with large datasets may find this frustrating. Additionally, even though Excel can be highly customized, doing so can be challenging and take a lot of time. Last but not least, Excel can make mistakes, particularly when complicated calculations are used. This could result in inaccurate data and report errors, which could have detrimental effects on business or study.

Pros

Microsoft Excel is an incredibly powerful spreadsheet software that has been an industry standard for decades. With its wide range of features and capabilities, it has become an indispensable tool for businesses, organizations, and individuals alike.One of the key strengths of Excel is its versatility. It can be used for everything from simple calculations and data entry to complex financial modeling and analysis. It is also a great tool for organizing and tracking information, creating charts and graphs, and generating reports.

Cons

One common criticism of Excel is that it can be overwhelming for new users due to the wide range of features and options available. It may take some time and effort to become proficient in using all of its functions and capabilities.Another criticism is that Excel can sometimes be prone to errors, particularly when dealing with large and complex datasets. Users need to be careful and thorough when inputting and analyzing data to avoid mistakes that can have significant consequences.

Pros

Ease of dealing with it, the ability to deal with a huge amount of data, the ability to analyze data and make graphs in a distinctive way

Cons

data visualization need more improvement

Pros

too many function, you can do everything what do you what, add pictures, notes, sharing with other people, very useful in our company

Cons

sometimes problem with adding links or find exact button

Pros

When people say Excel they use it as interchangeably as the word spreadsheet and it's now excepted that just saying Excel is to suffice on it's own. There is very little that cannot be accomplished with numbers using Excel. I have used Excel to complete financial statements, carry out financial modelling and valuation.

The UI is intuitive, familiar, and with the continual progression and development of Excel within the office family, it's compatibility and integration is easily done. Years ago I only ever recorded Macros to automate and do mundane or repetitive tasks but using VBA is so much better once you get to grips with it and the VBA editor is user friendly.

Functions and formulae are the real massive strengths. The current ones now, 2020, are some of the most comprehensive and impressive. If you are comfortable with logical math sequences then nested IFs are simple and a must!

Cons

I do love Excel but unless you're on a super monster processor with massive RAM, having references drawing on other sheets or very large data sets, can be very slow to initially process. Where possible it is more efficient to keep the data within the sheet but on other Tabs; but this is not always possible. It is not designed foremost to be a database with the large dataset handling but it does try given time to process.

Pros

Microsoft excel arranges data or information in an orderly and logical manner which makes easier for analysis. Through the use of excel spreadsheet it will be easier for analysts to carry out extensive analysis the use of advanced excel functions such as CHOOSE function (used in financial modelling for scenario analysis and SUMIF and COUNTIF used when dealing with huge amount of data.
Excel is also used to build nice charts and tables such as bar graphs, pie charts and pivot tables. It is also used in trend analysis and regression and correlation analysis. The other general advantage of Microsoft excel is that it helps analysts to make use of other software such as SPSS and Eviews.

Cons

The main disadvantage of excel is that it needs more time and attention for practice for the analyst to fully benefit from it. There is a problem of garbage in garbage out because of human error such as ommited negative signs and incorrect arrangement of rows may not be harmful but when they erode investor trust or cause a loss of investment opportunity. The other con of excel is that it contains several functions which needs time for an analyst to learn.

Pros

Microsoft Excel - is one of the most complete and advance spreadsheet application currently on the market. The better question would be, what can't it accomplish as this is an application that is used across the board in many companies and careers. It has an awesome ribbon feature which houses many groups of frequently used tools and is super customizable. I doubt that there is any one person that can house all knowledge about this one application. Just to list a few of what can be done:

* Write basic, intermediate and advance formulas and functions to carry out your day to day work.
* Create basic, intermediate and advance conditional formatting to style your sheet and or highlight specific areas and or thing on the spreadsheet to draw focus.
* You can create your own custom group to house your own list of preferred tools to be available at your finger tips.
* It comes equipped with a quick access toolbar to hold frequently used tools right at the top of the sheet which is super easy to access and is something I use at all times while carrying out my day to day routines.
* I love the clean and improved UI [User Interface] version over version.
* It has collapsible tabs and commands to give you more screen real estate when working on small screen devices and or monitors.
* The Developer option is the go to tab when working with VBA and Marcos.
* It comes equipped with the option to record and or write macros using the VBA editor, allowing you to automate your work flow.

Cons

I am not able to think about a con at the moment with so many pros available.

Pros

I use Excel almost every day, even when I am not at work. I find it easy to use and allows me to sort, filter, and color code anything I am working on. I do not just use Excel for accounting or data manipulation – I use Excel probably more than I use Word, if you can believe that. I love using it for lists and organizing information I want to keep track of. I even will email myself Excel files so I can access them on my smart phone when I am out shopping or whatever. I just finished making my Christmas card list and of course I used Excel. Now I can turn that sheet into my check off list so I can keep track of who I have or haven’t mailed a card to yet, and even add a column for the dates mailed and if I use more than one card I can keep track of which card I send to who.
My kids recently got part time jobs, and trying to keep track of who is working when and who does or doesn’t need a ride is certainly more manageable with their work calendars that I created in Excel. I love it.

Cons

I’ve been using Excel for so many years and they have made some good changes over the years, and being able to add the Spelling checker icon to my Quick Access Toolbar is super helpful, but I do wish it would underline or highlight a misspelled word (like MS Word does) while I’m typing information into Excel before I click on the Spelling checker so I can see if I even need to use it or not. If I have a lot of data sometimes I’ll just copy it all and paste it into Word just so I can quickly see my spelling and/or grammar errors, then I’ll go back to Excel and make the corrects as needed.

Pros

I use Excel to prepare monthly accounting reports. I love CSV files! You can pull all kinds of information from your accounting program into a CSV file, remove any unneeded information for your particular report, edit the content and change the formatting to make your reports look exactly how you want them to fairly quickly.

When you have several columns of numbers, you can put a formula in under the first column you want to add. Then copy that "total" cell and select the following columns that you also want to be totaled and paste it into the "total" row for each column at the same time and it automatically adds and inserts the total for each column.

Cons

The different formulas you can add to an Excel report are great and makes it easy to add totals for certain information; however, it is a little difficult to know the correct formulas and how to input them. I would like to have a reference guide listing various formulas and what they are for - the only lists I have found do not explain what each formula does. There could be a reference guide, but I have not found one yet.

Also, when you need to merge some cells and add text to the resulting cell, it would be nice if the cell height would automatically expand and shrink back down as the contents of the cell changes. I usually have to manually change the height, although not always, so there must be some trick to do that which I have not caught on to yet.

Pros

Microsoft Excel is so deeply ingrained in the world of financial research that at times while considering any other application, it's integration with excel becomes a key determinant of its usability. Excel can be a great fit for almost every type of user - individuals or corporates (whether big and small). It is loaded with features which are impressively intuitive such as pivot tables and data tables and there is no ceiling to the tips/ tricks that can be applied to perform a task more efficiently. The extent of automation possible with the use of VBA/ Python based macros and additionally now with RPA (Robotic process automation) is unbelievable and revolutionary.

Cons

Personally feel that its greatest advantage (being fully loaded) is probably it's biggest folly - The learning curve on excel can be quite steep. It can take a user a while to become an efficient formula builder and even then they can seem quite tedious, messy, and complicated. The program can be buggy at times while handling huge quantities of data and an unexpected crash (if the autosave feature isn't on) can lead to moments of madness with hours of work being lost in a a flash.
Also, the Macbook version isn't anywhere near as user friendly as the one on windows and hence one may lose a lot of functionality on the spreadsheets while sharing them cross platforms.

Pros

Easy to use. From basic to next level functions, you don't have to be a computer whiz to figure it out. If you ever have a question, search the help function. If you want to do something complex and don't want to read help article after help article, just google it. Everyone uses excel, or at least they should, and someone out there has done what you are trying to do. Simple design. I do not need fancy graphics and displays when I am trying to accomplish a task...I just want to get my job done. Excel is a hit for me. Straight and to the point. Capable of so much more than you could ever imagine.

Cons

If there is something missing from Excel, I haven't found it. In fact, I think you would have to be an engineer to find something that excel cannot do for you. It's not going to build you a website and it likely can't do your taxes for you (at least not out of the box); but if data is your world, if organization is your world, and excel can't help you accomplish the task, you probably shouldn't be using a computer at all. ¯\_(ツ)_/¯

Pros

I have been using Excel since the 90's and like how flexible the tool is. I've used it to create planners, budgets, to do lists, loan calculators, calendars, financial reports, reconciliation tools, resumes, contact lists, trip itineraries, financial models, statistical analyses, stock charts and surveys.

I really love how much formatting is possible, the depth of financial functions and the number of online resources to support use of this wonderful tool. Over time, the interface and functionality has got smarter and recent versions of the software seem to anticipate your needs and offer the correct options and functions based on the context of your current actions.

Cons

There is a tendency to use Excel for everything and in some cases a database or dedicated project management tool would be more suitable to the task at hand. I've seen investment companies using Excel to monitor and report on millions of dollars of assets and personally used Excel to manage complex projects where other tools would have been much less manual.

My criticisms may be due to lack of knowledge, but, I really struggled with collaboration and version control when working with an outside organization. We used the same Excel workbook and forwarded this document back and forth with updates. Manually keeping track of the versions and changes became a nightmare. I've also seen situations where you have functions referencing cells in other documents or tabs and the links can be fragile, easily broken - sometimes causing rework and potential errors.

Pros

1. It can quickly produce a relatively standardized form (that is, the vertical lines are aligned).

2. It is very convenient to perform calculations (formulas or functions), statistics (classification and summary, filtering, etc.) on the data in the table, and convert the data in the table into the form of a chart.

3. Only multiple cells can be merged, but one cell cannot be split. This shortcoming brings great inconvenience when making tables.

Therefore, if you only need the appearance of the table under normal circumstances (such as making a personal resume), it is made with Word, but if you often need to calculate and count the data in the table, you should use Excel, although functions and formulas can also be used in Word, they are very troublesome.

I have experienced using Excel and database to manage data. If you want to compare, I think the advantage of Excel lies in its ease of use, while its disadvantage lies in concurrency, capacity, and speed.

The main functions and characteristics of Excel spreadsheet is a kind series of office software, which realizes the data processing of the forms in daily life and work. Through a friendly man-machine interface and easy-to-learn intelligent operation, it enables users to easily have practical, beautiful, and personalized real-time tables. It is a right-hand man in work and life.

Cons

Due to the constraints of Excel's own conditions, the Excel accounting processing system has fewer functions and can only handle some common businesses. It is incapable of handling the complex business of large enterprises. Therefore, it is only suitable for small and medium-sized enterprises. Professional maintenance is more difficult.

Although the source files are open, easy to operate, and convenient to maintain, for some small and medium-sized enterprises and their accounting personnel with weak computer application foundation, there is no maintenance by technical personnel. It is easy to fall into trouble when there is a change. Therefore, the Excel accounting processing system is suitable for small and medium-sized accounting personnel with certain computer application capabilities.

Pros

As a engineering student this spread sheet software is very helpfull to me.Because I am doing many of practicles and researchs in a week. Therefore I have to plot many graphs using analyzed data and using this software it became much easier to me.It can easily insert data to tables and it can do mathematical calculation easily by using this tabled data.It can simply calculate evety data by giving the equation to one data and simply drag it to other datas.When doing many grhaps and table analyzing in the one week it is very time saving option to me in MS Excel. thid is one of my favorite option inthis software.Other favorite option is creating grhaps using this tabaled data.It so simple to make a grahp using data in the tables.There are different types of grhaps and diagrams which can draw using these data in tables.And also I can add this grhaps and tables to my Ms Word documents.I just need to do simply copy and paste the diagram and table to Ms Word.It is very helpfull and time saving to me when I have to add this datas to my course works and assignments.
Thats why I love to work this software this much.In the world lot of people are using this software therefor it became very easy to send my works using this software to other friends without any errors.User experience is outstanding and I recomend to every one to try this software.

Cons

This is very usefull software since from many years.But now so many softwares a developed with more options than Ms Excel.So I don't like to move on these softwares because I need to fit on those softwares and it takes some times.I wish these kind of option will be interdiuse to the Ms Excel soon.In first time I use this software I didn't know any mathematical equation entering methods to calculate data in the tables.Because thre is no grapical input method to add mathematical equations to solve using data in the graph.There for I need to google it on internet.Insted of that I wish it has some button type or any other graphical method to do this calculations easily.It will be very helpfull to new commers to using this software effectively.

Pros

1. it's formula function totally replaced my calculator tool or similar ones.
2. convenient cell operation for formula propagate or serial copying
3. if error occurs in the formula in cell, it is easy to check each step's result to find the root cause.
4. powerful online help for current operation focus as formula, operation, variable change, parameter usage, etc.
5. Macro recording function make dummy user can repeat the operation in huge data.
6. More flexible VBA scripts support make it possible build a easy trigger and running tool software.
7 widely used drawing function make it show more fabulous graphic with text to explain the data.
9, powerful statistic data visualization function make it easy to show the data in many axis

Cons

1. sometime there is interruption and without saving the latest version or recover the latest version in time.
2. free trail is limited time frame.
3. can not get password recovered in the excel file if you lost your password to open it.
4. when frequently processing huge data like more than 1 million rows, the file size will be increase much more, and it is not decrease right after you delete these huge data.
5. auto transfer from outside data source is not efficient, like convert txt data to excel cells, more than 1 million row will cost a lot of time to converting.

Pros

I like The price because It's very cheap when we compare it to the value.
It's a very powerful program and it helps me to create any kind of spreadsheets and use different kinds of formats and formulas.
It's very useful because it allows me to work with my business data and calculate everything by using just simple and basic math (+,-,×,÷).
I like all Excel capabilities and I like everything from the graphs to the stats, forms, lists, functions, autocorrection...etc.
It helped me to stay organized and to have all my data in one place.
I really love all the tips and tricks on how to use Excel to automate some tasks like using it with UiPath for example.
What I like about Excel is I can turn any simple spreadsheet into a multi-function tool to do some sort of difficult task and this allows me to save a lot of time by managing a huge amount of data.
It allows me to do whatever I want with my data and I can see it as a report or as a graph also, I can remove duplicate names, numbers, emails...etc.
I like the user interface because it's very user friendly and even someone with low knowledge of how the software works can create a spreadsheet.
I love their mobile app because it allows me to read, edit, and even create spreadsheets from scratch.
Microsoft Excel support is great and there's a lot of blog posts, Videos, Tutorials everywhere on how to use Excel and how to apply different formulas and create any kind of spreadsheet...etc.

Cons

It really takes some time to be an Excel expert and you need to learn different formulas and there are so many things to learn.
They can improve the Excel app and add more options to it.

Pros

Familiar to many office users
Handles spreadsheet functions very well
Highly customizable
Has relatively easy macro creation for automation of repeated tasks, which allowed me to create a customized spreadsheet application used by school districts in Tennessee
Uses Visual Basic for macros and code creation, and VB is a relatively simple, easy-to-read language

Cons

When it comes to standard use (entering data and running calculations), there's not much to dislike except that Excel costs money if you're an individual or a business. Google Sheets does not, and Sheets added macro recording not long ago.

Neither Excel nor Google Sheets has what I would consider great customer service. I mean, there's a wealth of information online about either which gets you past most obstacles, but there's no one I've found to talk to about issues such as the one described below.

At some point recently, a pop-up message has begun showing up about Excel waiting for another application to complete an OLE request (or something similar). This stops my code in its tracks, and since the point of programming is to eliminate button clicks and manual oversight, it defeats the purpose. Based on my research, I see that the error is even popping up for users who are using Excel with no macros or VB code -- very frustrating, and the "simple" fixes suggested in some places have not worked for me or many others. (The same code triggering this messages still runs well on an older, slower machine. It doesn't make sense that Excel would have problems on a newer, faster PC.)

Pros

The software is well-designed, accurate, precize and transparent. It is easy to manage and offers new opportunities all the time. It is doing its job very well. The application is very useful for me, I use it daily on both PC and Android device. Thanks to OneDrive, where I stop working on one device, I can continue on the other. I can easily work with it anywhere! That's great! It does its job on both Windows and Android. The modern version of Excel with its new built-in tools helps me get more out of my data. Available in all languages. Turn data into useful information. In spreadsheets, Excel is the best solution if you want to record a small amount of data in a variety of ways and look for relationships between them.
Even if you are unfamiliar with using database programs, Excel modules, formulas allow you to create complete databases, join multiple spreadsheets - even to a professional level for a statement, calculation task, and so on. Excel also benefits data miners because Pivot tables are very easy to handle and the Power Pivot module helps them a lot. And Power BI is deeply integrated with Excel, making direct publishing possible. The Help Center is very good, you can work with it step by step. Anyone can become a professional user of Excel with it (like me). I can only recommend.

Cons

Occasionally stops for a few seconds during editing. Many times it does not paste the formulas properly and moves the pasted text elsewhere. Sometimes it can process a 5-page document in 20 minutes. When you open a large file, it removes or does not display the entered formulas. Many times it freezes or crashes during the workflow of large files. Sometimes Excel opens in a different language and I always have to switch to my native language afterwards. Fonts are often confused. Excel cannot open two documents of the same name.

Pros

The industry standard spreadsheet Excel has made my life much easier. I use Excel at least 3 times a day. From organising my daily schedule, budgets, calorie charts to fulfill my academic errands of simple and complex arithmetic functions.
Excel has proved to be user friendly and is being constantly updated. The versatile functionalities of Excel has simplified even the complex tricky day today tasks. I find it very convenient that the information can be represented graphically, especially when being shared. The filter system in which information can be filtered using numerals, keywords comes very much handy during quick reference. The suggestions with keywords has simplified the use of Excel further and I found myself using it more often - not to mention the accuracy.
Excel can be installed in to your PCs, mac and even your android phones.
My life has become much easier with Microsoft Excel and I love it!

Cons

As much as Excel simplifies complex tasks, understanding certain complex functionalites of Excel is a great challenge.
I've messed up big time when it comes to dragging formulas over to a set of data or when copy pasting.
Further printing a spread sheet is very difficult, considering that the cell alignments and margins has to be repeatedly adjusted.
Sharing large Excel files is a challenge, which seems to be a drawback .
Excel should be modified as to being able to reset the password of protected files ; the lack of which is extremely inconvenient.