Topic: Sage 50-peachtree&advanced excel and access training -may-august 2016

ELDEMUZ ENGINEERING CONSULTING IS A registered LOCAL CONTENT PARTNER with the federal government of Nigeria IN CAPACITY DEVELOPMENT for the oil and gas industry. We offer training to, consultant, engineers, managers, senior and junior staff in the oil and gas industry as well as fresh graduates and focused undergraduates. Our interest is for those pursuing excellence and improvement in their career. Our work force is made up of young Nigerian engineering graduates who have acquired software skills through the PTDF scheme. Our goal is to transfer knowledge at its best. The software’s we offer are used mostly by SHELL, MOBIL, SCHLUMBERGER, TOTAL, ELF, AGIP,chevron, AND other major oil companies in Nigeria.we have experience in training and field operations.we have evolved over the years to be a brand name in oil and gas training and other computer based courses.enrol today.

TRAINING BROCHURE







SAGE 50 AND PEACHTREE ACCOUNTING EACH- 5 DAYS





ADVANCED EXCEL 15DAYS







SAGE 50/PEACHTREE

Session 1 Introduction and initialization, setting your preferences and security

? Session 2 Using the Charts of Accounts and Nominal Codes

? Session 3 Setting up Customer and Supplier records

? Session 4 Creating and Processing Sales Invoices, Processing Purchase Invoices

? Session 5 Processing Customer Receipts and Supplier Payments

? Session 6 Processing Bank Payments and Receipts, Petty Cash, Transfers

? Session 7 Prepayment, Accruals, Month End, Nominal Reports and Trial Balance

? Session 8 Completing your VAT return, Management Reports and Audit Trail





Comprehensive Microsoft Excel 2013



Class Description (comprehensive)

Class Overview

On the first day of this comprehensive Microsoft Excel 2013 training course, students will learn to use Excel 2013 to create, modify, and format Excel worksheets, perform calculations, and print Excel workbooks. The second day of class will focus on using advanced formulas, working with lists, working with illustrations and charts, and using advanced formatting techniques. And on the third, fourth and final day of class, students will learn to work with pivot tables, audit worksheets, work with data tools, protect documents for collaboration with others, and work with macros.

This Comprehensive Microsoft Excel 2013 Training class is a combination of the following courses:



Introduction to Microsoft Excel 2013 Training

Intermediate Microsoft Excel 2013 Training

Advanced Microsoft Excel 2013 Training





Class Goals





Create basic worksheets using Microsoft Excel 2013.

Perform calculations in an Excel worksheet.

Modify an Excel worksheet.

Modify the appearance of data within a worksheet.

Manage Excel workbooks.

Print the content of an Excel worksheet.

Learn to use formulas and functions.

Create and modify charts.

Convert, sort, filter, and manage lists.

Insert and modify illustrations in a worksheet.

Learn to work with tables.

Learn to use conditional formatting and styles.

Create pivot tables and charts.

Learn to trace precedents and dependents.

Convert text and validate and consolidate data.

Collaborate with others by protecting worksheets and workbooks.

Create, use, edit, and manage macros.

Import and export data.







Class Outline





Creating a Microsoft Excel Workbook

The Ribbon

The Backstage View (The File Menu)

The Quick Access Toolbar

Entering Data in Microsoft Excel Worksheets

Formatting Microsoft Excel Worksheets

Using Formulas in Microsoft Excel

Working with Rows and Columns

Editing Worksheets

Microsoft Excel 2013 New Features 1

Advanced Formulas

Working with Lists

Visualizing Your Data

Working with Tables

Advanced Formatting

Microsoft Excel 2013 New Features

Using Pivot Tables

Auditing Worksheets

Data Tools

Working with Others

Recording and Using Macros

?



Contact& TRAINING BATCH START DATES;

Each of the programs below fit into this schedule call us to enroll

MAY 2016-AUGUST 2016

MAY 2016

MONDAY -2ND MAY

----------- 16<sup>TH MAY

------------30TH MAY2016

JUNE 2016

-----------7TH JUNE 2016

-----------14TH JUNE

MONDAY -27TH JUNE 2016

JULY 2016

MONDAY-4TH JULY 2016

MONDAY-11TH JULY 2016

MONDAY -25TH JULY 2016

AUGUST 2016

MONDAY -1TH AUGUST 2016

MONDAY 8TH AUGUST 2016

MONDAY-29TH AUGUST 2016.



Contact;

Telephone -,08038812638,07051852201,08064673745

Email;[email protected],[email protected]



Office address-Eldemuz engineering centre,

1st floor ,60 Aba road ,by craft centre busstop ,portharcourt,

Rivers state, Nigeria</sup>

08038812638