Overview
We live in a world of data. You engage with data when you publish on Facebook or LinkedIn. You engage with data when you leave a comment on a friend's post or like their photos or comments. Every day, we generate and use data. By sharing content, like photographs, and leaving comments, you generate data that is used to analyze patterns in your behavior and of course your buying habits. Have you ever observed that, occasionally, when you click on something online, it appears to be following you across several web pages or websites? That is an example of Data and analytics
Microsoft Excel is a powerful tool for Data Analytics and the built-in pivot tables are arguably the most popular analytic tool that allows you to analyze data easily.
Course objectives
By the end of this course, you'll be able to:
Excel Basic
Excel functions and Formula
Pivot tables
Pivot chart
Data visualization
Data transformation
Data Modeling
Reporing in Excel