Hosted By: BCCIE

Data analysis and presentation with Excel

Date: May 9, 2017

Time: 2-4 p.m.

Format: Workshop

Cost: $35 (please note no refunds will be issued)

Address: SFU Harbour Centre, Room 2205 (Paperboard Industries Room), 515 W Hastings St.

City: Vancouver, BC

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.

Presenters

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 events@bccie.bc.ca.