Excel 2016 essentials: intensive

Course

In London

£ 139 VAT inc.

Description

  • Type

    Course

  • Location

    London

  • Start date

    Different dates available

On this course, you will learn the main key components of Excel for use in the office or at home. You will get to grips with the concepts, terms and functions of spreadsheets including entering data, changing the font, colour, size and style of your worksheeet, entering and deleting a column, row or sheet, using headers and footers, using common formulae and performing calculations such as Sum, Average, Minimum, Maximum, Count and If functions. You will also learn how to work on multiple sheets simultaneously, link across sheets and other applications such as Word.

Facilities

Location

Start date

London
See map
Keeley Street, Covent Garden, WC2B 4BA

Start date

Different dates availableEnrolment now open

About this course

•Enter data.
• Enhance the appearance of the data by changing the font, colour, size and style.
• Enter and delete a column, row or sheet.
• Use Headers and footers.
• Use key formulae.
• Perform key functions used in calculation such as Sum, Average Maximum and Count.
• Work on multiple sheets simultaneously.
• Link across sheets and other applications such as Word.
• Use spreadsheets in Word documents.
• Create charts, graphs and enhance their appearance.
• Use and create templates.

You will need to bring a pen and paper and a folder for your notes.

Each student has their own computer and you will be encouraged to practice as much as possible. An interactive whiteboard will help make demonstrations easy to understand. It will be a relaxed learning environment and step by step learning will help you become more skilled. You will have lots of opportunities to ask questions and address areas you need help in.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

Subjects

  • Ms Word
  • MS Excel
  • Word
  • Excel

Course programme

• Introduction to Excel.
• Entering data.
• Enhancing the appearance of the data by changing the font, colour, size and style.
• Entering and deleting a column, row or sheet.
• Headers and footers.
• Basic formulae.
• Basic functions used in calculation such as Sum, Average Maximum and Count.
• Working on multiple sheets simultaneously.
• Linking across sheets and other applications such as word processing.
• Using spreadsheets in word documents.
• Creating charts, graphs and enhancing their appearance.
• Using and creating templates.

Additional information

There are a number of courses you can do after this course, including Excel 2016 for the Workplace: intermediate. We run a number of courses in using Microsoft Office 2016 programs in the workplace. Our IT Skills for the Office - introduction or intermediate - would be an excellent follow on course. In addition, there are a number of courses with exams. Your tutor will advise you on the best courses to do next. For all courses with an exam, you will need to complete an assessment. Call our administrator on 0207 492 2511 to arrange an assessment with one of our course advisors or email General information and advice on courses at City Lit is available from the Student Centre and Library on Monday to Friday from 12:00 – 19:00. See the course guide for term dates and further details

Excel 2016 essentials: intensive

£ 139 VAT inc.