Content for an advanced Excel course

**Ctech** · 08-26-2010, 03:22 AM

Hi,

I'm gonna create and hold an Excel course internally in the department. Currently I've made some examples on how to use VLOOKUP, MATCH, INDIRECT, SUMPRODUCT etc.

However I need some more advanced examples of issues that a Management Consultant should know... we do a lot of business case, market analysis, data handling (statistics etc). In addition I need some more tricks and general good shortcuts etc for Excel that I can spice up the course with

Do anyone have any good examples, online tutorials, tricky formulas that I should know about so that I can include in this course?

PS!! If it matters, I am now professional and I do this only to help out fellow colleagues!!

**martindwilson** · 08-26-2010, 03:50 AM

id be suprised if a Management Consultant has the slightest idea what indirect is any way.

**royUK** · 08-26-2010, 04:11 AM

One of my previous managers, chartered management accountant, couldn't even use PivotTables

**Ctech** · 08-26-2010, 05:13 AM

Originally Posted by martindwilson

id be suprised if a Management Consultant has the slightest idea what indirect is any way.

Well I am one and I know what indirect is

**martindwilson** · 08-26-2010, 07:54 PM

seriously, the level will vary according to need. the most junior member may be more savvy than the mid or senior. you'll need to identify the strengths and weaknesses of any individual and tailor make a few examples for them to brush up on.