UBCevents Calendar http://events.ubc.ca/welcome.html January 21, 2018 - April 3, 2018 21 Jan 2018 12:21: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-604b8cb5-0160-4cdc5488-00000014myubc-team@interchange.ubc.ca&recurrenceId= Wed, 24 Jan 2018 08:30 PST Wed, January 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> 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, January 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 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-604b8cb5-0160-4cf5d41a-0000001amyubc-team@interchange.ubc.ca&recurrenceId= Thu, 25 Jan 2018 08:30 PST Thu, January 25, 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, January 25, 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 PowerPoint 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-604655a2-0160-468b24d3-0000009bmyubc-team@interchange.ubc.ca&recurrenceId= Thu, 25 Jan 2018 08:30 PST Thu, January 25, 2018 8:30 AM - 4:30 PM See description. $149+tax. <strong>Power Concepts - This course is exclusive for UBCO faculty and staff and is limited to ten people.</strong> Learn PowerPoint's commands, functions, and capabilities and how to quickly create a powerful and compelling presentation. This course starts with strategies on how to very quickly outline and create the "story" and then to learn to present the information in creative, clear and professional increments. The course is suitable for users from limited to advanced experience with PowerPoint. The following list summarizes skills that students will be comfortable with after this course: - Strategies for how to structure and create a successful presentation - Format a presentation using Slide Masters - Customize presentation options and views - Set up and run a slideshow - Insert and format shapes and slides - Insert and format tables and charts - Insert and format images, media, and Smart Art - Insert hyperlinks, media clips and sound - Apply transitions and animations - Set timing for automatic transitions and animations - Manage multiple presentations - Presentation tools and annotations - Protect and share presentations - Create notes and handouts This course assumes that students have completed the Intro to Microsoft Office course or have equivalent knowledge and experience. <strong>Thursday, November 16, 2017</strong> <strong>8:30 am to 12:30 pm</strong> <strong>Power Concepts Office, 1855 Kirschner Road, Kelowna</strong> <strong>Cost $149 pp + tax</strong> <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 Hiring Student Staff 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-60c77c6e-0160-c8aa459e-00000038myubc-team@interchange.ubc.ca&recurrenceId= Thu, 25 Jan 2018 09:30 PST Thu, January 25, 2018 9:30 AM - 11:00 AM Administration Building. Information for administrators on how to plan for, hire, manage and end student positions. From creating a student position taking into account hours of work, pay and benefits and collective agreement implications to recruiting, onboarding and managing student positions with all required paperwork. Robyn Bunn, Student Experience Facilitator, will also present and answer your questions regarding the Work Study program. Administrative staff who are involved in hiring students will find this helpful, we welcome drop-ins during this sessions with any questions. Date/Time: Thursday, January 25, 2018 - 9:30 AM to 11:00 AM Location: Admin Building - ADM006A <a href="http://01.cms.ubc.ca/Page26239.aspx">Register here</a> Presenters: Ashley Bloor and Ruth Calnan For more information please contact Lisa Frost lisa.frost@ubc.ca or Ashley Bloor ashley.bloor@ubc.ca Lynda.com: Creating a Positive and Healthy Work Environment 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-606f93ff-0160-6ff8f702-0000000bmyubc-team@interchange.ubc.ca&recurrenceId= Mon, 05 Feb 2018 00:00 PST Mon, February 5, 2018 12:00 AM - 12:00 AM UBC Okanagan campus. Free. Toxic workplaces cost organizations money in the form of lost productivity, poor employee health, and, in extreme cases, lawsuits. HR consultant Catherine Mattice Zundel explains how companies that invest in a positive workplace can see an amazing return on their investment. If you have a negative workplace, you can turn it around by creating a vision for change—and a positive culture committee to help you deliver a new culture to your workforce. Catherine provides insight into conducting surveys and updating your performance management system, and offers tools such as a sample strategic plan and an exercise for creating core values. Topics include: •Defining a negative workplace •The ROI of a positive workplace •Conducting an employee survey •Creating a vision for change •Building a strategic plan •Using your performance management system •Leading change <a href="https://www.lynda.com/Leadership-Management-tutorials/Creating-Positive-Healthy-Work-Environment/624208-2.html?srchtrk=index%3a1%0alinktypeid%3a2%0aq%3aCreating+a+Positive+and+Healthy+Work+Environment%0apage%3a1%0as%3arelevance%0asa%3atrue%0aproducttypeid%3a2">Creating a Positive and Healthy Work Environment</a> Please visit the <a href="http://lynda.ubc.ca/">UBC Lynda.com</a> homepage for faculty and staff single-signon (CWL) access to <a href="http://www.lynda.com/">lynda.com</a> For more information on staff and faculty training please contact Lisa Frost, ODL Specialist <a href="mailto:lisa.frost@ubc.ca">lisa.frost@ubc.ca</a> MS Office Word Expert 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-604b8cb5-0160-4cf9135a-0000001emyubc-team@interchange.ubc.ca&recurrenceId= Thu, 08 Feb 2018 08:30 PST Thu, February 8, 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> Learn the full capabilities of Microsoft Word to create manuals, forms, and even desktop publishing. Learn time saving skills like mail merge, tracking changes and document protection. Learn how to create and manage work group templates that will help all the members of your organizational team save time by using standard forms and documents. The following list summarizes skills that students will be comfortable with after this course. - Merge letters, labels and email using data sources - Compare or combine documents - Insert, modify, or delete comments - Track revisions made by one or more people - Accept or reject changes made in a document - Manage passwords or restrict types of access on a document - Generate a table of contents or index in a document - Work with section breaks and different headers and footers - Use form fields - Learn the skills needed to manage large documents, including using the navigation pane The course assumes that students have completed the Word Core course or have equivalent knowledge and experience. <strong>Thursday, February 8, 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 Healthy Measures Assessments 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-606f93ff-0160-6fee9609-00000005myubc-team@interchange.ubc.ca&recurrenceId= Wed, 14 Feb 2018 09:00 PST Wed, February 14, 2018 9:00 AM - 5:00 PM UBC Okanagan campus. No Cost. Free and confidential service for faculty and staff. Health Assessments will be conducted by We Care Home Health Services with the assistance of UBCO Nursing students. Body Mass Index (BMI) and Fitness (MCAFT) Testing will be conducted by Human Kinetics students. Assessments will be scheduled every half hour, but please allow at least 45 minutes for your appointment. Dates: Wednesday, February 14, 2018 Times: 9:00 AM to 5:00 PM Location: UBCO GYM Upper Mezzanine No Cost <a href="http://01.cms.ubc.ca/Page20269.aspx">Book an Appointment</a> If you have any questions in regards to the assessments please contact Dianne DeJong, WRAP Office Administration, Dianne.dejong@ubc.ca, ext 78829 Type - Information Session/Fair MS Office Word Core 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-604655a2-0160-4689b691-00000097myubc-team@interchange.ubc.ca&recurrenceId= Mon, 19 Feb 2018 08:30 PST Mon, February 19, 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> Learn to get the most out of Microsoft Word. Learn time saving shortcuts for selecting, navigating and formatting and create professional looking business documents such as letters, forms, and newsletters in a fraction of the time. Participants will learn key functions for using documents to manage project notes, details of jobs, notices, contracts and other administrative requirements. The following list summarizes skills that students will be comfortable with after this course: • Create and format documents • Customize options and views • Configure documents for printing or saving • Insert and format Objects such as Shapes, Images and Smart Art • Create Multi-level and Bulleted lists • Utilize Page and Section Breaks • Create, edit and format Tables • Apply References such as Endnotes, Footnotes, and Citations • Use captions for pictures • Generate Table of Contents and Index • Create Quick Parts and manage Building Blocks This course assumes that students have completed the Intro to Microsoft Office course or have equivalent knowledge and experience. <strong>Monday, February 19, 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 Core 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-604655a2-0160-468a60ec-00000099myubc-team@interchange.ubc.ca&recurrenceId= Tue, 20 Feb 2018 08:30 PST Tue, February 20, 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> Learn to use Excel to create budgets, track costs and generate quotes. Learn tools and ideas that will save time and create professional looking proposals and plans. Participants with only a very basic knowledge of Excel will quickly progress to create basic databases, budgets, graphs, reports and the fundamentals of building equations. The following list summarizes skills that students will be comfortable with after this course: • Customize Excel options and views • Create and manipulate tables • Filter and sort data • Apply formulas • Use the correct syntax to insert functions • Create and format cells and ranges • Order and group cells and ranges • Apply cell ranges and references in formulas and functions • Summarize data with functions • Apply conditional logic in functions • Format and modify text with functions • Create and format charts and objects This course assumes that students have completed the Intro to Microsoft Office course or have equivalent knowledge and experience. <strong>Tuesday, February 20, 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 Outlook 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-604b8cb5-0160-4d0e8d92-0000003bmyubc-team@interchange.ubc.ca&recurrenceId= Wed, 21 Feb 2018 08:30 PST Wed, February 21, 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> Outlook is a key communication tool in most companies yet is commonly underutilized and a time hog with too much time spent just responding to email. Learn powerful organizational strategies that can change the way you work and save you hours of time every week. Learn to navigate quickly, and far less, through Outlook and how to create a powerful single page dashboard that will let you strategically manage all your appointments, tasks, email and follow-up calls on a single page. This course maps to the Microsoft MOS Exam. After reviewing all topics in the manual participants will be prepared to successfully write the Microsoft Office Specialist Outlook Exam. This course assumes that students have completed the Intro to Microsoft Office course or have equivalent knowledge and experience. https://www.powerconcepts.ca/Location/Okanagan/profilePage/ <strong>Wednesday, February 21, 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 BCGEU Professional Dev. Funding Meeting 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-6013076c-0160-136795ef-00000014myubc-team@interchange.ubc.ca&recurrenceId=20180221T170000Z Wed, 21 Feb 2018 09:00 PST Wed, February 21, 2018 9:00 AM - 10:00 AM Administration Building. The intent of the BCGEU Okanagan Professional Development Fund is to encourage and support employees to access learning activities that will enhance current job performance as well as to support skill development that may open up other career opportunities for transfer and promotion throughout the University. The BCGEU Professional Development Fund Committee meets to review applications. For additional information, see: http://hr.ok.ubc.ca/learning/profdevl/bcgeu_pd.html Outlook Strategic Management and One Note 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-604b8cb5-0160-4cc35dff-00000012myubc-team@interchange.ubc.ca&recurrenceId= Fri, 23 Feb 2018 08:30 PST Fri, February 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> Join them for a powerful session on how to use Outlook and OneNote to organize and manage all your tasks, meetings, reminders and emails. Tired of living in your Inbox? Maybe you shouldn’t be there. Learn how to create a powerful time management dashboard in Outlook that will show you that you need to do on one screen and allow you to manage your priorities and schedule. Learn key setting changes in Outlook and a handful of keyboard shortcuts that can eliminate 100’s of mouse clicks per day and keep you more focused on what is most important in your day and better manage and delegate work. You’ll also learn how to use Microsoft OneNote to organize, locate and share information. You will learn how to collect and organize notes, insert files, capture screens, and enhance your notes for all types of projects. You’ll learn how this tool automatically integrates with Outlook and can dramatically improve your ability to manage projects and collaborate with others. Tired of trying to keep track of meeting agendas and minutes? OneNote will change the way your team addresses the management of your meetings and simplifying the creation and sharing of agendas, minutes and tracking of action items that come out of all the meetings you attend. <strong>Friday, February 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 - 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-604b8cb5-0160-4cdd80e4-00000016myubc-team@interchange.ubc.ca&recurrenceId= Wed, 28 Feb 2018 08:30 PST Wed, February 28, 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, February 28, 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 Lynda.com: Business Etiquette: Meetings, Meals, and Networking Events 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-60510475-0160-5188656d-0000002dmyubc-team@interchange.ubc.ca&recurrenceId= Thu, 01 Mar 2018 00:00 PST Thu, March 1, 2018 12:00 AM - 12:00 AM UBC Okanagan campus. Free. Setting the right tone in business communications is essential to success in every career. Knowing the proper etiquette for many types of professional interactions can help you avoid conflict and foster healthy relationships with colleagues. In this course, productivity and etiquette coach Suzanna Kaye shows how to navigate common business situations with professionalism. Suzanna illustrates how to identify and work with different personality types, and how to understand body language and vocal cues. She also covers proper etiquette for various business situations, including in-person meetings, video conferences, business meals, and networking events. Along the way, Suzanna reveals some of the most common errors in etiquette, and shows how to handle conflict and difficult situations gracefully. <a href="https://www.lynda.com/Business-Skills-tutorials/Business-Etiquette-Meetings-Meals-Networking-Events/625906-2.html">Business Etiquette: Meetings, Meals, and Networking Events</a> Please visit the <a href="http://lynda.ubc.ca/">UBC Lynda.com</a> homepage for faculty and staff single-signon (CWL) access to <a href="http://www.lynda.com/">lynda.com</a> For more information on staff and faculty training please contact Lisa Frost, ODL Specialist <a href="mailto:lisa.frost@ubc.ca">lisa.frost@ubc.ca</a> 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-604b8cb5-0160-4cf6f4c3-0000001cmyubc-team@interchange.ubc.ca&recurrenceId= Thu, 01 Mar 2018 08:30 PST Thu, March 1, 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, March 1, 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 BCGEU Professional Dev. Funding Meeting 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-6013076c-0160-136795ef-00000014myubc-team@interchange.ubc.ca&recurrenceId=20180314T160000Z Wed, 14 Mar 2018 09:00 PDT Wed, March 14, 2018 9:00 AM - 10:00 AM Administration Building. The intent of the BCGEU Okanagan Professional Development Fund is to encourage and support employees to access learning activities that will enhance current job performance as well as to support skill development that may open up other career opportunities for transfer and promotion throughout the University. The BCGEU Professional Development Fund Committee meets to review applications. For additional information, see: http://hr.ok.ubc.ca/learning/profdevl/bcgeu_pd.html MS Office Word Expert 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-604b8cb5-0160-4cf9c942-00000020myubc-team@interchange.ubc.ca&recurrenceId= Wed, 21 Mar 2018 08:30 PDT Wed, March 21, 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> Learn the full capabilities of Microsoft Word to create manuals, forms, and even desktop publishing. Learn time saving skills like mail merge, tracking changes and document protection. Learn how to create and manage work group templates that will help all the members of your organizational team save time by using standard forms and documents. The following list summarizes skills that students will be comfortable with after this course. - Merge letters, labels and email using data sources - Compare or combine documents - Insert, modify, or delete comments - Track revisions made by one or more people - Accept or reject changes made in a document - Manage passwords or restrict types of access on a document - Generate a table of contents or index in a document - Work with section breaks and different headers and footers - Use form fields - Learn the skills needed to manage large documents, including using the navigation pane The course assumes that students have completed the Word Core course or have equivalent knowledge and experience. <strong>Wednesday, March 21, 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 PowerPoint 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-604655a2-0160-468bda77-0000009emyubc-team@interchange.ubc.ca&recurrenceId= Thu, 22 Mar 2018 08:30 PDT Thu, March 22, 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> Learn PowerPoint's commands, functions, and capabilities and how to quickly create a powerful and compelling presentation. This course starts with strategies on how to very quickly outline and create the "story" and then to learn to present the information in creative, clear and professional increments. The course is suitable for users from limited to advanced experience with PowerPoint. The following list summarizes skills that students will be comfortable with after this course: - Strategies for how to structure and create a successful presentation - Format a presentation using Slide Masters - Customize presentation options and views - Set up and run a slideshow - Insert and format shapes and slides - Insert and format tables and charts - Insert and format images, media, and Smart Art - Insert hyperlinks, media clips and sound - Apply transitions and animations - Set timing for automatic transitions and animations - Manage multiple presentations - Presentation tools and annotations - Protect and share presentations - Create notes and handouts This course assumes that students have completed the Intro to Microsoft Office course or have equivalent knowledge and experience. <strong>Thursday, March 22, 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> <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 Publisher 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-604b8cb5-0160-4cff767c-00000024myubc-team@interchange.ubc.ca&recurrenceId= Thu, 29 Mar 2018 08:30 PDT Thu, March 29, 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> The objective of this course is to introduce Microsoft Publisher commands, functions, and capabilities. It is designed for computer users who are new to desktop publishing who want to gain a thorough understanding of Microsoft’s desktop publishing package. This course assumes that students have completed the Intro to Microsoft Office course or have equivalent knowledge and experience. <strong>Thursday, March 29, 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 Lynda.com: Transitioning from Technical Professional to Manager 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-60510475-0160-518de4b8-00000030myubc-team@interchange.ubc.ca&recurrenceId= Tue, 03 Apr 2018 00:00 PDT Tue, April 3, 2018 12:00 AM - 12:00 AM UBC Okanagan campus. Free. All too often, professionals are given the opportunity to take on management responsibilities based on the strength of their technical skills. Managerial roles, however, depend on achieving results through others—which requires a significantly different skill set. In this course, leadership coach Sara Canaday helps you incorporate the right mix of functional and interpersonal skills to meet corporate objectives, build a high-performing team, and expand your impact as a leader. Sara shares how to make the shift to management by gaining insights on your leadership strengths and weaknesses while expanding your perspective to focus on team results. Her key topics include self-awareness, emotional intelligence, communication skills, relationship building, and group motivation. Topics include: • Moving from technical skills to relational skills • Becoming more self-aware • Communicating with greater impact • Moving from individual to team results • Broadening your perspective • Building productive and meaningful relationships <a href="https://www.lynda.com/Leadership-Management-tutorials/Transitioning-from-Technical-Professional-Manager/628687-2.html">Transitioning from Technical Professional to Manager</a> Please visit the <a href="http://lynda.ubc.ca/">UBC Lynda.com</a> homepage for faculty and staff single-signon (CWL) access to <a href="http://www.lynda.com/">lynda.com</a> For more information on staff and faculty training please contact Lisa Frost, ODL Specialist <a href="mailto:lisa.frost@ubc.ca">lisa.frost@ubc.ca</a>