Learn Excel 2007 | 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

Learn Excel 2007

Learn Excel 2007 Updates And Enhancements

If you are experienced in using Excel 2003 or have completed an advanced training course at any time you will not need to enrol on a basic or even comprehensive course to learn Excel 2007. All you really need is a course to update you on all the changes that have been made and all the enhancements that have been included in the new updated version to learn Excel 2007. There are plenty of these types of courses available and you can even choose between doing an online course and enrolling on lectures to learn Excel 2007.

However, if you have no previous experience in Excel, it is recommended that you find a more comprehensive course to learn Excel 2007. These courses start at the very beginning of Excel with basic tutorials and continue right through to teaching the most advanced applications that can be used in Excel. There is absolutely no reason why you would not be able to use previous versions of Excel once you learn Excel 2007 although there may be some features that you have learnt that will not be available when you use the earlier versions.

There are also refresher courses available for the Excel 2007 user who just needs to understand the more advanced features of the software program. Refresher courses can also be used for users who have completed the Excel 2003 advanced courses and just need to be updated with the changes to learn Excel 2007. Should you be unsure regarding the type of course you need to enrol on to learn Excel 2007 you can take a simple test to determine what your current level of skill is in using Excel optimally.

To have access to the full range of courses available to learn Excel 2007 or to just get an update on the new features that have been added to the program, you can simply contact us.