Skip to content

Microsoft Excel 3 Course Bundle – Basic, Intermediate & Advanced Courses - Only £22

Excel Beginner, Excel Intermediate and Excel Advanced Course,

Oplex Careers

Summary

Price
Save 13%
£19 inc VAT (was £22)
Offer ends 30 April 2024
Study method
Online
Duration
120 hours · Self-paced
Qualification
No formal qualification
CPD
120 CPD hours / points
CPD What's this?
Additional info
  • Tutor is available to students
1,032 students purchased this course

Add to basket or enquire

Overview

The online Microsoft Excel Beginner, Intermediate & Advanced course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software. Whether you need to learn the skills for work, want to fill the gaps in your CV or simply fancy learning something new, this Excel beginner course is perfect to do so.

CPD

120 CPD hours / points
Accredited by The CPD Certification Service

Course media

Description

The online Microsoft Excel Beginner, Intermediate & Advanced course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software at an advanced level. Whether you need to learn the skills for work, fill the gaps in your CV or simply fancy learning something new, this Excel Advanced course is perfect.

Course Syllabus

Basic Level:

  • Introduction to Spreadsheets
  • Understanding Microsoft Excel
  • Excel Workbook Windows
  • Basic Spreadsheet Skills
  • Excel Help System
  • Opening and Closing Workbooks
  • Understanding Workbook File Formats
  • Creating New Workbooks
  • Selecting Cells
  • Auto Sum and Auto Fill Function
  • Cell Referencing and Request
  • Formatting Cells
  • Formatting Numbers
  • Placing Cell Alignment
  • Cell, Rows and Columns
  • Understanding Worksheets
  • Editing, Copying and Moving Cells
  • Page Layouts in Excel
  • Proofing Workbooks
  • Basic Options, Ribbons and Toolbar
  • Final Assessment

Intermediate Level:

  • Introduction to Excel Spreadsheet Intermediate Level
  • Defining Names in Excel
  • Sorting Data
  • Using Excel Tables
  • Filtering Data in Excel
  • Understand Charts
  • Chart Design Options and Tools
  • Chart Format Tools
  • Combo Charts
  • Functions within Excel
  • Understanding Date Function
  • Information Functions
  • Logical Functions
  • Financial Functions
  • Find and Replace
  • Headers and Footers
  • Adding Comments
  • Conditional Formatting
  • Final Assessment

Advanced Level:

  • Introduction to Excel Advanced
  • Using Text to Columns
  • The Paste Special Function
  • Data Validation
  • Subtotals and Grouping
  • Consolidating Data
  • Scenario Analysis
  • Data Tables in Scenario Analysis
  • What-if Analysis
  • Mats and Trig Functions
  • Text Functions in Excel
  • Using Lookup Functions
  • Vlookups
  • HLookups
  • Using Statistical Functions
  • Databse Functions
  • Formaula Auditing and Error Tracing
  • Hyperlinks in Excel
  • Linking Data
  • Understanding Pivot Tables
  • Using Pivot Charts
  • Workbook Properties
  • Protecting and Sharing Worksheets
  • Data Encrypting and Finalising Workbooks
  • Understanding to Macros
  • Custom Number Formats in Excel
  • Using Custom Lists
  • Working with Templates
  • Tracking Changes in Excel
  • Merging and Compare Excel Workbooks
  • Final Assessment
  • Microsoft Excel Software

This course relates to Microsoft 2013 software. In order to complete the course, learners should have their own copy of Microsoft Excel 2013. If learner does not own a copy of the software, Microsoft provide a free trial version of Microsoft Excel 2013.

Assessment

To assess the learners ability and knowledge to effectively understand the topics contained within the Microsoft Excel Basic, Intermediate & Advanced course, the course features a number of end of module interactive quiz questions.

Additionally, at the end of the course learners will also take an online multiple choice assessment test. This online multiple choice test is marked automatically so you will receive an instant grade and know whether you have passed the course.

Certificate

On successful completion of this Microsoft Excel Basic, Intermediate & Advanced course learners will receive a CPD Certificate of Achievement award from Oplex Careers.

