Microsoft Excel Training Course – Level 1

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 in 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.

Download course informationGet a Quote for this Course

 

Microsoft Excel Training – Level 1 Course Contents - Duration: 1 day

An Introduction to the Excel Environment

  • Accurately 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.

Moving and Copying Data

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

Formatting Cells

  • Correctly apply cell font formatting
  • Correctly apply numeric formatting.
  • Correctly apply advanced cell formats using the Format Cells window
  • Clear out 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

Excel Formulas

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

Working with Basic Excel Functions

  • Accurately enter SUM, MIN, MAX, AVERAGE, COUNTA and TODAY functions.

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

Sorting and Filtering Data

  • Sort data into alphabetical or numeric order.
  • Use Custom Sorting to sort to more than one level.
  • Filter data to show only the data you want to see.

Printing

  • How to use the Print and Print Preview areas
  • How to change margins and paper size
  • Using Headers and Footers
  • Scaling the page to fit on A4
  • 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

Speak to a trainer now

0800 0199 746
for any questions about the courses we offer