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
Program taught in:
English

See 363 more programs offered by John Academy »

Last updated June 8, 2018
This course is Online
Start Date
Open Enrollment
Duration
Request Info
Part time
Full time
Price
14 GBP
Deadline
By locations
By date
Start Date
Open Enrollment
End Date
Application deadline

Open Enrollment

Location
Application deadline
End Date