Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. Learn the main topics related to Microsoft excel 2007. Identify the basic excel techniques, explore the advanced functions of excel 2007 and create automated reports with the press of a button in this course. By completing this course, you will become an excel expert and use excel 2007 as a professional.

Who is the 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.


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


  • 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 applying for NUS Extra Discount Card;
  • 24/7 student support via email.

Career Path:

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

  • Admin Assistant.
  • PA.
  • Secretary.
  • Administrator.
  • Account Assistant.
  • Bookkeeper.
  • Accountant.
  • Office Manager.

Course Curriculum

Microsoft Excel 2007 for Beginners
Module One – Getting Started 01:00: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 01:00:00
Module Ten – Formatting your Data 01:00:00
Module Eleven – More Formatting 01:00:00
Module Twelve – Wrapping Up 00:30:00
Activities-Microsoft Excel 2007 for Beginners 00:00:00
Microsoft Excel 2007 Advanced Level
Module One – Getting Started 00:30:00
Module Two – SmartArt 01:00:00
Module Three – Inserting Objects 01:00:00
Module Four – Creating Charts 01:00:00
Module Five – Creating Pivot Tables 01:00:00
Module Six – Working with Pivot Tables 01:00:00
Module Seven – Creating Pivot Charts 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 01:00:00
Module Twelve – Wrapping Up 00:30:00
Activities-Microsoft Excel 2007 Advanced Level 00:00:00
Mock Exam
Final Exam

Course Reviews


10 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.



certificate mockup


John Academy - Accrediting Body 2

John Academy - Accrediting Body


John Academy - Awarding Body

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


John Academy - Course Partners




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.

 2nd Floor, 16-18 Whitechapel Rd, London E1 1EW, United Kingdom.
020 3744 3990

Certificate Code

Coming Soon


© Adams Academy Inc. Ltd. T/A John Academy.