Excel Training Is Essential For Accuracy Of Spreadsheets | 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 Training

Excel Training Is Essential For Accuracy Of Spreadsheets

The importance of proper Excel training cannot be overstated. With more than 80% of spreadsheets containing errors, it becomes apparent that there is a definite need for Excel training. Users often don’t know how to use the error, auditing, and tracing tools in Excel to enhance the accuracy of their spreadsheets and models. In addition, many users hardly ever use the basic spell check and reference tools of Excel. Although their spreadsheets may be accurate, the formatting and spelling leave room for improvement. For companies professional presentations of information cannot contain spelling, formatting, and accuracy errors.

Through proper Excel training as presented by Miricle Solutions employees can be trained in all of the above aspects, full usage of Excel as spreadsheet, financial modelling, and database tool, and also learn how to become power users of the application. Once users understand the full potential of the application and how to use various tools in Excel they will be able to contribute more to the office environment through accurate forecasts, analysis, and reporting.

Our Excel training entails specific modules of the application as well as general usage of the program. Whether a person needs to master graphs, charts, and reports in Excel, wants to learn how to use the new interface of Excel 2007 or wants gain knowledge regarding the various functions for statistics, finance or database applications, the person will certainly be able to do so through our various forms of Excel training.

We offer Excel training in the following formats:

Short 1-3 day advanced Excel training courses at specific venues around the country.

Short basic to advanced Excel training at client company venues to train several employees at once.

Online downloadable free video based Excel courses.

Fee based downloadable video and script based Excel tutorials and courses addressing specific modules in the application.

View our range of Excel training options and contact us today to enrol in one or more of the courses.