Wednesday, February 11, 2009

Online Excel Tutorials

From the first assignment I have learnt:


- how to add an icon/function to the Quick Access Toolbar. It is very practical like this you can add the icons that you use frequently so that you do not have to go look for them in a submenu for example.


- that with the ALT button you can use keyboard functions for every icon in Excel. It is helpful for when your mouse is not functioning or sometimes it is faster to use keyboard shortcuts than to use the mouse.


- the new features of Excel 2007, like: Safer files, Less risk of file corruption, Reduced file size, More useful data,...


- what the several extensions like *.xlsx, *.xlsm, *.xltx, *.xltm, *.xlsb, and *.xls (Excel 97 - Excel 2003 Workbook) stand for.




From the second assignment I have learnt:


- what #NAME?, #REF!, and ##### stand for. I always knew that it meant that there is an error in the cell but now I know to what kind of error it refers to.








The online tutorials are very good to get everyone in the class at the same level of Excel 2007 so that we can make more complex things, for example, like the Loan Payment Calculator that we did last class.

No comments:

Post a Comment