May 26, 2018
Summer is almost here. Join us on May 26th to increase your productivity in using Microsoft Excel and Outlook so that you can enjoy more time in the outdoors.
||Saturday, May 26, 2018|
|Time:||8:00 AM – 09:00 AM Registration and Breakfast | 9:00 AM – 12:30 PM Session|
|Location:||Executive Airport Plaza Hotel, 7311 Westminster Hwy Richmond, BC
|Cost:||$80 – (Regular) | $75 – (Early bird discount – until April 30, 2018)|
|Parking:||Complimentary Parking provided by the hotel (We will be sending out a parking pass prior to the event)|
|To Register:||Click here to register|
| Who Should Attend
Managers and owners of professional services and practice firms, or any private enterprises looking to increase their productivity and effectiveness Microsoft Office.
This session will start off by learning Excel Shortcuts and tips and tricks on how to improve your day to day productivity. Some of the topics presented include navigation shortcuts, manipulating text and date values, date validation and customized sorting. Whether you are new to Excel or an experience user, Functions and Formulas are likely something you deal with everyday, we will cover the many common ones used by accounting and financial professionals with a focus on taming IF statements and getting the most from lookup and data functions. The session will also assist on how to deal with misbehaved formulas, what to do when we aren’t getting the expected results and take a look at the tools available that can help fix any problems.
Microsoft introduced their Power Tools – PowerQuery, PowerPivot, PowerView starting in Excel 2013. Let’s see what these Power Tools do and why more and more accounting and financial professionals are adding these skills to their reporting toolbox.
Many of us spend a good part of our day dealing with emails. Let’s take a look at how we can better manage Outlook to be more productive in our day. We will dive into many features of Outlook – calendars, tasks, contact lists, appointments and see how to better use them to manage our time and commitments.
You are welcome to bring your laptop to follow along. Please ensure your laptop is fully charged as power is not available at the tables. Please also note there will not be any assistance available during the presentation.
Speaker: Richard Jang BCOM, MCP, CPA, CGA
RICHARD JANG, BCom, DipIT, MCP, CPA, CGA, is a member of the Sage Software Product Design team working on accounting and business management software. His focus includes reporting, business analytics and intelligence, helping companies in North America and internationally become more productive with information technology. He has presented multiple technical sessions at corporate conferences in the U.S. and overseas.