Level 3 Diploma in Microsoft Excel 2010

Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. Microsoft Excel 2010 is the spreadsheet application in the MS Office 2010 suite. You will begin with the fundamentals, assembling a strong foundation that will give you further knowledge as you advance into intermediate and advanced level topics. By the end of this course, you will have mastered the most important Excel 2010 tools and come out with confidence to finish any Excel assignments with proficiency and grace.

• This course is perfect for individuals who are looking forward to developing their skills of using Microsoft Excel application.
• This course is for office professionals who want to nail all the meetings and projects at the workplace.
• This course will be ideal for professionals in business, finance and many other areas that need to analyse data in accounts.

CPD

Microsoft Excel 2010 for Beginners

• 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
• Activities
• Activities-Microsoft Excel 2010 for Beginners
• Activities-Microsoft Excel 2010 Intermediate Level
• Activities-Microsoft Excel 2010 Advanced Level

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:

• After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of GBP39 or in PDF format at a cost of GBP24.
• PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days.

Why choose us?

• Affordable, engaging & high-quality e-learning study materials;
• Tutorial videos/materials from the industry leading experts;
• Study in a user-friendly, advanced online learning platform;
• Efficient exam systems for the assessment and instant result;
• The UK & internationally recognised accredited qualification;
• Access to course content on mobile, tablet or desktop from anywhere anytime;
• The benefit of applying for NUS Extra Discount Card;
• 24/7 student support via email.

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.