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

This software is a company standard use for a lot of other programs. It can filter data, create .csv files for upload and download of data, and handles equations to help with data analytics. There are a lot of guides on this program online if you are struggling with a problem and there are plugins that you can use to help make your job faster. Many companies have this as a standard so sending files to others is usually not a problem.

Cons

It is not meant to be used as a database for large data. It can lag out after you get to 60K lines of data. The biggest issue I have with this program is that it likes to convert large number text to scientific notation and you have to constantly do workarounds to prevent it from happening. It has some minor glitches if you have too many different files open at the same time. It is not the greatest with group collaboration because the files are meant to be used as one user at a time. You have to also manually save your files from time to time as you are working. Although you can often times get your file back if it wasn't saved and the program shuts off, it still is a practice you have to get into a habit of doing.

Alternatives Considered

Airtable and Microsoft 365

Reasons for Switching to Microsoft Excel

Excel has a longer standing in managing data through sheets. Often times, I would switch between Google Sheets for other projects that require group collaboration. The fact that it is not cloud based and some other program integrations require it makes it difficult to fully get rid of.

Pros

Excel's versatility and functionality to be its strongest features. Its ability to handle large amounts of data, provide powerful analysis and calculation tools, and support a wide range of file formats and data sources make it a valuable tool for many different industries and applications. Additionally, Excel's ease of use and familiarity make it a popular choice for users of all levels of expertise.

Cons

Excel has a steep learning curve, particularly when it comes to more advanced features such as macros and pivot tables. Additionally, Excel can be resource-intensive, particularly when working with large datasets or complex formulas, which may require a powerful computer to run smoothly.

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

What I liked most about Microsoft Excel was its ability to handle complex data sets and perform various calculations with ease. The app's range of functions and formulas made it a powerful tool for organizing and analyzing data. Additionally, I appreciated the app's ability to create visually appealing charts and graphs to display the data.

Cons

One thing that I liked least about Microsoft Excel was its steep learning curve, particularly when it came to using advanced functions and formulas. While the app was user-friendly for basic tasks, it could be overwhelming and confusing for more complex data analysis tasks. Additionally, the app's interface could be cluttered and difficult to navigate at times.

Alternatives Considered

LibreOffice

Reasons for Switching to Microsoft Excel

Simply is just better.

Pros

As an accountant, there are several aspects of Microsoft Excel that I greatly appreciate. Firstly, the extensive online communities available for Excel provide a wealth of knowledge and solutions for almost any problem or challenge I may encounter.Secondly, the ability to protect and encrypt data within Excel ensures the security and confidentiality of sensitive financial information, which is a top priority for me.Excel's macros feature is another favorite of mine, as it allows me to automate repetitive tasks, saving valuable time and increasing efficiency in my work.

Cons

While Microsoft Excel offers numerous advantages, there are a few drawbacks that are worth mentioning. Handling large data models in Excel can sometimes result in noticeable slowness, which can be a drawback when working with extensive datasets. Similarly, complex formulas can also slow down the performance of Excel, affecting the speed and responsiveness of calculations.

Pros

1) Easy To Use: Excel’s user interface is intuitive and user friendly, making it easy for people new to spreadsheets learn quickly how to use the program's features. 2) Flexibility: With its vast array of features like formulas, sorting capabilities, pivot tables etc., users are able to customize their spreadsheets however they want. 3) Comprehensive Data Analysis Tools: Excel includes comprehensive tools for analyzing large datasets quickly and easily such as trendlines , filters etc . 4) Visualization Capabilities : Charts in Excel allow you visualize your data so that patterns can be identified more quickly than if all were presented in plain text format . 5 ) Macro Feature : This feature enables users to automate tasks so that workflows become faster and more efficient .

Cons

Excel is a popular and powerful spreadsheet application that allows users to create charts, tables and graphs. Excel has a wide range of features, including complex calculations and data analysis tools.

Pros

Excel is widely used and supported by many platforms, including Windows, Mac, and mobile devices. This makes it easy to access and share spreadsheets with others regardless of the device they are using. This tool allows multiple users to work on the same document simultaneously. This feature is useful for teams working on a project or when multiple people need to access and update the same data.

Cons

Excel offers basic data visualization options but may not be as robust as other data visualization tools. Sometimes I need to export data to other software for more advanced visualization options.

Pros

Excel is mostly used in many organization because of it's function , it helps to maximize views in every areas of datas. In operation of business excel is really important because records of quantity , details, logs and etc. these are the important things to be recorded and excel is very good at that.

