Excel 2007 Advanced

Course Details

Course category: Web, IT & Graphics

Location: Online, self-paced, self-assessed

Duration: 12 months

Cost: £199.99

Qualification: Online Academy Certified Diploma

Click on a star below to
rate this course

Be the first to rate this course

Approved course:

About This Course
Do you want to master Excel? Learn how with Excel 2007 Advanced. The course teaches you the ins and outs of all things Microsoft Excel. Excel 2007 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 (2007) but wants to really hone their knowledge and take their spreadsheet skills further. Excel 2007 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 2007 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:
- Consolidate data and use the ‘Goal Seek’ function
- Quickly sort and filter data and group information together with ease
- Create and insert pivot tables in your spreadsheets
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
- Sort, filter, outline and grouping
- Pivot tables
- Understanding conditional logic
- Goal Seek and data consolidation

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

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

johnsa908

Confidence Booster

signsnazzy

Very clear and informative course

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.

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

kernelcapella

Excellent experience

unicornamoeba

Well worth the money!

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

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.

susans35485

Excellent course and feedback

Cdkc

The best online course I have experienced

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

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

Morse121

Professional and helpful - 100% would use again!

andreaweber

Very interesting course

RELATED COURSES

Once you have enrolled on your chosen course above, you will be given an additional 75% OFF voucher which you can use to get another course. You can share it with your friends and family or use it yourself to build your portfolio of qualifications to make your CV stand out. Your code will be given to you once you have enrolled on your first course.

Why you should learn with us - Our Accreditors