Level 3 Diploma in Microsoft Excel - CPD & IAO Accredited

John Academy

Programme Description

Level 3 Diploma in Microsoft Excel - CPD & IAO Accredited

John Academy

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, from all academic backgrounds. However, an education and experience in accounting is an advantage.
  • 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.

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 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 for Beginners

  • Module One – Getting Started
  • Module Two – Opening Excel
  • Module Three – Working with the Interface
  • Module Four – Your First Worksheet
  • Module Five – Viewing Excel Data
  • Module Six – Building Formulas
  • Module Seven – Using Excel Functions
  • Module Eight – Using Quick Analysis
  • Module Nine – Formatting Your Data
  • Module Ten – Using Styles, Themes, and Effects
  • Module Eleven – Printing and Sharing Your Workbook
  • Module Twelve – Wrapping Up

Microsoft Excel – 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 Macros
  • Module Seven – Working With Forms
  • Module Eight – Applying Advanced Chart Features
  • Module Nine – Working With Slicers and Timelines
  • Module Ten – Working With Multiple Tables, Relationships and External Data
  • Module Eleven – Working With PowerView
  • Module Twelve – Wrapping Up

Microsoft Excel – Advanced Level

  • Module One – Getting Started
  • Module Two – SmartArt and Objects
  • Module Three – Auditing A4
  • Module Four – Creating Charts
  • Module Five – Working with Charts A4
  • Module Six – Creating Pivot Tables and Pivot Charts
  • 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
This school offers programs in:
  • English


Last updated June 8, 2018
Duration & Price
This course is Online
Start Date
Start date
Open Enrolment
Duration
Duration
Part time
Full time
Price
Price
14 GBP
Information
Deadline
Locations
United Kingdom - London, England
Start date : Open Enrolment
Application deadline Request Info
End date Request Info
Dates
Open Enrolment
United Kingdom - London, England
Application deadline Request Info
End date Request Info