Seeking inspiration: How do you use IF, SUMIF, Pivot Tables, and VLOOKUP?

[KasperKL]

Hi fellow Excel fans!

I'm about to do some Excel training for a group of people. Some of the topics are: IF, SUMIF, Pivot Tables, and VLOOKUP.

I'm looking for inspiration to the specific assignments and examples that I'm going to use in the training.

What do you guys use IF, SUMIF, Pivot Tables, or VLOOKUP for? And how?

Please, be as detailed as possible and feel free to use screenshots.

I'd really appreciate any responses to this

 

[Macropod]

Cross-posted at: https://www.excelforum.com/excel-ge...ys-use-if-sumif-pivot-tables-and-vlookup.html

Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[KasperKL]

Thanks!

Please delete the thread so I can make a new one with links. I can't seem to edit my post now.

 

[Joe4]

Please delete the thread so I can make a new one with links. I can't seem to edit my post now.

You don't need to do that. Simply post the links in a Reply to this thread, if you have posted at any other sites other than this one and ExcelForum (since Paul already posted the link to that site, you do not need to post it yourself at this point).

In the future, just be sure to mention it and include the links in your initial post.

 

[KasperKL]

Thanks, Joe and Macropod!

I have only posted it on excelforum.com