View all courses at this school »

Microsoft Excel Certification Level 3

Oxford College of Education

Q&A
Price
school-reference
detail

Course description

Microsoft Excel Certification Level 3
Please Note: This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions.
The Microsoft (MS) Excel Certification Level 3 Course is the most comprehensive of the three Excel courses presented here. If a team member has successfully completed the Level 1 and Level 2 courses, they will be fully prepared to start the Level 3 course.
Formulae or functions are what advanced users of Excel want from this tool. When you use formulae, not only can you see the data that you require for your work, you can also analyse it and get answers to complex questions.
Although anyone with some Excel knowledge can use formulae, such as SUM, a user who has the advanced Excel skills presented in this course will use other formulae, both alone and combined, such as MATCH, INDEX, DSUM and VLOOKUP.
In addition to knowing and using these formulae, an advanced user of Excel knows how to debug these formulae, how to audit them and how to choose the perfect formula for the particular task to be carried out.
What’s Covered in the Course?
Any staff member choosing to study this course can expect to gain the following skills:
How to set A Password to an Excel document;
VLOOKUP Advanced formula options and manipulations;
Other advanced functions: OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND;
Functions of CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE;
Colouring a column and row with a formula;
Highlighting a cell with a formula;
Functions of ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK;
Functions of DGET, DMAX, DPRODUCT, DCOUNTA, DCOUNT and DSUM;
How to calculate depreciation in Excel, including SLN depreciation and SYD depreciation;
Calculating loan IPMT and EMI;
Functions of DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX;
Full explanation of the INDEX and MATCH functions;
Looking up data;
Selecting only cells containing comments;
Hiding formulae;
Automatically inserting serial numbers;
The employee will also learn about calculating depreciation, calculating interest and calculating IPMT and EMI for loans, all by using Excel functions.
The course features information on INDEX and MATCH functions, which is important in certain industries and roles. It also shows learners how to use the CHOOSE formula and how to create special charts.
What are the Benefits of the Course?
Upon completion of the Level 3 course, the employee will have access to the full functionality of Excel and will know how to use all of its formulae, functions and capabilities;
The Level 3 Excel course is designed for ‘power’ users, but not only for programmers and those interested in financial modelling;
Competent Excel users add huge value to an organisation, through advanced data analysis.
Modules
Module 1: Add a Password
Module 2 : AND Function
Module 3 : Auto Updating Drop-down Lists
Module 4 : CEILING Formula
Module 5 : Charts that Update Automatically
Module 6 : CHOOSE Formula
Module 7 : Compare 2 Lists with VLOOKUP Function
Module 8 : CORREL Function
Module 9 : Create an Advanced Calculator
Module 10 : Create a Combo Chart
Module 11 : Create a Custom Tab
Module 12 : Create a Pivot Chart
Module 13 : Create Visual In-cell Indicators
Module 14 : Create Visual In-cell Indicators with Icon Sets
Module 15: Customise the Status Bar
Module 16: DATEDIF Function
Module 17: DATEVALUE Function
Module 18: DAVERAGE Function
Module 19 : DCOUNT Function
Module 20 : DCOUNTA Function
Module 21 : Depreciation Formula
Module 22 : DGET Function
Module 23 : DMAX Function
Module 24 : DPRODUCT
Module 25: DSUM Function
Module 26: EDATE Function
Module 27: EOMONTH Function
Module 28: Find and Replace
Module 29: FIND Function
Module 30: INDEX Function
Module 31: INDEX MATCH Function
Module 32: INDIRECT Function
Module 33: Insert Serial Number Automatically
Module 34: IPMT Function
Module 35: ISBLANK Function
Module 36: ISERR Function
Module 37: ISLOGICAL Function
Module 38: ISNONTEXT Function
Module 39: ISNUMBER Function
Module 40: ISODD Function
Module 41: Isolate First Name
Module 42: ISTEXT Formula
Module 43: LEFT Function
Module 44: LEN Function
Module 45: MATCH Function
Module 46: VLOOKUP Multiple Results at Once
Module 47: OR Function
Module 48: PMT Function
Module 49: REPLACE Function
Module 50: Select all Cells with Comments
Module 51: Sparkline Charts in Excel
Module 52: Straight Line Depreciation
Module 53: Strikethrough
Module 54: Sum of Years Depreciation
Module 55: Timeline in Pivot Table
Module 56: VLOOKUP with 2 Criteria
Module 57: VLOOKUP with DropDown List
Module 58: VLOOKUP with MAX
Module 59: VLOOKUP with MIN
Module 60: Watch Window In Excel