This certificate will be produced in PDF format, hard copies of the certificate will be available at an additional fee of £9.99.

Course Format

This course is delivered online through eLearning. Learners of the course will receive instant access to our interactive student learning portal, which offers 24/7 access to the Microsoft Excel Basic, Intermediate & Advanced course.

Course Duration

The online Microsoft Excel Basic, Intermediate & Advanced course requires 120 hours to complete the course in full. This is only a guide to the learning hours required and it depends on how quickly an individual can absorb the information. The learning is online so it can be spread out over multiple sessions or done in one session.

Learners will have access to this course for up to 12 months from the date of joining. There is no time limit to complete the course during this period.

Tutor Support

When you are studying a course it is always useful to know that you have the help and support of tutors that want you to succeed in your studies.

As part of the Microsoft Excel Basic, Intermediate & Advanced course you will receive access to our dedicated tutor support service. The academic tutors will be able to provide you with unlimited online email support to help answer any questions that you may have whilst you are studying the course.

Course Compatibility

Our Microsoft Excel Advanced course is fully compatible with PC’s, Mac’s, Laptop, Tablet and Smartphone devices.

We know that more and more people are using the web whilst they are on the move, so we have designed this Microsoft Excel Advanced course to be fully compatible across tablet and smartphone devices. You will be able to access the same content from the course, just over a 3G or 4G network whilst on the move.

Questions and answers

No questions or answers found containing ''.

Jana asked:

hello - is this really 3 courses in one - beginner, intermediate and advanced? I have some skills but unsure if I am intermediate or advanced.

Answer:

Hi, Thanks for getting in touch. Yes this is a bundle offer for all three courses with a better saving than if you ordered individually. There are three levels, and one final assessment for each level. When you complete each test you will receive each certificate. Once you have registered onto your course, our team receive your order then send over your login details to get started right away. Hope this helps.

This was helpful. Thank you for your feedback.
su asked:

Is this a one off payment of £22 and can anyone do it or do you need to be registered with Reed.

Answer:

Yes the course is a one off payment of just £22 to enrol. Everyone is welcome to enrol on this course. I hope that helps.

This was helpful. Thank you for your feedback.
Ian asked:

approx how many hours to complete course?

Answer:

The course has a guided learning hours of around 90 hours, although you can complete within this time and will still receive your certificate from our team. Thanks

This was helpful. Thank you for your feedback.
Laurel asked:

I am deaf and I rely on lip reading and captions. Does your course media have captions or transcripts?

Answer:

You will be able to read the course material, so you can study the course through reading.

This was helpful. Thank you for your feedback.
Charmain Williams asked:

If I purchase the excel, basic, intermediate and advance course, do you get separate certificates for the different levels or 1 on completion ?

Answer:

Hi, thanks for getting in touch. Yes, once you have completed each final assessment (one for each level) we process and send out each certificate. So three accredited certificates on completion. Hope this helps!

This was helpful. Thank you for your feedback.
David asked:

do you use office 2016 version

Answer:

Yes we have a 2016 version of this course. Thanks, Helpdesk

This was helpful. Thank you for your feedback.
Dorothy asked:

I am using Home & Student 2019. Will it work with this course? Is there any printable training material, to use for future refresher training?

Answer:

Hey there, You will be able to use this course with your version, although there will be some features that look different due to course upgrades. The course is available all online only although you will have unlimited access during your 12 months access. Hope this helps. Thanks

This was helpful. Thank you for your feedback.
Astra asked:

Is there any other fees or just the one off payment of £22?

Answer:

There are no additional fees once you have registered. The price you see today is a one off fee that will include everything you need to successfully complete your course. This includes 12 months unlimited access, tutor support, your final assessment (retake if needed), and your accredited certificate emailed over on completion.

This was helpful. Thank you for your feedback.
Sara-Jane asked:

Hi. I am dissapointed that I cannot print the PDF doc's. Ideally, I want to create a work book that I can make notes to.

Answer:

