Excel Course – Proficient (Intermediate) Level


Product Total: 79.00
SKU: 5a4b25aaed25 Category:

Microsoft Excel is a key part of many office roles; it is particularly important to jobs with an element of finance, accounts or bookkeeping. However, many Admin, PA, sales staff and numerous other roles now require proficient level skills in Excel. Many employers will test their new employees on excel skills and will not hire staff who fail to demonstrate Excel skills.

Excel Training Course Objective

To enable students to gain proficient level skills in Excel. Our
training centre is a Microsoft Office Academy and this ensures that we
deliver all training to the highest level. The Excel Training Course is
also a CPD Accredited course, so CPD Certification is issued to staff on
completion of the training.

Course Format

The course is delivered using a virtual tutor on a live server. This is
a state of the art learning system. The virtual tutor will instruct you
and correct your exercises. This standard of interactive learning will
enable you to gain from interactive learning. This is available to you
on a flexible basis, either online at home or you can take the training
in our centre. You can also contact our live tutor at our centre in
London for any doubts.

Course Content

Increase your efficiency in Excel

  • Microsoft Excel Help
  • Checking spelling, find and replace
  • Inserting/deleting rows, columns and cells
  • Moving cells, copying to non-adjacent cells
  • Copying cell format quickly, merging cells, orientation of cell content
  • Cell styles
  • Sorting data

Multiple worksheets and various views

  • Sheet name, tab colour, inserting, deleting sheets#
  • Sheet background
  • Moving, copying, hiding sheets
  • Splitting the window, freezing a column/row, hiding elements of a sheet
  • Repeating rows/columns on printed pages

More complex Excel Tables, Formulas and Functions

  • Merging and Wrapping text
  • Absolute reference in a formula
  • Copying values, copying with a link, transposing
  • Calculating with functions
  • Control date, date formats
  • Simple conditions
  • Custom formats
  • Applying, managing conditional formats
  • Naming a range of cells
  • Validation rules
  • Multiple cell ranges and calculations in functions

Charts in Excel to present data

  • Creating and managing a chart
  • Selecting, adding and removing items in a chart
  • Formatting chart items
  • Modifying a chart’s text items
  • Printing and page layout of a chart
  • Sparklines in Charts
  • Managing chart options, data series, labels and axes

Visuals in Excel

  • Creating a drawing object
  • Selecting and deleting objects
  • Copying and moving objects
  • Resizing a drawing object
  • Modifying a text box
  • Modifying a drawing
  • Formatting drawing objects
  • Inserting a picture
  • Managing pictures
  • Rotating and aligning objects
  • Stacking and grouping objects

Database functionality with an Excel table

  • Subtotal rows
  • Automatic calculations in a table
  • Automatic filtering
  • Custom filters
  • Blank cells and duplicates
  • Advanced filtering with a criteria range
  • Criteria ranges
  • Copying rows filtered using a criteria range
  • Statistics with a criteria range
  • Flash Fill

Dates and Duration

The course lasts for three months, but can be completed earlier. It can
be taken online from anywhere. Learners have an option for one month of
training in our training centre.

Course Requirements

You will need to have the full set of skills covered in the Beginner Excel Course. Please look into taking our combined Beginner and Proficient Level Course, if you require some of the Beginner skills.

Course Benefits

  • Training written by senior Microsoft Trainers from a Microsoft
    Certified Academy, so the content has been certified to the highest
  • Interactive training from a live server with Virtual Tutor enables
    learner to receive instruction, as if they have a personal tutor
  • CPD Accredited Excel Course with a CPD Certificate of Excel Proficiency issued on successful completion
  • The training is highly practical with numerous exercise to ensure that you remember these details
  • Professional accredited qualification will build your CV

Excel Courses