Excel 2007 Help | Mirical Solutions

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 2007 Help

Beginner To Advanced Excel 2007 Help Training

Did you know that there is a simple tutorial for Excel 2007 help included with your software program? All you need to do is to simply click on the Excel 2007 help button on the task bar once you have opened the software program. The Excel 2007 help icon appears in the form of a question mark as per all other help tutorials available with other Microsoft products. You can then just type in the question or topic that you need assistance with and the Excel 2007 help tutorial will search relevant topics to assist you.

The problem with this is that it can take time to find the right answer to your questions quickly when using this form of Excel 2007 help. This can be time consuming and even when you do locate the right answer, it may not be as easy to implement the solution. The answer that you receive may also not provide you with the most efficient means of solving your problem. It may be better to consider enrolling on an Excel 2007 help course to assist you with learning all the applications available with this software program.

There are different levels of Excel 2007 help that you can consider enrolling on to provide you with the knowledge that you require. You can start with a beginner course if you have never had any previous Excel 2007 training or have had little to no experience using the software. There are also intermediate Excel 2007 help courses available to enhance your capabilities and functions in Excel applications. The more advanced courses are ideal for individuals who have some knowledge of how Excel works who would like to go more in depth with the functions and formulas available on Excel.

For further information on the types of courses, from beginner to advanced, that are available for Excel 2007 help training, please contact us.