As the course is based online only this can only be worked online. Feel free to make notes, although this will be notes that you can make separately. If you need guidance or study tips on note taking for online courses, feel free to look through the Study Resources available within your student account. Great advice can be found there! Hope this helps. Thanks

This was helpful. Thank you for your feedback.
John asked:

Can this course be done on an iPad?

Answer:

Yes! Any device that can access the internet can be used to study this course. As well as Smartphones, laptops and other tablets. Hope this helps. Thanks!

This was helpful. Thank you for your feedback.
Ben asked:

Do learners who do not own a copy of MS Excel 2013 could complete of the course? I own MS Excel 2007. Please advise Thank you

Answer:

Yes you can still complete this course with MS Excel 2007

This was helpful. Thank you for your feedback.
Jane asked:

I use Excel 2013 at work, will this be compatible please? Thank you

Answer:

Yes, this course will cover MS 2013 as well. So you will be able to see examples from your version.

This was helpful. Thank you for your feedback.
Newoffice asked:

Can this course run on office 365

Answer:

Yes it will. There may be some updates with the Office 365 that can look slightly different, although rest assured you will still be able to successfully complete this course. Thanks

This was helpful. Thank you for your feedback.
MSB asked:

Hi, Will this entire packaged work on a MAC? thanks,

Answer:

Yes this is compatible with MAC. Thanks!

This was helpful. Thank you for your feedback.
claire asked:

I have office 365, is this compatible with this course?

Answer:

This will work fine, although there will be some features that will look slightly different due to the updates in Office 365. Thanks

This was helpful. Thank you for your feedback.
Ben asked:

Hi, it says "To complete the course, learners should have their own copy of MS Excel 2013." How about for those who own MS Excel 2007? Thank you

Answer:

You can have an older version this is fine, it will just mean that some features illustrated throughout the course may look slightly different to what you already have. Once registered with us we can provide you with a trial version to use so you have the right version for your course. Hope this helps. Thanks

This was helpful. Thank you for your feedback.
Ben asked:

Will learners who do not have Microsoft 2013 software be able to complete the course? I currently possess Microsoft Excel 2007. Thank you

Answer:

Yes, this course will also cover topics that you will be familiar with in the 2007 software.

This was helpful. Thank you for your feedback.
Suzanne 246 asked:

Hi can you tell me if I need a laptop to do the excel courses or can I do on iPad. Does the course come with software or do I need to purchase?

Answer:

The course is standalone, you would need to have a version of MS Excel or use a trial version from Microsoft. The actual course itself you can study on any device.

This was helpful. Thank you for your feedback.
Mark asked:

I use Excel on a Mac with the 2016 version. Is this course compatible with my version?

Answer:

Hi Mark, The course covers the Excel software and as long as you have a copy you will be able to follow along. Thanks Oplex Careers Team

This was helpful. Thank you for your feedback.
Marianne Taylor asked:

Do I need to purchase a Microsoft Excel basic, intermediate and advanced book to go alongside this course?

Answer:

Hi, Everything you need will be provided as part of your course. The course includes reading materials, End of Module tests to help monitor your progress as your continue through the reading modules, in addition to downloadable exercise files to complete set tasks within the modules. I hope this helps. Regards, Helpdesk

This was helpful. Thank you for your feedback.
Amir asked:

Please can you advise if this course has exercise files to work on whilst learning from the video?

Answer:

Hi, Thanks for getting in touch. The course is in slide presentation and will also have exercise files for the tasks that can be downloaded to help you work alongside the course materials. Once you have registered onto your course, our team receive your order then send over your login details to get started right away. Hope this helps.

This was helpful. Thank you for your feedback.
Exel 2016 asked:

Hi, I want to do this course but I am provided with v 2016 at work. Is there a 2016 course i could do?

Answer:

Hello, The course cover Microsoft Excel Basic, Intermediate and Advanced from the 2016 software. So this course would be perfect. You can enrol onto this course through reed and we will send you the course access straight away. If you have any other questions just let us know. Have a great day. Thanks Oplex Careers Team

This was helpful. Thank you for your feedback.
Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Microsoft 365 courses, Microsoft courses, Online courses