Microsoft Excel Complete Course – Beginner, Intermediate; Advanced – CPD

Microsoft Excel Complete Course - Beginner, Intermediate; Advanced - CPDMicrosoft Excel Complete Course – Beginner, Intermediate & Advanced- CPD.

Student Discount Card Eligible | Lifetime Access | Online certified training |Online certificate and exam included.

Summary.

Exam(s) / assessment(s) is included in price Tutor is available to students.

Add to basket or enquire.

Overview.

Microsoft Excel – Full Course – Beginners , Intermediate & Advanced – CPD Accredited – Complete Excel Course.

We have combined our Microsoft Excel Beginners , Intermediate and Advanced Courses to make the most in-depth Complete Excel Course on the market and for Reed users we are offering this course for only £29!

One of the most widely used programmes in the world for visualising and analysing data is Microsoft Excel. This software is used in almost every industry, not to mention for personal use in households around the world. Small business owners rely on Excel to track hours, finances, and invoices, and large corporations rely on Excel for data analysis, to visualise data, and innumerable other tasks.

Whether you are brand new to the world of Excel, or you have training and knowledge of the software and looking to improve your skills, this series of courses can help. By the time you finish the beginner, intermediate and advanced courses, you, too, will be an expert in Excel.

You can learn at your own pace, as there is no time limit nor deadline to complete the courses. You can also access these courses from any mobile device, including tablets, computers, and mobiles, as long as you have access to the internet.

Since the lessons in this course are only a few minutes each, it makes it very convenient for one to stop and start when necessary. This helps to study when you have time, even if you have less than 10 minutes or 15 minutes.

** When purchasing this course you will be eligible to apply for the XO Student Discount Card!! You can save on brands such as New Look, Disney, ASOS, Hotels, Miss Selfridge , Domino’s and many more.**

CPD hours / points.

Course media.

Description.

MS Excel Beginners Course.

The MS Excel beginners course will give you a full overview of all of the most common features of Excel and how to use them.

Some of the highlights of this course include:

A basic overview of 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.

This beginners course is recommended for anyone who might use Excel at home or at work for uncomplicated reasons, such as tracking simple expenditures or for calculating sums or totals.

MS Excel Intermediate Course.

The MS Excel Intermediate Course will take what you learnt in the beginners course and expand upon it. Additionally, this course will teach you more advanced concepts than those that were presented in the beginners course.

Some of the highlights of the intermediate Excel course include the following:

Learning more about intermediate 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 Excel Creating random numbers Changing text case Adding passwords Sending emails from Excel Adding custom backgrounds How to auto fill data Adding special characters Changing border colour and theme.

Before jumping into the MS Excel Intermediate course, one should have a good basic overview of the beginner Excel functions. Those with experience in Excel might feel as if they can skip the beginner course, but it is best to at least go through the course and review it before starting the intermediate curriculum.

The curriculum in the intermediate course is designed for those who work with Excel in the workplace, and it is primarily for those who want to improve their skills with this program.

MS Excel Advanced Course.

The MS Excel Advanced Course is the longest and the most intense of the three Excel courses presented here. However, if you have successfully passed the beginner and the intermediate courses, you should consider yourself fully prepared to begin the advanced course.

Some of the concepts that you will learn in the MS Excel Advance Course include the following:

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 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 Selecting only cells containing comments Hiding formulas.

As you can see, the information you will get from the MS Excel Advanced Course will fully prepare you for virtually any career path, including those that require advanced skills with this software. Though this course is the longest and most involved of the three, once you complete it, you will have the knowledge and skills that most can only dream of.

Beginners Course Modules/Lessons.

Module 1: Introduction to Excel.

Module 3 : Multiply.

Module 4 : Subtraction in Excel.

Module 5 : Dividing.

Module 7 : Percentage.

Module 8 : Running Totals.

Module 9 : Print.

Module 10 : Paste Special.

