Register now or log in to join your professional community.
If you like the question please vote it up for the appreciation.
thank you all for your support..........
Financial Models require you to think straight and convert your thought process into Excel Spreadsheets. So the first part that should be taught is structured thinking. This can be done through exercises on Market Size Estimation, Marketing Funnel, Deriving the right drivers for Revenue, Costs, etc. Once the student starts thinking in a structured manner, the models automatically start rolling out. When you create the models, they should have a logical flow
Since most of the time would be spent in implementing the model in Excel, unless you are very comfortable with the tool, you would take too long navigating the tool rather than creating the model. Excel Shortcuts, knowing advanced functions, the referencing framework, etc. play a big role in helping you quickly implement your thoughts in Excel.
As a finance professional your job is to analyze data and come to conclusions. Each step of analysis and its implementation (Ratios, Valuation, etc.) should be taught to Finance Professionals.
Final results need to be presented. Most of the times, even good models are rendered useless unless they have a good dashboard to highlight the results to the end user.
It could be the use of electronic computing capabilities in many areas of accounting including the following:
First, the implementation of certain accounting procedures, such as:
Events demonstrate financial transactions in journals.
Migrating to the accounts in the professor's books and extraction trial balances.
Preparation of financial statements and periodic reports, such as balance sheet, and a list of the interior, and the statement of cash flows.
Second: the proof in some statistical records, such as:
Fixed assets register.
And staff record.
Payroll and payroll.
Suppliers and exporters record.
Stores records.
Third, store and analyze data to help make decisions such as:
Pricing under several different conditions and the impact on the profitability of the company.
Warehouse Management and define points and the amount of the purchase.
Analysis of the cost of labor on the sections and on other operations.
Analysis of deviations costs.
Analysis of break-even point in the event that the company produces and distributes several products.
Download indirect costs.
Determining premiums consumption.
financial lists analysis.
Management of cash flows using operations research.
Fourth, the accounting data and information and to deal with local and global information networks, storage and return us to discuss them in detail.
Disadvantages and risks of the use of computers in the information to the accounting system:
Despite the benefits added by computers for information to the system, but the technology remains, as they say, "double-edged" weapon of her along with a positive and another negative, and one of the cons of adopting the accounting information systems include:
Physical records: Under-mail operation of accounting information systems are recording and save the data process using electronic impulses in the main memory of the computer or on CD-ROM and compressed disappearance is impossible for a human to read, and the only one able to read is a computer and thus became the accounting data is visible.
Lack of good support for review: and intended to bail process data tracking audit and operations of the source and up to the final results, or vice versa, meaning the start of the final results of the process and completed its source "and with the electronic operation of accounting information systems this can not be achieved due to the absence of physical bonds the concrete advantages that allow operations to track and review all the data in order to verify them, and mail systems are not able to do so because as I have already mentioned that the data stored in the non-visible in the form of documents and electronic units are not able to read only computer programs allocated to them.
Ease of committing fraud and computer crimes: intended fraud and computer crimes in the field of electronic manipulation of computers in the computer programs through the manipulation of data files, operating, equipment, and this will lead to losses for organizations is that fraud in the use of computers located.
And also it meant that the crime is committed if someone using his knowledge of computerized work illegally and that require special techniques conversant with computers and accounting information systems.
Located such operations because the files have become intangible and invisible, and this is what can change, add, or delete data without leaving any trace of these processes to occur, making it easier to commit fraud and making it difficult to detect.
Computer viruses: The viruses computer a direct negative impact on the memory of the computer, which may destroy him to lose all memory or the data stored in whole or partial damage, which affects the work of the accounting information system and all this because of the transformation of the records and books of physical books, anyone can read them to digital files stored in computer memory only able to read the computer is the same. If this data infected with meaning system damage or corruption, which carries the institution expensive in some times.
Despite some flaws that resulted from the use of automated media in accounting information systems, the computer remains a necessity at the moment can not do without it in any accounting information system because of the advantages which are not counted and provided for this system, which
Beneficiaries:
Employees of financial departments and statistics departments of the various institutions.
Persons responsible for taking administrative and financial decisions in companies, government departments, financial managers, accountants, auditors and internal breakers and all of them related to financial and accounting matters.
Auditors and employees in financial control and audit of computerized accounting systems and auditing in the computer environment.
All working in the financial and administrative information systems.
agree with mr. georgei and ms. ghada
One of the most popular functions in Excel formulas is VLOOKUP adn Pivot Tables.
So much of this is going to vary job by job, but here are some of the core skills I think are needed to be able to be a strong Excel user:
VLOOKUP. Make sure that they also know how to do this when looking up based on more than one field (e.g. First Name, Last Name, Month).
INDEX and MATCH. Vlookups are a bit faster to write, but index match gives you a lot more flexibility in certain situations.
Separating input data from calculations. Each input data source should be pasted in directly as received, all calculations should be done in other sheets (using vlookup/index match to pull in the data)
IF, AND, OR every user needs to know how to use these basic conditional logic formulas.
Pivot Tables
Named Ranges
Making charts that combine multiple types (e.g. a line graph overlayed on a bar chart, clustered bar charts, )
Array Formulas (e.g. SUM of profit on all deals worth more than $1m usd where the buyer is from China)
Custom number formats (e.g. making 3000000 show up as "$3.0 million")
Conditional Formatting
Special types of paste (paste link, paste values, paste formats, etc)
Doing almost everything with keyboard shortcuts
Text-To-Columns (To parse flat text files)
Other useful are: SUMPRODUCT, IFERROR, CONCATENATE, MOD, LEN, RIGHT, LEFT, INDIRECT, OFFSET, YEAR, MONTH, DAY, ROUNDDOWN, MATCH, HLOOKUP , RAND, MAX, MIN, CORREL, IF.
Make a Tables with Data filter & Pivot table
