Skip to content

Microsoft Excel

Cyber Monday Offer | *Offer Ends Soon* FREE PDF Certificate | Beginner, Intermediate & Advanced Level Course


Janets

Summary

Price
Save 99%
£10 inc VAT (was £1,049)
Offer ends 03 December 2021
Study method
Online, self-paced
Access to content
Lifetime access
Qualification
No formal qualification
CPD
120 CPD hours / points
Achievement
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students

6,268 students purchased this course

Add to basket or enquire

Overview

Follow your dreams by enrolling on the Microsoft Excel course today and develop the experience, skills and knowledge you need to enhance your professional development. Microsoft Excel will help you arm yourself with the qualities you need to work towards your dream job.

Study the Microsoft Excel training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Microsoft Excel course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.

This Microsoft Excel course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Microsoft Excel course through a mixture of instructional video lessons and online study materials.

Receive online tutor support as you study the Microsoft Excel course, to ensure you are supported every step of the way. Get a free e-certificate as proof of your Microsoft Excel course completion.

Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Microsoft Excel course. The Microsoft Excel course is designed by industry experts and is tailored to help you learn new skills with ease.

The Microsoft Excel course is incredibly great value and allows you to study at your own pace. With full course access for the lifetime, you can complete the Microsoft Excel when it suits you. Access the Microsoft Excel course modules from any internet-enabled device, including computers, tablets, and smartphones.

The Microsoft Excel course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Microsoft Excel now and start learning instantly!

What You Get Out Of Studying Microsoft Excel With Janets

  • Free PDF certificate upon successful completion of the Microsoft Excel
  • Lifetime access to Microsoft Excel Course materials
  • Instant assessment results with the Microsoft Excel
  • Full tutor support available from Monday to Friday with the Microsoft Excel
  • Study the Microsoft Excel at your own pace
  • Benefit from instant feedback through mock exams and multiple-choice assessments
  • Gain a complete understanding of Microsoft Excel
  • Accessible, informative modules taught by expert instructors
  • Get 24/7 help or advice from our email and live chat teams with the Microsoft Excel
  • Study the Microsoft Excel in your own time through your computer, tablet or mobile device
  • Improve your chance of gaining professional skills and better earning potential by completing the Microsoft Excel

Achievement

CPD

120 CPD hours / points
Accredited by CPD QS

Course media

Description

Microsoft Excel Complete Course

Microsoft Excel for Beginners Course

The Microsoft Excel training course is delivered through Janets’ online learning platform. Access the Microsoft Excel content from any internet-enabled device whenever or wherever you want to. The Microsoft Excel course has no formal teaching deadlines, meaning you are free to complete the course at your own pace.

Highlights:

  • A basic overview of Microsoft Excel
  • Calculating sums, averages, and totals
  • Counting cells
  • Learning formulas, such as IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF
  • Pivot tables
  • Inserting, editing, and deleting comments
  • Creating borders
  • Wrapping text
  • Merging cells
  • Pasting, sorting, and converting columns to rows
  • Creating graphs and charts
  • Using hyperlinks

Microsoft Excel Intermediate Course

You will build upon what you have learned in the Microsoft Excel Intermediate course, with more advanced concepts. The basics learned in the Microsoft Excel for Beginner course will give you a good foundation, even for those with some experience in Excel. This is ideal for those who use Excel at work who want to improve their skills.

Highlights:

  • Learning more about intermediate Microsoft Excel functions including ABS, SUMIF, HLOOKUP, VLOOKUP, COUNTIF, AVERAGEIF, AVERAGEIFS, and AVERAGEA
  • Data validation with date, list, time, and numbers
  • Functions such as RANK, MIN, MAX, CHAR, MODE, MEDIAN, CODE, CLEAN, and EXACT
  • How to remove duplicates in Microsoft Excel
  • Creating random numbers
  • Changing text case
  • Adding passwords
  • Sending emails from Microsoft Excel
  • Adding custom backgrounds
  • How to auto fill data
  • Adding special characters
  • Changing border colour and theme

Microsoft Excel Advanced Course

The most in-depth of the three, the Microsoft Excel Advanced course will prepare anyone for full professional use of excel at work. It is ideal for those who need advanced level knowledge of Microsoft Excel, applicable in any career.

Highlights:

  • VLOOKUP Advanced formula options and manipulations
  • Other advanced functions including OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND
  • Functions including CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE
  • Colouring a column and row with a formula in Microsoft Excel
  • Highlighting a cell with a formula
  • Functions including ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK
  • Functions including DGET, DMAX, DPRODUCT, DCOUNTA, DCOUNT and DSUM
  • Calculating loan IPMT and EMI
  • Functions including DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX
  • Full explanation of the INDEX and MATCH functions, covering several modules
  • Looking up data with Microsoft Excel
  • Selecting only cells containing comments
  • Hiding formulas

*** Modules (Microsoft Excel Complete Course)***

**Microsoft Excel Beginners Course**

Getting Started with Microsoft Office Excel 2016

  • Navigate the Microsoft Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data

Performing Calculations

  • Create Worksheet Formulas
  • Insert Functions, Reuse Formulas and Functions

