Excel kayan aiki ne mai ƙarfi, mai iya ƙirƙira Dashboards cikakke sosai, na gani kwararru, ba da damar sabunta bayanai masu ƙarfi kuma tare da abubuwan haɗin gwiwa na ci gaba (zane-zane, yanki, gudanarwar shafuka masu yawa).
A cikin menu na wannan kwas, za ku koyi duk abin da kuke buƙata don ƙirƙirar wannan nau'in Dashboard:
- Yadda za a shirya bayanai don ƙirƙirar dashboard?
- Haɗa takardar shaidar hoto a cikin Excel
- Yi amfani da PivotTables da PivotCharts don nuna bayanan ku
- Nuna lokacin kwatancen a zahiri akan KPI na ku
– Ƙara masu tacewa da segments zuwa ga hangen nesa
- Ƙirƙiri menus a cikin dashboard ɗin ku
Don koyon duk wannan, za mu dogara da bayanan kasuwanci daga shagunan na Google. Wannan zai ba mu damar gina dashboard ɗin aiki bisa ainihin bayanai.
An shirya wani ɓangaren "Motsa jiki" a ƙarshen karatun don ku iya gwada ilimin ku.
Ina fatan ganin yawancin ku don wannan kwas! ?
