AuditExcel

258 subscribers

274,155 video views

Uploaded videos

1-10 of 118

3:25 IRR Calculator AuditExcel 5,568 views 3 years ago
3:27 MATCH Function V2 AuditExcel 528 views 3 years ago The MATCH function allows you to find the relative reference in an array of a particular cell.
1:43 ISNUMBER Function V2 AuditExcel 525 views 3 years ago The ISNUMBER function allows you to check whether a cell contains a number or not.
3:27 Address Function V2 AuditExcel 1,161 views 3 years ago The Address Function allows you to create, as text, a reference to a cell.
1:17 ISEVEN ISODD V2 AuditExcel 270 views 3 years ago How to find even & odd numbers in excel
6:06 VLOOKUP TRICKS V2 AuditExcel 8,767 views 3 years ago Once you have mastered VLOOKUP you may find that you use it for large datasets. The problem is that when you make changes to your spreadsheet you sometimes need to go throu...
3:32 Double header check function V2 AuditExcel 163 views 3 years ago Type in headers of the data you are expecting and use a check cell to ensure that the data you import contains the information in the correct order.
2:06 TRIM Function V2 AuditExcel 1,040 views 3 years ago The TRIM function removes all spaces from a cell except for a single space between words.
3:38 TEXT Function V2 AuditExcel 152 views 3 years ago The text function converts values to text in a specified format.
3:15 Out of range checks V2 AuditExcel 282 views 3 years ago By combining a visual border with some checks you are able to test whether you have accidentally put data in cells that won't be processed.

Advertisement

About AuditExcel

Free training in using Microsoft Excel spreadsheets. To see better quality video clips visit http://www.AuditExcel.co.za

AuditExcel.co.za

by AuditExcel

Latest Activity

Jan 12, 2009

Date Joined

Feb 18, 2008

Country

South Africa

Featured Playlists

118 videos Play all

Uploaded videos

by AuditExcel

3 videos Play all

Minimum Excel Knowledge

by AuditExcel

0 / 00Unsaved Playlist Return to active list

Your queue is empty. Add videos to your queue using this button:
or sign in to load a different list.

Loading...Saving...