Data analysis and presentation with Excel

Date: May 9, 2017
Time: 2-4 p.m.
Format: Workshop
Hosted By: BCCIE
Location: SFU Harbour Centre, Room 2205 (Paperboard Industries Room), 515 W Hastings St.
City: Vancouver, BC
Cost: $35 (please note no refunds will be issued)


Excel is a powerful, but daunting program with functionality that can manage data into meaningful information. Recruiters and administrators often don’t have the right technology to convert rough enrollment and student data into presentable charts and graphics that you can share in slides or documents. This workshop aims to show how Excel Pivot Tables and the COUNTIFS function can provide enormous capacity to do quantitative analysis on data for enrollment trends. Excel is not about memorizing all the formulas; understanding the logic behind your analysis helps to develop well-structured spreadsheets.

Learning objectives

  • Learn how to use Pivot Table to reorganize the information in a data table, generate cross tabulations or to show correlation
  • Learn how to use COUNTIFS function to evaluate multiple count and criteria ranges across several datasets
  • To visualize and understand large sets of data and to communicate reasons for strategical decision
  • To share achievements and challenges using data descriptions

Note: please bring your laptop with Microsoft Excel installed to participate in workshop activities.


Charlene Chang is an Associate International Recruiter/Advisor at the University of British Columbia. As a graduate with a degree in Economics, Charlene has combined her passion for data analysis with her work as an international student recruiter. She realizes that in many instances, a fully functional CRM system might not be available; thus, using an accessible and powerful tool like Excel allows recruiters and administrators to visualize data and ultimately use the data to support any strategical decisions.

Fabiano Maciel, currently an International Marketing & Recruitment Assistant at Langara College, became an international education advocate after his first experience as an international student in Vancouver (2001). For the past 10 years, he has been formally supporting students in achieving their goals pursuing education in Canada. He specialized in developing relationships with agents across four continents. In his opinion, the inaccessibility of costly CRM tools for many colleagues in our industry demands the ability to make available software really work to our advantage when it comes to gathering and interpreting data.

Registration deadline: Sunday, May 7, 2017

For more information, please contact