Introduction to Excel

These workshops are a very simple introduction to Excel using the same 'Jump in and try' approach as the other series. The main idea behind this approach was to give a little guidance and explanation as to what Excel can do, through letting the reader play around with my examples. This hopefully gives the reader enough confidence to work out their own problems and formulae etc without having to delve too deeply into ALL that Excel can do. If you want a wider view of Excel or more of a step by step approach a book is probably the best for you.

Averages and Mail Merges

Most people use Excel for its ability to dynamically work out the impact of new information using formula, so this workshop tried to briefly introduce these. I've also included a bit about mail merges as they are pretty useful things that are easy when you know how Read On >>

Basic Financial Statements

This VW takes the use of formulae further and places them in the context of financial modeling - not very complex financial modeling, but again just an introduction to the possibilities of using Excel for accounting. Read On >>

Database Functions

This is my favourite Excel workshop (and one of my favourite overall). A few years ago someone asked me if it was possible to do weblog analysis using Excel (rather than using a scripting language to do the filtering) and I worked this out. Not everyone is a Sysadmin with scripting skills and I think this is a great application of Excel, using it to extract and display only certain data Read On >>

A Whole Application

A solution to an assignment I set that illustrates how the techniques in the other workshops can be brought together to produce a end-user application. Read On>>

Planned Workshops

There are only four Virtual Workshops as I don't really use Excel or spreadsheets much myself and thus don't really have a great number of tricks and 'cute wee things' to share (beyond the basics) and so probably won't add anymore. I do have a vague plan to do something similar to this with Access as the tutorials tend to be horribly mind-numbing wizards affairs, or too complicated for the novice. There must be a middle ground and I may try to find it someday.

In this section

Related Reading

Related Books

Data Analysis and Business Modeling with Excel

Related Ads