Excel Training

Webtech Consulting provides short courses in Microsoft Excel using Excel versions 2003, 2007 or 2010. 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 and Average
Formatting headings
Sort and filter lists of data
Creating charts
Printing Excel Spreadsheets

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
Protecting data including formula cells and worksheets
Data Validation including drop down lists for data entry
Advanced functions such as IF, VLOOKUP, ROUND, COUNTIF, SUMIF
Analysing lists using Filtering, Sub Totals and Pivot Tables
Grouping
Templates and Macros

Courses