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!
