Advanced Excel Training | 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

Advanced Excel Training

The Advantages Of Advanced Excel Training

Microsoft Excel has become an indispensable tool for businesses all over the globe. Today Excel, far from being a tool used only by those in a financial function within a business is used by departments from Human Resources and Marketing to Finance. Almost every employee is expected to have at least a basic understanding of the functionality of Excel and be able to interpret information supplied in Excel spreadsheet form. There are, however, employees in the organisation who can benefit from advanced Excel training. These employees include those who have a responsibility for the strategic direction of the company, such as those at board level who will benefit greatly from advanced excel training.

Board members and ancillary employees such as company secretary’s are expected to be able to bring across complex data in a form that is easily understood by heads of department and others responsible for the day to day functioning of the organisation. Advanced Excel training is also important due to the increasing complexity of data, such as financial information that must be collated and interpreted if the company is to maintain its competitive edge in the business environment of the 21st century.

Advanced Excel training is today available in a number of formats, including online course material which includes video to supplement real world examples of how the software should be used. Onsite training and off site tuition is also available. Training service providers can also tailor make course material to meet the unique requirements of individual businesses. Many organisations prefer either online training or onsite training options due to the fact that these options reduce the amount of time that executives need to spend off site, which might result in high level skills not being available during mission critical times.

If you think that your company executives can benefit from advanced Excel training then don’t delay, speak to the experts today, contact us today about our advanced Excel training.