Excel Basic Certificate
Short course
In Exeter
Description
-
Type
Short course
-
Location
Exeter
-
Duration
1 Day
Suitable for: This course is suitable for anyone who wishes to use excel at a basic level.
Facilities
Location
Start date
Start date
Reviews
Course programme
Description: Getting started;*Workbooks*Inserting and deleting sheets, naming sheets and useful conventions.*Highlighting a whole worksheet*Copying lists (e.g. months of the year)*Tool bars and Menu bars* Creating a simple budgeting spreadsheet:*Setting up your workbook sheets *Entering outlines, adding borders and shading *Viewing the screen (including resizing and freezing panes) *Resizing columns to fit text *Adding and formatting headings *Autosum, addition, simple formulae and borrowing functions *Format numbers (style, decimal places and alignment) *Printing and page set up* Creating a Pie Chart*Resizing data labels *Changing the colour of the segments *Printing the chart*Inserting a chart into word *Creating a bar chart: *Creating a bar chart *Altering the Axes *Changing the background colour *Adding a deleting a border *The afternoon session is for delegates to practice what they have learnt in the morning, and bring any work they would like help and advice on.
Suitable for: This course is suitable for anyone who wishes to use excel at a basic level.
Excel Basic Certificate