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

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

    On completion of your course you will also be able to have your certificate endorsed and accredited by the CPD Certification Service for recognised CPD Hours.

    The CPD Certification Service was established in 1996 as the leading independent CPD accreditation institution operating across industry sectors to complement the Continuing Professional Development policies of professional institutes and academic bodies. The CPD Certification Service provides recognised independent CPD accreditation of our courses.

     

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

railsboft
Great that it can be completed in your own time
wheatweek10
Great study, own pace, actionable feed/bk
Caseycoughlan
The best boost for anyone

thoroughly enjoyed this course. There was no rush and I could take it at my own time. I am visually impaired and this has boosted my confidence immensely. I had no trouble with any of the modules. Mostly it was my not reading the question properly, so that is why I made the mistake I did. Thank you for the chance to prove myself as a person in my own right. When people know you have a disabilit...

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

Cdkc
The best online course I have experienced
unicornamoeba
Well worth the money!
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 ...

Morse121
Professional and helpful - 100% would use again!
bbSutton314
Great informative 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...

signsnazzy
Very clear and informative course

I was very pleased to undertake this course. It has motivated me to learn more about psychology. The assessments were at the right level and the final exam had useful feedback which I benefited from. The material throughout is presented clearly.

kernelcapella
Excellent experience
johnsa908
Confidence Booster
SHOW MORE
Why you should learn with us - Our Accreditors
  • CPD
  • UKRLP
  • CMA
  • XO