Calculate Sales Incentive in excel | Advanced Excel tips and techniques
Hi Friends,
Our assignment was..
Sum the sales by city wise and calculate the sales % on target and extract the incentive amount based on the sales% and category.
Check this video for the solution of our assignment.
If you wants to increase your knowledge in MS Excel, then join this YouTube channel. Very interesting and useful information is available. / excelmasterem
You can also join WhatsApp group if you missed any video notification. https://chat.whatsapp.com/DgbxaGuD4O0...
thank you !!!
Timestamp
00:01 - Intro
00:15 - Problem solvers
00:27 - Solution
00:53 - How to use sumif fuction in excel
01:52 - Shortcut code for filter in excel
02:27 - How to copy formulas in other cells in excel
02:43 - Calculate sales %
03:22 - Calculate incentives
03:50 - How to use if function in excel
09:00 - How to use paste special in excel and tanspose option
15:40 - How to use vlookup fuction in excel
17:48 - Thank you
Music: Bloomer
Musician: EnjoyMusic
URL: https://enjoymusic.ai