Office Excel Services And Products | 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

Office Excel

Microsoft Office Excel Services And Products

You may have worked with Office Excel 2003 in the past and now struggle to understand the new interface of Office Excel 2007. There is hope. We offer an extensive range of spreadsheet courses in the following formats:

In-house courses where the course content is customised to client requirements.

Prescheduled courses to address from the most basics to the most advanced tools and functions of the spreadsheet program.

Online downloadable Office Excel 2007 series of courses addressing specific modules of Excel.

Free quick reference video tutorials to assist users with specific problems.

In addition to the courses we also provide the following services and products:

Consultation and assistance in Excel model designs and analysis.

Aptitude and skills level testing regarding MS Excel.

Spreadsheet auditing packages to help streamline the auditing of spreadsheets.

Our courses come with a 100% money back guarantee and whether there is one or a hundred, the courses run on the scheduled dates. Our presenters are experienced accounting offices, auditors, and financial analysts. They have years of experience regarding the application of Excel in practice. The live courses are presented with a hands-on approach and the online courses can be downloaded allowing for practice in one’s own time.

We also provide free online Office Excel help. The tutorials are video based with audio and printable scripts; thus allowing for the various methods used for learning. If you want quick help with a specific problem simply click on the NEW VIDEOS section for assistance regarding for instance, VLOOKUP and TRANSPOSE. You can also find information on the basics of Excel and select any of the topics displayed on the left side of our home page.

Whether you want to enrol in one of our advanced Office Excel courses, need assistance with the auditing of spreadsheets, help with the design of spreadsheet models or simply want to learn in your own time, contact us for more information and assistance today.