Modifying a Worksheet

  • Insert, Delete, and Adjust Cells, Columns, and Rows in Microsoft Excel
  • Search for and Replace Data
  • Use Proofing and Research Tools

Formatting a Worksheet

  • Apply Text & Number Formats
  • Align Cell Contents & more

Printing Workbooks

  • Preview and Print a Workbook
  • Set Up the Page Layout & more

Managing Workbooks

  • Manage Worksheets
  • Manage Workbook, Workbook Properties and Worksheet Views

**Microsoft Excel Intermediate Course**

Working with Functions

  • Work with Ranges
  • Use Specialized Functions & more

Working with Lists

  • Sort & Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data

Analyzing Data

  • Create and Modify Tables
  • Apply Intermediate & Advanced Conditional Formatting

Visualizing Data with Charts

  • Create Modify and Format Charts in Microsoft Excel
  • Use Advanced Chart Features of Microsoft Excel

Using PivotTables and PivotCharts

  • Create a PivotTable & Present Data with PivotCharts
  • Analyze PivotTable Data with Microsoft Excel & more

**Microsoft Excel Advanced Course**

Working with Multiple Worksheets and Workbooks

  • Use Links and External References
  • Use 3-D References & more

Using Lookup Functions and Formula Auditing

  • Use Lookup Functions & Trace Cells
  • Watch and Evaluate Formulas

Sharing and Protecting Workbooks

  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks

Automating Workbook Functionality

  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors & more

Creating Sparklines and Mapping Data

  • Create Sparklines
  • MapData

Forecasting Data

  • Determine Potential Outcomes Using Data Tables & Scenarios
  • Use the Goal Seek Feature & more

Method of Assessment

To successfully complete the Microsoft Excel course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Microsoft Excel course.

Certification

All students who successfully complete the Microsoft Excel course can instantly download their free e-certificate. You can also purchase a hard copy of the Microsoft Excel course certificate, which will be delivered by post for £9.99.

Who is this course for?

The Microsoft Excel is ideal for those who already work in this sector or are an aspiring professional. This Microsoft Excel course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.

Requirements

The Microsoft Excel is open to all students and has no formal entry requirements. To study the Microsoft Excel course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.

Career path

The Microsoft Excel is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Microsoft Excel and gain an highly valuable skill that will help you excel in finding your ideal job.

Questions and answers


No questions or answers found containing ''.


Jo asked:

With so much covered in the course are you able to refresh your memory at some point in the future after completing the course?

Answer:

Dear Jo, Thanks for the question. Once you purchase a course, you will get a one-year access to the course. After your one-year validation is over, you can always get back to refresh your memory. You will just need to give us an email asking the access to the course. We happily extend the validity for you. Thanks, Help Desk.

This was helpful. Thank you for your feedback.

Jasmine asked:

Do I need to pay the postal charge for the hardcopy certificate?

Answer:

Dear Jasmine, Thanks for the question. You don’t need to pay any separate postal charge for the hardcopy certificate. We don’t charge our learners for the delivery of the certificate. Once you will successfully complete and pass the course, you will be able to obtain an accredited certificate. Thanks, Help Desk.

This was helpful. Thank you for your feedback.

Antony asked:

How long does the course take to complete?

Answer:

Dear Antony, Thanks for the question. Once you purchase any course, you will have a one-year access to the course. Therefore, you can complete it anytime within a year. However, the estimated courses duration is 11 hours. Thanks.

This was helpful. Thank you for your feedback.

Irma asked:

Are you tested individually at introduction, intermediate and advanced stage to receive certificate or all 3 stages before receiving your certificate.

Answer:

Hi Irma, There is a mock and a final exam after completing all the modules and stages. After completing all the modules of all stages, you can sit for the exam. Upon passing the exam, you will be able to obtain an accredited certificate. Thanks.

This was helpful. Thank you for your feedback.

dee asked:

does this course include spreadsheets ?

Answer:

Hi Dee, Thanks for the question. Yes, you will activity tasks throughout the course where you will find the spreadsheet tasks to complete. You can practice the lessons you learned from the activity section. Thanks Help Desk.

This was helpful. Thank you for your feedback.

Purvi asked:

After a year when I access the course do I need to pay again

Answer:

Hi Purvi, Thanks for your interest. No, you will not. Since the course has a lifetime access offer, you will not need to renew the course every year. Stay Safe

This was helpful. Thank you for your feedback.

ayaan toqir asked:

Hello I will be 14 Yr next week can I still do this course as my parent have purchased it for me.

Answer:

Hi Ayaan, Thank you for your interest. Yes, you can do the course with your parents consent. Stay Safe.

This was helpful. Thank you for your feedback.

Rose asked:

Hi there. What version of Excel is needed for this course? Thanks and kind regards, Rose

Answer:

Hi Rose, Good morning. Thank you for your interest. You need Microsoft Office Excel 2016 Version to complete this Microsoft Excel course. However, you will get one-year access to the course upon purchasing. Therefore, you can complete it anytime within a year. Stay Safe.

This was helpful. Thank you for your feedback.

Becky asked:

