-
Duration
One day: 9.30am - 4.30pm
-
Description
Microsoft Excel is a tool designed for storing and analysing numerical data as well as creating striking presentations of your data with charts. The course entails creating new or modifying existing spread sheets. Creating calculations to perform statistical analysis and designing charts to present the results.
-
Prerequisites
A basic understanding of Microsoft Windows.
-
Agenda
Exercise Details Exercise 1 Creating a simple spreadsheet - Entering data
- Editing the worksheet
- Formulae
Exercise 2 Basic formulas - Subtraction
- Multiplication
- Division
Exercise 3 Developing the worksheet - Naming the worksheet
- More formulae
Exercise 4 Changing the look of the worksheet - Changing fonts
- Changing cell dimensions
- Alignment
- Adding a border
Exercise 5 Printing the spreadsheet
- Print preview
- Scaling the print
- Changing the set-up
Exercise 6 Editing the worksheet
- Clearing and deleting cells
Exercise 7 Comments
- Adding comments and text boxes to a spreadsheet
Exercise 8 Copying and Pasting
- Copying and pasting headings in Excel
Exercise 9 Worksheets
- Importing worksheets
- Linking worksheets
- Source worksheets
- Dependent worksheets
- Paste special
​Exercise 10 Common Functions
- Introduction to the more common functions such as:
- Average
- Count
- Max and Min
Exercise 11 Creating a chart - Creating a column chart
- Formatting a chart
Exercise 12 Freezing panes - Freezing columns or rows in a large spreadsheet
-
Goals and objectives
Goals- To show how and where Microsoft Excel can be effectively and efficiently availed of as a useful business tool.
- To develop and improve the users understanding of working with spreadsheets and the various ways spreadsheets can be formatted.
Objectives
After completing this course you will be able to:
- Open Microsoft Excel
- Open existing documents and create new documents
- Enter, edit and delete text
- Select cells and format information
- Insert new rows into the spreadsheet
- Create formulae
- Make use of the auto fill feature
- Format the appearance of the spreadsheet including text, cell sizes and alignments and placing borders on cells
- Adjust print settings and print the spreadsheet
- Add text boxes, and comments to cells
- Cut copy and paste information
- Import worksheets into your spreadsheet
- Linking worksheets
- Other functions within Excel
- Create charts
- Format charts
- Freeze columns and rows.
You will be able to complete all of these course exercises using Microsoft Excel.
-
Costs
External attendees: £110 plus VAT per candidate.