Location

Community Services & Continuing Education - Cairo

Objectives

• To ensure that you deliver great content that resonates with your fans and followers, you need to track, test and measure the posts you put on your social networks.

Outcomes

1-analyze your social media activities using excel 2-data analysis 3-data collection 4-sort data to identify best performing content 5-convert numbers to visuals

Course Contents

1-how to analyze your social media activities using excel - build sheet-types of data -data analysis process -social media terminologies -outline the targeted data2-data analysis - data collection -sort data to identify best performing content -demonstrate a data cleanse using the oppropiate functions (trim-clean-substitute-duplicate)-creat if statements- VLOOKUP function -create & navigate a pivot table 3- convert numbers to visuals 4- capsules to become a champion in data reporting 5-interactive workshop