How can you tell if someone is truly an expert in Excel?

Asked by Last Modified  

1 Answer

+1

Follow 1
Answer

Please enter your answer

The problem with Excel is that each step is easy, so it’s a bit like Lego. So very few people put in the effort to master what is a large and sophisticated set of tools, with a dozen different modes of operation. Thus, nearly every spreadsheet is awful and financial regulators are worried that...
read more
The problem with Excel is that each step is easy, so it’s a bit like Lego. So very few people put in the effort to master what is a large and sophisticated set of tools, with a dozen different modes of operation. Thus, nearly every spreadsheet is awful and financial regulators are worried that they will cause the next financial crash; some say they created the last one. A real Excel Expert is someone who can make it quickly do the things that are needed, knowing syntax is less important than the more in-depth knowledge of how things can be best achieved in Excel. Excel development is much more of a real-time thing; an expert knows when to prepare out a quick sheet and when to build something resilient and is skilled at extracting from users what they want without a formal specification. A top-rate expert knows when to use MSTO to bring it more up to date and has the wisdom to know when to leave VBA and XL4 macros well alone and just patch. One would be defined as an expert. A reasonably smart person can learn any feature of Excel just like Python, SQL or any other tool. What distinguishes an expert from someone who has merely used something a lot is their ability to make the right decisions. That’s what one would look for when selecting people to recommend. Hope this helps read less
Comments

Related Questions

Is it necessary to have the knowledge of VB script for Excel Macro Training?
Please make a correction, its not VB Script but Excel VBA that you need to learn. VB Script is different form Excel VBA even though they both are subset of VB (the same parent), Please google to know more....
Suma K V
What are the benefits of using Excel in business?
Excel is mostly and widely used tool of Microsoft for business purposes, to maintain data, to maintain records as well as to have efficient result through calculations. Excel provides a bunch of formulas...
Vijay
0 0
8
How to create pivot table in excel?
If you wan to analyze the only data that is on your sheet. First be sure all columns has header after than select any cell from your data and go to insert tab and click on pivot table.
Rahul
0 0
6

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

Ask a Question

Related Lessons

MS Project: Importing data from excel to MS Project
User can import data from excel into MS Project. This video explains how to do it.

Flash Fill: Advance Excel
Flash Fill is only available in MS excel 13 and above versions. Flash fill is used to fill the data automatically in the below cells if a pattern is evident. It can also extract, insert or concatenate. Some...

HTML (Hypertext Markup Language)
HTML (Hypertext Markup Language) is the set of markup symbols or codes inserted in a file intended for display on a World Wide Web browser page. The markup tells the Web browser how to display a Web page's...

Idioms and meanings - Lesson 2 of 11
Idioms Beginning with C and D (Choose the answer that best fits the meaning) Idioms Beginning with C Idioms Beginning with D To "call it a day" means ___.a. to quitb. it becomes eveningc....

Dget-Extract From A Database A Single Record That Matches The Condition We Specify
Syntax: DGET(Database, Field, Criteria) The DGET function syntax has the following arguments: Database Required: The range of cells that makes up the list or database. A database is a list of related...
D

Daniel I

1 0
0

Recommended Articles

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

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