Microsoft Excel 2010 - Beginners, Intermediate & Advanced

As the most-used spreadsheet program in the world, learning how to use the Microsoft Excel will give you an edge in your professional career. This Microsoft Excel 2010 complete course is created to help you in learning all the functions and features of this program. Whether you are a beginner, intermediate and advanced level user, this course will help you in learning all the necessary skills, knowledge, and information about the Microsoft Excel.

You will learn how to plan and organise your data using the tools in this program. You will know how to use the functions of Microsoft Excel that will help you in finishing your tasks effectively.This course will provide you with the necessary skills, knowledge and information of Microsoft Excel.

Professionals who want to learn all about Microsoft Excel 2010 program.

People who have an interest in knowing all the functions and features of Microsoft Excel.

CPD

COURSE CURRICULUM Microsoft Excel 2010 for

• Module One - Getting Started
• Module Two - Opening and Closing Excel
• Module Three - Your First Worksheet
• Module Four - Working with Excel Files
• Module Five - Viewing Excel Data
• Module Six - Printing Excel Data
• Module Seven - Building Formulas
• Module Eight - Using Excel Functions
• Module Nine - Using Time Saving Tools
• Module Ten - Formatting Your Data
• Module Eleven - Advanced Formatting Tools
• Module Twelve - Wrapping Up

Microsoft Excel 2010 Intermediate Level

• Module One - Getting Started
• Module Two - Working with Permissions and Options
• Module Three - Sharing Workbooks
• Module Four - Performing Advanced Formula and Function Tasks
• Module Five - Working with Array Formulas
• Module Six - Working with Functions
• Module Seven - Working with Macros
• Module Eight - Working with Forms
• Module Nine - Applying Advanced Chart Features
• Module Ten - Working with PivotTables and PivotCharts
• Module Eleven - Using the Automated Analysis Tools Add -In
• Module Twelve - Wrapping Up

Microsoft Excel 2010 Advanced Level

• Module One - Getting Started
• Module Two - SmartArt and Objects
• Module Three - Auditing
• Module Four - Creating Charts
• Module Five - Creating Pivot Tables
• Module Six - Working with PivotTables and PivotCharts
• Module Seven - Macros
• Module Eight - Solving Formula Errors
• Module Nine - Using What If Analysis
• Module Ten - Managing Your Data
• Module Eleven - Grouping and Outlining Data
• Module Twelve - Wrapping Up

Assessment:

• At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.
• Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.

Certification:

• In addition to the course price there is an additional charge for certificate. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at the following price:
• Hard Copy by post - GBP39.00
• Soft Copy PDF via email - GBP24.00

We are a company who is best known for offering awarding body accredited online courses that are available for anyone who wishes to acquire a certification and take their professional life to the next level.

As an online learning site, we are aware of the fact that there are a lot of people out there who considers themselves to be a curious learner but the courses that they are interested in are not available in the area. So, we have decided to give them a chance to learn in a convenient way – in their own convenient place and time.