Excel Training - AVRA Communications

MICROSOFT EXCEL TRAINING

Microsoft Excel Training

From Pivot Tables, charts and forecasting to learning how to use functions to get the best out of your data analysis. Our Excel training is delivered to small teams to drive results from this powerful software.

Cost

Introduction: £150 per student *

Intermediate: £225 per student *

Advance: £225 per student *

*minimum of 2 students per course, maximum of 4

What’s in the training?

Microsoft Excel Introduction Level

Fundamentals of spreadsheets, understanding the grid and column grid, your first 10 really useful functions. You will learn how to organise information, make calculations and how to visualise analysis on a variety of charts. You will become competent in cell formatting, and referencing between cells in the same worksheet.

Duration: 2 x 2 hour remote sessions

Microsoft Excel Intermediate Level

You will build on the basics and will learn how to use more complex functions and nested functions. We will introduce you to Pivot Tables and how to utilise functions like VLOOKUP, INDEX, MATCH and IF. You will be competent in data validation, error handling and understand the basics of macros as well as understanding how to use filters.

Duration: 3 x 2 hour remote sessions

Microsoft Excel Advanced Level

You will be working with array formulas, data consolidation, using slices and tables. You will be able to handle larger data sets and master complex functions including dynamic array formulas. Learn how to harness the power of Excel forecasting and What If analysis.

Duration: 3 x 2 hour remote sessions

Customised Courses

All of our levels and training can be customised to your specific needs. If you want to focus on advanced functions or data manipulation we can create a course that meets your needs and the duration you require.

Refresher courses are also available for those who have completed any of the training above.

All sample data is provided to enable the tasks in the training to be completed and training is provided remotely via Microsoft Teams.

Staff Training

We have over 20 years experience in designing and delivering training. Specialising in website management, I.T. and digital marketing, you can ensure that your staff will be able to manage and utilise all the tools you use to communicate with your customers to a high level. We excel above the high standards expected from Skills Development Scotland, SQA, and Ofsted. Delivering these courses over two decades, we will bring our expertise to you to drive up the competence of your team in all digital areas.

AVRA Communications

5.0

Based on 7 reviews

review us on

mark cook

2 years ago

As a novice to making a corproate video I reached out to Avra with nothing more than a script. Paul was able to support through the entire process, shooting footage, running an autocue for pieces to camera, editing in stock footage, generation of graphics, overlaying background music, creating & placing subtitles and providing a very polished piece of video that AVRA delivered early. The finished product turned out better than we could have imagined.

Michael Magee

4 years ago

From first contact to completion of our project, AVRA were excellent throughout. Paul's knowledge, experience and passion for what he does was clear throughout the whole process and made it effortless on our part.
Would not hesitate to use AVRA's services again in the future, they were a pleasure to work with. Thank you!

Maciej Liszek

4 years ago

Getting Paul involved in our project was by far the best decision made by our company. The communication between us and AVRA during the project has been super easy and the quality of work produced by their team was definitely worth every penny. As a start up business we were on a tight budget to get things moving and Paul and his team were able to accomadate this and even save us money with their competitive pricing! I would greatly recommend AVRA to anyone!

Tom O'Reilly

4 years ago

Our experience of working with AVRA Communications has been excellent: they produced high-quality audio and visual content for a complex educational print & digital resource; they followed the brief and provided intuitive suggestions for improvement; all at a competitive price and with excellent communication throughout the project. Highly recommended.

Michael Macdonald

4 years ago

Paul and the team at AVRA made videos to accompany my guitar tuition book. The work was top class and we achieved great results. The post production was excellent and Paul couldn’t have been more helpful. I highly recommend AVRA communications.

Gary White

4 years ago

Working with Paul and the AVRA team was a truly seamless and very positive experience. Paul is thoroughly professional, friendly, courteous and knowledgeable of his art and made the entire band (Dapper) feel perfectly at ease at every stage of the process. Paul explained what would be happening, outlined the expectations for each of us and then did exactly what he said he'd do. This meant that his presence at our love sessions and in the studio was completely non-intrusive and allowed the band to focus on what we do - playing the music and enjoying ourselves in a completely natural environment.
Paul had great ideas of what he wanted to see, but he made sure that he sought the input and opinions of all of the band before hand, and built these into his own vision for our productions.
The result is that now we have a portfolio of really professional live and studio videos that truly capture the essence of Dapper.
We would recommend AVRA very highly to anyone looking for video promotion or production and they will be Dapper's first phone call for out next production.
Thank you to Paul and the team for being the 6th member of the band for this!

Microsoft Excel Introduction Level

Microsoft Excel Intermediate Level

Microsoft Excel Advanced Level

Get in touch to enquire about training