What do you hate the most about Microsoft Excel?

Asked by Last Modified  

1 Answer

+1

Follow 1
Answer

Please enter your answer

Excel is good at lots of things, often because it is the only tool on a person's desktop that gets used for solving problems. You can do everything from data analysis to computation to reporting all in MS Excel. You do this because it works but not necessarily because it works well. There are too...
read more
Excel is good at lots of things, often because it is the only tool on a person's desktop that gets used for solving problems. You can do everything from data analysis to computation to reporting all in MS Excel. You do this because it works but not necessarily because it works well. There are too many situations where Excel is a bad tool. Still, because the hours to work on these sub-optimal solutions are "invisible" in terms of costs so you can never justify the cost, it would take to get a better solution written. It is also annoying in some aspects of charts - named ranges can't be used, but most users hardly use named ranges, so I doubt many people stumbled on that issue. Some of the more annoying things are when you want to use the "Move" function. You would not like having to resort to VBA to maintain persistences after a calculation. The fact of setting the Fill and Font colours without having to resort to conditional formatting, yeah that can be really tedious. Hope this helps. read less
Comments

Related Questions

I have got over ten years in customer service. Currently working as a team leader in an MLM company. Will doing VBA course help me get a better package I am having CTC of 7 lakhs hoping to touch 8 to 9 lakhs CTC.
As you are a Team Leader, Learning VBA is not going to help you. You just need Basic Excel Knowledge to manage your team. VBA is for programmers who need to develop softwares. Learning VBA is like -...
Profile Photo
Francis
0 0
View Comments5
What is VBA and what is its importance?
vba is visual basic for application. it is used to automate the task and make user define formula.
Profile Photo
Shagufta
0 0
View Comments5
Excel formulas in advance level?
In excel we have lot of staff and formulas, we can learn based on your requirement, in excel vlookup, hlookup, pivot table if condition, sumif ifs, countA, if ifs, data validation, etc. and we have to...
Profile Photo
ManojGS

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

VBA Function - RIGHT
RIGHT function in VBA returns the Specified number of characters from the end of a text string Syntax: Right(String,Length) Sub RIGHT_1() Dim mystring As String mystring = "Narendra Modi" MsgBox Right(mystring,...
Profile Photo

Conditional formatting with formulas
Conditional formatting quickly formats information in a spreadsheet. But sometimes the biult in rules are not enough. Adding your own formula to a conditional formatting rule gives it a power to help you do custom things.
Profile Photo

Hidden Gems of MS Excel - Data Validation - Circle Invalid Data
Q) You apply Data Validation to a range of Cells. e.g. You apply Data Validation Drop-down List of 5 Indian Cities: Indore, Lucknow, Mumbai, New Delhi, Pune, to a range of Cells What if invalid data...
Profile Photo


Arrange and View Multiple Worksheets at Once in Excel
Arrange and View Multiple Worksheets at Once in Excel This feature allows you to view multiple worksheets at once from the same workbook at the same time. You need to follow beneath simple...
Profile Photo

Recommended Articles

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Looking for MS Office Software Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you