Home • Training • Databases • Contact Us • Site map

Onsite Microsoft Excel Training - Basic

Microsoft Excel is a spreadsheet application that features calculation, graphing tools, pivot tables and a macro programming language called VBA. It is used by a large proportion of the workforce for a variety of different purposes from storing lists through to complicated analysis. Microsoft Excel is an extremely powerful and easy to use application.

Our training Allows you to capitalise on this extremely useful resource. Our standard Basic course is outlined below but we can discuss bespoke courses and also collaborative development of any spreadsheet you wish to create.

Microsoft Excel Basic Training Course

Entering and editing data
Creating workbooks
Entering and editing labels and values
Entering and editing formulas
Saving and updating workbooks

Modifying a worksheet
Moving and copying data
Moving and copying formulas
Using absolute references
Inserting and deleting ranges

Using functions
Entering functions
Using AutoSum
Using AVERAGE, MIN, and MAX

Formatting worksheets
Formatting text
Formatting rows and columns
Number formatting
Using Format Painter and AutoFormat

Printing
Preparing to print
Page Setup options
Printing worksheets

Creating charts
Chart basics
Modifying charts
Printing charts

Web features
Saving workbooks as Web pages
Hyperlinks
Sending workbooks via e-mail