audit excel spreadsheet auditing
audit excel spreadsheet auditing
Quicklinks
(Click to expand)
 
-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
















Free Microsoft Excel Help

If you need Microsoft Excel Help then you have to the right place. With loads of new Microsoft Excel Help videos which can be viewed online with their transcripts, you will learn how to master difficult calculations, analysis, and modelling functions in no time.

You will for instance, get Microsoft Excel Help with the ISEVEN & ISODD.

ISEVEN & ISODD

If you need to find even and odd numbers in a list you can either use a complex formula to perform the function or you can simply make use of the Function Wizard. Your first step will be to open the Function Wizard and then to view the Information category. You will find the ISEVEN and ISODD functions in the list.

ISEVEN
Select a reference number in you list. Point to the number and the Wizard will give you the value of ISEVEN false or ISEVEN true. If you for instance, get a false you can copy it down the whole list and will then be able to identify which of the numbers are ISEVEN false. The same principle counts for ISODD.

Imported header checking

You may want to check imported headers and as such only require a quick reference help. This is where our short training videos make things easier for you. One of the new videos uploaded in the free training section is that of Import headers.

When you receive new information in your spreadsheet through importing it from another application, you will want to check the headers to confirm that you have received what you wanted. You can do this by including the headers twice. You will first type the headers that you expect to see in your spreadsheet as this will be your control to compare against. Now you can copy and paste from the other system or application.

You will use the EXACT function which is available once you activate the Function Wizard. Select the function and specify the cells that need checking for true or false values. When making use of our training video you will find out how and also learn an even easier way.

Microsoft Excel Help is just a button click away for any of the areas that you may struggle with.


  • Microsoft Excel
  • Microsoft Excel Help
  • Microsoft Excel Skills
  • Microsoft Excel Spreadsheets
  • Microsoft Excel Training Programs
  • 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 | Sitemap | Training | Sarbanes Oxley | Articles | Links | Blog