Course By
No Computers, No JOB?? Sohaib Jamal
(FCMA)
The Importance of computers in today’s business world is inevitable. Jobs market is saturating & it has
become difficult to get good jobs. Jobs requirements are changing & computer skills have become an
added value of any job beside academics. Most of our time in offices is spent in designing & printing
reports. In my 15 years career, I’ve trained thousands of professionals & university students & have
observed that their reporting skills are quite weak. Even if they’ve computer knowledge of certain level,
they are unable to apply this knowledge in their routine reporting. With 15 years of corporate experience
in management consulting, software designing & implementations & more than 100 workshops /
corporate trainings conducted, I’ve designed a course for students (especially of Finance domain) &
professional (who are on jobs) to become more productive & efficient by learning today’s top
requirements for any jobs.
The objective of this training would be
to make my participants “Master” in designing
Date: From 15th January till 10th Feb 2013 office reports in quick, efficient & flexible
manner using the above computer knowledge.
Therefore almost ALL of the business reports
Days: Sundays: (9AM-5PM) & From Tue Till Sat (6:30-9:30PM)
would used as practical in this training, for
example reports used in accounts, finance,
payroll, purchase, inventory, human resource,
Venue: Tabani’s School of Accountancy (TSA),
fixed assets, manufacturing etc. departments.
187-P, Block-2, PECHS, Karachi, Pakistan.
Opposite P.E.C.H.S Girls College
Most Important
I would be available for any guidance to each
Fee: Rs. 25,000 (100% Payable in Advance) participant after completion of training to
improve & automate their office reporting thus
Certificate would be awarded at the end of Training. improving their office productivity & efficiency.
This service would be free of cost.
Course Contents
MS Office Computerized Financial ERP Business Reporting
2010 Accounting Modeling Implementation Including Dashboards
Word 2010 •Review of Manual Accounting Part-A Developing Financial •Introduction to ERP Accounting
•Getting started •Computerized Accounting Vs Models Implementation •Monthly /Quarterly Trial
•Navigation & selection Manual Accounting •Overview •Concept & Scope of ERP Balances
•Editing & Formatting text •Accounting Transactions Cycles •Design Introduction •Emergence of ERP •PTD/YTD TB
•Tables & Page Layout •Financial Integration of •Features And Techniques •Advantages & Disadvantages •Financial Statements (PTD / YTD
•Proofing & printing docs Business Processes •Introduction To Excel •ERP Successful Factors etc.)
•Graphics & Styles •Non Financial Integration of •Built In Functions •ERP & BPR •Excel Based General Ledger
•Sections & columns Business Processes •Logic Building •ERP & Best Business •Reconciliation Reports
•Formatting tables •Introduction to Accounting •LOGIC QUESTION - 1 Practices •Financial Dashboards
•Printing labels & envelopes Information Systems •LOGIC QUESTION - 2 •Functional & Technical Inventory
•Templates & building blocks •Overview of Accounting •LOGIC QUESTION - 3 Consultant •Purchases (Date, Supplier, Item
•Graphics Software •LOGIC QUESTION - 4 •Scope In Pakistan & wise etc.)
•Managing docs revisions •Installation Instructions •Modeling Checklist Worldwide •Inventory Register with multiple
•Using Mail Merge •Application Interface •VBA •Organization Business reporting
•Objects & backgrounds •Creating/Maintaining •Auditing Toolbar Process Overall •Product Wise Reporting
•Working with forms Companies •Documentation & Testing •ERP & Accounting •Date Wise Inventory Register
PowerPoint 2010 •Understanding Menu’s and •Navigation •Computerized Accounting •Payment Ageing Schedule
•Getting started Areas •Security Cycle •Inventory Dashboards
•Formatting slides •Creating / Maintaining Chart of Part B APPLICATIONS •Introduction to ERP Apps Sales
•Working with graphics Accounts •Analysing performance •Introduction to General •Sales (Date, Customer, Item
•Using tables & charts •Creating / Maintaining •Cash flow Ledger wise etc.)
•Proofing & delivering PPT Inventory Items •Forecasting models •Features of ERP Apps •Sales Register with multiple
•Using graphics & multimedia •Creating / Maintaining •Forecasting financials •Application Implementation reporting
•Customizing SmartArt Customers •Variance analysis Methodology •Product Wise Reporting
graphics & tables •Creating / Maintaining Vendors •Breakeven analysis •Microsoft Project Planning •Date Wise Sales Register
•Action buttons, custom slide •Using General Journal Entry •Portfolio analysis •Configuration Document •Receipt Ageing Schedule
shows, & equations •Working with Customers related •Cost of capital •Budgeting Process •Sales Dashboards
•Distributing presentations transactions •Bonds •Sales Business Process Fixed Assets
•Integrating MS Office files •Working with Vendors related •Investment analysis •Production Business Process •Fixed Assets Register
Excel 2010 transactions •Risk Analysis & Management •Procurement Business •Depreciation Schedule
•Getting started •Year end Journal entries •Leasing Process •Category Wise Reporting
•Entering & editing data •Reporting •Company Valuation •Accounting Business Process •Lease Schedules
•Functions •Backing up and Restoring Data •Decision Trees (DuPont Ratio •Practical Implementation •Assets Dashboards
•Formatting & Printing •Setting up users and Password Analysis) Human Resource
•Charts & Graphs for closing •Revision •Personal Reporting
•Using multiple worksheets & •Department Wise Reporting
workbooks •Payroll Calculations
•Advanced formatting •HR Dashboards
•Outlining & subtotals
•Cell & range names •And Lots of Other Reportings
•Documenting & auditing
•Templates & settings
•PivotTables & PivotCharts
•Lookups & data tables
•Advanced data management
•Exporting & importing
•Macros & custom functions
