Description:

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. 

Who is the course for?

  • 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.

Entry Requirement:

  • This course is available to all learners, of all academic backgrounds.
  • 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 the cost of £39 or in PDF format at the 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 recognized 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.

Career Path:

The Microsoft Excel 2010 – Beginners, Intermediate, Advanced course is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as:

  • Accountant
  • Account Assistant
  • Administrative Assistant
  • Administrator
  • Bookkeeper
  • Office Manager
  • Personal Assistant
  • Secretary.

Course Curriculum

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
Activities-Microsoft Excel 2010 for Beginners 00:00: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
Activities-Microsoft Excel 2010 Intermediate Level 00:00: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-Microsoft Excel 2010 Advanced Level 00:00:00
Mock Exam
Mock Exam- Microsoft Excel 2010 Complete Course – Beginners, Intermediate, Advanced 00:30:00
Final Exam
Final Exam- Microsoft Excel 2010 Complete Course – Beginners, Intermediate, Advanced 00:30:00

Course Reviews

4.7

4.7
6 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

678 STUDENTS ENROLLED

Certification

Alpha-Academy-Certificate-Mockup11

Accredited by

John Academy - Accrediting Body 2

John Academy - Accrediting Body

Centre Approved by

John Academy - Awarding Body

Registered with the UK Register of Learning Providers (UKRLP)
UKPRN: 10063816

Course Partners

John Academy - Course Partners

NUS-CARD--John-academy

quality-john-academy

About

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

 11 Floor, 15 St Botolph Street, London EC3A 7BB
020 3744 3990
info@johnacademy.co.uk

Certificate Code

Free CV Review

free cv review

 

 

top

© John Academy.