Financial
Auditing
|
We also have Free
training videos on this site ( visit the
Home page
or the
Training Page)
Financial Auditing
Making use of Excel as software package for financial auditing
can be an extremely rewarding exercise, provided you know
how to use Excel efficiently. The very same features that
make the package so useful and extensive are also the features
you first need to learn.
Audit Excel the company with years of experience in spreadsheet
solutions offers several training programs, tutorials and
guides on the website that can be downloaded, purchased, used
on a trial basis and tested online. The software and solutions
will help you to become proficient in the use of Excel and
its many useful applications. Another software package named
Spreadsheet Professional is also available at the site as
well as guidance on modelling through the use of spreadsheets.
Some of the features of Excel making it such an excellent
package for financial auditing, forecasts, cash flow assessment
and data analysis are discussed below.
|
|
| |
|
Fluent user interface
The result orientated Excel user friendly interface helps users
to accomplish tasks quicker whether it is a formula creation or
insertion of a table. The user interface presents relevant commands
when needed.
Working with large amounts of data
Excel allows for the importation, organization and sorting of large
amounts of data through expanded spreadsheets. Spreadsheets of up
to one million rows and 16 000 columns can be handled.
Conduct complex calculations
Excel makes it possible through a multi-core platform to perform
hundreds of complex calculations through formulas. Learning how
to use the formulas in the most effective way is in turn made easy
through the solutions offered by Audit Excel.
Professional charts
Present results in a professional manner through visually attractive
charts which can be used in PowerPoint presentations and also in
Word format reports. Even shadowing, 3D and transparency effects
are possible.
Table support
Excellent support is given for pivot table views and expansion,
formatting, filtering and referencing to tables within formulas.
Table headings stay in view when you scroll down the page. The pivot
table views can be used when you need to find answers fast –
allowing for the dragging of relevant fields to places on the spreadsheet
where they are needed.
Trend identification
Easily identify trends or patterns in the data that can be used
in forecasts or budgeting as well as for the identification of possible
problem areas through the use of linear gradients, colour coding,
highlights, heat maps, performance indicators, and special data
bars.
Sharing of information
It is now possible through the use of SharePoint Server and Excel
Services to render spreadsheets in HTML format to be viewed in the
web browser. Users at remote locations can thus access data, make
changes, set parameters, input valuable data and conduct assessments
on shared content. Permissions can be set and users restricted to
specific areas of the spreadsheet. You can now share the financial
auditing results with clients without having to email large files
and can work in real time with colleagues who are at remote locations.
There is no better solution than Excel for financial auditing.
Visit the Audit Excel site to find out how you can fully benefit
from spreadsheet solutions and make the most of Excel to ensure
accurate results and forecasting.
|
