Aim

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

Who should attend

People with little or no working experience of spreadsheets. Confidence with Windows and the mouse is essential.
 

Course Content

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
Creating a new workbook
Inserting, deleting and moving worksheets

Calculations and Formula
Creating Calculations
Using Functions
Sum, Average, Max, Min, Count, Counta
Paste function

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

Copy and Move
Day and date sequences
Number sequences
Cut, copy and paste

Naming Ranges
Creating, using and pasting

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