Skip to main content

Read our latest COVID-19 (coronavirus) updates.

PayReportApply
PayReportApply
Read aloud icon Read aloud Accessibility icon Accessibility
IT training

Microsoft Excel 2016 (Basic)

  • Duration

    One day: 9.30am - 4.30pm

  • Description

    Microsoft Excel is a tool designed for storing and analysing numerical data as well as creating striking presentations of your data with charts. The course entails creating new or modifying existing spread sheets. Creating calculations to perform statistical analysis and designing charts to present the results.

  • Prerequisites

    A basic understanding of Microsoft Windows.

  • Agenda

    Exercise Details
    Exercise 1 Creating a simple spreadsheet
    • Entering data
    • Editing the worksheet
    • Formulae
    Exercise 2  Basic formulas
    • Subtraction
    • Multiplication
    • Division
    Exercise 3  Developing the worksheet
    • Naming the worksheet
    • More formulae
    Exercise 4  Changing the look of the worksheet
    • Changing fonts
    • Changing cell dimensions
    • Alignment
    • Adding a border
    Exercise 5 

    Printing the spreadsheet

    • Print preview
    • Scaling the print
    • Changing the set-up
    Exercise 6 

    Editing the worksheet

    • Clearing and deleting cells
    Exercise 7 

    Comments

    • Adding comments and text boxes to a spreadsheet
    Exercise 8

    Copying and Pasting

    • Copying and pasting headings in Excel
    Exercise 9 

    Worksheets

    • Importing worksheets
    • Linking worksheets
    • Source worksheets
    • Dependent worksheets
    • Paste special
    ​Exercise 10 

    Common Functions

    • Introduction to the more common functions such as:
      • Average
      • Count
      • Max and Min
    Exercise 11  Creating a chart
    • Creating a column chart
    • Formatting a chart
    Exercise 12  Freezing panes
    • Freezing columns or rows in a large spreadsheet

  • Goals and objectives


    Goals

    1. To show how and where Microsoft Excel can be effectively and efficiently availed of as a useful business tool.
    2. To develop and improve the users understanding of working with spreadsheets and the various ways spreadsheets can be formatted.

     

    Objectives

    After completing this course you will be able to:

    1. Open Microsoft Excel
    2. Open existing documents and create new documents
    3. Enter, edit and delete text
    4. Select cells and format information
    5. Insert new rows into the spreadsheet
    6. Create formulae
    7. Make use of the auto fill feature
    8. Format the appearance of the spreadsheet including text, cell sizes and alignments and placing borders on cells
    9. Adjust print settings and print the spreadsheet
    10. Add text boxes, and comments to cells
    11. Cut copy and paste information
    12. Import worksheets into your spreadsheet
    13. Linking worksheets
    14. Other functions within Excel
    15. Create charts
    16. Format charts
    17. Freeze columns and rows.

    You will be able to complete all of these course exercises using Microsoft Excel.

  • Costs

    External attendees: £110 plus VAT per candidate.

Read aloud icon Read aloud