Excel Help | Online Courses

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 Help

Excel Help Available

You will find free Excel help at our training section. We offer you several ways to get Excel help on a number of topics. Simply click on the topic of choice and you will have access to a free video based tutorial where an instructor explains step by step how to complete specific tasks in Microsoft Excel.
You for instance, will receive Excel help on how to enter data into cells. A few of the tools that can be used and tips shared are briefly described below. For more in-depth discussions and step by step instructions make your way to our training pages.

Auto Fill

This is an amazing tool in Excel. It allows for the quick completion of a list such as days of the week, months of the year, numbers and more. You can simply the enter the recognized value for the start of a series, then use the fill handle to drag over the cells where you want the information to be displayed, click on the fill box for options, and fill the series accordingly.

The IF function

It is one of the most powerful functions in Excel, and once you know how to use it properly, you will want to do so often. It is a function that allows Excel to make a decision based on the value input. With the IF function you can ask Excel to for instance, provide a pass or fail grade based on the value. If the value is below a certain number, a fail should be given.
Get all the Excel help you need with functions and tools right here at Audit Excel. Make your way to the training pages or contact us for more information about various courses to teach you advanced functions of Excel.