x

Contact Us


Please fill out this form to send us an enquiry.





01489 588453
Contact Us
Contact Us
icon

Project Management

icon

IT Courses

icon

Business Skills

Health & Safety

Microsoft Excel 1 - 2007

Print Page


Level Introduction
Date/Venue 25/08/10 - Salisbury
14/09/10 - Basingstoke
Duration 1 day
Time

9:15 to 16:30
Price Net - £150.00
VAT - £26.25
Gross - £176.25

Enquire

Introduction
 

You need to understand how to use the basic functions of Microsoft Excel. You may have used Microsoft Excel in your job or be new to Microsoft Excel, but have never been given any formal training in setting up a spreadsheet, manipulating its data and editing its content. This course will cover the basics relating to spreadsheets with an aim to improve your confidence when working with them. It will also include shortcuts that will enable you to achieve tasks quickly and efficiently with minimum effort.

At the end of the course you will have your training manual, access to a copy of the training file created during the course, additional Excel training files to download from our website and a course certificate.

Course Aims
 
  • To create and edit basic Microsoft® Office Excel 2007 worksheets and workbooks.
  • To improve your confidence when using Microsoft Excel at this level.
Course Objectives
 
By the end of this level you will be able to:
 
  • Create a basic worksheet
  • Modify a worksheet and its simple formulas
  • Create and Edit simple formulas [Sum, Min, Max and Average]
  • Format the data, cells and sheet
  • Sort a list of data and answer more complex questions of that data
  • Filter a list of data and answer more complex questions of that data
  • Create and edit a simple vertical bar chart
  • Print the contents of a workbook
  • Learn useful shortcuts
Content
 

Get Started with Excel - An Overview of Excel - Navigate in Excel - Select Data - Enter Data - Save a Workbook - Obtain Help

 
Modify a Worksheet - Move and copy data between cells - Fill cells with series of data - Edit cell data - Insert and delete cells, Columns, and rows - Find, replace, and go - to cell data
 
Perform Calculations - Create basic formulas - Calculate with functions - copy formulas and functions - Create an absolute and relative Reference - Quick and easy calculation techniques
 
Sort data - Sort options - Single column sort - Multi column sort - Question sorted data - Things you don’t do
 
Filter data - Simple filter - Custom filter - Top ten filter - Filter by text , date, currency, number, colour - Answer questions of filtered data
 
Format a Worksheet - Edit font size and type - Add borders and colour to cells - Change column width and row height - Merge cells - Apply number formats - Create a custom number format - Align cell contents
 
Develop a Workbook - Format worksheet tabs - Reposition worksheets in a workbook - Insert and delete worksheets - Copy and paste worksheets - Copy a workbook
 
Print Workbook Contents - Set a print title - Create a header and footer - Set page margins - Change page orientation - Print large and small data sets including charts
 
Customize Layout - Split a worksheet - Arrange worksheets - Freeze and unfreeze rows and columns - Hide and unhide worksheets
 
Create a simple Chart - Shortcuts to charts - Edit charts - Update chart data - Delete charts - Link charts
 
Further Information

If you wish to discuss any part of the course please don’t hesitate to contact us on 01489 588453

Course Includes
 
Lunch/refreshments, training manuals, training file created during the course, additional training files to practice with, certificate, post course support.
 
Training Venues for scheduled courses at: Whiteley - Southampton, Salisbury, Basingstoke
 
Testimonials
Comment: The trainer was excellent at explaining everything and made complicated things seem simple enough for me to put into practice. [CS Serco]  Comment: A most enjoyable course. The trainer was very knowledgable and approachable. Great to have a small class size. [SS Neuralt]
Excel 1

Enquire