Topic: Accounting software training- peachtree,palladium, advanced excel,crystal report

Helo

Babatunde Ajala & Co. is a well established firm of chartered accountants providing auditing, taxation, business advisory and accounting software implementation and user training services to a wide range of businesses and individuals.

Listed below is the training scheduled to come up soon, you can refer to today's(11/10/11) Guardian Newspaper, page 24 for further information:

CRYSTAL REPORT- COURSE OUTLINES

Templates

When and Why to Group Rec
Formatting Part or All of an Object

Inserting Special Fields

Filtering Data with the Select Expert

Selecting Records with Multiple Criteria

Viewing and Editing the Select Formula

Case Sensitive vs. Case Insensitive

Record Selection Formula ords

Creating a Group

Group and Sort Direction

Customize Group Name Field

Modifying Groups

Creating Multiple Groups in a Report

Using the Group Tree to Navigate the Report

Reordering Groups

Sorting Records within a Group

Summarizing Groups

Additional Summary Options

Grouping Data in Date/Time Intervals

Calculating Percentages

Ordering Groups Based on Their Subtotals Using the Group Sort Expert

Understanding Tables, Records, and Fields

Learning about Linking

Adding Multiple Tables to a Report

Understanding Crystal Formula Syntax without Being a Programmer

About the Formula Workshop

Using the Formula Workshop

Using the Formula Editor

The Formula Editor Toolbar

Performing Simple Number Calculations

Manipulating Dates with Formulas

Creating Boolean (True/False) Formulas

Creating String Formulas

Using Bookmarks to Navigate Through Formulas

Database function

Financial Function

Conditional Formatting

The Highlighting Expert

Setting Highlighting Priorities

Formatting Sections

Formatting Sections Conditionally

Conditionally Formatting Fields

Creating a Summary Report

Applying the Drill Down Feature

Applying the Drill Down Group Level

Producing Charts

Editing Charts

Formatting Charts

Using the Chart Options

Modifying Individual Objects in the Chart

Using Auto-Arrange Chart

Applying Chart Templates

Understanding Export Formats and Destinations

Using an HTML Format for Crystal Reports

HTML Preview

Exporting to Windows Applications

Exporting to a Report Definition Format

Setting Default and Report Options

Setting the Default Layout for Design and Preview Views

What are the Report Wizards?

Create a Report Using the Standard Report Creation Wizard

The Data Dialog Box

The Fields Dialog Box

The Grouping Dialog Box

The Summaries Dialog Box

The Group Sorting Dialog Box

The Chart Dialog Box

The Record Selection Dialog Box

The Template Dialog Box

DATE :19-21 October,2011.
FEE :N35,000(Pay before date to enjoy 10% discount)
TIME:10:00am-4:00pm

INTER. & ADVANCED EXCEL FOR ACCOUNTANTS & TAX PRACTITIONERS

Explore the user Interface

Work with the Ribbon

Work with Contextual Tabs

Use the excel Galleries

Customize the Excel Interface

Absolute and relative cells

Protecting and un-protecting Worksheets and cells

Work with Comments

Access External Resources Using Hyperlinks

Writing conditional expressions (Using IF)

Using logical functions (AND, OR, NOT)

Using lookup and reference functions ( VLOOKUP,HLOOKUP,MATCH,INDEX)

Specifying a valid range of values for a cell

Specifying a list of valid values for a cell

Specifying custom validations based on formular for a cell

Designing the structure of a templates

Using templates for standardization of worksheets

Sorting and Filtering lists

Sorting data according to color

Using multiple-level sorting

Using custom sorting

Using advanced filter options

Creating subtotals

Multiple-level subtotals

Creating pivot tables

Formatting and customizing pivot tables

Using advanced options of pivot tables

Pivot chat

Consolidating data from multiple sheets and files using pivot table

Using external data sources

Using data consolidation feature to consolidate data

Data and time function

Text function

Database function

Financial Function

Using goal seek

Using data table

Creating and editing scenarios

Cell styles

Creating list using table

Formatting the structure of the list

Conditional formatting

Using forms to simplify data manipulation

Specifying criteria for finding records

DATE :27-29 October,2011.
FEE: N25,000(Pay b4 date to enjoy 10% discount)
TIME: 10:00am-4:00pm

T

PALLADIUM ACCOUNTING SOFTWARE & PEACHTREE ACCOUNTING SOFTWARE (COMBINED)
GENERAL COURSE OUTLINES
General Ledger
Learn how to create your chart of accounts, define account segments, enter your journal entries, and define your budgets.
Accounts Receivable
Manage your receivables by learning how to maintain customers, enter and adjust orders/invoices, apply customer payments, and print statements and other reports on receivable.
Accounts Payable
Learn how to manage your payables by learning how to maintain vendors, enter and adjust orders/invoices, select invoices for payment, and record manual cheques.
Inventory
Manage your inventory by learning how to maintain inventory, sell a stock item, and adjust inventory.
Payroll**
Learn how to maintain employees with individual payroll details and deductions, pay employees, and print pay advice.
** (For Peachtree only)
Bank Reconciliation
Learn how to record transactions and reconcile your bank account. You will also learn to correct an out-of-balance reconciliation.

DATE: 27-29 October,2011.
FEE : N35,000 (15% Disc 4 payment made b4 26/10/11)
TIME : 10:00am-4:00pm

NOTE :Materials and Lunch are inclusive in d fees.
Get trained today and avail yourself the opportunity of developing your full potential and becoming an expert in any of the accounting software listed above.We also provide Walk-In-Anyday Training.
Enroll now in an instructor-led training at our well-equipped IT training center.


Our firm currently deploys accounting software called ‘PALLADIUM’. Palladium operates seamlessly in the most challenging of environments, supporting from the simplest stand-alone system, to the local area network environment and full support for wireless networking technologies, right to the PaaS (Platform as a Service) offering. (3year money back on data corruption)

Read more on their website www.palladiumsoftware.co.za
For more information, contact
58A, Kudirat Abiola Way,
Oregun Ikeja,
Lagos,
Nigeria
Telephone
234 1 8937264
234-803-409-3675
E-mail
[email protected]
www.babatundeajala.com

Regards!

Kazal
tanx for the interest,financial modelling is part of advanced excel. So u can come for d advanced excel training on 27-29 oct,takia.