Excel Spreadsheet Formulas | 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 Spreadsheet Formulas

Services And Add-Ins For Excel Spreadsheet Formulas

You don’t need to go to great expense to train all your employees in the optimal use of Excel spreadsheet formulas. Advanced Excel consultants should be able to provide you with a range of services for all your development requirements. These advanced Excel services should include feasibility studies, auditing and valuation packages, efficient cost cutting measures amongst others. The services are offered on a once off basis or you can employ the consultants on an ongoing basis to perform these tasks leaving your employees free to deal with their existing work load.

There are also a number of software options and add-ins that you can purchase for your Excel spreadsheet formulas. Spreadsheet Professional can be used to audit your spreadsheets to ensure that all your Excel spreadsheet formulas are correct and that any results achieved from the calculations match up. The AssumeIt Excel Sensitivity Tool will optimise the performance of your Excel Spreadsheet formulas, allowing you to run more than one sensitivity at a time without causing any operating system errors. Data Safe Excel is there to provide you with security measures in the form of password protection, encryption programs, restrict access to certain functions and provide you with time limits for your Excel spreadsheet formulas.

Excel spreadsheet formulas and the convenience of the software program has become an important tool in every business. But getting the best from your Excel spreadsheet formulas without the knowledge of what you are doing is just about impossible without training or the use of experienced consultants. While it is very important for you to optimise the usage of this software tool, it is just as important to figure out which means will offer you the most effective long term solutions in using Excel in your company.

For more information on how you can optimise the usage of Excel spreadsheet formulas in a number of functions in your company, please contact us.