Excel Intermediate

4.7
6 reviews
  • The instructor had a lot of knowledge on the subject matter. The rest of the course characteristics were accomplished, such as meeting the objectives, structuring the course, givinf examples, etc.
    |
  • I recommend this course as the instructor who gives the training is amazing: he knows a lot about the subject matter and his presentation skills are very good.
    |
  • Overall the course was very good. You could ask the tutor anything and he would give good examples and explanations. The course material was well structured and I avhieved all expectationes I had thought about before starting this course.
    |

Course

Inhouse

£ 535 + VAT

Description

  • Type

    Course

  • Level

    Advanced

  • Methodology

    Inhouse

  • Duration

    1 Day

  • Start date

    Different dates available

This course is suitable for those with prior experience and covers: working with tables; working with charts; working with graphics; workgroup collaboration; financial & logical functions; financial and logical functions; date and time functions; and managing workbooks.

Facilities

Location

Start date

Inhouse

Start date

Different dates availableEnrolment now open

About this course

This course is suitable for those with prior experience and covers: working with tables; working with charts; working with graphics; workgroup collaboration; financial & logical functions; financial and logical functions; date and time functions; and managing workbooks.

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

Reviews

4.7
excellent
  • The instructor had a lot of knowledge on the subject matter. The rest of the course characteristics were accomplished, such as meeting the objectives, structuring the course, givinf examples, etc.
    |
  • I recommend this course as the instructor who gives the training is amazing: he knows a lot about the subject matter and his presentation skills are very good.
    |
  • Overall the course was very good. You could ask the tutor anything and he would give good examples and explanations. The course material was well structured and I avhieved all expectationes I had thought about before starting this course.
    |
100%
4.6
excellent

Course rating

Recommended

Centre rating

Anonymous

5.0
10/08/2016
What I would highlight: The instructor had a lot of knowledge on the subject matter. The rest of the course characteristics were accomplished, such as meeting the objectives, structuring the course, givinf examples, etc.
What could be improved: Nothing bad.
Would you recommend this course?: Yes

Anonymous

5.0
10/08/2016
What I would highlight: I recommend this course as the instructor who gives the training is amazing: he knows a lot about the subject matter and his presentation skills are very good.
What could be improved: I cannot describe this course with any negative words.
Would you recommend this course?: Yes

Ben Fraser

5.0
10/08/2016
What I would highlight: Overall the course was very good. You could ask the tutor anything and he would give good examples and explanations. The course material was well structured and I avhieved all expectationes I had thought about before starting this course.
What could be improved: Everything OK.
Would you recommend this course?: Yes

Susan Bodth

4.5
10/08/2016
What I would highlight: Overall it was an excellent training with the advantage of back via web! The objectives and expectations were met; Grant Gamble, our instructor, was very good at presenting examples and structured the course very well.
What could be improved: Everything was good.
Would you recommend this course?: Yes

Stacey Booth

4.5
10/08/2016
What I would highlight: The course was perfect. There were no negative aspects. The tutor was amazing. The class was interactive and we met the objectives set at the beginning and the expectations I had.
What could be improved: Everything was good.
Would you recommend this course?: Yes

Sally McDonald

4.0
10/08/2016
What I would highlight: A very useful course as we covered a lot of different areas. Overall it was an excellent course: our instructor was superb and very knowledgeable.
What could be improved: I cannot describe this course with any negative words.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

Subjects

  • Excel
  • IT
  • Graphics
  • Financial
  • Financial Training
  • MS Excel
  • Excel Intermediate on-site training
  • Excel Intermediate in-house training
  • Excel Intermediate training

Course programme

This course is suitable for those with prior experience and covers: working with tables; working with charts; working with graphics; workgroup collaboration; financial & logical functions; financial and logical functions; date and time functions; and managing workbooks.

Working With Tables

Creating A Table, Enter Data Into A Table, Deleting Rows And Columns, Formatting A Table, Totaling Data In A Table, Sorting Data In A Table, Sorting Multiple Columns, Filtering Data Using Autofilter, Creating Custom FiltersOn Your Own

Working With Charts

Creating A Chart, Moving A Chart, Resizing A Chart, Changing The Layout And Style, Labeling Chart Elements, Formatting Chart Text, Formatting Chart Elements, Changing The Chart Type, Showing Or Hiding Gridlines, Customizing Axes, Creating A Pie Chart, Changing A Chart€™S Source Data, Moving A Chart To A Different Worksheet, Saving A Chart Template, Filtering Chart Data, Using Sparklines, Customizing Sparklines

Working With Graphics

Adding Clip Art, Adding Pictures, Adding Shapes, Formatting Drawing Objects, Inserting Wordart, Inserting Smartart, Inserting An Organization Chart, Modifying An Organizational Chart, Taking A Screenshot

Workgroup Collaboration

E-Mailing A Workbook, Web Page Preview, Converting Worksheets Into Web Pages, Inserting Hyperlinks, Viewing And Editing Comments

Financial & Logical Functions

Using The If Function, Using Nested Functions, Using The Pmt Function, Using The Fv Function, Using Autocalculate

Date And Time Functions

Understanding Date/Time Functions, Adding A Date And A Date Interval, Subtracting Dates, Calculating Time Intervals

Managing Workbooks

Creating A Workbook Using A Template, Creating A New Template, Editing A Template, Showing Or Hiding Workbook Elements, Creating A Workspace, Comparing Two Workbooks Side By Side, Saving A Workbook In A Different File Format, Using Data Consolidation

Additional information

£450 for one-to-one training

£550 for groups of up to 6 people

£650 for groups of up to 12 people

Excel Intermediate

£ 535 + VAT