AuditExcel
Loading...
224
subscribers
217,512
video views
Uploaded videos
1-10 of 118-
IRR Calculator
AuditExcel
4,959 views
-
MATCH Function V2
AuditExcel
455 views
The MATCH function allows you to find the relative reference in an array of a particular cell.
-
ISNUMBER Function V2
AuditExcel
437 views
The ISNUMBER function allows you to check whether a cell contains a number or not.
-
Address Function V2
AuditExcel
970 views
The Address Function allows you to create, as text, a reference to a cell.
-
ISEVEN ISODD V2
AuditExcel
233 views
How to find even & odd numbers in excel
-
VLOOKUP TRICKS V2
AuditExcel
2,918 views
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...
-
Double header check function V2
AuditExcel
143 views
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.
-
TRIM Function V2
AuditExcel
850 views
The TRIM function removes all spaces from a cell except for a single space between words.
-
TEXT Function V2
AuditExcel
144 views
The text function converts values to text in a specified format.
-
Out of range checks V2
AuditExcel
271 views
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
Play all(118)