MS Excel 2010 Essentials

Overview:

This excellent Excel 2010: Essentials course will get you up to speed with Excel 2010, whether you’re a beginner, or you just need to get to know the features of Excel 2010, there is something for you to learn. The course will teach you about entering data, configuring workbooks, working with calculations, applying regular and conditional formatting, creating custom formats, using names, leveraging the power of tables and charts, and outputting your work. 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?

• Break down Excel into its component parts to make it more manageable and less overwhelming
• Use common, understandable names to replace confusing cell references
• Apply traditional formatting, create custom formats and apply formatting that automatically changes based on conditions you designate
• Truly understand how formulas and functions work, no matter how seemingly simple or complex
• Learn the Commandments of Excel Usage™ to ensure your work is efficient and accurate
• Embrace the power of tables to sort, filter and manage data more easily
• Create charts with just one click

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 01: Getting Comfortable With Excel
• Module 02: The Basics Of Data
• Module 03: Managing Workbook Structure
• Module 04: Creating Formulas
• Module 05: The Basics Of Functions
• Module 06: What’s In A Name?
• Module 07: Making Data Look Good
• Module 08: A Picture Is Worth A Thousand Words
• Module 09: The Simplicity Of Tables
• Module 10: Managing The Excel Environment
• Module 11: Preparing Files For Distribution

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: Essentials 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.