Excel Training

Webtech Consulting provides short courses in Microsoft Excel using version 2003 or 2007. We can tailor a course for you running from 3 hours to a few days depending on the features of Excel you wish to learn.

Webtech Consulting IT Training and Website Design and Development Excel Basic

This course is for people who have no prior knowledge of Excel and need to produce reports, lists, budgets and analyse figures. Learn to use the following features of Excel;

Creating spreadsheets
Use simple formulas including AutoSum
Sort and filter lists of data
Creating charts

Excel Advanced

This course is for people who already use Excel and would like to learn spreadsheet enhancements using the following;

Linking worksheets
Relative and absolute cell referencing
Named ranges
Data Validation including drop down lists for data entry
Advanced functions such as IF, VLOOKUP, ROUND, COUNTIF, SUMIF
Filtering, Sub Totals and Pivot Tables
Grouping
Templates and Macros

Courses