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.