Microsoft Excel

Avantages

Excel is THE tool for analysts and engineers. While Google Sheets acts as a close competitor, for those of us who need the sophisticated capabilities that Excel provides, there really is no substitute. The ability to automate processes through advanced formulas and macros makes Excel the only solution for those seeking to manage and clean data. Excel has dominated the market for decades and you can rest assured knowing that everyone knows of Excel.

Inconvénients

Mass adoption is a double-edged sword. Despite Excel offering a lot of value to the user, there's very little in terms of substitutes to even consider. If you coworkers, colleagues and clients use Excel, you need it as well if you hope to send them spreadsheets. The Microsoft Suite suffers from a range of technical bugs that seems to get resolved only sporadically. Every time a new version of Excel is released (usually once every few years), some aspect of the user experience ends up changing. To those of us who have ingrained habits in terms of where to find specific buttons or memorizing certain shortcuts, the changes can be frustrating.

Avantages

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.

Inconvénients

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

Avantages

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.

Inconvénients

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.

Avantages

There are many things to love about excel. First off, if you're familiar with other microsoft products, it feels very familiar in terms of layout, and the tool bar. It can be used for a wide variety of things from simple to complex lists, data sheets, graphs and overall any type of information management. I love that excel allows you to use a barcode scanner to input data within cells, this is especially useful if you're in inventory management. I love that excel calculates many different formulas and helps you sort/filter and categorize information in a smart way. Pivot tables are especially easy to create and use to summarize data, and get it to display quickly and easily in a summarized format when you're managing a lot of data. Excel has the capability to add multiple tabs to one document which helps if you're building a big data file to track various information, and you want it all accessible in a single file, yet still organized. Excel performs calculations you never have to worry about trying to do yourself, and there is also plenty of knowledge available on many different sites as well as, Microsoft, because its one of the standard programs widely used.

Inconvénients

Excel can be a bit overwhelming if you're using it for the first time. You may not know how to apply formulas correctly, and the best way to learn is piece by piece. Start by learning one tool, and building from there. Excel can also take long to load large files with tons of information, and can sometimes crash when you have too many large files open.

Avantages

What I like most about Excel is just how smart this software really is! I'm still impressed with it on a daily basis, whether it comes to the more complicated tasks such as filling in the sales numbers of what my company has earned for the week or doing the really basic calculations of what I have spend on groceries for the week. This software is reliable calculations every single time, I don't need a calculator, Excel adds and subtracts every sum I require within seconds. I see this software not only as my personal book keeper, but I also trust it to be a mathematical wizard all rolled in to one, incredibly smart every day helper.

Inconvénients

What I like least about Excel is just how complicated it can get! It's a brilliant tool to use to help you keep your books, but if you don't know how to use v-look up for example or what a cell is even, you are going to be so lost using this software. It does look intimidating, especially when you see the layout for the first time and seeing all the lines and the numbered grids so neatly categorized out before you, but do not get discouraged because Excel is an awesome tool to use! If you are a first time user you will definitely need either a course in Excel to unlock all of its wonderful features or a coworker that is fluent in Excel to help you get started in the beginning.