Topics for excel tutorials. Intermediate level audience

x43r0

I need some inspiration.

I'm planning to run some excel sessions with my department in work to teach them some useful methods to get them from casual excel users to perhaps moderate-advanced.

I work as a business analyst focusing mainly on data analysis. I've been working with excel for a long time now and would consider myself to be a fairly advanced user but I've never taught it so I'm sure what best to cover.

As a start, I plan to go over topics like:

• Pivot Tables
• VLookups
• Conditional Formatting
• LEFT/RIGHT/TRIM functions
• Selecting visible cells only to copy when filtering
• Text to columns
• Simple Formatting (wrap text, merge/center)
• Different paste types

This is just a brain dump but if you guys can suggest anything obvious I'm missing or any topic you think is useful it would be much appreciated.

Thanks!

Overheal

Nothing about charts or graphing? Lot of depth to potentially cover with graphs that are outside of base-10

x43r0

Overheal wrote: »

Nothing about charts or graphing?

Good call - This is exactly why I asked the question

paulbok

Importing data in/out to a text file.
Maybe a simple macro?

Saipanne

sumifs, countifs