Excel Forum

Highline Excel Class 25: Fix Problems & Errors In Spreadsheet

Learn about:
1.Nine errors & what they mean and how to fix them: ####, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Reference, #NULL!
2.AVERAGE function will include zero in calculation, but not blanks
3.Go To Special Blanks
4.Ctrl Enter to add numbers to many cells instantly
5.SUM function will not add text, but the plus sign will
6.Convert number as text to numbers: 1) Text To Column or 2) Copy zero, Paste Special Operations Add

This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Got a Question? Ask it Here in the Forum.