User Reviews Overview
About Microsoft Excel
Microsoft Excel is a productivity solution that helps businesses of all sizes create spreadsheets to organize data and perform calculations. The platform enables managers to format and present data in charts, graphs, sparklines,...
Learn moreAll Microsoft Excel Reviews Apply filters
Browse Microsoft Excel Reviews
All Microsoft Excel Reviews Apply filters

- Industry: Construction
- Company size: 1,001–5,000 Employees
- Used Daily for 2+ years
-
Review Source
Excel - Cant Imagine a day without Excel
the overall experience with excel cannot be described in one word or in one sentence. I have recommend all my friends to use the excel in their daily routine. Excel is a part of my daily work and it had simplified all my works.
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 SheetReasons 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.
- Industry: Retail
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
Spreadsheet Data Management & Analytics
It is great for simple data and quick data filtering. It can quickly fix issues if you are using it for inventory editing and can come in handy for stand alone projects. If you add a lot of different equations in it or use it for larger data, it can become a pain using it. Since it is program on your computer and not cloud based, it can out perform tasks that competitors would struggle with that are cloud based.
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.
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.- Industry: Animation
- Company size: Self Employed
- Used Weekly for 1+ year
-
Review Source
Efficient and Versatile: A Comprehensive Review of Excel's Essential Features
In my experience using Microsoft Excel, I have found it to be a powerful tool for data management, analysis, and visualization. I appreciate its ease of use and intuitive interface, which has allowed me to quickly learn and master its basic features.One of the things I like most about Excel is its versatility. It can handle a wide range of data types and formats, from simple lists to complex databases, and provides powerful tools for sorting, filtering, and manipulating data. I also appreciate the ability to create charts, graphs, and other visualizations to help me better understand and communicate my data.
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.
Top Microsoft Excel Alternatives
- Industry: Education Management
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
"Efficient and Versatile: A Review of Microsoft Excel"
It is versatile and efficient making it a go-to for organizing, analyzing, and manipulating data. However, as with any software, there may be a learning curve to master its commands and functions. Overall, it is a valuable program that can greatly enhance productivity and decision-making abilities.
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
- Industry: Financial Services
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
Microsoft Excel Review
My overall experience with Microsoft Excel was positive. As a content creator, I found the app to be an essential tool for my work. I appreciated its ability to handle complex data sets and perform various calculations with ease.
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
LibreOfficeReasons for Switching to Microsoft Excel
Simply is just better.- Industry: Retail
- Company size: 5,001–10,000 Employees
- Used Daily for 2+ years
-
Review Source
My go-to spreadsheet.
Excel is my preferred spreadsheet software for daily activity tracking, tax forecasting, and performing various accounting computations that are essential to my job role. Its versatility and familiar interface make it an ideal tool for these tasks, allowing me to efficiently manage and analyze financial data. With Excel, I can easily create dynamic spreadsheets tailored to my specific needs, enabling accurate calculations and providing valuable insights for decision-making.
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.
- Industry: Information Technology & Services
- Company size: 201–500 Employees
- Used Weekly for 1+ year
-
Review Source
The Best Software for Data Analysis and Visualization: Microsoft Excel
My experience with Microsoft Excel has been an incredibly positive one. I've found it to be a powerful tool that can help make data more manageable, easier to understand and even more meaningful. It's user-friendly interface and range of features have helped me create reports quickly and accurately. I'm also able to use formulas and macros to automate repetitive tasks which saves time as well as making my work more efficient. The charts feature is great for creating visuals such as pie charts, bar graphs or scatter plots which helps in making complex data easier to digest at a glance. Overall, its versatility makes it an indispensable part of my workday and I have no doubt that I will continue relying on it in the future!
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.
- Industry: Real Estate
- Company size: 2–10 Employees
- Used Daily for 2+ years
-
Review Source
Microsoft Excel the Total Solution
Microsoft Excel helped my business to solve many problems related to data management, analysis, and presentation: Budgeting and Financial Analysis, Inventory Management, Sales and Marketing Analysis,Project Management, and HR Management.
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.
- Industry: Construction
- Company size: 1,001–5,000 Employees
- Used Daily for 2+ years
-
Review Source
Excellent for Data Base, Document Control and back tracking datas
As employee of construction company it is recommended to use this kind of program, because it really helps in business, in my experience I would like to know more about the excel and learn more about its function, overall in using it for the span of my career excel is very good program
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
- Industry: Civil Engineering
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
Powerful spreadsheet software
I use very often the VBA part of Excel which allows to create invoices and other administrative documents with automatic commands.
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.
- Industry: Management Consulting
- Company size: Self Employed
- Used Daily for 2+ years
-
Review Source
Excel Review
We have created significant analytical databases of contacts, survey results and demand/supply data for clients with Excel. The manipulation of that data is straightforward. The tools within Excel are a standard we use daily in our work.
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 TeamsReasons 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.- Industry: Insurance
- Company size: 1,001–5,000 Employees
- Used Daily for 2+ years
-
Review Source
Easy Office Tool to create Complex Tables and Charts
I typically used Excel to solve the business problem of measuring incremental impact of marketing campaigns - did those campaigns drive incremental or new customer growth or did they sell new food or restaurant products which were not purchased prior to the campaign. Excel allows me to visually show trend in total cases sold by month so I can show to category team and vendors if there was an year-over-year lift in cases of items targeted in campaigns or in the overall category to which those items belong. Excel charts enable easy visualization of incremental customer or product growth by creating charts.
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.
- Industry: Marketing & Advertising
- Company size: 2–10 Employees
- Used Weekly for 2+ years
-
Review Source
Still the champion of spreadsheet software!
My main purpose when using Excel these days is for conveying complex ideas to different stakeholders, whether they are other team members and colleagues, or clients. We prepare our project proposals in Excel, we calculate our advertising and operating budgets in Excel, and we sometimes even use it to build out calculators that help to take complex math around ad spend budgeting and make it into a user-friendly experience (with a little bit of formatting help to make it look nice, of course).
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.
- Industry: Information Technology & Services
- Company size: 501–1,000 Employees
- Used Daily for 2+ years
-
Review Source
Microsoft Excel - Most complete and advance spreadsheet application
My over all experience with the software has been nothing but awesome and wouldn't not trade it for any other spreadsheet application on the market. My main love of the software is the ability to record and or write macros using the VBA editor, on a basic, intermediate and advance level which really streamline my day to day workflow which saves me hundreds of hours on and average.
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.

