La nouvelle version Excel disponible est plus propre, mais elle est également conçue pour vous aider à obtenir rapidement des résultats professionnels. Vous y trouverez de nombreuses nouvelles fonctionnalités vous permettant de vous échapper des murs des chiffres et de dessiner des images plus convaincantes de vos données, vous guidant ainsi vers de meilleures décisions plus éclairées.
I work in banking industry. My daily job is to collect different types of banking data from different business units and process them into meaningful information for policy makers. For this purpose I almost entirely dependent of MS Excel. Everyday I collect a number of excel files from different sources and process them using various Macros for time saving. Then I summarize them using pivot table and graph. Finally I create some graphical presentation for higher management's consumption. Till today MS Excel never failed to serve me. Ofcourse, it is very resource hungry and it has some limitations regarding rows and columns size but my overall experience with MS Excel is very good.
My daily activities are heavily dependent on MS Excel. I work with very large amount of data and following abilities of MS Excel helps me to complete my job timely and effectively:
1. Ability to present data visually by different types of graphs
2. Ability to summarize data using Pivot table and Pivot graph
3. Ability to collect data automatically from different websites using connections
4. Ability to automate different redundant activities using Macro and visual basic
The things I don't like about MS Excel are:
1. Its very resource hungry. You need minimum 4gb of RAM for day to day activities and 8gb to 16gb of RAM for bigger spreadsheet with more than 200k rows of data.
2. Though the size of Spreadsheets is adequate for normal day to day use, it has a limitation of 1 million (1,048,576) rows and 16 thousand (16,348) columns. Sometimes this limitation forces me to divide my spreadsheets in 2 or 3 parts which is not optimal.
3. The learning curve of MS Excel is not very smooth specially for new users.
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.
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.
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.
Overall I love Excel for the variety of inbuilt functions that help you make models. I have heavily used Excel for my Ph.D. research in the last three years, and I can assert that Excel still has new functionalities that I have not discovered yet.
Excel is one of the most powerful tools that is used daily in Fortune 500 corporations. From simple graphs and tables to complex VLOOKUP functions that I use daily, Excel can be used in home, offices, and schools. I find Excel extremely useful to store and manage data. Excel can handle every large data sets and is very intuitive to conduct simple data analysis and visualize it. I have been using Excel for more than eight years now, and I can vouch for the plethora of functionalities it provides to make our lives easier. From making Pivot Tables to conducting sensitivity analysis in my financial research models, Excel is a one-stop solution for quick modeling work. I have found that sometimes, it is much easier to transform and clean data in Excel rather than writing complex scripts in Python or MATLAB.
Excel's way of indicating errors in your formulas aren't always helpful to figure out the exact source of error. Plus Excel doesn't have an inbuilt autocorrection to check for spelling errors. You must double-check the spellings in your Excel model/document before sharing it with anyone.
Overall, I think the learning curve on Excel makes many people hesitant to try it unless they see it as necessary for their profession. However, the basics of Excel really doesn't have much of a learning curve. The advanced stuff, yes has a learning curve (though not too bad), but the basics are pretty quick and easy to pick up.
I use Excel regularly - sometimes for its intended functions like calculations and personal business organization, as well as sometimes just an easy way to keep track of things visually by assigning it different colors and locations. Many of my calculations are quick-and-easy numbers where it's easier to make a quick plot on excel than type everything out on a calculator. Other times I've made very extensive sheets to organize a lot of data and perform calculations for special projects.
I find Excel useful for organizing and presenting data. There is a learning curve to understanding how to program it to perform different functions and calculations, but once you've gotten the hang of it then it is pretty easy to set things up to perform live calculations as you adjust your data. More advanced features include getting cells to change color based on the numbers or letters appearing in either that cell or others. Since I'm a very visual person, color coding is very helpful for me. And of course it is easy to convert your data into charts and graphs.
When you type a formula incorrectly, excel's error messages aren't always very helpful in understanding what the error is. There is no way to exit out of the cell containing the error without either fixing it or deleting all the text inside and starting over later after you've figured out what you did wrong the first time.
Creating graphs and charts isn't always as intuitive as it could be. Sometimes I've had to struggle a bit to get the data I want to appear along the axis I want in the correct intervals. It would also be nice if the chart would automatically adopt whatever color coding I used in the data cells so that I wouldn't have to manually modify the default colors.
For some of the more advanced functions, the editor can get very clunky. For instance, I did a sheet once where I had it return a different string of text for whichever number in a range was entered. This quickly became a very unwieldy mass of code in a single cell that was difficult to edit in the small text box and caused some lag in the program.
It's also annoying that when using search, I am limited to searching one sheet at a time instead of the whole workbook. I'd like to see more options to customize the location and parameters of my search.
I've been using Excel from my collage up to now, it means more than 10 years. Still I couldn't find any better substitute which can replace Excel. Now I use Excel at both my work and also for my personal stuff. All the formulas, pivots, connections are really helpful for the business use. Same time I use Excel for my personal purposes such as an expense tracker and a budget planner. If you can become an expert on Excel its gonna really help you to build your confidence at work and also to do your work faster than the others. All Time Best Spreadsheet Software.
Well, I would just say Everything, but to more specific, I really love to work in the Excel by using short keys, it helps you to speed your work. Then it would be the formulas and the most useful would be vlookup/hlookup. Those are the things which makes my life easier on a daily basis. I usually don't even open the calculator no matter how simple the calculation is, it will always be Excel.
Also I really love the Pivots and tables which are really cool, accurate and nice. Also everything can be customized in the exact way we wanted. Same time its very secure, you can protect the worksheet or the book. Having all these great features I use Excel even for any documentation needs instead of Word.
Am just a normal user who used Excel at work and also for my personal analysis/documentation purposes. But I'm not an Excel pro who knows Macro and all that. Hence this software satisfies all my needs, so I cant think of any cons at the moment provided that I don't even get the maximum out of this amazing software.
The only issue I have here in Excel is there is no inbuilt auto correction or a grammar, spell checker. I know we can always use F7 for that but it would be great if it is possible to underline the missed spell words by the the time we are typing them.
Voici quelques-unes des questions fréquentes sur Microsoft Excel.
Types de licences disponibles pour Microsoft Excel :
À partir de: 10,00 $US/mois
Type de licence: Gratuit, Licence unique, Abonnement
version d'essai gratuite: Non disponible
Nous n'avons pas d'informations sur les fonctionnalités de Microsoft Excel.
Utilisateurs habituels du logiciel Microsoft Excel :
Auto-entrepreneurs, Grandes entreprises, Entreprises de taille moyenne, Non Profit, Administration publique, PME
Langues dans lesquelles Microsoft Excel est disponible :
arabe, chinois (simplifié), chinois (traditionnel), tchèque, danois, néerlandais, anglais, finnois, français, allemand, hébreu, hongrois, indonésien, irlandais, italien, japonais, coréen, norvégien, polonais, portugais, russe, espagnol, suédois, taïwanais, thaï, turc, ukrainien
Types de licences disponibles pour Microsoft Excel:
Gratuit, Licence unique, Abonnement
Appareils pris en charge par Microsoft Excel :
Android, iPhone, iPad
Applications s'intégrant à Microsoft Excel :
1CRM, Amity, Celoxis, Insly, Mobile Field Report, NABD System, PipelineDeals, PlanGuru, SAP Roambi, moon
Ressources d'aide disponibles pour Microsoft Excel :
FAQ, Forum, Base de connaissances, Support en ligne, Support téléphonique, Tutoriels vidéo