Sunday, 28 September 2008

Macro and excel presentation topics

Excel Uses:
Creating lists
Write more uses…..
Robot making http://forums.trossenrobotics.com/showthread.php?t=1352

Getting help:
From the task pane
Online help which will connect to the Microsoft server, but it is a bit slow
You can switch to off line help, and search will be done faster. But the downside is that the online is always up to date, and might have articles and new answers that is not stalled in your computer.

Importing and exporting data
Import from web
Import from word
Exporting data

Contextual help
Format, cells, then from the help button, you can get specific help relating to that dialogue box you looking at.

Working with advanced functions:
If, time and date, lookup

Text concatenation
Using macros in excel (recording, deleting, ways of uses)

Printing of excel:
Show pupils how economize the use of paper
Printing and hiding data

No comments: