Freelancer: Siaaaaaa
Jaa:
Tee ilmoitus työstä

aggregate & dashboard & month pages

Hi, i have done with several pages: [Aggregate page] - only need input data into column A-C; - column D-P will update automatically with formula; - column D (totals) set with Pentagram icon as well as background&front color to highlight value >= 20; [Dashboard page] - Chart1: TOP20 clients with total points; - Chart2: monthly trend with birthdate slicer under which you can choose different years; [Month pages] - column A-C will update automatically with formula (same with Aggregate page); - only need input data into columns after column E; - cells after columnE have set data list you can pull down and choose value, directly input is also fine, if you input value not in -2~2 it will send alert. feel free to let me know any confusions.

Kilpailutyö #18 kilpailussa                                                 Excel attendance tracking sheet by client by event

Julkinen selvennystaulu

  • blui88
    blui88
    • 1 vuosi sitten

    Respected Winner,
    Zhang J.( https://www.freelancer.in/u/Siaaaaaa )
    Heartiest Congratulations>

    Regards

    Santosh

    • 1 vuosi sitten