UBCevents Calendar http://events.ubc.ca/welcome.html May 23, 2018 - June 19, 2018 23 May 2018 07:70:00 UT en-US Copyright 2008-2009, Bedework info.events@ubc.ca MS Office Excel Expert - Functions, Forms & Linking Data http://www.calendar.events.ubc.ca:80/cal/event/eventView.do?subid=-1&calPath=%2Fpublic%2FEvents+Calendar%2FPersonal+and+Professional+Development+%28Okanagan%29&guid=CAL-09d22401-62b5916a-0162-b6c324b7-0000003cmyubc-team@interchange.ubc.ca&recurrenceId= Wed, 23 May 2018 08:30 PDT Wed, May 23, 2018 8:30 AM - 4:30 PM See description. $259+tax. <strong>Power Concepts - This course is exclusive for UBCO faculty and staff and is limited to ten people.</strong> If you are experienced in Excel but need to start building more complex calculations and to build sequential operations then join us for this advance Excel course to learn how to assemble complex operations simply one step at a time. Also learn to manage multiple sheets or multiple books and to apply protection, navigation and form controls. We also develop simple Macros and learn how to apply, share and create buttons to control them. The following list summarizes skills that students will be comfortable with after this course: - Use advanced functions such as: Information, Lookup and reference, Conditional logic, Conditional summary - Create, modify or remove a hyperlink - Work with shared workbooks - Add Protection to workbooks and worksheets - Track changes - Consolidate Data - Create and run Macros - Add form controls This course assumes that students have completed the Microsoft Excel course or have equivalent knowledge and experience. <strong>Wednesday, May 23, 2018</strong> <strong>8:30 am to 4:30 pm</strong> <strong>Power Concepts Office, 1855 Kirschner Road, Kelowna</strong> <strong>Cost $259 pp + tax</strong> Lunch will be provided by Power Concepts. <a href="https://www.powerconcepts.ca/CorporateProfile/profile/">Registration Link</a> If you have any questions please do not hesitate to contact Lisa Frost at <a href="mailto:lisa.frost@ubc.ca">lisa.frost@ubc.ca</a> or at 250-807-9021 Type - Workshop MS Office Excel Expert - Database Management & Analysis http://www.calendar.events.ubc.ca:80/cal/event/eventView.do?subid=-1&calPath=%2Fpublic%2FEvents+Calendar%2FPersonal+and+Professional+Development+%28Okanagan%29&guid=CAL-09d22401-62b5916a-0162-b6c96dce-0000003emyubc-team@interchange.ubc.ca&recurrenceId= Thu, 24 May 2018 08:30 PDT Thu, May 24, 2018 8:30 AM - 4:30 PM See description. $259+tax. <strong>Power Concepts - This course is exclusive for UBCO faculty and staff and is limited to ten people.</strong> Need to do time tracking of various staff on various projects? Need to download reams of data from an online data source? Now you need to make sense of it all! Learn how Excel will capture potential data errors, minimize input errors and then automate the updating of datasets into Excel table and then into Pivot Tables and Pivot Charts. Also learn strategies for collecting and validating data with tables. Understand how to automate the collection and cleaning up of data using Power Query and then how to analyze with Pivot Tables. And also learn how to create dashboards for visually displaying data and using slicers to quickly filter and change graphical reports. Learn to use the new Excel's Business Intelligence (BI) Tools that can make updating and analyzing data a breeze. The following list summarizes skills that students will be comfortable with after this course: - Create tables and learn to sort, filter and report on data with a few clicks - Add data validation, including using pick lists - Remove duplicate data; circle invalid data - Use data analysis tools - Create and modify Pivot Tables - Create and modify Pivot Charts - Add calculations and custom Functions within a Pivot Table - Use slicers and filters with Pivot Tables - Import Data with Power Query This course assumes that students have completed the Microsoft Excel course or have equivalent knowledge and experience. <strong>Thursday, May 24, 2018</strong> <strong>8:30 am to 4:30 pm</strong> <strong>Power Concepts Office, 1855 Kirschner Road, Kelowna</strong> <strong>Cost $259 pp + tax</strong> Lunch will be provided by Power Concepts. <a href="https://www.powerconcepts.ca/CorporateProfile/profile/">Registration Link</a> If you have any questions please do not hesitate to contact Lisa Frost at <a href="mailto:lisa.frost@ubc.ca">lisa.frost@ubc.ca</a> or at 250-807-9021 Type - Workshop Pit Stop ~ Student Hospitality & Housing http://www.calendar.events.ubc.ca:80/cal/event/eventView.do?subid=-1&calPath=%2Fpublic%2FEvents+Calendar%2FPersonal+and+Professional+Development+%28Okanagan%29&guid=CAL-09d22401-61b3ffd3-0161-b4780634-0000001dmyubc-team@interchange.ubc.ca&recurrenceId= Fri, 01 Jun 2018 10:00 PDT Fri, June 1, 2018 10:00 AM - 11:00 AM See description. $2 donation. The SHHS office invites you to the June Pit Stop! Faculty, staff and students are all invited to drop by for coffee and snacks and to mix and mingle with the SHHS Staff. <strong>Friday, June 1, 2018</strong> <strong>10:00 - 11:00 am</strong> <strong>Location: Purcell Terrace</strong> $2 donation to the United Way campaign. Theme: Garden Party If your department would like to host a Pit Stop please contact Lee Meehan, ODL/WRAP Admin Assistant <a href="mailto:lee.meehan@ubc.ca">lee.meehan@ubc.ca</a> Type - Information Session/Fair Good Things Happen: Communicating with Co-Workers for Positive Results! http://www.calendar.events.ubc.ca:80/cal/event/eventView.do?subid=-1&calPath=%2Fpublic%2FEvents+Calendar%2FPersonal+and+Professional+Development+%28Okanagan%29&guid=CAL-09d22401-6368fc1b-0163-6b480612-00000048myubc-team@interchange.ubc.ca&recurrenceId= Tue, 19 Jun 2018 09:00 PDT Tue, June 19, 2018 9:00 AM - 4:00 PM UBC Okanagan campus. Expand teamwork by creating a new level of team communication In this skill-building workshop designed specifically for you so that you will: 1. Gain insights about yourself and your co-workers 2. Recognize your blind spots 3. Develop skills to give clear effective feedback openly and candidly 4. Learn how you unwittingly sabotage your own efforts 5. Talk about the real issues – and not just what is on the surface 6. Use full, radical listening 7. Identify and eliminate the trigger words you use 8. Learn tools to avoid getting defensive 9. Practice giving and receiving feedback The workshop is open to all faculty and staff. To review your professional development fund requirements, please go to our website for Faculty and staff; M&P, BCGEU and EA. When: June 19th Time: 9am-4pm Where: EME 4218 Cost: $275 includes workshop materials, lunch and beverages This is a practical, easy to apply, highly interactive workshop. “Good Things Happen” applies powerful communication and influencing tools to your most critical, sensitive and important face-to-face conversations. You get the opportunity to practice your crucial conversations and receive specific, helpful feedback. This workshop gives you the versatility and the confidence to give feedback that increases clarity and improves understanding. About the Facilitator; Joyanne Landers has gained a solid reputation over the last twenty-five years as a facilitator and trainer. Her clients describe her as “dynamic”, “powerful”, and “thought-provoking.” She builds on her wide-ranging experience guiding leaders and employees in the public and private sectors throughout Canada to create shifts in the way they relate to their work and their colleagues. She stimulates participants to challenge their perceptions. Joyanne has the ability to lead workshops that are practical and easy to apply in real-world situations. Her plain talk, humour, and boundless enthusiasm are contagious.