QUICKBOOKS ACCOUNTING SOFTWARE
CREATION OF A NEW COMPANY FILE
- Using a default sample Industry.
- Create a new company from Scratch.
NAVIGATING AROUND QUICKBOOKS
- Over view of the menu
- Homepage
- Icon Bar
MAINTAINING THE CHART OF ACCOUNT
- Numbering of Accounts (Accounts codes)
- Adding/Editing/Deleting
- Creating Sub Accounts
- Enter G/L beginning balances.
MAINTAINING BUDGETS
- Building/Maintaining budget
MAINTAINING INVENTORY
- Adding/Editing/Deleting Accounts.
- Entering beginning/Opening Quantity of Inventory.
ACCOUNTS RECEIVABLE
Learn how to Manage your receivables by learning how to:
- Maintain Customers
- Enter and adjust orders
- Credit Sales
- Cash sales
- Sales Returns
- Apply customer payments (Receipts)
- Print statements and other reports on receivable
ACCOUNTS PAYABLES
Learn how to Manage your accounts payables by learning how to:
- Maintain Vendors
- Enter and adjust Local purchase orders
- Cash purchases
- Credit purchases
- Select Suppliers invoices for payments
- Purchases Returns
- Record manual Cheques
- View and print reports on accounts payables
INVENTORY ACTIVITIES
Manage your inventory by learning how to:
- Inventory Adjustment
- View and print inventory report.
GENERAL JOURNAL AND OTHER TASK
- General Journal entries.
- Using the account Register.
- Bank Reconciliation.
UTILITY
- Setting users Passwords/Access Rights
- Backing up QuickBooks Accounting file.
- Restoring QuickBooks company file.
- How to export to excel and import list.
SAGE 200 ACCOUNTING
CREATION OF A NEW COMPANY DATA BASE
- Using a default sample Industry.
- From an existing company Database.
- Logging into Sage200.
NAVIGATING AROUND SAGE 200
- The menu.
- The system Tree.
- Working with Records.
- Producing Reports.
MAINTAINING THE CHART OF ACCOUNT (GENERAL LEDGER)
- Default setting of the General Ledger
- Numbering of Accounts (Accounts codes)
- Adding/Editing/Deleting
- Creating sub Accounts.
- Enter G/L beginning balances.
MULTI-CURRENY
- Maintain Currencies and their Exchange rates
- Assign currency to a customer or supplier
- Generate report.
MAINTAINING BUDGETS
- Building/Maintaining budget
MAINTAINING INVENTORY
Default setting of Inventory.
- Creating multiple warehouses.
- Adding/Editing/Deleting Accounts.
- Entering beginning/Opening Quantity of Inventory.
ACCOUNTS RECEIVABLE
Learn how to Manage your receivables by learning how to:
- Maintain Customers
- Enter and adjust orders
- Credit Sales
- Sales Returns
- Record Customers Receipts
- Print statements and other reports on receivable
ACCOUNTS PAYABLES
Learn how to Manage your accounts payables by learning how to:
- Maintain Vendors
- Enter and adjust Local purchase orders
- Credit purchases
- Apply Payments to Suppliers invoices.
- Purchases Returns
- Record cashbook payments.
- View and print reports on accounts payables
INVENTORY ACTIVITIES
Manage your inventory by learning how to:
- Inventory Adjustment
- Transferring inventory from one warehouse to another.
- View and print inventory report.
GENERAL JOURNAL AND OTHER TASK
- General Journal entries.
- Posting Cash expenses.
- Bank Reconciliation.
FIXED ASSETS
- Fixed Assets Overview
- Setting up Fixed Assets
- Fixed Assets Maintenance
- Fixed Assets Processing
- Fixed Assets Reporting
UTILITY
- Backing up SAGE 200 Accounting file.
- Restoring SAGE 200 company file.
- How to export to excel and import list.
- Setting users Passwords/Access Rights
SAGE 50 ACCOUNTING
CREATION OF A NEW COMPANY FILE
- Using a default sample Industry.
- Create a new company from Scratch.
- From an existing company File.
NAVIGATING AROUND SAGE 50
- Over view of the menu
- Navigation Bar
- Navigating inside each center
MAINTAINING THE CHART OF ACCOUNT
- Numbering of Accounts (Accounts codes)
- Adding/Editing/Deleting
- Enter G/L beginning balances.
MAINTAINING BUDGETS
- Building/Maintaining budget
MAINTAINING INVENTORY
- Adding/Editing/Deleting Accounts.
- Entering beginning/Opening Quantity of Inventory.
ACCOUNTS RECEIVABLE
Learn how to Manage your receivables by learning how to:
- Maintain Customers
- Enter and adjust orders
- Credit Sales
- Cash sales
- Sales Returns
- Apply customer payments (Receipts)
- Print statements and other reports on receivable
ACCOUNTS PAYABLES
Learn how to Manage your accounts payables by learning how to:
- Maintain Vendors
- Enter and adjust Local purchase orders
- Cash purchases
- Credit purchases
- Select Suppliers invoices for payments
- Purchases Returns
- Record manual Cheques
- View and print reports on accounts payables
INVENTORY ACTIVITIES
Manage your inventory by learning how to:
- Inventory Adjustment
- View and print inventory report e.g. Profitability reports, stock valuation reports etc.
SETTING UP PAYROLL AND EMPLOYEES
- Introduction
- Entering Payroll Default
- Entering Employee Defaults
- Adding Employees
- Processing Payroll
- Printing Pay slip
GENERAL JOURNAL AND OTHER TASK
- General Journal entries.
- Using the account Register.
- Bank Reconciliation.
- Setting users Passwords/Access Rights
UTILITY
- Backing up SAGE 50 Accounting file.
- Restoring SAGE 50 company file.
- How to export to excel and import list.
MICROSOFT EXCEL
Introduction
- Interface
- Tabs and Ribbons
- Document Windows
- Navigation Tips
- Office Button and Save
Entering, Editing and Formatting Data
- Introduction
- Entering Data
- Fonts, Fills, and Alignment
- Cut, Copy, and Paste
- Paste Special
- Undo and Redo
- Moving, Finding, and Replacing a Value
- Cell Styles
- Comments
Formatting Numbers
- Introduction
- Currency Format
- Format Painter
- Formatting Dates
- Custom and Special Formats
Managing Worksheets
- Introduction
- Naming and Moving Worksheets
- Copying Worksheets
- Adding, Deleting and Hiding Worksheets
- Grouping Worksheets
- Moving, Copying, Deleting and Hiding Grouped Worksheets
Modifying Rows and Columns
- Introduction
- Inserting and Deleting Columns and Rows
- Inserting & Deleting Cells
- Inserting Multiple Columns & Rows
- Modifying Cell Width and Height
- Hiding and Unhiding Rows and Columns
Understanding Formulas
- Introduction
- Using Operations
- Creating Formulas
- AutoSum
- Common Formulas
- Searching for Formulas
- Copying Formulas
- Using Relative and Absolute References
Changing Views
- Introduction
- Workbook Views
- Show/Hide
- Zoom Features
- Freeze Panes
- Split Windows
- Viewing Multiple Windows
- Minimize The Ribbon
- Worksheet Backgrounds
- Watermarks
AutoFill and Custom Lists
- Introduction
- AutoFill a Series
- AutoFill Non-Adjacent Cells
- AutoFill on Multiple Sheets
- Creating Custom Lists
- Series Formatting
Conditional Formatting
- Introduction
- Highlight Cells Rules
- Top/Bottom Rules
- Data Bars
- Colour Scales
- Custom Formatting Rule
Tables
- Introduction
- Insert a Table and Style Options
- Add Rows and Columns
- Perform a Function in a Table
- Summarise With Pivot Table
Data Tools
- Introduction
- Data Validation
- Drop-Down Lists
- Removing Duplicates
- Text To Columns
- Goal Seek
- Scenario Manager
Referencing Formulas
- Introduction
- Multiple Sheet References
- Consolidating Data - With or Without Links
- Trace the Precedents and Dependents
- Using the Watch Window
Ranges and Dates
- Introduction
- Cell Names
- Named Ranges
- Formulas with Cell Names
- Date Formulas
Lookups
- Introduction
- VLOOKUP
- VLOOKUP Exact Match
- HLOOKUP
- HLOOKUP Exact Match
Conditional Logic
- Introduction
- IF Statement
- Nested IF
- AND
- OR
- NOT
- IFERROR
- SUMIF
- AVERAGEIF
- COUNTIF & COUNTIFS
- SUMIFS
- AVERAGEIFS
Text Formulas
- Introduction
- Case Formulas
- Fix Number Fields
- Trim Spaces
- Substitute Text
Introduction to Charts
- Introduction
- Chart Types
- Instant Chart
- Update Chart
- Column Chart
- Picture Fill
- Adjust Chart Size
- Line Chart
- Scatter Chart
Formatting Charts
- Introduction
- Chart Styles
- Chart Layouts
- Add Labels
- Axis Options
- Chart Title
- Legends
- Data Labels
Adding Graphics to Spreadsheets
- Introduction
- Insert Pictures
- Modifying Pictures
- Insert Shapes
- Insert SmartArt
- Apply Themes
- Arrange
Outline, Sort, Filter, and Subtotal
- Introduction
- Group and Ungroup
- Sort Data
- Sort Multiple Levels
- Filter Data
- Advanced Filter
- Conditional Sorting and Filtering
- Sorting with Custom Lists
- Subtotal
PivotTables
- Introduction
- Creating PivotTables
- Choosing Fields
- PivotTable Layout
- Filtering PivotTables
- Modifying PivotTable Data
- Pivot Charts
Protecting Data
- Introduction
- Workbook Passwords
- Protecting Workbooks
- Unlocking Cells
Collaboration
- Introduction
- Document Properties
- Inserting Hyperlinks
- Sharing a Workbook
- Track Changes
- Accept/Reject Changes
- Mark as Final
Printing
- Introduction
- Page Orientation
- Page Breaks
- Print Area
- Margins
- Print Titles
- Headers and Footers
- Scaling
- Sheet Options
Saving a Workbook
- Introduction
- Save As Previous Version
- AutoRecover Save Options
- Templates
- Save As PDF
- Save As Web Page
- Macro-Enabled Workbook
Macros
- Introduction and Macro Security
- Recording a Macro
- Assign a Macro to a Button or Shape
- Run a Macro upon Opening a Workbook
- How to Inspect and Modify a Macro
Microsoft Nav
Microsoft Basic
Microsoft Advance
