|
Featured Tutorial
Featured Macro
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
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