Auditing Software | Audit Excel

MAIN PAGES

-Home Page
-Company Profile
-Free Tutorial Page
-Training Schedule
-Contact Us

BLOG

- Our BLOG

SOFTWARE

-Spreadsheet Auditing
-Spreadsheet Sensitivity
-Spreadsheet Security

NEW Videos

- 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

Excel Basics

- Function Wizard
- Audit Toolbar
- Good Design
- Add In's

Tips and Tricks

- 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 tips

- VLOOKUP Use
- Large VLOOKUP's
- VLOOKUP Risk
- Automatic Sorting

Financial

- IRR Calculator
- Interest rate
- IRR
- NPV
- CAGR
- PMT
- Amortization table

Database

- Database

Lookups

- Use ADDRESS
- MATCH Function
- INDIRECT function
- VLOOKUP
- Transpose
- CHOOSE
- OFFSET
- SUMIF/ COUNTIF

Dates

- DATE
- EOMONTH
- EDATE

Statistics

- Rank
- MAX/ MIN

Logical

- IF
- AND/ OR

Text

- TEXT Function
- Remove Spaces
- FIND
- Length
- Join characters
- Change Case
- Extract Text

Information

- IS number EVEN/ODD
- Is cell a number
- ISERROR

Maths

- SUMIF/ COUNTIF

Other Tools

- 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

How errors happen

- Copy/ Paste
- Delete Cells
- Insert rows
- Insert cells
- IF functions
- Linked Sheets
- Hidden Cells
- Lookup's
- MIN/MAX function
- Referencing

What If's

- Goalseek
- Data Tables
- Scenarios
- Watch Window

Download All Videos

- Download All

Auditing Software

Microsoft Excel is not just a spreadsheet application. It is a very powerful and versatile tool used by many businesses as for accounting and as auditing software. Audit Excel offers several courses to teach you to become proficient with Excel and utilise its remarkable depth of ability. It is especially handy when used in business as auditing software.

Excel can easily import data from other applications and manipulate it as necessary through the various quick menus, formulas and tools that are available. This makes it ideal for financial data management. View and change permissions can be set – right down to cell level – against unauthorised access and changing of data, and to prevent fraud. Fraud identification and risk may also be spotted easily when analysing the data.

Excel may be used as auditing software to find vendors’ billing errors, check whether vendors are compliant with the terms of their purchase agreements, identify cost saving opportunities, pinpoint under deductions and over payments, find duplicate entries and assess whether deductions have indeed been made or not. Procedures may also easily be set up to identify certain trends. Spreadsheets can be made available in HTML to enable users in remote locations to access the data and make changes as the permissions have been set up to allow them. This means users can view the spreadsheet in their browsers, making for fast an accurate data sharing.

Clearly, Microsoft Excel is powerful auditing software that can be used privately or for small and large businesses alike. Contact Audit Excel to find out how you can learn more about Excel through our specialised courses.