Excel Intermediate

Expand your knowledge. Begin your journey into the more advanced aspects of Excel.

Learn fundamental keyboard shortcuts. Build custom formulas by combining functions with conditional formatting. Master pivot tables, slicers and named ranges. Put it all together by creating a basic model with a dashboard and then finally, protect your work.

Overview of the day

At the start of each training day, all participants will be given a workbook outlining three scenarios. We will work through the first scenario together as a team. Later in the day, we will challenge you to take on the second scenario as an individual, thus helping us to identify further training needs. The last scenario will be for you to take away at the end of the day to further practice.

Throughout the day, we will provide light refreshments (complementary fruit and snacks) to keep energy levels and concentration up. Lunch will not be provided. Quizzes, with prizes(!), and videos will be used to reinforce learning and keep the mood light-hearted. A larger quiz will be used at the beginning and end of the course to help you appreciate how much you have grown in knowledge throughout the day.

Typical day – 7 hours.

But the learning doesn’t have to stop there. We also make provision for each attendee to have up to one hour 1-1 support for five working days afterwards. During this time, feel free to contact us and ask for support related to the training provided.

Excel Intermediate

Expand your knowledge. Begin your journey into the more advanced aspects of Excel.

Learn fundamental keyboard shortcuts. Build custom formulas by combining functions with conditional formatting. Master pivot tables, slicers and named ranges. Put it all together by creating a basic model with a dashboard and then finally, protect your work.

7 hrs | Maximum attendees: 10

We will cover the below topics:

Formula Manipulation

Data Manipulation

Data Presentation

As well as…

£259 + VAT

(per attendee)

solve. excel.

Three things make the training at Solve & Excel Consultancy special:

Training based on scenarios. Our training is built around scenarios and storytelling rather than a to-do list of learning. This method leads to a more enjoyable and memorable training session for all.

Tailored training: Did you know that Excel has over 500 functions? As well as teaching the commonly used functions, we can tailor our training to focus on those relevant to your company.

Continued support after we leave: We provide 1-1 support for all attendees lasting 5 working days after the training day. It is perfect for those moments when you can’t quite remember what to do next or, why the error keeps coming up in your newly learned formula! There is also our free YouTube Channel content, where you can continue to access relevant videos and ask questions long after we have left. Subscribe here.

Excel Calculator

Good training is an invaluable investment that can offer returns for a lifetime.

Interested in a booking a training class for you and your team? We have created a calculator to help guide your planning. Please feel free to call us for further information.

  1. Choose the course from the drop down menu
  2. Type in the number of attendees expected – bearing in mind the maximum number of attendees per class
  3. Type in the postcode of where training will be. The first half of the postcode will suffice. The postcode will also determine if there will be a travel fee added to the cost
  4. Select if you would require a training room to be booked.

Please note that the calculator serves as a guide only.

Excel humor:
What is the most used function in a programme?
‘Export to Excel’.

We would love to speak with you. Book your free consultation below.