MS Excel (2010) - Beginner to Advance

[ferris17]

Hey guys,

I was wondering if anyone can list content structure for Excel.

So, in order to go from a beginner to advance what skills do I need to learn methodically?



Cheers

[jeffreybrown]

This is a very broad question which I don't think has a right answer.

Excel offers so many attributes...

To name a few...

• Functions
• Pivot tables
• VBA
• Charting
• Subtotals
• Conditional formatting
• Data validation
• What-if-analysis

Here's one example with functions...

In cell A1 Jeffrey Brown

If you wanted to return the first name, we could use... =LEFT(A1,7)

But the 7 is hard coded. To make it dynamic based on the length of the name, you could use...=LEFT(A1,FIND(" ",A1))

But that returns 8 for Jeffrey and it should be 7. So now an option is...=TRIM(LEFT(A1,FIND(" ",A1)))

So you can see, we have used three fuctions to build a robust formula, but there are other ways to accomplish this.

An easier method could be...Text to Columns

So, in order to go from a beginner to advance what skills do I need to learn methodically?

Advance is a very subjective term. Advanced compared to what or whom? I can tell you about some forum members who are masters at using formulas, some who are VBA masters, and some who can do both with ease. To me, they are all advanced, so I don't know if there is a order in which to learn Excel. I have learned enough stuff I am pretty comfortable performing my job at work and every once in awhile I am advanced enough to answer a query on one of the many forum's I visit. Often times the query is way above my current abilities.

Here is a good link to get you started in your quest...
https://www.mrexcel.com/forum/genera...ml#post3604871

Maybe you weren't looking for this much information, but hopefully it helps in some way...

[ferris17]

@jeff - Thanks for the info mate. Really appreciate it.

As for the attributes you listed, do you think they are enough for a performance analyst or office administrator?

[jeffreybrown]

Originally Posted by ferris17

As for the attributes you listed, do you think they are enough for a performance analyst or office administrator?

Well, what I listed is a mouthful, but I suppose the answer could be yes.

It really comes down to what type of performance analyst they will be doing?

Some of those skills may not be necessary and some may be very important.

Are you looking for a way to test a candidates strength with using Excel?

If so, I've seen many a person say their Excel skills are strong, but yet they cannot build a satisfactory pivot table.

I use Office 2010 at work and speaking of pivot tables, slicers blow their minds.