Teaching a Microsoft Office Lesson

dresdenphile

I've been volunteered to teach the secretaries (about a dozen 40+ women) in our company something about Microsoft Office. Most of them only use Word, Excel, and Outlook, so those are the three programs I want to draw from to teach them something. The last time I was asked to do this, I talked about mail-merge, which seemed to go over pretty well. I don't have to cover one topic exclusively, but I'm supposed to talk for about 45-60 minutes.

Any suggestions on topic(s)? I want to be talk about something more advanced than "This is how you bold a word", but I'm afraid things like macros might cause blood to violently eject from their eye sockets.

starmanbrand

What do they use excel for? I would probably spend a good chunk of the time going over common errors people make with formulas, if they do any of that.

Crashtard

If they use excel a lot, maybe something like using the data sorting options would be a good lesson, or teaching them how to use the find & replace function to highlight cells you want to find easily. Data sorting makes my job easy, but it'd be a pain if someone didn't know how to use it.