Intermediate Microsoft Excel

Who should attend?

This course is ideal for anyone who wants to learn the intermediate uses of Excel and has some basic knowledge of this application. This course will provide further tools to complete more difficult tasks and reduce time in their completion. It is recommended that the introduction course is completed if you find working with formulas difficult or have no prior knowledge of Excel.

Course objectives

This course aims to give delegates confidence when using the Microsoft Excel programme in easy to follow steps. Those attending will be able to summaries’ tables based on varying criteria and look at quick ways to get work done with time-saving tips and tricks. Aimed at users with a basic knowledge of Excel.

Course outline

This session will include:

  • Introduction to more Advanced Functions
  • Working with dates, text and conditional questions
  • Use of conditional Formatting
  • Working with Data
  • Working with External Data
  • Charting with Excel
  • Tables
  • Collaboration Tools
  • Auditing Workbooks

 

Course Progression

We offer a full range of further IT courses, including Advanced Excel.

Book This Course

To book onto this course, please contact us or click below to fill out our booking form.

Book Now

Latest Tweets

APPRENTICE QUALITY INSPECTOR-new role available in the largest independent lubricants company in the UK. They manufacture/supply products to industry, agriculture, transport, automotive and garage sectors. Interested send a CV to tracey.secker@ptp-training.co.uk #apprenticeships pic.twitter.com/BIDJxBNALz

Checking the facilities @WarwickshireCCC for the @LadderForBrum apprenticeship awards @ReachEventsWM @PtpTraining Retweeted by PTP Training Ltd

Great conversation led by @isamutlib and @KevinRDavis @bameaaUK lunch regarding the importance of #leadership in #DiversityandInclusion. Great point made- "if it's not important to the boss it's not important to the #business" pic.twitter.com/4uaDajftaP Retweeted by PTP Training Ltd

@PtpTraining offer apprenticeships in a number of different areas including business administration, engineering, manufacturing, dental, care, IT, butchery and warehousing. #WomenInBusinessExpo #Birmingham, Register Your FREE Ticket: Eventbrite : bit.ly/2zg1v5R pic.twitter.com/Z8YNdPpD10 Retweeted by PTP Training Ltd

Follow us on Twitter @PtpTraining

Sign up to receive updates


I agree to PTP sending me marketing information by email about courses, apprenticeships, events, offers and company news.
If you give consent to be contacted we will retain your details on our system and only contact you via the methods selected, with the information you have said you wish to receive. If you decide in the future that you wish to withdraw consent, please contact us via info@ptp-training.co.uk or select unsubscribe on email communications.