Contact Us: +905397472269   -   +905373777978     Email: training@euro-training.net    Download Brochures
COURSE FINDER
LikeLike this course PrintPrint E-mailSend to a friend
BOOKING INQUIRY PDF

Finance and Accounting Seminars


Course: Designing and analyzing financial data using Microsoft Excel


REF: F2076  DATES: 17 - 21 Feb 2019  VENUE: Washington, DC (USA)  FEE: 6750 

Overview:

Overall objective of the course:

The course will discuss the skills of dealing with spreadsheets such as MS Excel and database management programs such as MS Access

And how to use these programs in the development and design of electronic accounting applications, as well as provide them with the skills of how to use these programs in the analysis of accounting data and information, and analysis of financial statements in order to assess the financial performance and management of the facility, and the provision of financial information that helps in the management decisions, Financial Planning Design Planning Budgets.

And improve the skills of the application and support the experience of participants and expand the horizons of their practice in the use of computers for the purpose of raising the level of professional performance of accounting work in various aspects.

 

Detailed Course Topics:

Introduction to software programs used in accounting applications:

  • Introduction to M S Excel
  • Introduction to M S Access
  • Specialized accounting software

Using the M S Excel program in financial planning:

  • Cost planning.
  • Analyze parity and prepare profitability map using Chart Wizard.
  • Forecasting and Financial Planning Using Solutions Processor.
  • Financial analysis and differentiation between decision alternatives using scenarios.

Design of accounting systems using M S Access:

  • Identify the system objectives.
  • Identify key components and components of the system.
  • Prepare and design system files.
  • Design of data entry documents (input forms).
  • Design of system outputs (information reports).
  • Link system elements using macros and Modules

Development of accounting work Using a computer 1:

  • Implementation of the full cycle of accounting work.
  • Analyzing, recording and summarizing the financial operations and preparing the final financial statements using the computer.

Development of accounting work Using a computer 2:

  • Audit of outcome account items and financial statement items: audit program and evidence collection.
  • Full workshop:Use structured software to review revenue and expense items, asset items and electronically generated commitments.

Development of accounting work Using a computer 3:

  • Planning budget and preparation problems.
  • Stages of current budget preparation criteria and procedures.

Development of accounting work Using a computer 4:

  • Project Balancing and Survey Tasks Assessment of the feasibility of investment.
  • Performance accounting Measurement, evaluation and planning for improvement.
  • Full workshop: Using the computer in the analysis and criticism of financial statements.
  • Full workshop: Use of computers in the preparation, writing and presentation of financial reports.

 

 


 

COURSE DATES
17 - 21 Feb 2019
COURSE REF
F2076
VENUE
Washington, DC (USA)
COURSE FEE
6750 

COURSE REF: F2076

Course: Designing and analyzing financial data using Microsoft Excel

Washington, DC (USA)

COURSE DATES: 17 - 21 Feb 2019
COURSE FEE: 6750 

BOOKING INQUIRY
 

Contact Us


Istanbul, Turkey
Phone: +905397472269

Dubai, UAE
Phone: +971544558902
Lebanon
Phone: +96181746278

Email: training@euro-training.net
Copyright Euro Training © 2011