Excel Training
This one day Excel training course introduces the skills necessary for productive development of Excel workbooks. It includes tasks to explore Excel, use basic Excel workbook skills and create simple Excel formulas. Delegates will also learn how to use the Office Assistant, page setup, and how to print Excel worksheets.

SETTING UP A WORKSHEET
Overview of Excel
Screen Layout
Selecting areas of a worksheet
Moving around worksheets
Text and numbers
Saving workbooks
Opening and closing workbooks
Autorecovery
Creating a new workbook
Inserting, deleting and moving worksheets

CALCULATIONS & FORMULAS
Creating Calculations
Using Functions
Sum, Average, Max, Min, Count, Counta
Paste function
Conditional Sum Wizard
Lookup Wizard

FORMATTING WORKSHEETS
Using fonts and colours
Bold, italic and underline
Formatting numbers
Clearing cell formats
Inserting and deleting columns and rows
Resizing columns and rows
Task Pane

COPY AND MOVE
Day and date sequences
Number sequences
Cut, copy and paste
Office Clipboard
Smart Tags

NAMING RANGES
Creating, using and pasting
Protecting Ranges

PRINTING
Preview and print worksheets
Print ranges
Print headers, footers and titles

3D WORKSHEETS
Selecting more than one worksheet
Formatting and data entry
Creating 3D formula
Copying 3D formula

Follow on courses:

• Intermediate Excel Training
• Advanced Excel Training
• Excel Visual Basic for Applications (VBA) Training
• Excel 2007 Upgrade Training
• Excel Public course schedule dates

Tailored Excel Training, details available on request.

4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
information@premiercs.co.uk