Excel Formulas – Understand The Basics | 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 Formulas

Excel Formulas – Understand The Basics

We offer you free online tutorials and courses to understand the basics of Excel formulas in 2003 and 2007 versions of the application. Simply view the video based tutorials for assistance with Excel formulas or if you want to master from the most basic to the most advanced of Excel formulas:

Enrol in one of our online courses which can be downloaded and studied in your own time. Each of the courses is written for a specific level of user and you can thus choose how basic or how advanced your level is.

Enrol in one of our live Excel courses running over the course of one to three days. These courses are presented at various venues around the country and predetermined dates. The course content is aimed to address specific areas of application in Excel.

In the basic courses on Excel formulas you will learn about the various formulas, how to enter formulas correctly, apply absolute and relative referencing, to apply the formulas to specific ranges and how to copy the formulas.

You will also learn which Excel formulas to use for every application. One of the most common problems users experience is that of knowing which Excel formulas to apply. In addition tools such as the fill handle for the copying of Excel formulas to adjacent cells, the paste special functions and how to copy Excel formulas to cells not directly adjacent to the referencing cell will be learned.

Learn how to use data from another worksheet in the current worksheet and how to apply the Excel formulas in such instances. Master absolute, relative and mixed referencing when working with Excel formulas in the calculation of for example interest, VAT, and percentages.

View our full range of Excel courses whether live, tutorial based, for free or paid and contact us today for more information about courses specifically dealing with Excel formulas.