Microsoft Excel  - Level 1Download Course Outline

This is the outline of our Microsoft Excel Level 1 course - Duration: 1 day

To be able to use a spreadsheet confidently has now become part of most people’s work.  However, it’s also where many people flounder because of lack of confidence and the necessary skills.  This course will give you the confidence and skills to use an Excel spreadsheet to enter, change and analyse information necessary to do your job. You will learn how to start working with Excel’s formulas and functions to manipulate both numbers and text and you’ll also find out how to create charts so you can communicate information effortlessly to your clients and colleagues. By completing structured exercises, using data relevant to your work, this course will show you how easy it is to use Excel and get the skills to become more efficient and productive in your work. It also prepares you for moving on to the Microsoft Excel Level 2 Course.

To get the most out of this course you don’t need any previous experience of using spreadsheets but you should be reasonably confident in general computer use and want to learn how to use the everyday features of Excel.

We specialise on on-site training and can come to you to run our course either on your PC's or provide our own high specification equipment.

If you want specific training for your staff, we're happy to customise this course to your requirements, adding or removing topics as necessary.


 Call us on 0800 0199 746  


Microsoft Excel  - Level 1 course content

Download a PDF course outline using the "Download Course Outline" link on the right.

An Introduction to the Excel Environment

  • Distinguish and use different parts of the Excel screen.
  • Understand cell referencing.

Basic Spreadsheet Skills

  • Enter spreadsheet data
  • Edit, clear and delete spreadsheet data.
  • Insert and delete columns and rows.
  • Adjust column widths and row heights.
  • Work with multiple columns and rows

Moving and Copying Data

  • Move and Copy the data provided using Icons
  • Move and Copy the data provided using th mouse

Formatting Cells

  • Correctly apply cell formatting
  • Correctly apply advanced cell formats using the Format Cells screen
  • Clear our formats from cells accurately
  • Copy formatting using the Format Painter

Working with Worksheets

  • Insert and Rename new Worksheets efficiently
  • Delete Worksheets
  • Move and Copy Worksheets using the mouse
  • Link worksheets to copy data onto multiple sheets

 

Autofill

  • Quickly copy the contents of a cell by "Dragging Down"
  • Automatically enter sequential dates, days or months
  • Create your own numeric sequences

Formulas and Functions

  • Accurately enter an Excel formula
  • Accurately enter an Excel function e.g. Sum, Min or Max

Using Quick Analysis* 

  • Entering formulas using the Quick Analysis feature. 

Freeze rows and Columns

  • Keep a portion of the sheet visible while the rest of the sheet scrolls

Printing 

  • How to use Print Preview
  • How to change margins and paper size
  • Using Headers and Footers
  • Scaling the page to fit on A4
  • Using Page Break Preview
  • Using Page Layout View 

Simple Charts 

  • How to insert a simple chart to show your data accurately.
  • How to modify a chart

 *Only applicable in an Excel 2013 training course

We also offer this course as Live Online Learning - follow this link to learn more.


 Call us on 0800 0199 746