Cons

some functions are hard to understand but can be learn, always room for improvement

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

There is nothing to dislike about Excel - it is the standard for data creation and manipulation. The best features are its easy functionalities via simply clicking on icons in the header (ribbon display) and efficiently creating equations in the cells/rows. Copy/paste, insert columns and automatic population of rows with either mathematical formulas or counts is so helpful and efficient.

Cons

Sometimes the Search function doesn't return the best results. I'd also like to see a function where right-clicking on the workbook name (located at the top of the display header while the workbook is open) enables copying the filename with its file path so as to send a link to someone wither in an email or other method.

Alternatives Considered

Evernote Teams

Reasons for Switching to Microsoft Excel

I have been using Excel since it came out (in the 1980's?) and swear by its usefulness. Years ago, I decided to figure out how to use it to manage data and create strong analyses, rather than be a repository for simple math calculations. It has evolved over time to be the gold standard for data capture, manipulation and analysis.

Pros

Microsoft Excel allows me to import thousands of rows of marketing data from web analytics software. I can then analyze it to see success metrics such as trend in year-over-year growth in new customers, cases sold, merchandising category such as grocery, etc. This analysis can be done by creating column or bar charts which show both a spike and lift in traffic or conversions during periods when the marketing campaigns ran. So, I can quickly correlate the lift or drop in performance to when the marketing campaigns started and when they ended. I can also use advanced analytics functions such as vLookup or pivot charts to associate email addresses to those customers who didn't purchase so my marketing team can run re-targeting campaigns against them. Or, deduplicate function to remove duplicates and extract a unique set of customer ids and names so I can run business intelligence reports against them.

Cons

Microsoft Excel uses significant ram of a computer when number of rows being analyzes is in thousands. Or, if multiple files of Excel are open simultaneously. In such scenarios, Excel crashes and all open files close. It has to be restarted and not all changes are saved in backup versions of the files. Unless Excel being used is part of the cloud version of Microsoft Office also called Office 360. Similar challenges are faced when using advanced analysis functions like vLookup. When using vLookup against thousands of rows and multiple columns, Excel hogs more ram and slows down cpu so whole system freezes.

Pros

I often need to do financial projections as part of my work, as well as organizing lists, information about different events that are being organized, structuring new projects that are being undertaken, and various other calculations that just need to happen in the course of my business, on a day-to-day basis. In other words, its fair to say that I basically "live" in Excel. The thing I love most about this tool is just how much you can do with it, when you take the time to really understand how to use it. Excel is simple enough to use as a place to keep a list of people who are coming to an event organized, and complex enough basically act like a mini database. The flexibility to use a single tool in so many different ways is one of my favorite things about this software.

Cons

Even though I've used this software for many many years, probably a decade or more, and most people regard me as an expert in it, there's still functions and applications of it that I haven't yet mastered. There's so much going on under the hood that it's next to impossible to know absolutely every single function that this piece of software can accomplish for you. Which means that if I'm trying to do something a little bit more complex than my usual activities, and I need to stretch my own limits on what I know how to do with the software, I can often lose an hour or two hunting for how-to guides and videos on the internet to make sure that I get the result I really want. However, once I get it, I've just added another tool to my toolbox that continues to make the software even more powerful. So, all in all, even that is time well spent, in my opinion.

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

Use the conditional format

Excel users can format their spreadsheets using different color tones, bold and italic, to differentiate between the columns and bring the most important data to the front. This function can be useful in the presentation of accounting information, such as the benefit before taxes and the balance that will be transferred by the company. Users can select an appropriate color scheme using the quick analysis button, and then by using the Format tab.

Help identify trends

When presenting the data in the form of tables or graphs, it may be useful to include middle lines, which explicitly detail the key trends that emerge from the information. This can help demonstrate key points to other users in a direct way - for example, an executive from a different department during a board meeting. Excel allows trend lines to extend beyond the graph, to provide predictions of activity in the future - and such forecasts can help companies develop their future strategy.

Collect data

Excel can be used to carry information from different files and documents together, so it exists in one place. As well as raw data and information from other spreadsheets, it is possible to import text and images. Other objects can be added using the Insert tab, spreadsheets or they can be added to the file.

Cons

Disadvantages of Excel
Some people consider graphics insufficient or of poor quality
It is a payment program that does not have an affordable price available to everyone
It is a program unable to handle dates before 1990
Information may be lost when the application is divided into too many files
Files take up a lot of space
Viruses can be attached to an Excel file through macros
It is not an application of which one can be self-taught, but in general courses are needed to be able to get the necessary party
It is not useful at the domestic level
Does not work to be customized with financial subsets
Each operation must be entered manually
It requires, for your needs, a powerful computer and in good condition
Only compatible with Windows and Mac
It usually presents unexpected errors that cause the program to close abruptly and unrecoverable data is lost

Pros

I remember once, many years ago I had a teacher saying that Excel was originally created to augment and support another spreadsheet program. However by the time they finished developing the original version it far out-shined the program it was meant to support. So much so that the other software was dropped entirely in favor of Excel. I don't know how factual this recounting is, but it wouldn't surprise me if it is true.

Excel rocks. I use it all the time for my business. Yes I also have Quick Books and other accounting software. But nothing beats a good ol spreadsheet. I can put all of my numbers in and edit them with an endless amount of formulas.

It is truly mind-boggling the depth of the program too. Sure it can auto-sum columns and sort data by the 3rd letter of someone's name, but it can do much much much more. I once created a program inside of excel to aid in the scanning of bar codes. We had a bar code scanner that would simply dump all scanned data into a single column in excel. Using the built in scripting I created a button that (after dumping the data in) would auto sort the data into it's necessary column and prep the sheet for printing and signatures. Not only that but I set it so that at the push of a button the end user could create the next week, month, or even yearly document at the press of a button.

Also, using O365 you can have multiple people editing the same document simultaneously. This is Huge! No more editing copies of copies.

Cons

I really can't think of any. I suppose how fun it is. I've wasted many many hours creating complex spreadsheets for my simple budget merely because I wanted too.

Pros

This is a must have spreadsheet software; it's used everywhere for a reason. From making simple charts to making sortable lists, everyone from temporary summer students at the office all the way to the IT department all use Excel for their various needs. The built in functions allow for basic "automation" of different calculations so that you don't have to do it by hand. More advanced users can design macros in VB to integrate advanced functions and forms into the spreadsheet. It also copies and pastes into different Microsoft applications like powerpoint and word for seamless coordination between programs.

Cons

There are so many different functions that it can be overwhelming to orient someone at first. However, it is easy to use the simple functions of the software immediately; it's just the advanced functions that take time. The problem that I always have is resizing rows or columns - you can input a numerical size, but it means absolutely nothing - I don't know what the units are, whether it's pixels, or just some arbitrary size. Additionally, the automatic formatting is awful, especially when it comes to inputting ratios in the format X:X. Excel converts them to completely unreadable jibberish, and even when I reformat the cells to be text, the next person I send it to often has the same issue - they'll see jibberish like 010542349080398 instead of the ratio that was input.

Pros

As a financial analyst with 15 years experience, I've been using Microsoft Excel for quite some time. With all the new business intelligence software out there, some may be of the opinion that Excel is becoming obsolete. I would argue that is still has it's place in a today's analyst's toolbox. In our office we have utilized some of the fancier tools like Alteryx or Tableau to wrangle/present data but Excel still remains a major part of our regular processes. Excel offers tremendous flexibility in summarizing, analyzing and presenting data for whatever the deliverable calls for. It also acts as an excellent scratch pad for ad-hoc analysis via filters or pivot tables. What I like most about Excel is the fact that you can directly manipulate your data in an intuitive manner without the need for knowledge of programming or scripting languages. Bottom line, if you are an analyst, spreadsheets will always be part of your world and Excel is the industry standard.

Cons

It's honestly difficult to think of anything that I don't like about Excel as it has served me well for more than a decade and a half in my professional life. I suppose like any other software it can at times be slow to respond when your files get to large. Probably the thing I like least about it is the tendency to get corrupted when too many formatting options are used in a single workbook and/or the tendency to not always allow you to make a clean break when you want to remove a link to another file that another user has created. Other than that, it's pretty solid.

Pros

1.Multiple worksheets.

2.Easy to "program"

3.Can hyperlink among worksheets in identical record or different documents.

4.Has respectable graphics, graphs, charts, etc. to reveal your information.

5.Table feature permits you to clear out out information conveniently.

6.Great for calculations.

7.Almost anybody can use Excel.

Excel is likewise very beneficial equipment for simple graphs and charting and in case you need to take analytics to a pro-degree then it helps integration with superior analytics equipment inclusive of Power BI. Autosave characteristic and excel subscription as part of Office 365 let you shop your excel documents at the cloud which may be accessed everywhere the use of net connectivity.

Cons

1.It isn't intended for enhancing huge portions of data.

2.It isn't intended for storing huge portions of data.

3.It isn't a database.

4.It may be hard to show the equation for an extended feature in addition to severa cells that the equation is relating to if the worksheet is huge.

5.It could be very functional, however occasionally you want a database.

There isn't anyt any alternatives to have a cloud primarily based totally Excel spreadsheet. If there were, I am quite positive maximum organizations might ditch their cutting-edge software program and stay with Excel. Our commercial enterprise has more than one bodily stores, so being capable of proportion to report among all stores for them to collaborate might be ideal.

Pros

The ease of use, amount of functions, possibility of things can be done, writing functions within functions, giving link to cells between sheets and other Excel files.
It's almost possible to create a database-like structure using VOOKUPs, HLOOKUPs, which result in "Join"s.
Functions have not only basic operations such as sums, dot products, but also return statistical parameters too. For instance, one time I needed the slope of an array (I actually work as a data scientist and use Excel, too) and there was a function for this. All I need to do was to point out the array and Excel fits a linear regression in background, giving me the slope of it as I needed.
Not only that but availability of VBA extends the functions of Excel even furthermore. For that reason I cannot imagine anything Excel cannot do that one would be able to do on paper and pen.

Cons

As I explained above, I work as a data scientist and I sometimes deal with huge amount of data "BIG DATA". As much as I love working on Excel, unfortunately Excel sometimes cannot handle big data, especiaily if there are millions of rows. That's the only downside of Excel I can think of.

Pros

I think the best part is the fact that the spreadsheet is like one giant calculator! Invaluable in today's times when you need to be able to get things done on the go!

There is the auto-sum function which sums all cells in a row/column/custom range, which I use for my budgeting. I have also used their financial functions a lot, to calculate my debt and mortgage repayments. They still have a myriad more functions to explore!

You can format and style your spreadsheets and print them out very neatly. Excel can work with CSV files which are often the raw data output for many software, so data processing tools are at hand. And finally, to top it all, any data can be plotted in over a dozen different ways and visually represented for either your perusal or a business presentation.

This is a fantastic piece of software and definitely my most favourite out of the whole MS Office software bundle.

Cons

There is one massive minus to Excel - which had been there for ages. You can't scroll sideways while holding down the Shift key, as in all other programs. This is so unfortunate since Excel's columns can be far-reaching to the right very often, and so while vertical scrolling works, for horizontal scrolling one still needs to use the old-fashioned "drag and drop the scroll bar". I hope the devs of Excel will read this and fix it soon - to make the experience perfect!

Pros

Microsoft Excel is truly amazing. I have used it for SO many things including the following:
-Creating simple lists or databases
-Utilizing more complex rules and formulas within my data
-Creating a TON of different type of charts and graphs for data analysis and reporting
These are definitely my top three favorite features and capabilities, and those that I use most frequently. In addition, everything can be customized to meet your needs and preferences in Excel as well. Fonts can be changed in size/type/color/style, cells can be highlighted, and charts and graphs can be customized in these same ways as well.

Cons

There is nothing I dislike about Excel, but I know that its capabilities are far beyond my knowledge and ability. It can seem complicated, but once you learn how to utilize all of its features, it can truly be an asset in so many ways. A personal goal of mine is to get some more training in that area so that I can take advantage of this software's capabilities to the full extent.

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

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

I would consider myself to be a professional Excel user. I have been using Excel for more than 20 years and I cannot see using any other type of spreadsheet software. I started with Lotus (a predecessor of Excel) and have not looked back when Excel became the software to use. I am also one of those people who takes to using new technology relatively quickly. Excel provides so much in the way of capability that there are some aspects of Excel that I am not familiar with, even though I am no longer a daily user. The help function (the question mark in a box) is very user friendly and there are also many help topics that reside within the software. If you are asking a really tough or programming question, there are also online forums for those who would be considered power users. For those who are simply in need of a place to gather information and make some simple calculations, I also would not look any further than Excel. With the Microsoft 365 subscription, you get all of the most recent updates and functionality without the high price of buying the software license each time the software gets an upgrade.

Cons

The only con would be if you purchase the full license. When you subscribe through Office 365, you get all the latest updates without having to purchase a new license each time. If you are not familiar with spreadsheets, Excel's functions and tool bars can be a bit daunting to look at. But, if you take some time and familiarize yourself with them, they are quite logical in their layout and functions. You can also customize the toolbar to include the functions you need the most. It just takes a little time to do so.