Call us on 01452 221 777
Email us at info@glosenterprise.co.uk
My Cart
Login | Register

Excel - Intermediate

Who should attend?

Those who wish to develop their skills and who are proficient in the basic use of the application and now need to learn the product beyond the basic skills.

Why should you attend?

Delegates should be should be competent at the Windows interface and with the basic functions of Excel. Attendance on the beginners course would prove advantageous, but is not essential. Suitable for users of both 2010 and 2013, our trainer will guide you through the workings of MS Excel, with plenty of time for queries and questions. Bursting with hints and tips, you’ll come away with knowledge that will save you time and effort from the very next time you open a workbook.

Course outline

After the course delegates will be able to:

  • Make decisions using the IF function
  • Make decisions based on more than one criteria
  • Work with cross-referenced cells
  • Link data between worksheets, workbooks and MS Word
  • Create and customise charts
  • Use conditional formatting to highlight significant data
  • Use Excel to sort and filter data
  • Analyse tables of data with common functions
  • Work with dates in Excel

Cost

Course: £252.00 +VAT

Time & Location

9:30AM until 4:30PM @ Twigworth Business Centre

Available dates

Related Courses

insert-alt

Excel - Advanced

This course is delivered over 1 full-day at our training centre in Twigworth. Building on the regular user’s skills, this course will demonstrate use of macros, merging of data with existing databases, complex questioning styles and data mapping. Designed for the high level user who wants to design custom interfaces and act as an administrator for other colleagues, this course will release the enormous potential of Excel.

 insert-alt

How to Set & Manage a Budget

Please email us at info@glosenterprise.co.uk if you are interested in attending this course and we will let you know the next date. All good supervisors, managers and senior managers should understand their business's finances to do their job well. You don't have to be accountancy-trained, but having confidence around the "numbers of the business" stands you in good stead, regardless of your role. This course provides the solid foundation on which you can build.​

 insert-alt

PowerPoint

This course is delivered over 1 full-day at our training centre in Twigworth. The most graphical of the MS Office suite members, PowerPoint has rapidly become popular for creating presentations, slide shows and electronic animated displays using project outlines, backdrops and graphic files. This course will demonstrate the fundamentals of presentation creation and show how the introduction of pictures, backdrops, transparencies and font styles can transform a presentation into an experience.