Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Analysis

Data Analysis

ResolvedVersion 2013

Mon 23 Mar 2015, 16:03 Delegate Pearl said...

Pearl has attended:
Excel Advanced - Formulas & Functions course
Excel Advanced course
Emotional Intelligence at Work course

Data Analysis

How to Validate information

Tue 24 Mar 2015, 13:44 Trainer Marius said...

RE: Data Analysis

Hello Pearl,

Thank you for your forum post. Data validation covers a wide range of possibilities. Please could you tell me what type of data you have and how you wish to validate the data?

Kind regards
Marius Barnard
Excel Trainer

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.

=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips

Data Analysis

Data Analysis

RE: Data Analysis

Excel articles

Excel tip:

Adding a comment to a formula