- Industry: Professional Training & Coaching
- Company size: 51–200 Employees
- Used for 1-5 months
-
Review Source
With Excel you can sort the information easily and quickly, and separate tables and columns
Drawing graphics quickly and easily
Printing facilities being possible to preview the print on screen. You can print vertically and horizontally
Files can be protected with a password for greater security
Manage headers and footers, titles, margins, automatic numbering of pages, automatic insertion of date and time
Allows manipulating information directly, moving or changing size objects
Allows you to see two or more applications on the screen at the same time
Realization of arithmetic operations with formulas
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
- Industry: Real Estate
- Company size: 2–10 Employees
- Used Daily for 2+ years
-
Review Source
The best thing since sliced bread
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.
- Industry: Research
- Company size: 1,001–5,000 Employees
- Used Daily for 2+ years
-
Review Source
The gold standard spreadsheet software for a reason.
With such a versatile software, there are definitely areas of possible improvement. The good side is that Excel is not hampered by these tiny blips; it definitely is possible to work around these limitations and annoyances quite easily. I will say that I find some of the features to be less intuitive than other spreadsheets, but the customization abilities and integration of Excel into popular software modes can't be beat.
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.
- Industry: Financial Services
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
Excel is still relevant
I've used Excel to create countless spreadsheets during the span of my career. It's feature-rich and there is always some new tip or trick to discover. With the inclusion of Visual Basic for Applications under the hood, I've been able to use Excel for automation long before the current wave of business intelligence applications started to hit the market. In addition to it's obvious functionality as a spreadsheet program, the later versions of it feature pretty robust drawing tools which allow for business graphics creations in situations where you don't always have access to dedicated vector drawing software. In addition to my work at the office, I also make extensive use of Excel at home for keeping track of my family's personal finances.
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.
- Industry: Computer Software
- Company size: Self Employed
- Used Daily for 1+ year
-
Review Source
Best spreadsheet software "Microsoft Excel"
Excel has been wonderful to me in view that I first began out the usage of it as a pupil in center school. Since then, I've slowly began out growing my talents with it - functions, pivot tables, electricity query, macros, VBA - and it has paid off immensely for my career. Though I use different programming languages pretty often, Excel compliments them pretty nicely and understanding that 99% of the corporations use Excel, I recognize that it is a software program really well worth making an investment in.
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.
- Industry: Consumer Electronics
- Company size: 5,001–10,000 Employees
- Used Daily for 2+ years
-
Review Source
Business solution with no better alternative
I used Excel as a student, where I carried out basic tasks. I kept using Excel as IT Business Analyst where I extended the amount and type of functions I used. I carried out project management and basic data analyses in Excel. Finally, for the past year or so, I work as data scientist and I sometimes use Excel to carry out data cleaning and inspection on Excel because it's the good old pal I know. Excel is my best tool at work and I totally, even emotionaly love Excel.
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.
- Industry: Information Technology & Services
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
Excel-lent!!
I use Excel every single day! For work-related and personal tasks. Doing my budget there, projections, calculations, data processing, modelling, charting - you name it! So versatile and so useful, worth every penny you pay for it!
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!
- Industry: Health, Wellness & Fitness
- Company size: 201–500 Employees
- Used Weekly for 2+ years
-
Review Source
This Product Has Very Useful and Extensive Capabilities
Elaborating on my favorite features of Excel, the following more specific functions are of tremendous help to me on a regular and ongoing basis:
-The ability to easily sort lists based on any piece of your data, (for example, sorting by last name, by zip code, but dollar amounts, by dates, etc.) On top of that, you can sort by multiple data at once with one click of a button.
-The formulas you can customize and insert into your workbooks are phenomenal. The program essentially does the math for you saving time and effort once you create and insert a formula. These can be very simple or very complex depending on your specific needs.
-The graphs and charts Excel can create based on data you enter into a workbook are wonderful. Often when I create presentations for our board of directors, particularly when reporting on key data, the graphic element these add is incredibly helpful. There are multiple different types of charts and graphs available, and each of those is entirely able to be customized, from font to colors, to data included, and more. Even better, these can be used outside of Excel once created. They are easily copied and pasted into Word, PowerPoint, etc. to suit your needs as well, which I also do pretty frequently.
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.
- Industry: Information Technology & Services
- Company size: 2–10 Employees
- Used Daily for 2+ years
-
Review Source
Excel help my working efficiency
Most time in regular using excel is very good in hand. And it is compatible with all other Microsoft family software, so it's output data can be directly used in other related software tools, like chart, grids, files and data sources.
For usually using excel tool is enough for different users in many fields, such as student, science researching, accounting, financial calculation, engineering data analysis or event programmer developing software on it.
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.
- Industry: Information Technology & Services
- Company size: Self Employed
- Used Daily for 2+ years
-
Review Source
Excel is still king, but....
I used Excel to save me countless hours when I was a student data manager for a Tennessee school district. Being able to record or write macros so that tasks are automated -- that's priceless, and I'm grateful for Excel's role in that.
As I said, I've created an application using Excel that is used by some school districts in Tennessee to save work hours (in some cases, shrinking time spent from 5 hours or more to 5 minutes). I've been able to carve out a small business doing so.
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.)
- Industry: Religious Institutions
- Company size: 2–10 Employees
- Used Weekly for 2+ years
-
Review Source
Spreadsheets with Power
Excel has been my go to for financial statement preparation (as an accountant). I have used it for the accumulation of tax data and preparation of tax forms. At one point, I programmed Excel spreadsheets to do many of its own functions for these very forms. Today, I continue to use Excel as a way to track data for the church I serve. I use it for time tracking, information gathering and formatting, and to track the data I maintain of people and thing in the church.
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.