Presentations

How did it come about?

Was it 1997, ’98? For an Excel training I had to do in English (as a primarily Dutch speaker), it seemed practical to have some key points ahead of time. After some scribbling on paper and several false starts, PowerPoint proved to be a suitable medium. Thus the first version of Excel 97.ppt came into existence, containing some fifty slides.

It worked and gave me an appetite to do more. Wouldn’t it be nice to have all of Excel made accessible in this way: with all kinds of trivia, exceptions and tricks ready at hand. And with the differences per version (Microsoft’s ‘perversions’). That’s how the thing grew to ± 1,400 slides. To prevent the work from disappearing into the void, with a ‘format c:’, after the memorial service, I published the result, ten years later, in our collective everlasting memory.

I figured that what was advantageous for Excel should also be possible for PowerPoint, Access, Word, Visual Basic for Applications, etc.

How far did I get?

In more than fifteen years of work, I didn't get very far. I can be brief about Office 2007 up to 2017: no trace to be found (yet). The presentations regarding Excel, PowerPoint and Introduction to Visual Basic for Applications are pretty much complete. Access is about halfway done. Word ... still nothing yet.

The language used is a sad story as well: sometimes Dutch, mostly poor English.

In these ten years, I've done other things in the meantime, such as earn a living. Anyhow, the presentations have taken quite some time. If you appreciate my activities and want to encourage me working on it more, you can either send me greetings, patches or make a donation:

How to use?

The presentations usually consist of three parts:

  • an introduction to the program, what it is capable of and how to use it.
  • an elaboration drill down of all menus, commands and options.
  • interesting details such as shortcut keys, specifications and how Windows settings may influence the behavior of the program.

The first twenty slides give an explanation on how the presentation is organized. Then, from the main menu that follows and with a few clicks, you can find a specific topic.

The PowerPoint.ppt presentation is in itself a realization of all the features of PowerPoint.

The files

The content on this site may not be used for commercial purposes. The presentations and example files (in whole or in part) may not be used in work, courses, classes, books or presentations without my express permission. I hope these files will add to your knowledge of the programs covered.

The use of the files is at your own risk.

For best performance [Save] and view the files locally. That will work better than [Open] in the browser. Most presentations contain macros. According to me, they are safe :-). Switch the macro security to Medium that you can choose to (not) use them.

Presentation Mb Zipped Slides (±) Language Comments
Excel.ppt 20.6 13.0 1,400 English A lot (almost anything) about Excel.
PowerPoint.ppt 22.4 14.4 1,200 English Ibid regarding PPt. Still missing are the slides on actually delivering a presentation to an audience.
Access.ppt 21.4 13.0 1,950 English This presentation is still very shaky. I hesitated on publishing it, but the beginning is interesting enough (according to me).
VBAIntro.ppt 5.9 3.1 750 Dutch In this ‘Intro’, basic, elementary Visual BASIC topics are discussed: variables, loops, etc.
VBAatje.xls 2.4 0.8     In VBAatje.xls you‘ll find it all as working code.