Computer Tutoring Logo
Est. 2002
Menu Button

Cost Calculator

Training Delivery
Number Students?
Laptop hire?
Offsite training?

Course Price: £ *
Price Per Head:
£ .

Duration:
1 Day

Location: Northampton
* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

Live Online Face-to-Face
First Name:

Last Name:

Email:

Tel:

Location:

Num Students:
First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.
I would like to receive software tips and special offers

Northampton Testimonials

Brampton Valley Homes

"Having 1-1 training with Simon was fantastic. He has an in-depth practical knowledge that I found really reassuring and no question was too ridiculous, especially when it related to something more specific to the company I work for. Illustrator is an extremely complicated tool and I feel that after a day with Simon, I have the tools build up on, with daily use of the software."

Beam Baking

"Excellent course and pitched at just the right level with the chance to focus on areas of the course we we felt would benefit us most. Would highly recommend and I am sure we will use Simon again."

Dirks

"A fun learning experience coupled with excellent course delivery and content"

World Vision UK

"The course was very informative and interesting, this is the first time I have used this programme and enjoyed the learning. The tutor was very clear and patient. The training came at the right time as I will be able to use this with the new Recruitment Process Mapping etc that is due for updating."

Microsoft Excel 365 Training Course Northampton Advanced

Advanced Microsoft Excel 365 Training Course training course Northampton - Victory House

Microsoft Excel 365 Training Course Advanced Northampton Victory House

Victory House
400 Pavilion Drive
Northampton Business Park
Northampton
NN4 7PA
United Kingdom

This centre is located in one of Northampton's premier business parks. The building occupies a prime position on Pavilion Drive, with rear office views overlooking a parkland Golf course. Perfect for your Advanced Microsoft Excel 365 Training Course training course.

Alternatively if you live in and around Northampton and wish to have your training on-site the we can provide all the equipment, included laptops & projector, required. All we ask is that you provide a little space for the trainer to set up.

Apart from Microsoft Excel 365 Training Course training courses we also conduct many other training courses in Northampton.

Excel Training Course Northampton Advanced Overview

Welcome to the Excel 365 Advanced Training Course! This comprehensive course is designed to take your Excel skills to the next level and empower you with advanced techniques and features to maximize your productivity. Whether you''re a business professional, data analyst, or student, this course will equip you with the knowledge and skills needed to tackle complex data management tasks, streamline your workflows, and unleash the full potential of Excel 365.

Throughout the Excel 365 Advanced Training Course, you will dive deep into advanced formulas and functions, explore powerful data management techniques, master advanced conditional formatting, and discover the world of forms and automation. By the end of the course, you will have gained the following key skills and knowledge:

  • Gain proficiency in advanced formulas and functions, including an overview of common formulas and functions.
  • Master the application of array functions, such as TOCOL(), UNIQUE, SEQUENCE, and the powerful LAMBDA function.
  • Optimize your formulas using the LET function for enhanced efficiency and readability.
  • Acquire data management skills by learning how to group, summarize, and analyze data across multiple sheets using SUMIF, COUNTIF, and other techniques.
  • Explore advanced features of Power Query, including data unpivoting and applying Power Query steps for quick data transformations.

Length of Course: 1 Day

  • Unlock the potential of advanced formulas and functions, including array functions, TOCOL(), UNIQUE, SEQUENCE, and the revolutionary LAMBDA function.
  • Optimize your formulas using the LET function, enhancing efficiency and readability.
  • Master data management techniques such as grouping and summarizing data across multiple sheets, leveraging the power of Power Query for data transformation, unpivoting data, and connecting data with PivotTables and Pivot Charts.
  • Utilise advanced conditional formatting to visually highlight and analyse data patterns and trends.
  • Explore forms and automation, including the use of checkboxes, Power Automate, and macros to streamline repetitive tasks and enhance productivity.

With these skills in your arsenal, you''ll be able to tackle complex data analysis projects, automate repetitive tasks, and present your findings in visually appealing formats. Excel 365 Advanced Training Course is your gateway to becoming an Excel power user, equipping you with the tools to excel in the modern data-driven world.

If you feel that this course isn't the one for you, please take a look at these Excel 365 training course outlines:

Microsoft Excel 365 Beginners Training Course

Microsoft Excel 365 Intermediate Training Course

Microsoft Power BI Beginners Training Course

Power BI DAX Beginners Training Course



Microsoft Excel 365 Training Course Northampton Advanced

At Computer Tutoring, we prioritise your privacy and only collect the necessary information to provide our services. We will only share the personal data you provide in a form if you have opted in for those services. Our website also uses Google Analytics. You have the right to access, amend, or request deletion of your personal data by contacting us at info@computertutoring.co.uk.

For more details, please read our full Privacy Policy.