PACEM GROUP Profit and Growth Expert
Pacem Accounting and Businesss Advisory Consulting Inc.
Pacem Professional Bookkeeping Services Inc.
Pacem Digitize Records Solutions Inc.
Accuracy, Integrity and Personal Services are our Principles, we have built our business on.
Phone No. 647-622-3233
OUR TRAINING PROGRAMS
We don't teach you from Text Book but share with you actual Office' s operations and management's expectation.
Quickbooks Practical Bookkeeping
Basic Level (Job Purpose):
​
Suitable for Jobs, like Accounts Payable, Accounts Receivables, Reconciliation and/or Payroll for Small Business Corporations. This practical training is best for all students looking for a job or existing job holders want to grow in this field and become full cycle bookkeeper
This training is completed in 4-5 sessions each max 2 hours. All the 4 modules is covered in this training:
​
-
Account Payable,
-
Account Receivable,
-
Payroll,
-
Bank Reconciliation and
-
Filing HST and payroll taxes
-
Year-end adjustment & Reports
​
​
Intermediate Level - Self Employed (owners):
​
Suitable for self-employed for bookkeeping of your own business. After our practical Training, you can manage your business including filing HST, Payroll and WSIB without the help of Bookkeeper.
​
This training is completed in 6-7 sessions each max 2 hours. All the modules stated in the Basic Level is covered in this training in details. In addition, the process and procedures for HST, Payroll Tax, WSIB filing and year-end adjustment is also covered in this training. Help after the training is provided.
Expert Level-(Bookkeeper):
​
Expert Level Training is best for those who want to start bookkeeping business part time or full time under our Supervision or independently. This training is completed in 9-10 sessions covering both Basic and Intermediate Levels and after our practical training, you can operate as a full cycle Bookkeeper for any Corporation operating in any business.
Note: All training are delivered on a one to one basis. Phone call help is also made available to trainees for 6 months.
Advance Excel for Financial Analysts
This Advance Excel training is suitable for the graduate looking for a job as a financial, accounting, business and data analysts in large corporations including banks and existing job holders want to grow in this field. We share with you our industry-specific experience.
​
The Advance Excel training covers the following in Detail:
​
1st SESSION
Introduction to Excel Ribbon - Insert Row, Column, copy/mover worksheet, - Merge cell, wrap text, find & replace, insert comments - Grouping - Transpose - Text to Columns - Concatenate, Ampersand, Trim - Left, Right, Mid Functions - Sort, Filter, Advanced Filter - Unique Value - Sub-total, Copy visible Cell only - Absolute and Relative $ signs - Name Range and Table - Direct and Indirect Data Validation and Dynamic
2nd SESSION
Sum-product function - Count-IF and Count-IFS functions - Sum-IF and Sum-IFS functions - Average, Average-IF and Average IFS Functions - If functions - IF(AND) Function - IF(OR) Function - IF Nested Function
3rd SESSION
Vlook-up Exact Match - Vlook-up Approximate Match - If error and Vlook-up - Vlook-up with data validation, name range, LRM - Nested Vlookup - Vlookup with column reference
​
4th SESSION
Pivot Functions and Ribbons - Pivot with Name Range - Pivot with Table - Pivot with formula field and items - Pivot reconciliation - Pivot from Multiple Sheets or Files - Consolidated sheets
​
5th SESSION
Link and edit Link - Macros absolute and relative - Conditional Formatting - Date and Time Functions - Print and Layout options
​
6th SESSION
Goal Seeking - Scenarios - Chart simple and dynamic - File, Cell and Formula Protection' - Formula Auditing
​
Data for preparing reports from large data and using the advance excel skills and techniques is provided for practice purpose only.
Practical Accounting
& Bookkeeping
Mastering Basic Practical Accounting:
​
This training is designed for those who want to refresh their accounting knowledge or those who want to learn the Accounting first time.
​
The training is completed in 06 sessions, each max of 02 hours. The contents covers, basic rules of Debit & Credit, Ledger, Trial Balance, Balance sheet, Profit & Loss Account etc.
Mastering Practical Bookkeeping of Small Business Corporations:
​
​
​
Are you thinking of starting a bookkeeping business, but do not know where to look for training. We are here to train you in Practical Bookkeeping for Small Business for all kinds of Corporations.
This training consists of Practical Accounting and Expert Level Quickbooks. We also cover in the training how to market your clients and pricing.
​
We cover all the three levels of Quickbooks training and also share with you our practical tips and techniques which are not written in books.
