Course Description

Excel 2010 Advanced

Excel 2010 Advanced is a course run by 1 Training, Dublin. For more information about Excel 2010 Advanced at 1 Training, please review the details below.

Excel 2010 Advanced

Please note: We do not provide any software with this course.


This excellent Excel 2010: Advanced course will get you up to speed with Excel 2010, whether you’re an intermediate user, or you just need to get to know the advanced features of Excel 2010, there is something for you to learn. The course will teach you to take core skills to the next level by exploring advanced functions and chart features, connecting to external data, utilising data tools, leveraging auditing features, and gaining insight with what-if features. This course is taught by an expert instructor with years of experience, who has an abundance of insider knowledge to share with you.

Our learning material is available to students 24/7 anywhere in the world, so it’s extremely convenient. These intensive online courses are open to everyone, as long as you have an interest in the topic! We provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.

What skills will I gain?

  • Take basic Excel skills to the next level by integrating and extending basic skills to create elegant solutions
  • See how advanced functions and data tools automate routine tasks and provide easy answers to not-so-easy questions
  • Discover the power of simplifying complex data through advanced charts and pivot tables
  • Import & connect to external data
  • Create macros and make simple edits using VBA to automate routine tasks

Meet the Instructor:

Erin A. Olsen has been spreading her enthusiasm and vision for the power of desktop technology since 1994 to more than 37,000 people in seven countries. Since founding PCKeys Technology Solutions, she has authored more than 36 CBT titles, developed hundreds of courses and effectively presented to thousands. When Erin started her technology career, the PC was fairly new. Windows 3.1 was just coming out so she had to find ways to explain this new technical environment in terms non-technical people could understand. Her illustrations and explanations did and continue to do so today in fundamental to advanced topics. Erin combines her formal education in information technology and education with an emphasis in instructional design and technology (B.I.T., M.Ed.), with her technical expertise, real-world experience and understanding of adult learning to present these technical topics in an easy-to-understand, easy-to-apply and fun manner using relatable examples and analogies. Erin’s unique combination of personality and skills allow her to provide an enhanced learning experience for all that is effective, engaging and memorable.

Course outline: 

  • Module 1: Advanced Calculations
  • Module 2: Subtotals & Outlines
  • Module 3: Pivottables©
  • Module 4: Adapting Charts For Complex Data
  • Module 5: Advanced Data Tools
  • Module 6: Auditing Calculated Values
  • Module 7: Performing A What-If Analysis
  • Module 8: Macros, Vba & Security

How will I be assessed? 

  • You will have one assignment. Pass mark is 65%
  • You will only need to pay £19 for assessment.
  • You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days

What Certification am I going to receive?

Those who successfully pass this course will be awarded a Excel 2010: Advanced certificate. Anyone eligible for certification will receive a free e-certificate, and printed certificate.

The Excel 2010 Advanced course at 1 Training is listed in's national courses finder.
Training Provider1 Training
Course LocationDublin
Course Fee18
Entry RequirementsYou must be 16 or over You should have a basic understanding of English, Maths and ICT You will need a computer or tablet with internet connection (or access to one)
Carear Path• Administration • Reception • Accounting • Bookkeeping • Business ownership • PA professionals
Phone+44 208 610 9650
For more information about 1 Training, please visit our College page on by clicking here.

Course Provider

1 Training

63/66 Hatton Garden, 5th Floor, Suite 23, London. EC1N 8LE, Dublin, United Kingdom. Eircode: EC1N 8LE

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to 1 Training

Captcha code        I confirm I have read the Cookie Information, Terms and Conditions and Privacy Policy and I agree to join the community.


1 Training
63/66 Hatton Garden, 5th Floor, Suite 23, London. EC1N 8LE
United Kingdom
Visit Website