The Secret Excel & Data Analytics
Go from the very beginning of how to navigate excel and study common business problems solve them using excel. the course title: The Secret Excel: Uncovering Insights through Analytics
1. What exactly is data analytics, why companies perform data analytics and visusalisation? why its useful to be data literate
2. collect from avrious sources, online, social media, website, database, other workbooks, etc
3. clean - remove duplicates, handle blanks, errors, format consistent, delete etc
4. analyse - explain what has happened, descriptive statistics and some frameworks to describe any dataset
5. Visualise data - charts, graphs, visual representations of the data,
go through multiple scenarios.
demonstarte the power, efficeincy and usefulness of pivot tabels, pivot charts, power query, what if analysis, solver, etc