• Hello, I am starting out with more advanced feature of Excel, and I have been trying to solve some problems.

    I believe that it is mostly about Pivot tables, Vlookup, IF function? Please, see attached EXCEL file with the data to better grasp the problem.

    Q1: Show in one table the number of merchants per sales specialist. Highlight in a scalable way sales specialist with more than 40 merchants
    - Here I'd use pivot table, which is pretty easy. (not sure how to highlight the 40+ merchants though)

    Q2: Modify the raw data table to add category group information to each line. Clarity of formulas will be evaluated (Hint: Search function, data table)
    - No idea how to classify the data here

    Q3: Modify the raw data table to calculate points for each merchant signed. Show in one table the number of point per sales specialist with a category group break down
    - Not sure what to use here and how to create a function
    Q4: How many listings have been obtained for companies that contain the word 'Software' as part of their merchant name?
    - can be done by search function

    Q5: Show in a chart the number of points that have been obtained by sales specialist for all product lines that belong to the category group Hardlines
    - i tried using pivot table, and then Slicers. Though, I don't know how to create a function to identify the ranges (1-19=0,5 points, 20-149=1 point etc.) and classify the ranges

    Thank you in advance for any help with my learning!

  • Re: SOLVING PROBLEMS in EXCEL (questions)

    Here is a link that has numerous video tutorials on Pivot Tables

    This link will advise you on how to use Vlookup

    and this will show you how to use the IF function

  • Hi Guys,

    I was just praticing the exercise of excel for thoses questions and I would like to know if someone can provide me the answers in order to check if I did all question properly.

    :) I will really appreciated if someone can send me a file with all the answers.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!