audit excel spreadsheet auditing
audit excel spreadsheet auditing
Online Excel Training Links
 
-Home Page
-Company Profile
-Free Tutorial Page
-Training Schedule
-Contact Us
- Our BLOG
-Spreadsheet Auditing
-Spreadsheet Sensitivity
-Spreadsheet Security
- IRR Calculator
- Count error checks
- Check import headers
- INDIRECT function
- IS number EVEN/ODD
- Is cell a number
- MATCH Function
- Identify missing categories
- Check that data within range
- TEXT Function
- Remove Spaces
- Use ADDRESS
- Function Wizard
- Audit Toolbar
- Good Design
- Add In's
- Identify missing categories
- Check that data within range
- Count error checks
- Check import headers
- CAGR
- Show all formula
- Fill in blanks
- Data Cleanup
- Multi sheet changes
- Automatic Sort
- VLOOKUP Use
- Large VLOOKUP's
- VLOOKUP Risk
-
Automatic Sorting
- IRR Calculator
- Interest rate
- IRR
- NPV
- CAGR
- PMT
- Amortization table
- Database - Use ADDRESS
- MATCH Function
- INDIRECT function
- VLOOKUP
- Transpose
- CHOOSE
- OFFSET
- SUMIF/ COUNTIF
- DATE
- EOMONTH
- EDATE
- Rank
- MAX/ MIN
- IF
- AND/ OR
- TEXT Function
- Remove Spaces
- FIND
- Length
- Join characters
- Change Case
- Extract Text
- IS number EVEN/ODD
- Is cell a number
- ISERROR
- SUMIF/ COUNTIF - Data Validation
- Group/Ungroup
- Autofilter
- Workbook protect
- External Links
- Goto Special
- Find/ Replace
- Conditional Format
- Pivot Tables
- Data Sort
- Data tables
- Multiple Windows
- Hyperlinks
- Protect cells
- Paste Special
- Copy/ Paste
- Delete Cells
- Insert rows
- Insert cells
- IF functions
- Linked Sheets
- Hidden Cells
- Lookup's
- MIN/MAX function
- Referencing
- Goalseek
- Data Tables
- Scenarios
- Watch Window
- Download All












IFRS 7 Spreadsheet Solutions

Spreadsheet solutions in line with IFRS 7

IFRS 7 as the short for International Financial Reporting Standard, which made its debut at the start of 2007, is the most significant development in financial audit reporting since IAS39. IFRS 7 does not only apply to the banking sector as many mistakenly believe, but also governs financial reporting of all entities that have financial instruments such as accounts payable.

It also sets the standard for disclosure of objectives and policies utilized in managerial capital. Greater transparency is thus required about the risks faced by companies as the result of the usage of their financial instruments. It is applicable to all entities which make use of financial instruments for the financial year which started at 1 January 2007.

The new standard provides the marketplace with additional insight into an entity’s financial assets. In addition the liabilities of the entity as well as any financial risks are also now more transparent to the marketplace.

Full adherence to IFRS 7

It is a replacement of the IAS30 and IAS32 requirements. Adherence to the new accounting standard can be difficult for companies which did not keep track of information required in the past. Adequate software such as Excel with its powerful features should be used while an auditing software package such as Spreadsheet Professional will greatly enhance the accuracy and error reporting on the spreadsheets. It is also extremely important that the personnel using these software tools are well trained and understand the requirements of the new standard.

As such, Miricle Solutions provides training in spreadsheet solutions to help entities adhere to the new international financial accounting standards. In addition, powerful tools such as Spreadsheet Professional can be obtained through us. Make sure your company complies with IFRS 7. Contact us for more information on training and spreadsheet solutions.


  • Excel Spreadsheets
  • Excel Statistical Formulas
  • Excel Tutorial Videos
  • Excel Tutorials
  • Excel Videos
  • Excel Audit & Financial Modeling Review

    Miricle Solutions provides review and auditing services on excel spreadsheets that are important to the organisation. Using the benefits of the internet these services can be provided to companies worldwide.

    More on excel audit and reviews

    Excel design and development

    Miricle Solutions designs and develops professional excel spreadsheets. Benefit from the combination of our business knowledge and modeling experience.


    More on design and development in excel

    Spreadsheet & Excel Risk Management in the Sarbanes Oxley world

    Excel has become a core tool in the business world. However few companies have managed to address the risks associated with these spreadsheets. Now Sarbanes Oxley is making it compulsory to address the issue in the States and it will reach the rest of the world soon. Visit our new SOX site , which covers spreadsheet controls relating to documenting ,access, input, testing, version control, audit trails, change control and backup/ archiving,

    More on reducing SOX risks due to excel use

    Decision Modeling

    The business world is all about making decisions. Miricle Solutions can provide the services to understand your problems, develop a Excel spreadsheet model to assess the decision, and ensure that the necessary level of quality is generated.




    More on decision modelling using excel and spreadsheets

    EXCEL TOOLS
    arrow Spreadsheet Professional Video Clip
    arrow
    Download Trial Copy
    arrow
    Quick start guide
    arrow
    Spreadsheet Professional
       Read our privacy policy if you are concerned about your information
     

    Home | Contact Us | Site Map | Training | Sarbanes Oxley | Articles | Links | Blog