Seeking inspiration: How do you guys use IF, SUMIF, Pivot Tables and VLOOKUP?
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
How long do you have?
Seriously, your request is way too general. Share the data examples you want to use and we'll suggest which functions could be demonstrated.
I find it extremely amusing that someone about to run a training session would need to ask members of a forum to provide examples and screenshots.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
And not only here, but elsewhere, it seems!
Rule 08: Cross-posting Without Links
Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without including links here to the other threads on other forums.
Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.
Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!
Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
No further help to be offered, please, until the OP has complied with this request.
Hi AliGW,
Thanks for getting back to me.
Totally forgot about the cross-posting rules. And now I can't edit the post. Please delete the thread for now so I can return with a more elaborate one.
I'm glad you find it amusing
I have plenty of examples from previous training sessions but I find it nice to keep my examples fresh. Maybe someone here works with the IF function in a way I've overlooked in my other examples. I can see why my post needs to be more specific!
No need for the thread to be deleted, and please do NOT open another - just add detail here. But first, supply the cross-post link - you can do that in your next post to this thread.
Well, nobody here wants to tell you what you already know, so maybe share them?I have plenty of examples from previous training sessions but I find it nice to keep my examples fresh.
Last edited by AliGW; 01-15-2018 at 08:29 AM.
Thanks, Ali
I've posted it here: https://www.mrexcel.com/forum/genera...s-vlookup.html
Alright, I'll start with something.
1) A student of mine, Birgit (Danish name), set up a rather large system that her sales force could fill in when completing orders. The system generates proposals for the sales person to send out afterwards.
Birgit used a lot of IF functions (now she uses IFS instead) to fill the right information in the right cells depending on the input of certain cells.
Once a week, she collects all the information from the orders generated from the system and put it in a Pivot Table. Before using Pivot Tables, she used SUMIF and COUNTIF a lot to create a report with basically the same information as what the Pivot Table can spit out with minimal set up time.
She's struggling with getting a macro to do all the dirty work for her so it's a process, really.
2) Another student is often exporting inventory lists and sales sheets from his e-commerce site. When he get's a custom request from one of his big customers (sometimes they request prices on 100+ different items) he uses VLOOKUP to find details (prices, qty in stock) from the exports automatically, instead of using his slow ERP.
How about you guys? How did you use IF/SUMIF/Pivot Tables/VLOOKUP the last time you used it?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks