£142.80

Excel Intermediate | LIVE Online Event |

Actions and Detail Panel

£142.80

Event Information

Share this event

Date and time

Location

Location

Online event

Refund policy

Refund policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

Event description
Ideal for the reasonably experienced user of Excel who wants to improve their skills when using Microsoft Excel.

About this event

This course is delivered over two 2.5 hour sessions on Tuesday 22nd June:

  • Morning: 09:30am - 12:00pm and
  • Afternoon: 2:00pm - 4:30pm

This course can be booked as:

  • a place on the live, online event for the date displayed above. Simply click the 'Tickets' button to get started
  • 1 credit from a Virtual Learning Credit Plan, saving you 16% off the full price (call us on 01392 409 198 to buy a credit plan)
  • an In-Company training course just for your team on a date that suits you (call for details on 01392 409 198)

Course overview

Our Excel intermediate course is ideal for the reasonably experienced user of Excel who wants to improve their skills when using Microsoft Excel. This Excel training course will develop your knowledge and teach you how to use more complicated functions.

You will train on the version of Excel that you use in your office or at home. Our courses are highly practical and interactive. We limit the class size to 8 to ensure the tutor has time to deal with any specific queries you may have. All Open courses take place in our Exeter training suite, we supply laptops for use during the session and your materials will be provided to you on a USB drive.

This course will build on your existing Excel skills and develop your knowledge to undertake more complicated tasks.

Who is it for?

A proficiency in basic Excel use is assumed. This course is designed for those who want to build on their existing Excel skills and learn the more complicated commands in Excel. This course is ideal for people who have been using Excel, but wish to gain a better understanding of the capabilities of this powerful application.

Anyone who has successfully completed our Excel Introduction Plus and feels ready to progress their skills will enjoy this course.

What will you learn?

You will develop more complex spreadsheets, use more advanced formulae and develop skills in data analysis techniques. You will learn how to work with multiple spreadsheets and how to link other spreadsheet and other workbooks. You will also learn how to link Excel with other Microsoft applications such as Microsoft Word.

Course Content

  • Customizing Quick Access Toolbar
  • Autofill – Fill By Example & Custom Lists
  • Working With Sheets, Links & Group Mode
  • Using IF, SUMIF, COUNTIF and other logical functions
  • Statistical functions, Rounding
  • Logical functions - Nesting, SUMIF & COUNTIF
  • Range Names
  • Linking to Word & External Workbooks
  • Short Cuts
  • Pivot Tables
  • Database Functions, Multiple Sorts & Filters
  • Date Arithmetic
  • Conditional Formats
  • Charting
  • Lookup Tables
  • Manipulating Data
  • Formatting and Display techniques
  • Sorting and Querying Data
  • Protection and Security

To view our other upcoming live, online courses, visit:

https://www.crisp-cpd.com/training-courses/open-courses

Please feel free to get in touch with our team on 01392 409 198 or email open@crisp-cpd.com to discuss;

  • Online open courses, including our training credit plans
  • In-company training
  • ILM accredited training
  • Coaching
  • E-Learning

... or with any other questions. We'd love to chat!

Share with friends

Date and time

Location

Online event

Refund policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

{ _('Organizer Image')}

Organiser Crisp Professional Development

Organiser of Excel Intermediate | LIVE Online Event |

At Crisp Professional Development, we've been delivering transformational learning for 30 years. We bring our knowledge, passion and unwavering belief that learning makes a difference, to organisational performance and individual well-being.

Our programmes are infused with emotional intelligence, positive psychology and an appreciative mindset ensuring participative and safe learning environments.

We only use qualified coaches and subject matter experts.

We operate across the UK and internationally, with a client base that includes PLCs, multi-nationals and the full range of SMEs and owner-managed businesses.

Our most popular professional development areas include:

 

Please feel free to call us on 01392 409 198 or email info@crisp-cpd.com to discuss your training requirements.

Save This Event

Event Saved