Highline Excel 2013 Class Video 27

How To Track Down Excel Formula Errors (16 Examples)

DESCRIPTION

Topics in this video:
1. List of possible errors in Excel.
2. 4 Steps to finding formula errors.
3. 3 Examples of how to use the 4 steps.
4. Cleaning Text data with the TRIM function and Paste Special Values.
5. Cleaning Date data (Dates stored as text) with the Text To Columns function.
6. Examples of #DIV/0! #REF! #NAME? #N/A #VALUE! #NULL! #NUM! ####### Circular Cell Reference Errors.

WORKBOOKS

Download “Highline Excel 2013 Workbooks” Highline-Excel-2013-Video-Workbooks.zip – Downloaded 187 times – 21 MB




Be the first to comment

Leave a Reply