• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Level 3 Diploma in Microsoft Excel 2010

Level 3 Diploma in Microsoft Excel 2010

By John Academy

4.3(43)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 32 hours

  • All levels

Description

Description: 

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.

Who is this course for?
  • 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.

Entry Requirement:
  • This course is available to all learners, of all academic backgrounds. However, an education and experience in accounting is an advantage.

  • Learners should be aged 16 or over to undertake the qualification.

  • Good understanding of English language, numeracy and ICT are required to attend this course.

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 hard copy at a cost of £39 or in PDF format at a cost of £24.

  • 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 career advancement opportunities;

  • 24/7 student support via email.

Career Path:

The diploma in Microsoft Excel 2010 will be very beneficial and helpful, especially to the following professionals:

  • Admin Assistant.

  • PA.

  • Secretary.

  • Administrator.

  • Account Assistant.

  • Bookkeeper.

  • Accountant.

  • Office Manager.

Microsoft Excel 2010 for Beginners

Module One - Getting Started

00:30:00

Module Two - Opening and Closing Excel

01:00:00

Module Three - Your First Worksheet

01:00:00

Module Four - Working with Excel Files

01:00:00

Module Five - Viewing Excel Data

01:00:00

Module Six - Printing Excel Data

01:00:00

Module Seven - Building Formulas

01:00:00

Module Eight - Using Excel Functions

01:00:00

Module Nine - Using Time Saving Tools

00:30:00

Module Ten - Formatting Your Data

01:00:00

Module Eleven - Advanced Formatting Tools

01:00:00

Module Twelve - Wrapping Up

00:30:00

Microsoft Excel 2010 Intermediate Level

Module One - Getting Started

00:30:00

Module Two - Working with Permissions and Options

01:00:00

Module Three - Sharing Workbooks

00:30:00

Module Four - Performing Advanced Formula and Function Tasks

01:00:00

Module Five - Working with Array Formulas

01:00:00

Module Six - Working with Functions

01:00:00

Module Seven - Working with Macros

01:00:00

Module Eight - Working with Forms

01:00:00

Module Nine - Applying Advanced Chart Features

01:00:00

Module Ten - Working with PivotTables and PivotCharts

01:00:00

Module Eleven - Using the Automated Analysis Tools Add -In

00:30:00

Module Twelve - Wrapping Up

00:30:00

Microsoft Excel 2010 Advanced Level

Module One - Getting Started

00:30:00

Module Two - SmartArt and Objects

01:00:00

Module Three - Auditing

01:00:00

Module Four - Creating Charts

01:00:00

Module Five - Creating Pivot Tables

01:00:00

Module Six - Working with PivotTables and PivotCharts

01:00:00

Module Seven - Macros

01:00:00

Module Eight - Solving Formula Errors

01:00:00

Module Nine - Using What If Analysis

01:00:00

Module Ten - Managing Your Data

01:00:00

Module Eleven - Grouping and Outlining Data

00:30:00

Module Twelve - Wrapping Up

00:30:00

Activities

Activities-Microsoft Excel 2010 for Beginners

00:00:00

Activities-Microsoft Excel 2010 Intermediate Level

00:00:00

Activities-Microsoft Excel 2010 Advanced Level

00:00:00

Mock Exam

Mock Exam- Level 3 Diploma in Microsoft Excel 2010

00:30:00

Final Exam

Final Exam- Level 3 Diploma in Microsoft Excel 2010

00:30:00

Order Your Certificate and Transcript

Order Your Certificates and Transcripts

00:00:00

About The Provider

Tags

Reviews