Sign In

CPA Yukon PD - Excel: The Next Level of Skills

June 19, 2018 | 8:30am-4:00pm | Coast High Country Inn | 7 CPD Hours

Course Description

Level
Advanced.


Prerequisite
Intermediate knowledge of, and capability working with, Excel 2007 or newer.

Overview

It is time to take your Excel skills to the next level! Discover the best features and functions in Excel to make your accounting and finance tasks easier, faster and more accurate. This hands-on workshop will provide you with the skills for creating and editing macros, conditional formatting and data validation. Learn how to bring data into Excel from databases and use PivotTables for creating presentations in Word and/or PowerPoint. This seminar will cover many advanced features of Excel to make your work easier and increase the sophistication of your data analysis and reporting.

Who Should Attend
CPAs, students, and accounting and business professionals who want to learn advanced Excel features and functions, and their application to business.

Content

•   create Excel Tables and PivotTables for analysis and reporting

•   extract and manipulate data from data sets for PivotTables

•   ‘what-if’ analysis using Data Tables, Scenario Manager and Goal Seek

•   record and edit Macros with the Visual Basic Editor

•   integrate Excel with other Office programs such as MS-Word

•   consolidate data from multiple workbooks or worksheets

•   workbook sharing and collaboration with Office 365

     Special Notes
     This is a hands-on seminar. Attendees are required to bring their own laptop with Excel 2007 or higher installed.



Seminar Leader
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.


CANCELLATION AND CREDIT POLICY

Cancellations must be received in writing by emailing pdreg@bccpa.ca. Cancellations received at least 10 calendar days prior to the start date will be eligible for a full refund. Cancellations received less than 10 calendar days but more than 2 business days prior to the event start date are subject to an administration fee of $50. Cancellation requests received less than 2 full business days prior to the event start date will not be accepted - there will be no refunds or credits in this case. No shows - registrants who do not show up for the event will also not receive any refunds or credits.


When
6/19/2018 8:30 AM - 4:00 PM
Where
Coast High Country Inn 4051 - 4th Ave Whitehorse

Program


Tuesday, 19 June 2018

Description
Registration for Excel: The Next Level of Skills seminar
Time
8:30 AM - 4:00 PM
6/19/2018 8:30 AM