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
railsboft
Great that it can be completed in your own time

My Animal Psychology Diploma was a well written and informative course. Easy to follow and complete. Great that it can be completed in your own time, allows for day to day activities to be undertaken and study to fit in when it can.

bbSutton314
Great informative course
Caseycoughlan
The best boost for anyone
johnsa908
Confidence Booster

I was given Criminology for beginners course as a Christmas present, would never have thought of doing it myself but I have enjoyed it so much. It was so easy to do and very hard to put down. It’s like reading a good book then having a test on it. There is no pressure, no tutor hurrying you up and no time limits on the tests, just how learning should be. The written report I received after the ...

corndexter
Great experience friendly and helpful staff

Brilliant learning experience! The staff are incredibly quick to respond to queries! No matter how many questions you have they are more than happy to help. Usually replied within minutes! I did a foot health practitioner course diploma 4. The module is sometimes difficult to understand as it is written in technical terms but nothing that is too difficult to understand. I did the fast track cou...

signsnazzy
Very clear and informative course
Cdkc
The best online course I have experienced
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...

wheatweek10
Great study, own pace, actionable feed/bk

was very impressed, overall the course has good content, easily digestible. I love online studies as you can go as quickly or slowly as you want, online tutors to help answer any questions. I think that the units, could have better quality content, broken into easier formatted module titles. Nice comments returned on improvements and context to think in own life scenarios! They certainly give ...

kernelcapella
Excellent experience
Morse121
Professional and helpful - 100% would use again!
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...

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

unicornamoeba
Well worth the money!
andreaweber
Very interesting course
SHOW MORE
Why you should learn with us - Our Accreditors
  • QLS
  • UKRLP
  • CMA
  • XO