Microsoft 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

Microsoft Excel Tutorial

Enrol For An Online Microsoft Excel Tutorial Today

Many of us make use of Excel on a daily basis, but are not 100% familiar with all its functions and features. If you need to know more about this program and how it works, but have a full time job, then enrolling for an online Microsoft Excel tutorial would certainly be in your best interests. One of the major advantages to doing an online class or tutorial is that you will not need to travel to a training academy and can study at a quicker pace, should you feel the need.

An online Microsoft Excel tutorial will provide you with access to online course content which you can download. You won’t need to purchase any books and should you get stuck along the way, there are tutors that can assist you via email and the net. Whether you are a beginner looking for a complete course, or an advanced Excel user looking for a refresher course, Miricle Solutions is just the place to go. This particular company is one that is dedicated to bringing cost-effective Microsoft Excel tutorial assistance to those that require it. Whether you are looking for assistance with Excel formulas or simple spreadsheets, Miricle Solutions will be able to assist.

Most Microsoft Excel tutorials offered by Miricle Solutions are designed to focus on specific skills and can last anything from one hour to three. You can learn how to set panes, name ranges and cells, locate data, work on multiple spreadsheets, insert hyperlinks, calculate and insert formulas and a great deal more. The fact of the matter is that Excel is such a useful program, and those of us who do use it have probably barely scratched the surface of what it is able to do.

When looking for the best online Microsoft Excel tutorial take the time to contact Miricle Solutions. They will ensure that you are provided with access to the best study material available on the market and that your training enables you to handle your job better and get things done on Excel that you may have been struggling with before.