Microsoft Excel - Advanced Course
Master the advanced features of ms® excel in this comprehensive course
4.99/5 Rating
(from 1000+ reviews)
About this course
This course is designed to provide a comprehensive overview of the various features and functions of MS® Excel, including both the basics and more advanced techniques. Whether you’re new to Excel or looking to refresh your knowledge, this course has something for you.
We’ll start by covering the fundamentals, such as creating and formatting worksheets, entering and manipulating data, and using basic functions and formulas. From there, we’ll dive into more advanced topics such as automating worksheet functionality, using data analysis tools, and working with multiple workbooks.
You’ll also learn how to audit your worksheets to ensure accuracy and integrity, import and export data in various formats, and create professional-looking Excel forms. By the end of this course, you’ll have a solid understanding of how to use Excel effectively and efficiently in a variety of situations.
Course features
Engaging learning experiences
Downloadable study material
Certificate of completion
4.99/5 Rating (from 1000+ reviews)
What you'll learn
- Learn how to update workbook properties
- Practice creating and editing a macro
- Know how to apply conditional formatting
- Learn how to troubleshoot invalid data and fix errors
- Understand the functions of PivotTables
- Collaborate with others by protecting worksheets and workbooks
- Learn how to analyse data using statistical analysis tools
- Know how to import and export MS® Excel data
Course format
Group Discussions
Case Studies
Action Planning
Presentations
Individuals & Groups
Role Playing
Experiential Games
Assessments
Course content
Take a sneak-peak inside to see what you can expect from this course:
➜ Auditing worksheets
➜ Create dynamic worksheets by using PivotTables
➜ Working with multiple workbooks
➜ Importing and exposing MS® Excel data
Our happy customers
Pricing
Choose the best training solution for you:
Online Live
Virtual instructor-led training
Contact us for pricing
Face-to-face
3,600 AED
per delegate
In-house
For 4+ delegates
We recommend in-house
Sign-up to world-class training today!
Why get certified?
The majority of ILM’s qualifications and courses give learners the skills, knowledge, and experience they need to do a management job in the real world. According to research, 9 in 10 learners said they were able to apply the leadership and management skills learnt through ILM to their day-to-day job role and would recommend ILM’s qualifications and programmes.
Training your team on an ILM qualified course will improve their performance and bring positive change to your organisation. 88% of employers say their business was immediately positively impacted by ILM training programmes. 78% of employers said investing in ILM training increased their income.
ILM qualifications are very sought after and will improve your career prospects. If an employer has two candidates that they can’t decide between, they are likely to make the decision based on qualifications. So having ILM certification is a great way of increasing your chances of promotion or employment.
Frequently asked questions
Yes, after the course you will receive a certificate of completion.
All participants receive an e-copy of the certificate, but if requested you will receive a hardcopy as well.
Yes, we provide e-workbook before the course and the PowerPoint after the course.
Have more questions? Click here to get in touch.
Request a call back
Slots are limited, so request your call back as soon as possible.
Discover Select
Select Group is an internationally recognised Learning and Development provider with more than 17 years of experience in the field of corporate training and consultancy.
✔ Qualified Trainers
✔ English & Arabic
✔ Customer Focused
✔ Internationally Qualified
Our partners
Courses
Training
ABOUT US
RECENT ARTICLES
Head Office: Office 1501 Al Yasat Tower, Fatima Bint Mubarak (Najda) Street, P.O. Box 44705, Abu Dhabi, UAE.
Dubai Office: Office 208, Al Attar Business, Centre, Sheikh Zayed Road, Al Barsha 1, P.O. Box 334058, Dubai, UAE.
KSA Office: Office 7470, Uthman ibn Affan Road,
Al Taawun District, P.O. Box 84994, Riyadh, K.S.A.
Request a call back
Slots are limited, so request your call back as soon as possible.
Discover Select
Select Group is an internationally recognised Learning and Development provider with more than 17 years of experience in the field of corporate training and consultancy.
✔ Qualified Trainers
✔ English & Arabic Delivery
✔ Innovative Customer Focus
✔ International Qualifications
Our partners
Head Office: Office 1501 Al Yasat Tower, Fatima Bint Mubarak (Najda) Street, P.O. Box 44705, Abu Dhabi, UAE.
Dubai Office: Office 117, Al Attar Business, Centre, Sheikh Zayed Road, Al Barsha 1, P.O. Box 334058, Dubai, UAE.
Request a call back
Slots are limited, so request your call back as soon as possible.
Discover Select
Select Group is an internationally recognised Learning and Development provider with more than 17 years of experience in the field of corporate training and consultancy.
✔ Qualified Trainers
✔ English & Arabic
✔ Customer Focused
✔ Internationally Qualified
Our partners
Courses
Training
ABOUT US
RECENT ARTICLES
Head Office: Office 1501 Al Yasat Tower, Fatima Bint Mubarak (Najda) Street, P.O. Box 44705, Abu Dhabi, UAE.
Dubai Office: Office 208, Al Attar Business, Centre, Sheikh Zayed Road, Al Barsha 1, P.O. Box 334058, Dubai, UAE.
KSA Office: Office 7470, Uthman ibn Affan Road,
Al Taawun District, P.O. Box 84994, Riyadh, K.S.A.