Accounting Course starting every Monday starting November 14,2016
Sales Ended
Accounting Course starting every Monday starting November 14,2016

Accounting Course starting every Monday starting November 14,2016

Event Information

Share this event

Date and Time

Location

Location

FITTS CANADA

301C - 3050 Confederation Pkwy

MISSISSAUGA, ON L5B3Z6

Canada

View Map

Friends Who Are Going
Event description

Description

SAP-FICO :

These courses comprised of practical training of SAP-FICO and MS Excel, designed as per Canadian corporate environment and after training enable you to work as General accountant. Major course feature include Excel-based financial modeling, SAP General Ledger, Receivable module, Payable module and Fixed assets module.

SAP-FI (Financial)

General Ledger

Chart of Account (COA)

Document inquiry

Account inquiry

Document entry

Reversing entry

Recurring entry

Assignment template

Accounts Receivable & Payable

Creating vendor/Customer

Document entry (Receipt & payment Vouchers & JVs)

Account Receivable & Payable queries

Debit/Credit memos

Special Ledger

Down payment

Clearing invoices

Reports

Account Receivable & Payable reports

Retrieving and modifying reports using Information

SAP-CO (Controlling) time

CONTROLLING

Cost element accounting

Cost center accounting (Cost center & Profit Center)

Cost center Analysis

Cost center reporting

Cost drivers

Office integration accounts

FIXED ASSETS

Create Asset

Acquisition and disposal

Asset Inquiry

Depreciation run

Settlement Run

CAREER SUPPORT

Provided under the guidance of an associated HR & recruitment company Talent factors

Resume upgrade

Interview preparation

Experience Exposure

Assessment support

Placement support

CORPORATE TAXES:

Individual Tax return T-1

Corporation tax returns T2

GST and HST returns

Depreciation and CCA

Communicating Revenue Canada

Excel Intermediate

Course Description

This course is instructor guided hands-on workshop based on 2010/2013 versions of MS Excel. You will learn how Excel helps Accountants, finance professionals and those interested in handling complex numerical data, involved in analysis and calculations to develop complex financial reports like Financial statements & budgets, manipulate data, prepared reports and help management decision-making

This course will teach you how to use:

Toolbars, Excel Icons, Navigation, and Excel Options

Functions like cell properties, insert rows and columns, Spreadsheet move and duplicate

Cut and copy functions

Paste special function

Transpose data in cell range

Excel formatting like merge cells, centralization and wrapping cell contents

Conditional Formatting

Insert comments in cells- Hide/Unhide/Print

Auto Sum and Excel formula writing

Absolute and relative cell reference application for formulas

Table

Go to functions

Print Layout and options

Find and replace cell contents

Using Data Filter and Advance Filter

Left, Right, Mid Functions

Concatenate

Sort Data and calculate Subtotal

Grouping of data

Formula Auditing for data verification

Linking and Edit Link

Excel Advanced

After attending this course you will become advance user of MS Excel 2010/2013, who can work with large set of data and develop complex interlinked reports using V-Lookup, Pivot tables and Macros

This course will teach you how to

Create data Validation rules

V-lookup

If Error Function

If and nested if functions, IFAND, IFOR functions

Sum if Functions

Data Text to Column and its use

Pivot Tables

Macros

Charts

File Protection

Name Range

Share with friends

Date and Time

Location

FITTS CANADA

301C - 3050 Confederation Pkwy

MISSISSAUGA, ON L5B3Z6

Canada

View Map

Save This Event

Event Saved