Excel spreadsheets | 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

Excel spreadsheets

Spreadsheets are created in spreadsheet applications like Microsoft Excel and simulate a paper worksheet. This worksheet is made up of columns and rows in a grid that forms cells; each cell can contain data or formulas that calculate how their data is obtained. This may be done by calculating their data from other cells in the spreadsheet that they refer to. Spreadsheets are very useful for accounting purposes because of this ability. Audit Excel presents Microsoft Excel courses to teach people how to use the Excel spreadsheet software.

Spreadsheets can perform multiple calculations concurrently, with almost boundless cell cross references. Every time a cell’s content is changed, the spreadsheet can recalculate all the formulas and calculations in the entire worksheet. This is extremely useful when utilising the spreadsheet to calculate financial data. Many what-if scenarios, costing and financial planning calculations can be performed and one can see how the figures add up every time one makes a change.

Microsoft Excel can be used as accounting software in small business where specialist accounting software would have been too costly. Microsoft’s continual development of the software and its increasing power and versatility have given it the critical mass to become the dominant spreadsheet software used in the world today.

Creating spreadsheets with Microsoft Excel and managing data, finances and accounting this way is easy if you are well versed in the inner workings of the software. Contact Audit Excel to find out how you can become an Excel expert. It is easier than you think, and it is great to have Excel literacy on your CV.