Riverside Training Logo
|

|

Call us: 01432 359 244

Top
Intermediate Microsoft Excel
Intermediate Microsoft Excel
  • Short Course
  • Anywhere
  • Posted 4 months ago
  • Riverside Training
  • Next Course: 16th May 2017
  • Course Level: Level 2
  • Course Basics: A suitable course for people who have a broad knowledge of Microsoft Excel but want to proceed to the next step. a learn more advanced techniques and tools.
Apply now!
Upload your CV/resume or any other relevant file. Max. file size: 64 MB.

Intermediate Microsoft Excel

Duration: 1 day

Intermediate Microsoft Excel

In this unit you will develop skills to input, manipulate and output data, using complex and non-routine techniques to analyse and interpret the required information. You will use complex and non-routine knowledge and understanding, for example, data restrictions, data validation using formulae, pivot tables, data maps to set up and develop the functionality of spreadsheets in work based scenarios. You will use advanced spreadsheet tools, functions and techniques that are complex, require new learning aid and, at times, will involve having the idea that there may be a tool or function to your task easier.

  • Import Data from External Files
  • Use Data Validation (Drop Down Lists)
  • Use Conditional Formatting
  • Auto Filters
  • Advanced Auto Filtering (Subtotal)
  • Using Named Cells and Ranges
  • Calculating Across Worksheets
  • Protecting Worksheets
  • Advanced Functions (IF, AND, OR, VLOOKUP, HLOOKUP, CONCATENATE etc.)
  • Introduction to Pivot tables & Pivot Table Charts

What is involved?

Courses are delivered as workshops to gain new knowledge. Successful Certification comes from completing an external test or work based assignment focused on your business.

Courses are delivered at our Offices in Hereford or, if appropriate, can be delivered in your workplace according to numbers.

COURSE DATES

4th May 2017 – 1 day course

LOCATION

Riverside Training Ltd
6 St Martins Street
Hereford
HR2 7RE

COSTS

Funding is available through the European Social Fund according to eligibility criteria:

  • Learner is aged 19+, living and working in the Marches (Herefordshire & Shropshire)
  • The business employs no more than 250 employees (or 49 for Level 4)
  • The learner is not on any other government programme such as college or university

Riverside Training

Riverside Training is a Grade 2 Training Provider delivering Government subsidised Apprenticeships and commercial training. Based in Hereford and established in 1996, Riverside Training has grown from a city based operation to a provider operating nationwide. We offer work-based learning through nationally accredited qualifications that meet the needs of individuals and businesses. Ours is a personal approach that is flexible, responsive and professional. If you are looking for an apprenticeship, please have a look at our current vacancies, alternatively please contact us to discuss your requirements. If you are an employer and are looking to recruit, a £1,500 Government incentive may be available to assist your business. We also offer a variety of funded and commercial courses available to suit your training needs.