Microsoft Excel
About Microsoft Excel
Microsoft Excel pricing
Microsoft Excel has a free version and does not offer a free trial. Microsoft Excel paid version starts at US$6.00/month.
Alternatives to Microsoft Excel
Microsoft Excel Reviews
Feature rating
All Microsoft Excel Reviews
- Industry: Design
- Company size: Self Employed
- Used Daily for 2+ years
-
Review Source
Comes on many computers and is Fantastic especially if included.
I have used Excel for over 20 years and I have not even scratched the surface of what can be done with it. It can do so many things when you need to make calculations, spreadsheets or do something with accounting. I love it and really for me a numbers guy I think it is fun.
Pros
It is so versatile. I use it instead of Calculator as I can easily see what I am calculating. I have made a simple payroll system with it and have used it for many weekly tax calculations. Calculating using fields from other pages is fantastic. Really anything you need to do with accounting can be done with it.
Cons
Two things if you don't have it free with your computer then you have to buy it and it can be kind of expensive and if you want to be able to collaborate and make on the fly changes with others then you need office 365 and you have to pay monthly you can never own it.
Alternatives Considered
LibreOfficeReasons for Choosing Microsoft Excel
While LibreOffice is the best option for free and that is a software for your computer, my wife ended up getting Microsoft office 365 free from work because of remote work so this is the main reason I have gone to excel as it is a little better and I didn't have to pay for it.Switched From
LibreOfficeReasons for Switching to Microsoft Excel
I do still use google sheets for mine and my wife's budget and we can change it on the fly at the same time if we need online. I used LibreOffice as my main until I got Office 365 from my wife's work. I think Excel is better than the other two in sheer offline and spreadsheet features but not sure I would pay more than about $50 for office 2019 and don't like paying monthly for 365.- Industry: Education Management
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
The Go-To is still the most capable
I enjoy using and learning more about Excel. There are so many ways in which to use it that no review can truly capture the breadth and depth of its capability. When it is frustrating it is because of an inability of process or lack of me as a user being able to achieve what i know to be possible and thus I approach it as a puzzle to be unpacked.
Pros
Excel is a versatile spreadsheet application that continues to benefit from its age, the weight and momentum behind it, and the continued focus on it as core Office app. The variety of applications of this application are what continue make it a winner.
Cons
Stemming from the same positive attributes of its age and flexibility are the downsides to its age and flexibility - its overlapping years of feature additions and subtractions to the building more on top of pre-existing structures mean that somethings need to be unpacked in order to work how you'd like them too and the robustness of the product can be daunting. Knowing that you'll never know ALL that it is capable of and that the best way to achieve anything is to picture it and then hunker down for an evening of searching and learning.
- Industry: Accounting
- Company size: 11–50 Employees
- Used Weekly for 2+ years
-
Review Source
Versatile and Essential, But Requires Practice for Advanced Features
Excel is a very useful program that can be applied in many areas of everyday life. However, some of the more advanced features, like pivot tables and complex formulas, can be tricky to master without consistent use. Overall, Excel is a highly versatile product with great functionality.
Pros
Excel makes it easy to create tables, and especially when it comes to financial matters, it's convenient for creating visually clear data. In a typical household, it seems to be useful for organizing and easily looking up records of living expenses.
Cons
To make the most of Excel tables, you need to set up formulas, but if you don't use it frequently, it can be hard to remember how to do it.
- Industry: Education Management
- Company size: 2–10 Employees
- Used Weekly for 2+ years
-
Review Source
I would rather use Numbers for anything and everything.
I have been in educational leadership for over 25 years. For all of that time I have had to run budgets, strategize enrollment projections and much, much more. For the vast majority of that time I had to utilize Excel. It was the go to vehicle for each and everyone of my treasures and book keepers to keep track of our financials. Even when I was setting up documentation on my own, I always turned to excel. However, as an educator with no accounting training I always had to turn to an expert to set up my formulas and interwoven sheets. I knew what I needed them to do, knew that Excel could function that way, but making that happen was well beyond me. It was always very frustrating. After many years I founded my own program and suddenly had no one else to turn to to arrange my tracking systems. I was stuck. I had to figure it out. Or did I? Because I am a Mac user and as I was struggling to set my Excel sheets up, I suddenly and excitedly stumbled upon Numbers. I must say, while Excel can do whatever you want it to, Numbers can do it better, with more intuitive functions. I imagine for an accountant there may be more to this picture, but for a lay user who depends of ease of use, clarity of function and ultimate success, I am happy to leave Excel in my tool bar while I create my budgets, rosters, calendars and more on Numbers.
Pros
For decades Excel was the only way to go. Its ability to utilize formulas to create the documentation we needed was invaluable.
Cons
It is clunky and hard to intuit for novice users. I have always had to impose upon other users to set my sheets up to do what I wanted to do.
- Industry: Broadcast Media
- Company size: 2–10 Employees
- Used Daily for 2+ years
-
Review Source
The Standard Spreadsheet, But Needs to Change with the Time
Microsoft Excel is a great product that is limited by accessibility.
Pros
I love spreadsheets and Microsoft Excel set the standard for spreadsheets.
Cons
While I have used Microsoft Excel for years, they have not kept up with the changing landscape of team work on the cloud. I need my spreadsheets to be fully accessible in real time by my whole team.
- Industry: Consumer Goods
- Company size: 501–1,000 Employees
- Used Daily for 2+ years
-
Review Source
Best office product
Very easy and has a lot of shortcuts to get things done fast
Pros
Very organised way to handle detailed information
Cons
Can glitch sometimes but usually works fine
- Industry: Financial Services
- Company size: 51–200 Employees
- Used Daily for 1+ year
-
Review Source
Incredible Excel
Amazing powerful tool for any accounting recording or research use.
Pros
Formulas, Pivot tables. Very useful for accounting purposes
Cons
Very complex, the tutorials aren't as helpful and you might need a whole class to under the uses.
- Industry: Automotive
- Company size: 51–200 Employees
- Used Weekly for 1+ year
-
Review Source
Foundation of data handling.
Microsoft Excel helps us complete tasks in a systematic way,create reports and analysis.
Pros
It helps us create a dataset which is technically a spreadsheet.It is the easiest tools which we use to create complex spreadsheets.I like the various functionalities like pivot charts,tables and graphs which are really top notch and features which help reduce the manual intervention.
Cons
There is nothing to dislike about it as it is an important software to manage things and data.
- Industry: Commercial Real Estate
- Company size: 2–10 Employees
- Used Daily for 6-12 months
-
Review Source
First time using excel
Very good, makes my work easier, i recommend
Pros
Easy to use, quick to learn, was hard at first but once i understood the basics, it was easy
Cons
Complicated at first, I almost left it but you just have to put more effort when learning
- Industry: Hospital & Health Care
- Company size: 11–50 Employees
- Used Weekly for 2+ years
-
Review Source
Necessary for Business
I use Excel with the entire Microsoft 365 Suite, including SharePoint and Outlook.
Pros
Being abke to track expenses easily with quick formulas and copy paste.
Cons
The amount of time it takes for a workbook to open.
- Industry: Financial Services
- Company size: 1,001–5,000 Employees
- Used Daily for 2+ years
-
Review Source
Great product if you have the time to fully invest in becoming knowledgeable
Absolutely love it! Trying to do my job without this product at my disposal would be an absolute nightmare.
Pros
Excel is a product that we frequently joke about being a “black hole of possibilities.” I’ve found that if I ever think “wouldn’t it be great if you could do XYZ in excel” that it’s probably something that CAN be done. You just have to go through the process of searching and finding out how to do it. We use Excel constantly and so much of our day to day tasks are done within Excel because it’s just the best way to keep track or to analyze data. I don’t know what we would do without such a product at our disposal.
Cons
I don’t know if it can actually be labeled as a con, but when using Excel outside of just needing a few columns here or there or to do basic calculations, it can be difficult to just figure out how to accomplish a needed function. It really is necessary to devote significant time to delving into the functions within the product and to become knowledgeable about the product and it’s many possible functions.
- Industry: Computer Software
- Company size: 2–10 Employees
- Used Weekly for 2+ years
-
Review Source
More useful than the competition
I use excel for many things, from simple financial controls to task lists, everything I don't need to synchronize with teams becomes an excel spreadsheet. We also exchange files frequently with customers, where even more advanced formulas and graphics are implemented. Due to compatibility with other formats, and the undeniable ease of the interface, it is still my main spreadsheet tool. I end up paying Office 365 just because of Excel, as it pays off in productivity. I also like the model library, it helps when starting something fast.
Pros
I love the versatility, look and ergonomics of Excel. The wide formulas and small assistance tools, which make it unnecessary to do certain things manually. Example, if you copy / paste / move formulas and references, it almost always manages to adjust and correct.
Cons
In years of excel the most terrible thing that ever and continues to have is poor support for CSV files. In LibreOffice, for example, when opening a CSV, it tries to detect the conventions and display for you to confirm. Excel has a persistent bug with this, and it almost never manages to open CSV correctly (regardless of whether you use a semicolon, comma or other), the best way to use this is to open CSV in LibreOffice, copy and paste in Excel , which is very annoying. At the office level, it is also bad to be forced to install all the applications in the package, even if you only want excel and a few others.
Reasons for Choosing Microsoft Excel
Before I used only LibreOffice, but it is visually ugly, it ends up being boring for you to spend hours a day dealing with spreadsheets in an old-fashioned and less productive environment. Libre has its qualities, that's why I never give up, but Excel allows me to do so many more things, and in a much faster way, that I found myself returning to Excel two years after trying to use only Libre, and even today I keep both. If you need to come up with something attractive to show your client it was also something I had in mind when I return to pay for Office, years ago.Switched From
LibreOfficeReasons for Switching to Microsoft Excel
When Excel became expensive, in the last economic crisis, I did several experiments with other spreadsheets, including Google Sheets, which is part of my Gmail, and free alternatives. The test results showed that Excel is superior in several aspects: visual, facilities, productivity accelerators. G-Sheets is good, I still use them in the G-suite, but it is very limited, everything has to be done manually, and formatting is a drag. Excel has everything ready, it's half the way to deliver something final, and it rarely breaks formulas. The free alternatives clearly seem to have stopped in time and not have many innovations, so as I am in this job to make money, I thought it was worth spending a little to deliver value to the customer. Since 2015 I use Excel for professional work for productivity, Google Sheets for ease with the G-suite and for quick things and LibreOffice for the added tools of CSV and native support for the open document format.- Industry: Financial Services
- Company size: Self Employed
- Used Daily for 2+ years
-
Review Source
Almost essential
I use Excel each day in my business and in my own life and I have been utilizing it throughout recent years and I never had any issue and the best thing is it's an across the board apparatus and no compelling reason to utilize different devices like 2 or 3 devices to complete the work.
Pros
Excel is my go-to application for everything from straightforward data sets to more intricate revealing and dashboards. The most significant part of Microsoft Excel is that when I use it consistently for accounting page angles in my business. I love that it is simple and easy to understand in helping me with assembling my rotate tables. I can use the lines and sections effectively where it is not difficult to put any information data effortlessly in a solitary sheet. The wide range of functions it offers might be frustrating at first. However, once you get the hang of it, it becomes one of the most useful software in your life.
Cons
You cannot recover the password for a file once you have lost it. You can't work together (in a group climate) which you can do in Google Sheets. It very well might be difficult to show the condition for an all-encompassing component notwithstanding a few cells that the condition is identifying with if the worksheet is immense.
- Industry: Civil Engineering
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
the god of spreadsheeds softwares
I use Excel since the 90's. And as an engineer it is a vital tool for me, so much that I no longer only use it for my work, but I have created spreadsheets even to keep track of what is in my cupboard. Honestly, for me it is already natural to use Excel for any calculation of my daily life.
Pros
I think I know Microsoft excel since I had my first computer in the 90's and since then it has been my favorite spreadsheet program. It has definitely evolved and improved over the years and now it has millions of functions that it did not have in the 90's and that make Excel the god of spreadsheets. Obviously you can do mathematical calculations associating cells, but it goes much further. You can generate charts of different formats from data from the spreadsheet, do complex calculations and format the sheet to improve its appearance, associate tables to documents or external links and print spreadsheets directly from Excel. It can be a bit overwhelming the first time you face it, but once familiar with the software, it becomes very easy and intuitive. In addition, the office help platform is great and has everything you need to take advantage of all the Excel functionalities to create maybe just a calendar to the organized calculation of your expenses and your monthly budget and the best thing is that you don't have to create the spreadsheet from scratch, because you can look for predesigned formats created by Office to enter up your monthly expenses, the programming of your daily activities, a record of attendances, a list of guests and more ...
Cons
I think it is still very difficult to format a spreadsheet to go from the computer to the paper. I would like them to improve the printing process, since many times I have had to print a document over and over again and modify the sizes of the cells in a trial and error process to achieve a finished product that is pleasant once printed.
- Industry: Arts & Crafts
- Company size: 2–10 Employees
- Used Daily for 2+ years
-
Review Source
A business must have!
I have used Excel for business, home and small home business. I started using Excel many years ago with no computer experience and taught myself mostly. I started using it to keep track of data and parts usage in automotive productions. I started simply and grew from there.
Next I started using it to create and track part testing schedules. I was easily able to create the test parameters, details of these tests, add schematic and print information, dates, machine information, production lines, schedules, reports and file all completed tests and results as well as share these with engineers and customers.
The ability to attach photos to these reports is a huge bonus.
My next feature I learned with Pivot Tables and this opened a whole new arena of possibilities. I gathered all production line data and entered it into line items such as Production line, products coming off this line, counts, scrap, maintenance issues, costs, personnel and down time. This was them accessible in a pivot table I could manipulate to see where the cost where coming from, downtime issue and ways to cut costs and streamline production and maintenance. By simply clicking on which data I wanted to see, in an instant the data changed.
From here I could transfer this data into charts for management to use at a glance.
Pros
Easily store any and all data, information, photos, contacts... the use is endless. I believe I had only scratched the surface in Excel. The more I used it and explored its capabilities the more excited I got about how I could use it.
It uses as it applies to large and small businesses is never ending. You can use it for home business and personal storage of information as well. My Grand kids even started to use it at age 5, obviously not for business but they taught themselves how to use it, PowerPoint and Word.
Cons
I think the only issue I ever had was with updates. For personal use it is pricey when you need to update to the newest version, I suppose in the scheme of things and for its many uses its not that expensive though. Again for personal use when working or sharing with others the various versions can create some issues but they have gotten better about making sure each updated version can transfer data from the older versions Its only an problem when the person using the older version needs data thats on the newer version.
As far as learning in Excel, there are so many books, tutorials and videos you can usually find what you need but there is also so many features in Excel I was only frustrated by wanting to know it all now rather than later.
- Industry: Computer Software
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
Excel - formatting and analyzing data more effectively and efficiently
Excel has emerged as one of the main data analyzing tools used in day to day life . With its facilities to store large amount of data, format data according to the users preferences, depicting patterns and analyzed information thorough graphs and charts it has become more and more popular among the users.
Pros
Excel is an application which can be used to store large amount of data and organize them. Data entered to a excel sheet can be organized according to the user preferences easily with all the facilities supplied by the product itself. Users can organize the data in ascending or descending order very easily and filter the data and group them under particular name .Excel provide wide variety of data representation techniques . different types of graphs , scatter plots helps to analyze the data more effectively and efficiently .Also the product provides function which helps to deo automatic calculations easily. Users don’t need to make the calculations from one point to another . Al they have to do is apply the formula for all the relevant places.
Cons
When there is a large set of data to be applied it is bit difficult to enter all the data using Excel. As there is no any error checking mechanism to detect human errors in the process of data entering .Also entering large amount of data manually consumes a big amount of time which results in loss of productivity. The product is not for free. Whatever may be the advantages or disadvantages of the product in order to use Excel users have to make a payment and acquire a licensed copy of the product .For a beginner to Excel may need some time to be compatible with the product as the product is not very much user friendly . It is little bit difficult to operate with out proper guidance or practice
- 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.
- Industry: Religious Institutions
- Company size: 201–500 Employees
- Used Daily for 2+ years
-
Review Source
Excel Review
This program is great for making budgets, payroll, forecasts, reports, statements, calculators, inventory programs, but it is also a great tool for graphically displaying the research part of a thesis. Using functions and formulas, it also enables you to perform financial calculations and mathematical tasks. A particular company can solve its organizational and operational problems wit Excel, too. The time spent on a task can be greatly reduced by the program.
Excel is excellent for both private, professional and business use, too. Very good. I can only recommend it to everyone!
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.
- Industry: E-Learning
- Company size: 501–1,000 Employees
- Used Daily for 2+ years
-
Review Source
MS Excel
I love Excel. I’m not as good at using the complex mathematical functions as some users who are in the accounting profession, but I do alright. I showed a co-worker the other day how to use the Goal Seek function and she loves it and it saved her a tom of time trying to figure out their enrollment target. I recently taught myself how to create Macros to help me save time and I did it by watching an online video, and it was fairly easy. My boss was so impressed she wants me to teach others in our office how to create their own Marcos too.
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.
- Industry: Education Management
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
Excel for Small, Medium and Large Organizations
On the overall, I have more than an excellent experience with Ms Excel. I love it.
Pros
Ms Excel is a very cheap yet powerful spreadsheet tool for data manipulation and analysis that produce information that can be used for planning, budgeting and forecasting. Its sorting and filtering, charts and graph, data formatting features help to fine tune data manipulation. Programmers can also use the list feature to ensure that only certain values are entered into those formatted cells. The availability of different currencies is an added advantage. Excel can also be interfaced with Ms Word, Access, PowerPoint and even Ms SQL. The benefit of importing plain text files and converting them to cell values by separator text in those files is something else. I was also able to export the data in Excel to an Access database I worked on for a small sales shop. One great thing about Excel is that it can accept data from scanning devices instead typing obscure data, you can simply scan it into the cells. Linear Problem Programming (LPP) and Project Chart Diagramming is possible with Excel. What more can you ask for? Did I fail its data security features. I was able to restrict user access to certain portions of programmed sheet, plus I I can password the entire file to ensure additional security to the file by scrupulous or malicious individuals. I had it setup on a SharePoint for a shop with different terminals to ensure smooth sales by different sales personnel. Though this required some in dept knowledge.
Cons
What more could I have asked for in Excel that I didn't get? I used Google sheets but still preferred the regular Microsoft Excel.
- Industry: Education Management
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
A great software for basic data management.
Pros
Almost all students have worked with Excel, but less than half of them know everything it has to offer. Microsoft Excel is a requirement, and although we say we know how to use it, this is limited to the basic functions. As we know, it is a spreadsheet in which we can organize information, apply formulas to obtain results quickly, create graphs, generate more than one sheet in the same file, among others. This is why it is a program that most companies handle today as a database, inventories, organization of students or customers, simply for everyday use is a great software.
Cons
Being a software of the Microsoft family, most of its great features are limited to have a 365 subscription on this software, but leaving that aside, Excel is not a tool for a data analyst, as it has many deficiencies in this area, I think it serves a lot for office work, but do not go beyond control and have a proper management of figures and monetary amounts, for that there are better software, but it is not a tool for a data analyst, as it has many deficiencies in this area, I consider that it is very useful for office work, but you do not go beyond control and have a proper management of figures and monetary amounts, for that there are better software.
- Industry: Information Technology & Services
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
A software in need is a software indeed
I live in and writing this review from Hungary, yet I am sure in other nations as well, MS Excel and Office tools are the leaders, but not the only sw. used to deal with a table file, in Hungary we do not even call them "documents", "table files", simply refer to them as "Excel" that is how big impact this program has made on our life.
MS Excel is on the market around for nearly 40 years, one of the most widely-can-be-used sw. on the market and I think is the best.
Happy to have it, personally I am utilizing Office kit from my elementary school days and will in the future.
Yes, there are some rivals to MS Excel, yet it is still the uncrown king. You may give a try to its rivals, there are free and paid versions too, so as online version are available.
Pros
Tons of educational stuff, examples, tricks, cheat sheets, "homework" like tasks are available.
You may get it for free, if you are a student, genuine activation keys for a nominal price can be found in the net, yet can be used with a Microsoft account for free (limitations, less feature are obviously there), with great functionality.
MS Excel is widely-known I reckon in the planet and used by numerous governments, also in Hungary. In the governmental entities, employees, officers use Office software daily, so it is thought until and even after the uni.
Companies, literally in every-single sector utilizing Excel (or Excel-like sw.) daily.
The features MS Excel a bit too enormous for one single user, simply not all the functions, and capabilities can be known.
Small companies like mine, has an Excel for everything, follow up on the expenses, make statistics, handle a table of contracts and important info in them, instead of a CRM, export reports data into, plan the sw. development activities there, embed file in Excels, put pictures in, track daily activities, even you may have excel with VB knowledge to create new files with macros, you can make more filtering, read-write data, manipulate other Excel documents and so on.
Also an important feature, you can lock you sheets, your workbook with a password, so as you can protect your Excel Visual Basic codes.
During your private life, Excel will be your help to do your tasks.
3rd party add-ons are available.
Cons
You have the possibility to share a workbook and simultaneously edit it with others, if the doc. saved to an on-line store, you can edit it on-line or on your on-premise, these function needs to be developed furthermore, sometimes not that smooth, incompatibly due to these versions, loss of functions, occur.
Writing a program to use other docs. data can be not that smooth at first, its programming language VB could be better.
You can crack the Excel workbook password protection if you check it on the web.
Bugs can appear, like resetting a font to the "inherited" one, not showing the result but instead of the formula, not properly loading a different time and language zone created Excel according your settings, showing English formulas instead your own language. Excel also tends to bet slow or even crash when you supply it too much data (but like Power Query, Power Pivot and other, newly introduced "tools" aiming to make these better). Consuming RAM, hard drive could be better.
On the IOS, Android apps world, Excel I am not sure the best, nor the leader (as MS got aware this "market" a bit later).
When moving from away from your "initial" network or VPN to a different one, it tends to not be able to save your work or give you dialog boxes to re-save your work or overwrite the existing file.
Conversion between other text file types, data inputs, reading, opening, editing inherited data, handling dates, are some points Excel can give you hard times.
- Industry: Education Management
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
powerful analytical and data managing tool
My overall experience with app/software/SAAS can be summed in the follwing points:A. The given app/software/SAAS has been solving the following business problems :- organisation of data- data entry- preparing accounting statements- comparison of data- B. i have been able to realize the following benefits with the help of the given app/software/SAAS :- data analysis- budgeting- sales forecast-account - work sheet of staff
Pros
Pros : i found the following features as most impactful:- analysis of large amount of data- exceellent tool to edit or summarise data- data visulaisation tools- data calculation tools- tabulation of dataYes the product is quite easy to use for: - fiteration of desired data- sorting and calculating of data- presentation of data as charts & graphs- pivot tables could be used easily- fast calculation of data Yes i was successfully able to implement the integration of the app/software/SAAS with my existing business processes quite smoothly and easily as i could set it up with a little self-help, effort, and online training guides..
Cons
Cons : I found the following features that were either missing or could be improved:- database aspect missing- human error probability is maximum- proper user guide missing- ability to recover lost filesI found the following features or aspects of the product that are difficult to use:- pictures alignment with cells- collaborative working becomes difficult- difficult to use macros - difficult to handle mathematical equations and formula- mobile application difficult to use No, the integration of the app/software/SAAS with my existing business processes not so much difficult as i could set it up with a little self-help, effort, and online training guides.
- Industry: Accounting
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
The most powerful spreadsheet software (yet simple by far, especially for large scale complex...
The amount of work we handled could only be done by this software, we tried other alternatives and nothing worked, especially at the amazing speed of MS Excel. Many people have this software which makes it easy to share and collaborate. That is the reason why this software is the standard in industry.
Pros
It is extremely powerful, fast and reliable software for medium to large scale financial reporting. My personal experience with this software is a testimony of this statement. I have worked for years in (large scale) financial reporting, the position is called financial controller of car manufacturer which produces 500,000 cars per year. Our financial reporting software for the past 5 years has been MS Excel and to give you an idea of the scale, we use very large spreadsheets (100 sheets, with a couple of thousand used rows and hundreds of columns, linked to 30-40 files with a large VBA codes in them) we even had to migrate from .xlsm to .xlsb to speed up the process. We've integrated it with SAP (ERP software) and work flawlessly and fast, we have even developed our own MS Excel in house Add-ons.
It is easy to track errors and formulas, you can combine Boolean conditions easily with the use of sum-product, lookup and indexing functions, it even has an optimisation solver embedded (simplex, non-linear and integer). The regression tools are at the level of specific data analysis software.
But the best part of it is that many people have MS Excel installed in their computer which makes it extremely convenient and easy to share with anyone. I can only tell that by far is the best software (in general) I've ever used. I simply love it (as you can tell).
Disclaimer: I've no longer work as a controller, I've moved to research and I still used it every day.
Cons
When you are moving the same file in different devices with different display resolutions, sometimes it gets a bit messy with graphs losing their proportions. Also a big drawback of some of their online and mobile device versions is that those are not very well integrated with "complex" VBA code.
- Industry: Civil Engineering
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
Microsoft Excel always excels!!
I have been using Microsoft Excel for the last 10 years, and this software has never ceased to amaze me by the amount of features it has packed into it. I started using it as a student when completing my Civil Engineering degree, then used it even more when I was working as a structural engineer, used it again when doing my masters and using it even now when working as an engineer again - on a daily basis!! Through all these stages I have found new features, explored them and realized them to be so useful in simplifying my day to day work. As an engineer I have to perform complicated calculations, manage huge amount of data, present that data to clients for them to make sense of it, and Excel is a one stop solution for that. I realize that even after over a decade of use, I have managed to merely scratch the surface. There were times when I thought I wish Excel had this feature, and if I made the effort to check it online it shows up that the software had that particular feature all along. Add to that the option of programming Macro's by writing a code of merely recording steps that I do repeatedly, it just reduces the tedious jobs of a 100 steps to a click of the button. Its so easy. Moreover, it has been a part of the Microsoft Office suite and thus its easily accessible to the masses. Add to that having the online Microsoft 365 functionality, with OneDrive, you can access Excel and your work from anywhere around the globe. I definitely recommend learning this software.
Pros
I have been using the software for over a decade and I have come to just love the following features.
1. Formulas - You can find over 100s of formulas to apply within the software, to give you the necessary output. They have been conveniently sorted into groups like Logical, Text, Lookup, Math & Trigonometry. I have come to use the HLOOKUP, VLOOKUP, MATCH, INDEX, the Logical formulas and the trigonometry formulas a lot owing to the nature of my work. Another neat feature is the use of definition. This makes it easier to define a cell to have a specific name and then refer that name in the formula. That way when I click on a cell to see the formula I can clearly understand the formula based on the variable name, instead of referring the cells.
2. Under the Data tab, I love the Text to Column function along with the What If analysis. Text to Column helps me separate a string of text into different columns based on a specific character like a letter or symbol. The most used feature of What If is the Goal Seek function wherein I can find set a cell to a target value and then tell excel to change a variable to get the target value.
3. The Excel graphs are so intuitive. You just select the data and make a graph out it, its that simple. And the variety of plots and graphs available is astounding. Really helps in data visualization in presentations.
4.Macros - It really helps in productivity as I can have a Macro programming do the tedious work for me with just a click of a button.
Cons
There is hardly anything that I would criticize about the software. Since even today I am still understanding the load of features and functions it has to offer. However, if I talk about the thing I like the least is how the formulas are presented. Since I am structural engineer I have to present design calculations, and I use PTC Mathcad and Microsoft Excel interchangeably based on my need. Mathcad has this beautiful way of presenting the calculations, because its made for that. However, I would love to see that feature make its way in Excel as well. Wherein I can have a line output the applied formula complete with Greek Symbols without having to painstakingly embed a formula, which again works just as a visual aid but does not actually calculate any value. It would be neat feature to have. Moreover, on the rare occasion that Excel crashes and my work saved on a Local Drive is lost, Excel gives me the opportunity to restore that work. But its not always easy to select the file I want to save. Sometimes the data is different, the files shows that its a more recent one but the data within the file shows otherwise. Those are the only two things which I don't like.