Excel 2010 Advanced

Overview:

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

What are the requirements? 

You 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)

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.

What careers can I get with this qualification?

With this course, you are able to fulfil various roles, such as:

• Administration
• Reception
• Accounting
• Bookkeeping
• Business ownership
• PA professionals

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