Class schedule

Course duration
52 weeks
Start dates
Every Monday
Classes per week
1 lesson per week (each lesson lasts 60 min)
Class days
Monday - Sunday

Class schedule may change depending on availability and season.

Class level

All levels, beginner to advanced
You will take a placement test on your first day to determine your class level. You may also take this test before your arrival in High Wycombe.

Class size

Average 12 students
Maximum 15 students

Student age

Age range 16 - 35 years old
Average 19 years old

Certificate

A certificate of completion will be issued at the end of the course.
Read more...
school

School description

Welcome to Oxford College of Education (OCE)

A Beacon of Academic Excellence and Opportunity

Nestled in the vibrant town of High Wycombe, just a short distance from the dynamic city of London and the global gateway of Heathrow Airport, Oxford College of Education (OCE) stands as a cornerstone of opportunity for students worldwide. At OCE, we blend academic rigor with a nurturing community, creating an environment where every learner can thrive.

Why Choose OCE?

Modern Facilities, Inspiring Spaces

Our state-of-the-art campus features cutting-edge classrooms, dedicated staff areas, and comprehensive study resources designed to foster academic success. Beyond infrastructure, we cultivate a supportive community that feels like a home away from home.

A Diverse, Global Community

OCE welcomes students from across the globe, creating a rich tapestry of perspectives that enhances learning and prepares you for success in an interconnected world. Whether you're a local student or an international learner, OCE is your launchpad for growth.

Flexible, World-Class Education

In today’s fast-paced world, flexibility is key. Our bespoke online courses for GCSE, IGCSE, AS, and A-Level qualifications allow you to study at your own pace, from anywhere. Tailored to modern learners, these programs offer:

Early completion options for ambitious students.

Flexible scheduling to suit your lifestyle.

Accessible, high-quality content to ensure academic success.

Industry-Recognized Professional Training

Elevate your career with over 500 CPD-accredited training qualifications, curated by experts and globally recognized. Our flexible online courses let you join anytime, from anywhere, empowering you to start or advance your professional journey.

Holistic Student Experience

At OCE, we prioritize your overall development. Our campus offers:

Access to the largest public library in the area for research and study.

A variety of dining options within walking distance.

A vibrant, inclusive community where every student feels valued.

Our dedicated academic and non-academic staff go above and beyond to support you, ensuring a welcoming environment that fosters lifelong learning.

Our Accreditation

OCE is proudly accredited by the Accreditation Service for International Schools, Colleges, and Universities (ASIC), a globally respected independent body. This accreditation reflects our commitment to delivering high-quality education and helps students make informed choices about their academic journey.

Award-Winning Excellence

In 2021, OCE was honored with the Inclusivity through Information Technology Award, recognizing our innovative use of technology to make education accessible to all.

Academic Programs and Partnerships

Course Offerings

We partner with leading awarding bodies to deliver world-class qualifications:

CIE, Edexcel, AQA, OCR for GCSE, IGCSE, AS, and A-Level courses.

Trinity College London, QUALIFI, ICQ, and more for specialized programs.

University Pathways

OCE collaborates with prestigious universities to support your progression to undergraduate, postgraduate, and PhD studies. Our team provides personalized guidance to help you take the next step in your academic journey.

Our Esteemed Team

Our faculty comprises British-trained, qualified experts with a passion for education. With extensive experience across diverse disciplines, they are committed to guiding you toward success.