Do i need excel to be installed on my computer to carry out this course?

Answer:

Hi Becky, Yes, you will need to have Microsoft Excel installed on your computer to carry out this Microsoft Excel course. Best of luck. Stay safe.

This was helpful. Thank you for your feedback.

Inna asked:

does this course have PRACTICE EXAMPLES (tasks) after each chapter, and/or chunk of material ?

Answer:

Hi Inna, Good morning. There will be a unit called 'Workbooks' after each part for the practice purpose. Stay Safe.

This was helpful. Thank you for your feedback.

Akanksha Mavooru asked:

Hi, I am currently not living in the Uk. Would you be able to post the certificate overseas?

Answer:

Hi Akanksha, Good morning. Yes, the hard copy certificate will be posted to your address. Stay Safe.

This was helpful. Thank you for your feedback.

Jerry Igbinoba asked:

Dear Janet, please what format are the learning materials i.e videos or books? Thanks Jerry

Answer:

Hi Jerry, Good morning. The course is designed by Video-based Learning Modules. Stay Safe.

This was helpful. Thank you for your feedback.

Todd asked:

The course is fully online, can the test be taken online too?

Answer:

Hi Todd, Good morning. Yes, the whole exam will be conducted online. Stay Safe.

This was helpful. Thank you for your feedback.

Jay asked:

Hi, how long would I have access to tutor support? Thanks

Answer:

Hi Jay, Thanks for your interest. You will have lifetime tutor support with this course. Stay Safe

This was helpful. Thank you for your feedback.

Elizabeth King asked:

Do I need to purchase a Microsoft excel licence as well as the course? Or is access to excel included in the course?

Answer:

Hi Elizabeth, Thanks for your interest. Our course price covers only the study materials for the Microsoft Excel course. However, the learner needs to have arrangements for the excel software by herself. Stay Safe

This was helpful. Thank you for your feedback.

David Deveson asked:

which. version of excel is required?

Answer:

Hi David, Thanks for your interest. Microsoft Excel 2016 version is required to do the course. Stay Safe.

This was helpful. Thank you for your feedback.

Deol asked:

Are there any exams?

Answer:

Hi Deol, Thanks for your interest. The learner will have a mock and the final exam at the end of this course and it will be an automated multiple-choice exam. Stay Safe

This was helpful. Thank you for your feedback.

Yvette asked:

Hi, does the course cover beginner, intermediate and advanced or do you have to pay separately for each level? Many Thanks

Answer:

Hi Yvette, Thanks for your interest. All the levels are included in the Microsoft Excel course and the learner does not need to pay separately for them. Stay Safe

This was helpful. Thank you for your feedback.

Heidi asked:

Is this a one off fee of £10 today ? And no hidden extra fees?

Answer:

Hi Heidi, Thanks for your interest. The complete course price is worth £10 without any hidden charge to it and it is a one-off payment. Stay Safe

This was helpful. Thank you for your feedback.

Ly asked:

What is included in the lifetime access? Do you get a year to complete the course only? Is this different to the lifetime access?

Answer:

Hi Ly, Thanks for your interest. Lifetime access means that the learner will have access to the course content for an unlimited time. Stay Safe

This was helpful. Thank you for your feedback.

Hajra asked:

Hi I am purchasing more than one course. There is no guarantee that I will be able to complete within one year of purchase. Would I lose access?

Answer:

Hi Hajra, Thanks for your interest. All the courses will be expired after one year from the date of purchase. However, if the learner has multiple courses signed up for and could not finish it all within the time frame, they can extend their courses by paying an additional amount. Stay Safe

This was helpful. Thank you for your feedback.

Kyra asked:

Would I have to go to a text centre to take the exam or would it be done at home?

Answer:

Hi Kyra, Thanks for your interest. Please note that the test is an online-based text which will be taken through the learners' learning portal and the learner does not need to go to centre to take the exam. Stay Safe

This was helpful. Thank you for your feedback.

DAVID KI asked:

1. How do I pay for the course if I don't have a credit card? Am a Ugandan living in UAE 2. Equipments needed to access the course. Thanks

Answer:

Hi DAVID, Thank you for your interest. You can pay through PayPal, Visa Debit/Credit Card. And the Microsoft Excel course is accessible through any internet-connected device. Stay Safe

This was helpful. Thank you for your feedback.

Irene asked:

Would this course be relevant to Microsoft 365 versions of Excel?

Answer:

Hi Irene, Good morning. Yes. Stay Safe.

This was helpful. Thank you for your feedback.

Samantha Jones asked:

Can you please tell me what software (year) is required to complete the course? Thanks

Answer:

Hi Samantha, Good afternoon. You will need Microsoft Excel 2016 software in order to complete the course. Stay Safe.

This was helpful. Thank you for your feedback.

Reviews

4.3
Course rating
86%
Service
85%
Content
89%
Value

FAQs

What does study method mean?

Study method describes the format in which the course will be delivered. At reed.co.uk 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.

What are CPD hours/points?

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.co.uk, many of which can be completed online.

What is a ‘regulated qualification’?

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.

What is an ‘endorsed’ course?

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.