Notice

This website or its third-party tools process personal data (e.g. browsing data or IP addresses) and use cookies or other identifiers, which are necessary for its functioning and required to achieve the purposes illustrated in the cookie policy.
You accept the use of cookies or other identifiers by closing or dismissing this notice, by clicking a link or button or by continuing to browse otherwise.

Excel 2013 Advanced

QLS (ABC)
£199.99
  • About This Course
    Do you want to master Excel? Learn how with Excel 2013 Advanced. The course teaches you the ins and outs of all things Microsoft Excel. Excel 2013 Advanced will take your spreadsheet knowledge to a whole new level so that you can take advantage of everything Excel has to offer and supercharge your efficiency.  
     
    Who is this course for?
    This online course is ideal for anyone who understands multiple features and functions of Excel (2013) but wants to really hone their knowledge and take their spreadsheet skills further. Excel 2013 Advanced is aimed at experienced Excel users who need to use the software for more complicated tasks, such as tracking and calculating finance data or creating progress reports. It’s also ideal for people that want to find out how Microsoft Excel can further benefit them, either at home or in the workplace.  
     
    What will you get from this course?
    Excel 2013 Advanced allows you to discover Microsoft Excel’s full potential and to turn this potential into real results. You’ll learn to get the most out of Microsoft Excel and will possess the skills to complete any task with ease and speed, so that you can become the Excel expert of your business. 
     
    When you have completed this course, you will be able to:
    • Use a variety of database functions and data analysis tools
    • Easily find data with the VLOOKUP, HLOOKUP and IF functions
    • Understand how to appropriately secure and send spreadsheets
    • Create and insert pivot tables in your spreadsheets 
    • Create simple macros to help you save time 
     
    Course features 
    • Easy-to-follow lessons which you can dip in and out of at your leisure 
    • Content can be accessed via any platform: mobile, tablet or computer
    • Bitesize learning so that you can get to grips with the advanced functions of Excel quickly and easily
  • Course lessons
    • IF, VLOOKUP and HLOOKUP
    • Pivot tables 
    • Security, sharing and spreadsheet protection
    • Data analysis, macros and options 
    • Database functions
  • Accreditation

    This course has been accredited by Online Academies. On successful completion of this course you will be able to download or print off a PDF of your Online Academies Certificate (please note: you will also be given the opportunity to have a hard copy of the certificate printed off and posted out to you for a small additional charge). If you would like to view a sample of the certificate, please click here.

    Online Academy work with Quality Licence Scheme (Quality Licence Scheme). The Quality Licence Scheme is part of the Skills and Education Group, a charitable organisation that unites education and skills-orientated organisations that share similar values and objectives. With more than 100 years of collective experience, the Skills and Education Group’s strategic partnerships create opportunities to inform, influence and represent the wider education and skills sector.

     

    Assessment

    At the conclusion of each module there is a multiple choice question assessment. This will help you remember the main points of the lesson and act as a check that you have retained the essential knowledge and understanding of that particular section. The results can be seen instantaneously and you can correct wrong answers. When the result is satisfactory you can progress to the next module.

    Course Outcomes

    Once you have successfully completed all the modules for your course you will be awarded:

    A Diploma issued by Online Academies

WHAT OUR STUDENTS SAY
bbSutton314
Great informative course

I have done 3 courses now, 2 on dog grooming and one on human anatomy. All have been at my own speed. The modules allow me to pick it up and do when i have a spare 40 minutes. The end of module questions give me the revision i need to make sure it sunk in. I’m pleased with what I have achieved on these courses and would recommend them.

unicornamoeba
Well worth the money!
Caseycoughlan
The best boost for anyone
SarahJBailey
Fantastic, I'm on top of the world

I studied level 4 diploma child psychology, I completed the course in 7 weeks with fantastic support from my tutors. The course information was very informative and I was able to gain extra knowledge through links. I emailed tutors a few times, I had replies within the hour. My final assignment was marked within 3 days and I am over the moon with my result of distinction and feedback from tutor...

kernelcapella
Excellent experience

I am totally satisfied with my courses. They give the flexibility of studying from home by pursuing a career at my own pace.

signsnazzy
Very clear and informative course
wheatweek10
Great study, own pace, actionable feed/bk
andreaweber
Very interesting course

Really worth doing this course it gives a better understanding of autism and the strategies and what the path is to help others to put in place proper plans to suit each individual and there needs and giving them a voice it was tough course but with research and determination I found it interesting glad I completed it. Well worth doing, it takes a lot of hard work and a good attitude to complet...

RiceFlatly
Fantastic and so well set out

I recently brought the veterinary nurse assistant diploma. The course was quickly uploaded into my account, and I started it straight away the sections were set out in a easy to read way and the tests were multiple choice. Once I had finished all the sections I was offered the credited course at a cheaper price which, I took. There were plenty if question and was all essay related. Once I sent ...

johnsa908
Confidence Booster
railsboft
Great that it can be completed in your own time
Cdkc
The best online course I have experienced

I was able to complete the course at my own pace at a time that met my needs. I would and have recommended the course to my friends and I have been able to tell them about my learning experience and how my confidence grew as I progressed through the course.

susans35485
Excellent course and feedback

I have just completed a Reflexology Diploma Course and also took the exam on completion. The course itself was excellent and in particular I liked the test at the end of each lesson. It refreshes your memory of what you have been studying. The Anatomy and Physiology was the hardest part of the course but with plenty of studying it is achievable. The final exam which you pay for if you want to t...

corndexter
Great experience friendly and helpful staff
Morse121
Professional and helpful - 100% would use again!
SHOW MORE
Why you should learn with us - Our Accreditors
  • QLS
  • UKRLP
  • CMA
  • XO