Approved Exam Centre

OCE is an authorized exam center for Pearson Vue and ACCA (CBE), hosting hundreds of candidates monthly for their professional and academic exams.

A Journey of Continuous Growth

Since our founding in 2017, OCE has been dedicated to excellence and innovation. Here’s a glimpse of our milestones:

2017: Established Oxford College of Education.

2018: Achieved ASIC accreditation and began recruiting local and international students.

2019-2020: Welcomed our first student cohorts and delivered BTEC Level 3 Business courses and apprenticeships.

2020-2021: Transitioned to digital systems, launched 500 CPD-accredited courses, and won the Inclusivity through Information Technology Award.

2022: Enhanced our platform with Moodle Workplace and gained Ofsted approval for childcare provision.

2023: Expanded international enrollment and secured Crown Commercial Service (CCS) approval.

2024: Forged partnerships with schools and corporate clients to deliver GCSE, A-Level, and CPD courses.

As we look to the future, OCE remains committed to empowering students and fostering innovation in education.

Join Our Community

At Oxford College of Education, we believe in unlocking every student’s potential. Whether you’re pursuing academic excellence, professional growth, or personal development, OCE is your partner in success. Join us today and embark on a transformative journey of discovery, growth, and endless possibilities.

Oxford College of Education: Where Dreams Take Flight.

Year opened
2017
Number of classrooms
6

Accreditations

Facilities

  • Library
  • Elevators
  • Wheelchair access
  • Eating Area
  • Free Internet
  • Wireless Internet
  • Computers
  • After-Class Seminars
  • Studying Area
  • Audio Learning

Teacher qualifications

Native English speakers
Over 50%
Teachers with English teaching certification
Over 50%
Teachers with college degrees
Over 50%

Nationality and age mix

The nationality and age mix at Oxford College of Education varies over different time periods, courses and levels. Throughout the year, the average age is 19. In the summer, the average age is 19.

School holidays

OCE does not hold classes on the holiday dates below. The school does not compensate for these holidays, so make sure to choose your start date accordingly.

Open dates
Year round
School holidays
None
Read more...
photos

Photos

  • Oxford College of Education 1/10
  • Oxford College of Education 2/10
  • Oxford College of Education 3/10
  • Oxford College of Education 4/10
  • Oxford College of Education 5/10
  • Oxford College of Education 6/10
  • Oxford College of Education 7/10
  • Oxford College of Education 8/10
  • Oxford College of Education 9/10
  • Oxford College of Education 10/10
visa

Visa support

We cannot apply for visas on behalf of students. However, the school can supply you with all the documentation you need to support your visa application.

If you are studying in the UK for over 11 months, you will receive a reference number called a Confirmation of Acceptance for Studies (CAS) that you need to submit to the UK embassy along with your General Student Visa application. Students who have successfully booked a language course and have paid their fees will receive a CAS from OCE. Please note that UK law states that a CAS can only be issued to students who intend to pursue English language studies for over 11 months.

If you are studying in the UK for 11 months or less, you have to apply for a special visitor visa called a Student Visitor Visa. As a student visitor, you will not be able to work part-time while studying. If you plan to study in the UK for 11 months or less, a letter of acceptance will be sent to your home address by regular mail at no charge to you.

Learn more about how to get a UK visa »

Flights and airport transfer

Please note that we do not book flights for our students. If you are researching airfare costs, we recommend using Kayak.com, a search engine that lets you compare flight options from your home country to High Wycombe based on your budget, schedule and preferences.

Travel insurance

Study abroad worry-free with Language International's health and personal effects insurance coverage. When you book a course with us, you can opt to purchase an international insurance plan that covers not only your health care cost but also loss of your personal belongings. You must book your insurance in advance when you register.

Learn more about our insurance plan »

Read more...
questions

Questions and answers

Have questions? Get answers from Oxford College of Education staff, Language International student advisors, and past students.

Ask a question
Show prices