Description This Advanced Excel Skills course provides Excel users with advance spreadsheet solutions to common data analysis challenges. Providing users with hands-on practise analysing and automating useful spreadsheet tasks. Nesting functions is a significant part of this training day where you will get significant practise in nesting Excel functions.
What you will learn Performing spreadsheet calculations using Date & Time Using Data Validation to control the input of data Finding data using VLOOKUP and INDEX & MATCH Nesting Logical Functions – IF, AND, OR, ISERROR Analysing data with advance use of Pivot Tables Automating repetitive tasks with macros – VBA Further information Provider: We Are Excel Duration: 1 Day
Locations:
Birmingham, London
Contact Information We Are Excel
Longcroft House
Locations
The information taught is applicable to a great range of requirements within my work and I look forward to applying the knowledge. I'd recommend the WeAreExcel courses to anyone looking to develop their understanding of excel at any level.
Sam R 23 Apr 26
Such a great experience! You can interrupt and ask anything you want and Chris will try to answer it.
Martina K 26 Mar 26
A great day - have learnt so much and had a good laugh too!
Absolutely want to book further courses.
Friendly, informative and super efficient!
Also - great pen
Jessica R 26 Mar 26
This was a fantastic course with time being spent with us to make sure we had full understanding of the material. I liked that nothing felt rushed or too intense. Samples were linked to real life examples and Chris had a great teaching style and sense of humour. I appreciate the info provided on next steps and additional courses available. I really hope to be back for another one! Especially if it means we get another pen :)
Laura H 26 Mar 26
Was a very good experience, would recommend.
Paul M 12 Feb 26
Read more reviews >
020 7183 7740
Email