7:30 Registration 8am Breakfast Seminar: Creating a Workplace to Attract and Retain Employees Gerald Walsh
In this thought-provoking presentation, Gerry tackles the most pressing business challenge facing employers today: how to get and keep good employees. The most troubling news for employers is that a growing labour shortage, shifting demographics, an improving economy, and changing attitudes toward work, means this problem is not likely to get better anytime soon. But why do certain companies succeed in hiring and keeping talented employees while others struggle with that same task? Drawing upon his own unique experiences recruiting for leading employers as well as studying the ‘best practices’ of some of North America’s most-respected employers, Gerry delivers a powerful and clear answer to this question: the RESPECT Workplace Model, a series of employee-focused workplace strategies that will help employers gain a competitive advantage in this war for talent. Many employers use compensation as their principal tool to influence the recruitment and retention of employees. However, Gerry’s RESPECT Workplace Model suggests that offering money alone is not the best answer. Rather, a combination of tools should be used including: employee recognition programs, meaningful work, life-work balance, corporate social responsibility, a commitment to the environment, professional development, personal well-being initiatives, as well as money. Using clear examples of both good and bad practices, Gerry challenges the audience to think strategically about their own recruitment and retention activities, and offers practical and simple advice on how to overcome today’s most pressing business problem.
9am – 5pm Pivot Tables, Macros Functions and Best Features in Excel CTC TrainCanada
- Creating Formulas with cell references
- Utilizing Functions to avoid complex math
- Copying formulas/functions with relative vs. absolute cell referencing
- Consolidating data using formulas across multiple worksheets
- Consolidating data using formulas across multiple workbooks (files)
- Defining and utilizing range names
- Creating charts (graphs)
- Securing cells, worksheets, workbooks and files
- Grouping multiple worksheets for printing, copying and moving
- Parsing data in a single column into multiple columns
- Sorting data
- Filtering data
- Subtotaling data
- Doing high level summary analysis of data (with drill-down capability)
- utilizing pivot table
- Repurposing Excel data in Word and PowerPoint
- Auditng (tracing formula dependencies) and Error Tracing
- Data validation (to control data entry into cells)
- Using a Macro to automate repetitive actions
- Scenario manager for 'what if' analysis
9am – 12pm Risk Management – Bob Forsyth
This is a half day seminar intended to cover risk assessment and management. We will look at the topic both as a theoretical concept and from the point of view of a larger organization. The seminar leader has conducted risk assessment reviews for a number of organizations, including an international bank, a large educational institution and several governmental organizations. In addition, he has taught seminars on risk mitigation. Who should attend? CGAs who are responsible, directly or indirectly, for organizations that have exposure to risk, in one form or another will find this useful to help identify, assess, mitigate and manage potential problems. Public practitioners will be able to help their clients understand as well as manage risk in their businesses. How you will benefit: - Understand the concepts of the risk field.
- Work through the definitions, theory of risk management and methodology.
- Review strategies to cope with the uncovered risks.
- Work on case studies.
12:15 - 1:15 Social Lunch 1:15-5:00pm Pivot Tables, Macros Functions and Best Features in Excel Continued 1:15 – 5:00 pm Estimating Revenue and Expenditures - Bob Forsyth
What happens when we need to use accounting data, but it is incomplete, inaccurate or undependable? This is a half day seminar is designed to assist you in assembling, assessing and using better estimates of revenues and expenditures. (Please note this is not a seminar on projecting revenues and expenditures – future oriented – but rather establishing what revenues and expenditures were in the past) Although some of the approaches and methodology come from forensic accounting, the techniques taught here have applications in: tax; audit; controllership and financial analysis. Who should attend? CGAs, students and colleagues who may have to use incomplete accounting information to make decisions or give advice to others concerning imperfect data. What You Will Learn: - How to establish revenues and expenses for income tax and/or HST purposes.
- Evaluating accounting data and assertions for reviews and audits.
- How to help clients who have litigation-type matters such as: insurance claims; child and spousal support; shareholder or partnership disputes; or business acquisitions.
- How to research and document multiple estimates of revenues or expenditures where no single approach is suitable.
5:30 PA1 & PA2 Candidates’ Workshop The presentation will cover the basic issues related to the PA1 and PA2 examinations and will cover: • Overview of professional applications exams • Difference between PA1 and PA2 • What is competent? What is a competency? • How PA is evaluated • How to read a case question • Tips for case analysis
7:00pm AGM, World Trade Convention Centre 9:00pm Hospitality Suite (Prince George Hotel)
|