Module 11 : Merge.

Module 12 : Filter.

Module 13 : Average.

Module 14 : AVERAGEIF.

Module 15: SUMIF Formula.

Module 16: IF Formula.

Module 17: VLOOKUP.

Module 18: HLOOKUP.

Module 19 : Countif Formula.

Module 20 : CountBlank.

Module 21 : Counta Formula.

Module 22 : Count Formula.

Module 23 : Concatenate.

Module 24 : Transpose.

Module 25: Date Formula.

Module 26: Month Formula.

Module 27: Pivot Tables.

Module 28: Pie Charts.

Module 29: Doughnut Charts.

Module 30: Line Charts.

Module 31: Column Charts.

Module 32: Bar Charts.

Module 33: Number Formatting.

Module 34: Create Borders.

Module 35: Conditional Formatting.

Module 36: Comments FAQ’s.

Intermediate Course Modules/Lessons.

Module 1: SumProduct Formula.

Module 2 : Data Validation With Date.

Module 3 : Data Validation with Whole Numbers.

Module 4 : Data Validation with List Feature.

Module 5 : ABS Function.

Module 6 : CHAR Function.

Module 7 : CLEAN Function.

Module 8 : CODE Function.

Module 9 : EXACT Function.

Module 10 : AVERAGEA Function.

Module 11 : AVERAGEIF.

Module 12 : AVERAGEIFS Function.

Module 13 : CELL Function With 10 Variations.

Module 14 : LARGE Function.

Module 15: MAX Function.

Module 16: MEDIAN Function.

Module 17: MIN Function.

Module 18: MODE Function.

Module 19 : N Function.

Module 20 : RANDBETWEEN Function (Insert Random Numbers)

Module 21 : RANK Function.

Module 22 : Remove Duplicate Values.

Module 23 : ROUND Function Up/Down.

Module 24 : Add Custom Background Image.

Module 25: Change Text To Lower Case.

Module 26: Change Text To Upper Case.

Module 27: Change Text To Proper Case.

Module 28: Insert Special Character.

Module 29: Use Autofill : A Time Saving Trick.

Module 30: Treemap Chart.

Module 31: Sunburst Chart.

Module 32: Use Tables.

Module 33: Use Templates.

Module 34: Use Themes.

Advanced Course Modules/Lessons.

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 and Match Formula.

Module 32: Indirect Formula.

Module 33: Insert Serial Number Automatically.

Module 34: IPMT Formula.

Module 35: Isblank Formula.

Module 36: Iserr Formula.

Module 37: Islogial Formula.

Module 38: Isnon Text Formula.

Module 39: IsNumber Formula.

Module 40: Isodd Formula.

Module 41: Isolate First Name.

Module 42: ISTEXT Formula.

Module 43: Left Formula.

Module 44: Len Formula.

Module 45: Match Formula.

Module 46: Vlookup Multiple Results at Once.

Module 47: OR Formula.

Module 48: PMT Formula.

Module 49: Replace Formula.

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.

Who is this course for?

There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.

Testimonials.

Ivica Vrabelova – London.

Highly recommend this Excel course.

Website is easy to navigate; three main areas: beginners, intermediate and advanced are very well structured; videos and exercises are short, and interactive which is convenient if you study on the go; not boring at all.

You can always come back to the particular topic if it is not clear or you want to refresh your memory. Highly recommend this Excel course if you are beginner or you just want to become an expert in certain parts of this programme.

The price is just right for the quality of course you get. I believe my skills improved a lot since starting this course.

Requirements.

Our Course is fully compatible with PC’s, Mac’s, Laptop, Tablet and Smartphone devices. Now more than ever people are using the internet while on the move so our course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.

There is no time limit for completing this course, it can be studied in your own time at your own pace.

All tests are online and are taken either during or after the course, these are included in the price.

Career path.

Having excel qualifications will open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA.

Questions and answers.

