Microsoft Excel Level 1

Course Aims

This extremely practical course introduces the learner to Excel It is entirely “hands on”, so those
attending will get practice in creating and modifying actual spreadsheets. A number of commonly used
timesaving features are also introduced giving the necessary skills to use this software effectively.
By the end of the course, the user will be competent with the following skills:

Course Content

Fundamentals

  • Spreadsheet Principles
  • The Screen Layout & Ribbon
  • Understand the Quick Access toolbar
  • Use Help & Set Preferences

Open & Close Workbooks

  • Open & Close Workbooks
  • Move Around a Workbook
  • Open Multiple Workbooks

Create & Save Workbooks

  • Understand Spreadsheet Structure
  • Enter Labels & Numbers
  • Save a New Workbook
  •  Save in Different Formats

Formulas

  • Create Simple Formulas
  • Understand Mathematical Operators
  • Use Brackets, Percentage & Ranges
  • Select Cells
  • Use AutoSum
  • Check Formulas

Edit Cells

  • Edit Cells by Overtyping
  • Edit Data in the Formula Bar
  • Edit Data in a Cell
  • Delete Cell Content
  • Use Undo & Redo

Copy & Move

  • Copy & Paste, & Cut & Paste
  • Use the Clipboard
  • Copy to a Range
  • Use the Fill Handle
  • Copy Formulas
  • Move or Copy Cells by Dragging
  • Use Shortcut Menus

Print

  • Print Worksheets
  • Use Print Preview
  • Change Orientation & Margins
  • Create & Edit Headers & Footers
  • Print Gridlines & Headings
  • Print Formulas

Format Cells

  • Use Bold, Italic & Underline
  • Change Font & Font Size
  • Format Numbers
  • Enter & Format Dates & Times
  • Use Alignment
  • Add Border Lines, Cell Colour & Font Colour

Format Worksheets

  • Manipulate Long Labels
  • Change Column Widths & Row Heights
  • Insert Columns & Rows
  • Delete Columns & Rows
  • Hide Columns & Rows

Workbooks

  • Use Multiple Worksheets
  • Rename Worksheets
  • Display Multiple Worksheets
  • Copy & Move Worksheets
  • Insert & Delete Worksheets
  • Group Worksheets

Cell Referencing

  • Use Relative Cell Addressing
  • Use Absolute Cell Addressing
  • Use Mixed Addressing

Functions

  • Understand & Use Insert Functions
  • Use SUM, MAX & MIN
  • Use COUNT & AVERAGE
  • Use the ROUND Function
  • Use the IF Function
  • Use COUNTIF & SUMIF

Charts

  • Understand Charts
  • Create Quick Charts
  • Create Embedded Charts
  • Compare Data Using Charts
  • Create Various Chart Types
  • Format, Modify & Print Charts

Who Should Attend?

This course is designed for complete beginners to Excel and those who are self-taught who wish to
refresh existing skills and learn quick ways of performing tasks. A good working knowledge of the
Microsoft Windows operating system is required.

Follow on Course
Excel Level 2

To book your place or for more information, call us on 0131 625 7142, or complete the form below:

Course Enquire

We’ll only use these details to contact you about your Course enquiry. Privacy Policy

Course Location

This course will be run at the Edinburgh Training and Conference Venue, which is situated in the centre of Edinburgh, just 5 minutes walk from Waverley Station and close to major bus routes, including the airport bus. Discounted parking is available at the St John's Hill NCP Car Park. Our training rooms are light and spacious, all are air conditioned with natural daylight.

Complimentary breakfast and lunch will provided, as well as tea and coffee throughout the day. If you've got any special dietary requirements just let us know, ideally in advance, and we will be pleased to cater for them. Our team will be there on the day to make sure everything goes smoothly. If there's anything you need please ask, because "If we Can we Will".

Chat with us
Chat with us
Hello, how can we help you ?
Connecting...
We are offline, but if you leave your message and contact details, we will get to to you as quickly as we can.
All of our operators are busy. Please try again later..
:
:
:
How can we help ?
:
:
This chat session has ended
Was this conversation useful? Vote this chat session.
Good Bad