Annual Conference 2022

Home > Annual Conference 2022

Annual Conference 2022

Thank you to all who attended the Annual Conference 2022. To view more on this conference, see our list of presentations below.

 

Stay informed about our next Annual Conference in 2023 by visiting us on Facebook.

Presentations from the Annual Conference 2022

Wednesday, November 23, 2022

1:00-1:30pm
Community Financial Review Process
Michelle Richard
Ulnooweg

1:30-2:00pm
AFOA Canada Update
Terry Goodtrack
AFOA Canada

2:00-2:45pm
Considerations for Managing Remote Workers
Detry Carragher

9:15-10:00am
Asset Management
Matt Delorme
Ex. Director, AIM Network

10:00-10:45am
How Cohorts can be set up in the Communities
Mary Beth Doucette
CBU

11:00-12:00pm
CMHC
Keith Kelly
CMHC

Thursday, November 24, 2022

10:45-11:45am
Audit Preparation
Sarah Doyle
Sr. Op. Officer, Abeqweit First Nation

10:00-10:30am
ISC
Paula Chabassol
A/Manager, Transfer Payment Management Services, ISC

9:15-10:00am
Psychological Health and Safety in the Workplace
Detry Carragher

CALLING ALL FINANCE EMPLOYEES, HUMAN RESOURCES MANAGERS AND PUBLIC ADMINISTRATION STAFF IN THE ATLANTIC REGION!

The AFOA Atlantic Annual Conference is happening November 23-24, 2022 in Halifax NS! This free conference is a fantastic way to get up to speed on the latest updates.

It’s also a great time to catch up with fellow professionals, share success stories and best practices and ask questions from the people involved in our regions departments and professional services fields.

Venue:

Prince George Hotel – 1725 Market Street Halifax, Nova Scotia, B3J 3N9

Times:

Day 1 – Starts at 9:00am on November 23 until 4:30pm (AST)
Day 2 – Starts at 9:00am on November 24 until 12:00pm (AST)

For hotel booking information:

https://reservations.travelclick.com/13608?groupID=3648710

Thank you for your interest. Our ticket sales have ended. If you have further questions, please contact Jennifer Martin:

jennifermartin@afoaatlantic.ca

Pre-conference Workshop

Excel – Fundamentals for Financial Reporting

Part 1 – General overview

  • General overview of Ribbon and how to customize
  • Copy and paste options
  • Format painter
  • Formatting options, wrap text, merge and center, indents
  • Number formatting
  • Page Layout
  • Conditional Formatting with exercise
  • Find & Select with exercise

 

Part 2 – Formulas

  • Most common formulas and their uses – with mini exercise
  • Review categories of formulas with exercise
  • Flashfill and series
  • Naming cells and sheets
  • Error checking and watch window

 

Part 3 – Tables and sorting data

  • Creating tables and sorting data with exercise
  • Tables to charts with exercises
  • Adding formulas to tables
  • Basic pivot table

 

Part 4 – Saving and exporting

  • Review of File menu
    • Locking worksheets
    • Adding comments
    • Tracking changes
  • Saving as PDF
  • Printing options
  • Saving best practices

Financial Reporting Under the Financial Administration Law

Tara White, Senior Capacity Development Manager, FNFMB

Amanda Peters, Capacity Development Manager, FNFMB

 

We will review the following aspects of Financial Reporting for First Nation communities under the Financial Administration Law. This reporting is also considered best practice for those who do not have a Financial Administration Law. Included we will review the importance of and how to structure monthly, quarterly and annual financial reporting to Council. We will also talk about who is using the financial statements and what they are used for as well as understanding the audited financial statements.