Our Microsoft Excel Advanced course is a highly practical and interactive tutor-led session delivered by highly experienced Microsoft Certified Trainers. Delegate numbers are kept low to ensure individual support can be given to each participant.
Our Microsoft Excel Advanced course is a highly practical and interactive tutor-led session delivered by highly experienced Microsoft Certified Trainers. Delegate numbers are kept low to ensure individual support can be given to each participant.
Courses can be delivered on your premises on dates that suit you or you can complete the course at one of our public courses in London or Bristol.
Course Content – Overview
Short overview of intermediate topics
Named Ranges
Lookup Functions – VLOOKUP, MATCH, INDEX, INDIRECT
Advanced Functions – OFFSET
Date and Text
Data Validation
File Linking
Protection
Consolidation
Macros
Goal Seek, Using Solver and Goal See
Outcomes
On successful completion of the course, delegates will be able to create and apply names ranges, understand Lookups, solve problems by using Goal Seek, record macros and assign to buttons and link objects between different applications.
We’ve been providing successful training and development programmes since 1996 and we love it! We get a buzz from the altruistic sense of genuinely helping people, of unlocking potential and helping individuals, teams and organisations to be the best that they can be!
At Elliott Training we believe that at the heart of any business there must be a focus around culture, passion and the desire to make a difference. As one of the UK’s leading training companies, we’re passionate about the power of training.
We know your people are your biggest asset, so we use all our knowledge and experience to create award-winning training programmes that inspire your people and enable your business ambitions.
It is our fundamental belief that an organisation is only as good as its people. Creating a balance that combines the correct depth and blend of skills is fundamental to the achievement of goals within your business. We align our programmes to your organisational values, culture, vision and strategy; making sure you have the right people, with the right skills at the right time.
We have a wealth of experience gained from our extensive work within Leadership, Management and Customer Service. We will work closely with you to identify the successes, strengths, best practices and gaps that are delivering current results before putting together a programme to address area’s where improvement in skills, behaviours and knowledge can be encouraged.
Our approach to training and development is to make a difference. We develop programmes that inspire people to think differently, behave differently and continue to make a difference when they return to the workplace
Whilst all our work is underpinned by the best that psychology and business brains have to offer – it is translated into memorable and usable tools and techniques for everyday use in business and in life. We’re unashamedly eclectic in our use of theories and concepts – we take the best from all schools of thought and create what feels right.
For complete beginners who need to understand the functionality of Excel. Learn to work efficiently, producing factual and well formatted spreadsheets.
n site Microsoft Word courses tailored to your needs, designed for businesses and professionals. All Microsoft Office Word versions including 2003, 2007, 2010, 2013, 2016 and Office 365 covered.
The course enables the delegates to create complex queries, make forms and build a database with a good relational structure. During the one day course, the delegates will learn how to create basic to advanced reports, design Access databases, manage interfaces with Access Forms and automate tasks ...
Whether you are a new user or have been using Publisher for years, this course will vastly increase your understanding of Publisher. Existing users will learn how to get the most out of Publisher, break any bad habits, learn shortcuts and discover a massive range of hints and tips from our expert
Microsoft Excel Intermediate Training is designed for those professionals and/or individuals who are familiar with the Microsoft Office packages but do not have expert level knowledge or understanding of any particular Microsoft Office application.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy