HOME
 

Microsoft Excel Intermediate Certificate

New Skills Academy
Course summary
10 hours
80 GBP
Online courses
Next available date: Inquire for more information - Online courses
Professional Training

Course description

MS Excel Intermediate Course

Please Note: This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions.

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.

What you will learn

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

    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.

    Do you have questions about COVID-19 in relation to this course?

    At findcourses.co.uk we are committed to helping everyone who wants to learn, to learn. So are our trusted partner providers.

    Get in touch on this page to find out whether there are any changes to this course in light of COVID-19.

    About provider

    New Skills Academy

    New Skills Academy

    Welcome to New Skills Academy – Part of the Be-a Education Family In November of 2013, a single question was asked: ‘What do you want to learn?’ From there, a vision was born of comprehensive, high quality, and affordable online...


    Read more and show all courses with this provider

    Request info

    Tell us what kind of professional training you're looking for and we'll put you in touch with relevant training providers who will send you a quote.

    Contact info

    New Skills Academy

    Hertford Rd, Ware
    SG12 9LH Hertfordshire

    Need Help?

    Tell us what kind of professional training you're looking for and we'll put you in touch with relevant training providers who will send you a quote.

    U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

    Are you curious about the L&D strategies of some of the U.K.'s top companies?

    Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

    uk-ld-report-2019

    Learn more

    Find a course for you!

      Read the course
     summary on this page

     Fill in your details and Request information

     Receive all the info you need

    Find more courses here