DAT101

DAT101 - Introduction to Data Analysis using Excel

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.

Course Objectives: On completion, you will be able to:

  • Create flexible data aggregations using pivot tables
  • Represent data visually and filter data using pivot charts and slicers
  • Calculate margins and other common ratios using calculation on pivot table
  • Create aggregate reports using formula-based techniques
  • Use basic functions such as Min & Max; Left, Right and Mid
  • Use conditional functions such as VLOOKUP, HLOOKUP, Sumifs and Countifs 

Fee: Le3,500,000 per person.

5% Discount for Women. Additional 5% Discount for Groups of 10+; and 10% Discount for Entrepreneurs. All discounts can be claimed.

Registration:

Participants will be required to register through our website www.fbs.edu.sl/dat101 for the course and are expected to attend all classes to be eligible to receive a Certificate.

Dates:                         27th February to 23rd March 2019

 

Session:                   Wednesdays, Fridays and Saturdays – (Wednesdays and Fridays – 6:00pm to 8:00pm, Saturdays – 2:00pm to 2:00pm)

 

Fee:                            Le3, 500,000 per person. 5% Discount for Women. Additional 5% Discount for Groups of 10+; and 10% Discount for Entrepreneurs. All discounts can be claimed.

 

Venue:                      Africell American Corner, 25 Bathurst Street, Freetown