Skip to content

Data Analysis In Excel

CPD Accredited - The Leading Global Excel Training Platform

Excel with Business

Summary

Price
£49 inc VAT
Study method
Online
Duration
2 hours · Self-paced
Access to content
Lifetime access
Qualification
No formal qualification
CPD
2 CPD hours / points
CPD What's this?

Overview

This short course aims to take you from a novice to an expert in under 2 hours!

CPD

2 CPD hours / points
Accredited by The CPD Certification Service

Course media

Description

In a world where we are constantly bombarded with information, making sense of it all can sometimes be difficult and time-consuming. This is particularly true of Excel. Analysing large amounts of data and presenting information that makes sense to your audience is an essential skill for many people.

What you get with this Data Analysis in Excel course:

  • 15 brand new demo videos with professional voiceovers
  • 11 modules with text, that is relevant and easy to understand
  • 10 downloadable exercises
  • Quiz questions in every module
  • Specific objectives and condensed accelerators

In this course you’ll learn:

  • Clean up data ready for analysis
  • Create PivotTables and PivotCharts
  • Lookup information using VLOOKUP, HLOOKUP and INDEX-MATCH
  • Make decisions using IF Statements
  • Highlight information using Conditional Formatting and Rules
  • Build a basic Interactive Dashboard

More about us:

  • We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
  • We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
  • Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
  • Our platform is award-winning and improving all the time.

About the author:

Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).

Who is this course for?

In this short, ten module course we aim to teach you the basic skills you need to analyse data effectively and efficiently. From Pivot Tables and Conditional Formatting to Lookup Formulas and beyond, ‘Excel Data Analysis’ will set you up with a great foundation upon which to build further skills.

Questions and answers

No questions or answers found containing ''.

Bernadette Rawles asked:

Hi, When does the offer expire, and does the course have a deadline to complete? Thank you.

Answer:

Good morning. Thank you for contacting us, Once you have purchased a course from reed you will receive a code which you can use whenever you wish. Once you redeem the code, you will have 12 months to complete the course from the day of redemption. Please let me know if you have further questions so we may assist. Kind regards.

This was helpful. Thank you for your feedback.
Roy asked:

Does the course cover "slicers"?

Answer:

Good afternoon. Thank you for contacting us It will cover different subjects such as: Clean up data ready for analysis Create PivotTables and PivotCharts Lookup information using VLOOKUP, HLOOKUP and INDEX-MATCH Make decisions using IF Statements Highlight information using Conditional Formatting and Rules Build a basic Interactive Dashboard Let us know if you have further questions. Thank you

This was helpful. Thank you for your feedback.
Cathy asked:

will certificate be issued upon completion free of charge

Answer:

Good morning. Thank you for contacting us, Correct! At the end of the course, you will receive a certificate of attainment, which will be the certificate of completion. This will have the modules you have complete and the time you have spent on each of them. Please let us know if you have further questions so we may assist. Thank you.

This was helpful. Thank you for your feedback.
Chelle asked:

Is this course suitable for beginners?

Answer:

Good afternoon. Correct, This will suitable for beginners mainly. Please let us know if you have further questions. thank you

This was helpful. Thank you for your feedback.
Shirley asked:

Do I need to buy a proper desktop to be learn, only have iPad? If I don’t understand online video tutorial, is there anyone able to contact by phone.

Answer:

Good afternoon. Thank you for contacting us, The course is 100% online and although we recommend completing on a computer, it is available on any device as long as you have a good internet connection. If you come across any issues within the course. Please contact support at Excel with Business. They will do their best to help you. Happy learning!

This was helpful. Thank you for your feedback.
Maria Katrina asked:

hi will the certificate be displayed in our reed account? so we can attract employers? thanks

Answer:

Good morning. Thank you for contacting us, Once you have completed the course. Excel with Business will provide you with the certificate of attainment which will be the certificate of completion. Let me know if you have further questions. Thank you.

This was helpful. Thank you for your feedback.
Maria Katrina asked:

will the certificate be displayed here in reed?

Answer:

Good morning. Thank you for contacting us, At the end of your course, you will receive a certificate of attainment which will be a certificate of completion you will need to download from the Excel with Business platform. Let me know if you have further questions. Thank you,

This was helpful. Thank you for your feedback.
Vincent asked:

Hi, I have MS Excel 2007 and keen in learning about developing interactive dashboards. Would I need a newer version of Excel? Will I learn VBA code?

Answer:

Good morning. Thank you for contacting us, This course would not cover so much VBA, I suggest at least, you have a slightly newer version 2013 onwards as the features will be quite similar. Please let me know if you have you have further questions so we may assist. Thank you.

This was helpful. Thank you for your feedback.
Ola asked:

I will like to enroll for this course. Could you please send me the link. Thank you.

Answer:

Hi there! Thank you for contacting us We are unable to send any time of link, please find the topics the course covers. In this course you’ll learn: Clean up data ready for analysis Create PivotTables and PivotCharts Lookup information using VLOOKUP, HLOOKUP and INDEX-MATCH Make decisions using IF Statements Highlight information using Conditional Formatting and Rules Build a basic Interactive Dashboard feel free to contact support if you have any questions. Thank you.

This was helpful. Thank you for your feedback.
Lamia asked:

Hello, May I know how much does it cost? The cours there is practice not just theoretical course Thanks

Answer:

