Excel Tutorial | 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 Tutorial

Advantages Of An Online Excel Tutorial

Did you know that you can have access to an online Excel tutorial that will provide you with all the information that you require? There are several advantages to enrolling online on an Excel tutorial. Probably the greatest benefit is that you will save yourself both time and money not needing to travel to and from a training facility. You will also be able to grasp the concepts at your own speed meaning that you can take your time with more difficult concepts and that you won’t have to wait for the slowest member of the class to catch up.

An online Excel tutorial is also much more cost-effective than other forms of Excel training. You will not require any workbooks and can simply download the information you require. Any questions or queries you have regarding the course can be dealt with via e-mail correspondence. The information is printable so that you can have a hard copy of any information that you feel you may struggle within the Excel tutorial. There are a wide variety of online Excel tutorials available to cover the requirements of a beginner learner to more advanced individuals who just need a refresher course.

Another advantage of enrolling on an Excel tutorial is that you will receive greater employment options on the job market. Most companies require their employees to have a good knowledge and experience in using all Microsoft Office programs. If you have no experience whatsoever on Excel tutorials or any of the other Microsoft Office software programs, you can also enquire as to whether these courses are available online. Most online Excel tutorial providers will have a range of training courses available in other forms of Microsoft Office programs.

Save yourself time and money in your endeavour to improve your knowledge and skills with an online Excel tutorial and other computer programs and contact us today.