Speak to one
of our advisors
today

0208 443 2888

Microsoft Excel

Duration: 3 days
Next Courses :

Excel Advanced
13th October 2008

Cost: £100
Concessionary offer*: Only £50!
Times: 10am - 4.30pm

 

 

 

 

Do you need to improve your Microsoft Excel knowledge? In the modern office this is an essential tool required by most employers.
At the end of this course you will have a good understanding of the basic features and functions of Excel. You will be confident using Excel, and be able to create a spreadsheet from scratch. You will understand how to use the built-in calculation and formula functionality. All in all you will be more productive with Excel in your work and at home.

Suitable for:

Our Microsoft Excel introduction course is designed to accommodate complete beginners.

Prerequisites:

  1. A basic understanding of the windows environment.
  2. A basic level of numeracy and literacy is required.

Book this course now by calling 020 8443 2888 or complete the online enquiries form

Course outline:

Getting Started

  • Spreadsheet terminology
  • Exploring the Excel window
  • Getting help
  • Opening and navigating
  • workbooks
  • Closing workbooks

Entering and Editing data

  • Creating workbooks
  • Entering and editing
    labels and values
  • Entering and editing formulas
  • Saving and updating workbooks

Modifying a Worksheet

  • Moving and copying data
  • Moving and copying formulas
  • Using absolute references
  • Inserting and deleting ranges

Using Functions

  • Entering functions
  • Using AutoSum
  • Using AVERAGE, MIN, and MAX
  • Formatting Worksheets

Formatting text

  • Formatting rows and columns
  • Number formatting
  • Using Format Painter and AutoFormat

Printing

  • Preparing to print
  • Page Setup options
  • Printing worksheets

Creating Charts

  • Chart basics
  • Modifying charts
  • Printing charts

List Management

  • Working with lists
  • Sorting and filtering lists
  • Advanced filtering

Using Templates

  • Built-in templates
  • Creating and managing templates

Book a course now by calling 020 8443 2888 or complete the online enquiries form
*Concessionary offer is courtesy of Part-funding from Enfield Lifelong Learning Service where applicant meets the necessary criteria. Please enquire for more details.


Back to Top