• My account
  • Cart
English courses / EUR

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

Regular Price: 337€

Special Price: 44€

  • 2 students have purchased
  • Express
Centre
New Skills Academy
Town
Hertford
Address
Ability Business Centre Ware Herts SG12 9LH See in Google maps
Contact
support@newskillsacademy.co.uk
http://newskillsacademy.co.uk/
Map
Description
GAINING QUALIFICATIONS HAS NEVER BEEN SO EASY WITH NEW SKILLS ACADEMY New Skills Academy are dedicated to delivering affordable and comprehensive online courses which have all been accredited by IVCAS so you are guaranteed quality course material with in-depth learning. Why You Should Train With New Skills Academy: Discounts of up to 90% for all Hotcourses students - we believe in providing online learning to everyone and are committed to the most cost effective training -Wide range of courses -Comprehensive, yet easy to understand syllabus -Our online courses enable you to study anywhere -Go at your own pace – no time limits -Gain a verifiable qualification ACCREDITED by IVCAS & CPD -Improve your career prospects -Tutor support via email and our forums

Benefits

  • Easy to follow
  • Make your own study schedule and take advantage of online tutoring hours
  • Obtain a certified diploma once you finish the course.

Details

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...

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

Conditions

Thanks to this offer, valid exclusively for one person, you will obtain a Microsoft Excel – Intermediate Online Course - Accredited - Best Selling Intermediate.

How to register

By buying the course in Emagister Express, you will obtain an access coupon. We will send you the codes and keys to the coupon. Send the coupon code and the key to support@newskillsacademy.co.uk. The training provider will then give you access to the course.

This course has not been reviewed yet
Hi! According to your location, we have changed your payment currency to EUR.
You can change to other currency by using the option on the header.