Good morning. Thank you for contacting us, The Cost of this course will be £15. This will include readable exercises, images and videos to follow along, downloadable exercises to work with and quizzes to test your self! Please let me know if you have further questions so we may assist. Thank you.

This was helpful. Thank you for your feedback.
MIRACLE asked:

THIS DATA ANALYSIS CAN IT ALSO BE FOR CHEMICALS, LIKE LABORATORY ATTENTANTS?

Answer:

Good afternoon. Thank you for contacting us, This course its mainly for the user to learn how to manage data in Excel, You can apply what you learn here to your day to day tasks! You will be shown the introduction of the subject and slowly jump to Excel interface, entering and understanding the data, editing, sorting and filtering and much more! Please let me know if you have further questions so we may assist. Thank you.

This was helpful. Thank you for your feedback.
Tom asked:

Is this course suitable for people wanting to work in finance? And does it matter if I am a beginner?

Answer:

Good afternoon. Thank for contacting us, This course is for beginners mainly, It will definitely be a great start to help you with your excel and data manipulation. Let us know if you have further questions so we may assist. Thank you.

This was helpful. Thank you for your feedback.
Robinah asked:

Will you get me a job after this course

Answer:

Good morning. Thank you for contacting us, Please note the course will not guarantee any job placement, This is course is for self-development and self-growth. Let us know if you have further questions. Thank you

This was helpful. Thank you for your feedback.
Hamza asked:

Hi, Is this course design who new in to Data Analysis Foundation start? Will this lead new opportunity job position?

Answer:

Good morning. Thank you for contacting us, The course its a Beginner to Intermediate level. It will be a great start for your learning. It will not guarantee job placement but it will definitely helo built up your CV and advance your knowledge in the subject. Let us know if you have further questions. Thank you.

This was helpful. Thank you for your feedback.
Alice asked:

It is displayed on Reed that this is a CPD certified course and worth two points. Where is the certification of this?

Answer:

Good morning. Thank you for contacting us, At the end of your course, you will receive a certificate of attainment which will be CPD accredited. You will find the certificate on your Excel with Business dashboard once you have completed the course. Please let me know if you have further questions so we may assist. Thank you.

This was helpful. Thank you for your feedback.
Brahim asked:

Is the price covers the exam fee no other fee will be added thank you

Answer:

Good morning. Thank you for contacting us, There will be no extra fees, the test will be included within this price. Let us know if you have further questions so we may assist. Thank you.

This was helpful. Thank you for your feedback.
Brahim asked:

Doese the price cover all fees and there is no other fee to pay thanks

Answer:

Good morning. Thank you for getting in touch. There will not be any additional fees. everything is included within this price. Let us know if you have further questions so we may assist. Thank you.

This was helpful. Thank you for your feedback.
Abhi asked:

how does this course helps in career and in which field plus what are the starting wages.

Answer:

Good morning. Please note this will not be a formal certificate of such as a Diploma or degree after the completion of your course. This will also not guarantee job placements. This course is about improving your skills, its self-taught and personal growth. The Data Analysis In Excel course will give you the tools to learn new skills or simply brush them up! You will need to research the wages and job placement as we do not have accurate information for the above. Thank you.

This was helpful. Thank you for your feedback.
II asked:

Hi, Would we have certificate at the end of the course? Thanks

Answer:

Good morning. Thank you for contacting us, Correct! At the end of your course, you will receive a certificate of attainment, which will be the certificate of completion. This will have the modules you have completed and the time you have spent on each one of them. Please let me know if you have further questions so we may assist. Thank you.

This was helpful. Thank you for your feedback.
Oheneba asked:

Please would a certificate of completion be awarded at the end completing the course?

Answer:

Good morning, Thank you for contacting us, That is correct, At the end of the course, you will receive a certificate of attainment, which will be the certificate of attainment. This will have the modules you have completed and the time you have spent on each one of them. Let us know if you have further questions so we may assist, Thank you

This was helpful. Thank you for your feedback.
David asked:

Is this course suitable for students with a basic knowledge of excel?

Answer:

Good morning. Thank you for contacting us, That is correct, This course will teach you the basics knowledge in Excel. Let me know if you have further questions. Thank you.

This was helpful. Thank you for your feedback.
Slimane asked:

What about the certificat is recognase

Answer:

Good morning. Thank you for contacting us, At the end of your course, you will receive a certificate of attainment which will be the certificate of completion. This is not a formal certificate such as a degree or a diploma. Let me know if you have further questions so we may assist. Thank you.

This was helpful. Thank you for your feedback.
Brahim asked:

Can I use excel 2013 version for this course Thank you

Answer:

Good morning. Thank you for contacting us, Correct, this will be compatible with the 2013 version. Let me know if you have further questions. Thank you.

This was helpful. Thank you for your feedback.
Emma asked:

what excel software is needed for this course?

Answer:

Good afternoon. Thank you for contacting us, I would suggest to have Version 2016 for this particular course! Let us know if you have further questions. Thank you.

This was helpful. Thank you for your feedback.
LUMUMBA asked:

how do i purchase the course and will i get a certificate at the end of the course

Answer:

Good afternoon. Thank you for contacting us, Once you purchased from Reed. You will receive your log in details within 24 hours. Once you have completed the course, You will then receive a certifiate of attainment which will be the certificate of completion. Let me know if you have further questions so we may assist. Kind regards.

This was helpful. Thank you for your feedback.
Ask a question

Reviews

3.3
Course rating
80%
Service
60%
Content
60%
Value

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2024. All rights reserved.