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
Google
Web AuditExcel.co.za


















Excel Folrmulas

Formulas in Excel begin with an equal sign.  The equal sign tells Excel that the succeeding characters constitute a formula.  If you don't enter an equal sign, then the calculation you are trying to make will fail. In Excel, you can construct formulas that do subtraction, multiplication, division and exponentiate. The – symbol means subtract, the * means you are multiplying, the / means division and the ^ means exponential operation. Excel calculates formulas automatically.

Today, there is no excuse for not drawing up a financial budget and  although mastering it can be rather complicated, Audit Excel fully understands this and being the experts, have developed a number of Excel help solutions made available to the Excel user to use to their full potential.

Our experts will provide assistance in the creation of your spreadsheet budgets and the use of formulas, and take you through the entire process step by step. Our on line training assists you in building the Excel spreadsheet suitable for your business, and some big clients like MTN, and AngloGold Ashani can testify to our expertise knowledge.

What is great about Excel is that it allows you to copy a formula in one cell to another cell that needs a similar formula.  This can really save lots of time when building your complex spreadsheets. Excel and its use of formulas allows for the creation of a budget that is of notable worth, and will keep one out of financial danger. So, do not let yourself make the mistake of not drawing up or building a financial spreadsheet because it seems too timely and intricate.

AudioExcel can assist you in building a spreadsheet your company will be proud of. Our free on-line Excel training videos and tutorials are widely used by novice and advanced users. Become proficient in all aspects of the package by making use of our free on line Excel training videos, advanced courses, and CD-Rom packages. Way to go – Make AudioExcel your destination for spreadsheeting training, our formulas for success.

 


  • Excel Help
  • Consulting Services
  • Formulas
  • Multi Sheet Changes
  • Tools and Features

  • 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