All of us will agree that we live in the “Digital Age”. Organisations and individuals do everything on their computers and mobile devices. This means that every single second, billions of data is generated. Even in a developing country like Sierra Leone, the digital information out there is massive. This has made data analysis an important skill to possess as it helps organisations make better decisions when they can make sense of the information available to them. Data is used in many different industries by millions of users who share the goal of reporting the performance of companies and organisations. There are many tools used to analyse data, however, the most popular one easily available is Microsoft Excel. This course explores Excel as a tool for solving business problems as Excel formulas can be used to aggregate data to create meaningful reports.
In this course, you will learn how to perform data analysis using Excel’s most popular features. You will learn how to create pivot tables, slicers and dashboards; and see the power of Excel pivots in action, their ability to summarise data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data. In addition, participants will be exposed to data cleansing methods, VLOOKUP, HLOOKUP and other conditional functions and formulas that they can use regularly for their professional work.
Each week for the 4-week period of this course, participants will build on their Excel skills and be provided an opportunity to practice what you’ve learned. Finally, you will have a chance to put your knowledge to work in a final project. Participants will be required to bring their own laptops; however, Freetown Business School will provide Microsoft Excel 2016 for all participants.