Clients

Health Canada

Justice Canada 

House of Commons

Town of Banff

Ministry of Finance (Ontario)

Auditor General of Canada

Agriculture and Agri-Food Canada

Royal Canadian Mounted Police

Alberta Health and Wellness 

Environment Canada

City of Dawson Creek

Ministry of Attorney General (British Columbia)

City of Mississauga

Fisheries and Oceans Canada

Ministry of Government Relations (Saskatchewan)

Public Works and Government Services

Bank of Canada

Canada Border Services Agency

New Brunswick Internal Services Agency

Industry Canada

Service Alberta

Canada Revenue Agency

City of Burnaby

National Research Council

City of Regina

Canada Mortgage and Housing Corporation

Ministry of Transportation (British Columbia)

Manitoba Agriculture

Correctional Services Canada

Atlantic Canada Opportunities Agency

County of Peterborough

New Brunswick Power

Elections Canada

Finance Canada

Manitoba Environment

Global Affairs

Infrustructure Canada

Canadian Food Inspection Agency 

 National Energy Board

Ministry of Agriculture (British Columbia)

New Brunswick Police Commision

Canadian Transportation Agency

Ministry of Government Services (Ontario) 

Department of Health (New Brunswick)

National Capital Commission

Parks Canada

Privy Council Office

City of Red Deer

Veterans Affairs

Western Economic Development

 Sustainable Resource Development (Alberta)

Ministry of Attorney General (Ontario)

Powell River Fire Rescue

Publc Health Agency of Canada

Royal Canadian Mounted Police

Canadian Forces

Canadian Space Agency

Canadian Environmental Assessment Agency

Transport Canada

Ministry of Aboriginal Affairs (PEI)

Service Ontario

Parole Board of Canada

Enterprise Saskatchewan

Treasury Board Secretariat Canada

Alberta Health Services

 Service Canada

Shared Services Canada

City of Prince George

Ministry of Environment (Ontario) 

Canadian International Development Agency

Legislative Assembly of Alberta

 Office of the Commissioner of Lobbying

Canadian Coast Guard

 Department of Natural Resources (Nova Scotia)

 Grey Bruce Health Unit

Ministry of Forests and Range (British Columbia)

Government of Newfoundland

Infrastructure Canada

Ministry of Education (Ontario)

BC Assessment

Canada Border Services Agency 

Alberta Liberal Caucus

  Department of National Defence 

Alberta Employment and Immigration

Parksville Fire Department

Ontario Victim Services Secretariat

Abbotsford School District

Ministry of Highways and Infrastructure (Saskatchewan)

Regional District of Okanagan

Infrastructure Ontario

Citizenship and Immigration Canada

New Brunswick Securities Commission

Saskwater

Financial Services Commission of Ontario

Ministry of Northern Development and Mines (Ontario) 

Metrolinx

Statistics Canada

Transport Canada

 Ministry of Community and Social Services (Ontario)

Legislative Assembly of BC

 Labour Relations and Governance (Ontario)

Ministry of Aboriginal Affairs (Ontario)

Strathcona Regional District

Department of Health (New Brunswick)

Red Deer County

Nova Scotia Gaming Commission

City of Vancouver

Advanced Microsoft Excel Course

Time: 9:00 am -- 3:30 pm (Group registrations may arrange any suitable date and time)


Cost:$ 474.00



Group Cost: $ 2,774.00



Summary:

Excel Formulas and Functions -- The objective of the module is to help students grasp the structure, or 'grammar', of common and powerful functions. This enables students apply that grammar to the functions they use on the job, making it easier to learn new functions on their own. 

  • Formulas and functions basics
  • Review of basic formula & function construction
  • Working with Relative Addressing and Absolution References
  • Understanding Order of Operations
  • Using the Function Library
  • Understanding Array formulas
  • Using IF functions
  • Building an automatic Subtotal Report
  • Using the IF variants of common functions: SUMIF, COUNTIF, AVERAGEIF to build a manual subtotal report
  • Working with Date and Time functions    

Pivot Tables and Database Functions -- The focus of this module is on using Excel to maintain lists of records – sorting and filtering, controlling data accuracy and using the data to generate reports and interactive analysis tools. 

  • Working with Excel lists and tables
  • Converting a list or range to an Excel Table
  • Using the Total row
  • Removing duplicate records
  • Sorting and filtering a table
  • Formatting a table
  • Understanding and building pivot tables
  • Deciding when and how to use a Pivot Table to analyze data
  • Editing an existing Pivot Table
  • Creating a Pivot Table from scratch
  • Manipulating data in a Pivot Table
  • Working with Data Validation Rules to create database consistency
  • Using database functions and Advanced filter tools 
 Who Should Attend:

Public servants at all levels who wish to advance their strategic Excel skills.

In this information-packed course you will learn:
 
The key Excel skills to be taught are outlined above. 
 
Instructor:

Laurie has trained over 10,000 students over the past twenty years. She is a highly-experienced educator and trainer with a strong background in computer training and the author of over 30 best-sellling instructional books on computers and software.  

Olivier is a computer science specialist with a Microsoft Office Specialist Master Certification (Excel, Word, Outlook and PowerPoint).  He has a passion for teaching and conveying knowledge. Olivier understands the distiction between important features that are useful in a government environment as opposed to mere counterproductive accessories.  He is a computer science graduate of the University of Technology (France).

 How to Attend:

Prior to the session, you will receive simple login instructions.  

An Individual Annual Training Pass for all courses can be purchased for $974.00.  A One (1) Year Unlimited Office Training Pass may be purchased for $4,200 for up to 10 employees,  $7,400 for up to 25 employees and $11,700 for up to 50 employees  (for larger department discounts, please contact us at 1-888-764-1542).  

Clients   |   Privacy Notice  |   Refund Policy  |   Code of Ethics   |   FAQ   |   Contact Us