No questions or answers found containing ‘ ‘.

Lamesgin asked:

After I finish the course, I may forget what I’ve learnt. Is there any way I can practice after finishing the course please?

Answer:

Hi Lamesgibn, You will have lifetime access to the course so you can log in at any time to revisit modules.

This was helpful. Thank you for your feedback. 0, text: currentQuestions[0].helpfulText()”>

Agnes asked:

The price for GBP29.00, is it for all three levels.

Answer:

Hi Agnes, Yes, that’s correct. The fee includes three diplomas, all worksheets, assignments and exams. You have lifetime access to the course.

This was helpful. Thank you for your feedback. 0, text: currentQuestions[1].helpfulText()”>

Catherine asked:

If I purchase and sign-up today, but commencement is delayed a few weeks, that ok?

Answer:

Hi Catherine, Yes, no problem at all. You have lifetime access to the course so no rush 🙂

This was helpful. Thank you for your feedback. 0, text: currentQuestions[2].helpfulText()”>

Abdulaziz asked:

What is the average time to complete the course?

Answer:

Hi Abdulaziz, The course duration depends on the student themselves as you can study as much or little as you want, when you want. If you completed the course in one sitting, it would take approximately 40 hours.

This was helpful. Thank you for your feedback. 0, text: currentQuestions[3].helpfulText()”>

Saira Qureshi asked:

Is there a separate fee for the certificates?

Answer:

Hi Saira, You can download/print your certificate free of charge from your account at any time. If you would like a hard copy of your certificate sent via post, there will be a small fee for this.

This was helpful. Thank you for your feedback. 0, text: currentQuestions[4].helpfulText()”>

lisa starr asked:

hi i would like to purchase this course but only have mircosoft office 2007 am i still able to do this course?

Answer:

Hi Lisa, You will still benefit from the course, however we would suggest using the 2010 version at least (2010, 2013 or 2016).

This was helpful. Thank you for your feedback. 0, text: currentQuestions[5].helpfulText()”>

Michele asked:

Is there a certificate after each difficulty level? Beginners, intermediate etc?

Answer:

Hi Michele, Yes, that’s correct. Once you have completed the Advanced level, you can then download the ‘Complete’ certificate too. Hope this helps.

This was helpful. Thank you for your feedback. 0, text: currentQuestions[6].helpfulText()”>

Marek asked:

Which version of MS Excel does this course use? Will I have to buy that. or the latest, version to benefit?

Answer:

Hi Marek, We would recommend you use the newest version of MS Excel (2016) for the course. However, you will still be able to complete the course with both 2010 and 2013 versions. Thanks, Be-A.

This was helpful. Thank you for your feedback. 0, text: currentQuestions[7].helpfulText()”>

Donna mcparland asked:

Is this course compatible with Office 365 Personal?

Answer:

Hi Donna, Yes, that’s correct.

This was helpful. Thank you for your feedback. 0, text: currentQuestions[8].helpfulText()”>

Angela asked:

Do you receive a manual with this course so you can refer back to learning points later? Thank you.

Answer:

Hi Angela, You have lifetime access to the course so can refer back to the course content and videos whenever you like.

This was helpful. Thank you for your feedback. 0, text: currentQuestions[9].helpfulText()”>

Ash asked:

Do you provide a certificate after the completion of the course.

Answer:

Hi Ash, Upon completion you will be able to download and print off your certificate for free, Alternatively we can send you our a hard copy for an admin fee of £10.

This was helpful. Thank you for your feedback. 0, text: currentQuestions[10].helpfulText()”>

Jaqui asked:

hello, I am using version 2002. Can I still do this course?

Answer:

Hi Jaqui, Thank you for your enquiry. The version of Excel used in the tutorials is 2016. There may be some small differences between different versions of Excel, but all functions should still be the same.

This was helpful. Thank you for your feedback. 0, text: currentQuestions[11].helpfulText()”>