Office Training - Excel - Account, Expenses, Stock Tracking

Employees with Excel proficiency are highly sought after and it's rare to find a job that won't ask for at least one of the Office components Word, Excel or Outlook. Excel training courses tend to come in a variety of levels ranging from Introduction through to Intermediate and finally Advanced level courses.

Introduction Excel courses are focused towards new computer users who are competent in using a mouse, navigating windows and possibly surfing the internet. These courses guide students through the basics of Excel including the following skills:

Creating basic work sheets - navigating the user interface,

Basic Excel formulas - creating basic formulas, using functions

Manipulating data - inserting cells, rows, columns, searching for data

Formatting worksheets - changing fonts, adding borders, applying cell styles

Printing workbooks - using print options, page breaks

Managing several workbooks - using worksheet tabs

Intermediate courses are ideal for students with previous knowledge of Excel who are looking to progress their skills one step further. An intermediate course focuses more on formulas, tables and graphical objects in the Excel environment. Some of the skills covered by an intermediate course are:

Using advanced formulas - using cell and range names, calculating data between cells and over ranges, using lookup functions.

Working with table data - creating and modifying tables, sorting data and table calculations

Presenting data with charts - Creating, modifying and formatting Excel charts

Inserting graphical objects - inserting pictures and ClipArt, drawing shapes, creating workflows

Customizing the environment - customizing workbooks, managing themes

Advanced Excel training courses extend students knowledge into the more specialised areas of Excel such as Macros, Collaboration and auditing. Advanced courses are only suitable for people with a good experience of Excel who need to take their skills to the highest level. These courses tend to focus on the following Excel skills:

Macros - creating Macros, validation and conditional formatting

Collaboration - sharing work books, revision tracking and merging workbooks

Auditing - using trace cells, watching formulas, creating data lists

Analyzing - creating a trend, using scenarios

Working with multiple workbooks - creating a workspace, linked cells, edit links

Excel and the web - publishing worksheets, importing data, using web queries

XML - creating XML maps for workbooks