Microsoft Excel – Intermediate Course - CPD Accredited
Student Discount Card Eligible | Lifetime Access | Online certified training |Online certificate and exam included
Be-a.co.uk
Summary
- Exam(s) / assessment(s) is included in price
- Tutor is available to students
Add to basket or enquire
Overview
MS Excel Intermediate Course - CPD accredited
The MS Excel Intermediate Course follows on from our 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 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 these functions to meet your needs as an Excel user.
Other information in the MS Excel Intermediate Course includes how to change the text in Excel, i.e. changing text to all upper case or lower case. You will also learn how to change the background and add a custom image, how to use AutoFill and how to insert special characters.
Upon completion of this course, you will know about most of the functions that Excel has, and how to use this software at an intermediate level. Additionally, you will have the skills necessary to use Excel in most business environments. You will also be fully prepared to begin the MS Excel Advanced Course.
** 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
Course media
Description
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
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 however some excel knowledge is advised for our intermediate course.
Testimonial
Jordan Price – Swindon
I would highly recommend
Fantastic course with great instruction and demonstrations.
I can already feel the benefit of this course whilst at work through improved efficiency and the handy tips I have picked up.
I have been using Excel for years now and I really regret not seeking some tuition sooner as I have learnt so many simple but useful things that can really make a difference straight away.
Very pleased with this provider and looking forward to the advanced level and possibly further courses in the future.
I would highly recommend this to anyone wishing to enhance their current knowledge or as a refresher.
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
how many hours is the course?
Answer:Our intermediate course should take you around 15/20 hours to complete :)
This was helpful.
Reviews
Currently there are no reviews for this course. Be the first to 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.