The different Wise Owl Excel training courses

You can see our Excel courseware, exercises, venues and blogs at our main Excel page.  This page shows you what our different Excel courses cover. 

Introduction to Excel

Our one-day introduction to Excel course will show beginners in Excel how to create basic spreadsheets like this:

Excel formatted spreadsheet

Learn how to create formulae in spreadsheets, and format them to look nifty!

 

The course covers creating formulae, formatting spreadsheets, printing and (if time allows) creating charts.

Intermediate / Advanced Excel

We run a two-day training course called Advanced Excel, although in truth it's more intermediate-cum-advanced.  The course covers all of the useful features in Excel which a basic user could not be expected to stumble across.

The VLOOKUP function

One of the functions covered on our advanced two-day course: VLOOKUP.

The easiest way to get an idea of what's covered on this advanced Excel course is to have a look at some of the exercises.

Excel Business Modelling

As an alternative to our two-day advanced Excel course, we offer a two-day training course in creating robust financial models in Excel.

Although much of the content on this course is the same as for our advanced course, the modelling course is aimed at more proficient users of Excel.

The modelling course covers, among other things:

Topic Contents
Range names Everything there is to know about range names - the raison d'etre of the course!
Styles How to apply consistent formatting easily to different parts of a model.
Functions Not just the "easy" functions like IF and VLOOKUP, but also MATCH, INDEX, INDIRECT, SUMPRODUCT ... in fact, an example of every useful Excel function.
Short-cut keys If you like short-cut keys in Excel, this is the course for you.

Excel Data Analysis (PowerPivot, PowerView, PowerMap)

This two-day course covers the Power Business Intelligence side of Excel (Power BI), including PowerPivot, PowerView and PowerMap.  If you spend your life creating pivot tables in Excel, this will almost certainly make your life easier!

Data model in PowerPivot

PowerPivot lets you import tables from a variety of data sources, and create data models linking them together with renamed and simplified fields and tables.

We think everyone who analyses data in Excel should be using PowerPivot (you're welcome to call or email to find out more about what this course covers).

Excel Visual Basic for Applications

Finally, we offer two courses in Excel VBA: a two-day introductory course for most people, and an advanced course for experienced VBA programmers.  The enjoyable but challenging starter VBA course will teach you how to write (and understand) code like this:

Sub ScatterWombles()

 

'random coordinates to put Womble at

Dim RandomRow As Long

Dim RandomCol As Long

 

'dimensions of Wimbledon Common

Const MaxRows As Long = 100

Const MaxCols As Long = 100

 

'name of womble being blown about

Dim WombleName As String

 

'check macro not already run

If Range("A1").Value = "" Then

MsgBox "Already scattered!"

Exit Sub

End If

 

MsgBox "WHOOOOSH!"

 

'refer to each of the cells in the range of Wombles

Dim WombleCell As Range

 

'set up reference to range of Wombles

Range("A1").Select

Range(ActiveCell, ActiveCell.End(xlDown)).Select

 

'loop over each of these cells

For Each WombleCell In Selection

 

RandomRow = Int(Rnd() * MaxRows)

RandomCol = Int(Rnd() * MaxCols)

 

'cut the contents of this cell

WombleName = WombleCell.Value

WombleCell.ClearContents

 

'paste them into random cell

Cells(RandomRow, RandomCol).Value = WombleName

 

Next WombleCell

 

'say we've finished!

MsgBox "Oh dear! A strong gust of wind has scattered the Wombles all over Wimbledon common (otherwise known as your spreadsheet). See if you can find them all and tell Uncle Bulgaria where they are (using the immediate window, perhaps)."

 

End Sub

You can see more about our VBA courses here.

This page has 0 threads Add post