Course not currently available

Microsoft Excel – Intermediate Online Course - Accredited - Best Selling Intermediate

Course

Online

Save 86%
£ 39 VAT inc.

Description

  • Type

    Course

  • Methodology

    Online

MS Excel Intermediate Course - CPD & IVCAS accredited

**We have now partnered with NUS so once you've purchased your course you are eligible by studying with us to apply for an NUS Extra card which gives you 1000's of discounts with the biggest companies**

The MS Excel Intermediate Course follows on from our best selling Microsoft Excel Beginners Course and 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.

Before jumping into the MS Excel Intermediate course, we highly recommend you taking our best selling excel beginners course or another beginners courses which can be found by clicking on our logo on the top right hand side of your screen.

Like the beginner course, the intermediate course is set up into short modules, and you can watch the module videos on any device that can connect to the internet. 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. There is a lot of useful information found in this course, and these skills are necessary for anyone who is going into investments, banking, or consulting, and will also be useful for administrators or for those who track or analyse a lot of data. If you are someone who is new to the workforce, you, too, will find that employers are looking for candidates with at least intermediate Excel skills.

The course teaches students how to use functions, including AVERAGEA, AVERAGEIF, AVERAGEIFS and ABS. You will also learn data validation information and students work through several modules, each of which are focused on a type of data validation, such as date, list, and time. The course deals with more information on specific functions, which include CHAR, CODE, MEDIAN, MODE, and ROUND. Additional information is given on how to manipulate...

About this course

Information Technology

CPD

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Internet
  • IT
  • Microsoft Excel
  • Image
  • Consulting
  • Banking
  • Accredited
  • Microsoft excel training
  • MS Excel

Course programme

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

Learning more about intermediate Excel functions including ABS, 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
How to use Templates
Insert Charts
Adding custom backgrounds
How to use Tables
How to auto fill data
Adding special characters
Changing border colour and theme
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

Additional information

Lifetime

Microsoft Excel – Intermediate Online Course - Accredited - Best Selling Intermediate

£ 39 VAT inc.