Skip to content

Microsoft Data Analysis Toolkit

CPD Accredited - The Leading Global Excel Training Platform

Excel with Business

Summary

Price
£236 inc VAT
Or £78.67/mo. for 3 months...
Study method
Online
Duration
65 hours · Self-paced
Qualification
No formal qualification
CPD
65 CPD hours / points
CPD What's this?

Overview

If you’re ready to solve complex problems using Excel, take control of your database using Microsoft Access, create compelling visualizations and reports of your data using Microsoft Power BI and automate data tasks with VBA, this four-course bundle is for you!

Our Microsoft Excel course now also offers a BRAND NEW 2019 VERSION.

CPD

65 CPD hours / points
Accredited by The CPD Certification Service

Course media

Description

Are you ready to raise your earning potential?

Microsoft still reigns supreme in the world of data analysis. Knowing how to use these tools to extract meaningful business decisions from data could be the difference between business or career success and failure.

What you get with this Microsoft Data Analysis Bundle:

  • 4 skills based, practical business courses to help accelerate your career.
  • 350+ modules of training, covering the most business-relevant areas of Microsoft Excel and Business Management.
  • Tailored learning. If you have some knowledge, you can use the filter to show only what you most need to learn.
  • Multiple videos, practice exercises and test questions to aid your learning.
  • Knowledge to understand the data that drives your business.

The courses this bundle will cover:

Microsoft Excel:

  • How Excel works, how to navigate and design a spreadsheet
  • The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF
  • To use PivotTables, Pivot Charts and Basic Macros
  • To create beautiful looking graphs and charts
  • Formatting, including; conditional, cell and number formatting
  • How to print what you want

Microsoft VBA:

  • To automate tasks and operations that you perform frequently.
  • How to define and manage variables, set up subroutines, and create functions.
  • How to use input boxes and message boxes to interact with end users.
  • Practical methods for using macro errors to improve your VBA code.
  • About the PivotTable object and basic approaches to utilizing it.
  • What variables are, and how they relate to functions versus methods and subroutines.
  • To create cross-functional flowcharts

Microsoft Access:

  • How to set-up a database—on your desktop, or on the web.
  • How to add records, and save and delete data.
  • To explore the Ribbon interface and how to work with touch devices.
  • To use table templates to create forms and add custom elements.
  • To sort data and run queries.
  • Macros and how they work.
  • How to import data from external sources.

Microsoft Power BI:

  • How to use the Query Editor to transform and morph data into the right format for your reporting purposes.
  • How to perform complex data modelling operations using relationships, calculated columns, measures, and DAX expressions.
  • How to share dashboards and reports, with colleagues, business partners and potential clients.
  • How to use Power BI’s sophisticated security features to control the exact content your audience can view.
  • How to use Power BI Desktop, Service and Mobile Apps
  • How to connect with a variety of data sources

More about us:

  • We have nearly a million students
  • Our training is personal. Use the filter to show you which parts of the course to skip.
  • Our platform is award-winning and always improving. We work with our authors to ensure our courses are up to date.
  • All of our courses are certificated on completion – most of our Business Courses are alsoCPD Accredited.

Requirements

Microsoft Excel is available in versions: 2003 PC, 2007 PC, 2010 PC, 2016 PC, 2013 PC, 2019 PC, 2011 MAC, 2016 MAC

Microsoft Access is available in versions: 2013 & 2016

Questions and answers

No questions or answers found containing ''.

Des McQuilkin asked:

Please sent login details again, i may have deleted the email by mistake.

Answer:

Good morning. Thank you for contacting us, Please send us the email address so we may send you your log in details again. Thank you.

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

Is there a time limit on the course

Answer:

Good morning. Thank you for contacting us, You will have 12 months to complete the course. You may go back and forth as many time you wish during your time. with us. Please let me know if you have further questions so we may assist. Kind regards.

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

I'm an HR Data Analyst and I have lot of experience with excel but not so much with access or power BI. Is this course suitable for me?

Answer:

Good afternoon. Thank you for contacting us. This bundle has different courses, including Power BI. This will take you from a beginner to an intermediate level. This will you insights and lost of practise with the Power BI tool. Let us know if you have further questions. Thank you

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

Can we access the material and videos after 1 year or will they be locked and our account deleted?

Answer:

Good afternoon. Thank you for contacting us You will have 12 months to complete the course, unfortunately, you will not have access to the course after 12 months. your account will be active, however, the content will not be available. Please let me know if you have further questions. Thank you.

This was helpful. Thank you for your feedback.
Eric Hall asked:

Is it possible to use Access 2010 for the course?

Answer:

Good morning. Thank you for contacting us. I am afraid we only have 2013 and 2016 version for the Access course. 2010 will not be compatible with the course. Let us know if you have further questions so we may assist. Thank you.

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

Can videos of lessons and material be downloaded?

Answer:

Good morning. 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. Videos and other course material are subject to copyright and can therefore not be downloaded nor distributed. Happy learning!

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

Can i complete the course on multiple devices (e.g. two laptops)?

Answer:

Good morning Thank you for contacting us, That is correct! You may use different devices to complete the course, as long you have an internet connection the platform should be working correctly. Thank you.

This was helpful. Thank you for your feedback.
Desmond McQuilkin asked:

Hi i purchased this course yesterday evening, can you send the confirmation email again please, many thanks, Des.

Answer:

Good morning. Thank you for contacting us, I believe we have already sent you the log in instructions, please have a look in your spam as it might arrive there! Let us know if you have further questions so we may assist. Thank you.

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

Does it come with a certificate and what would be the title on the certificate?

Answer:

Good afternoon. 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 which will be CPD accredited. Let me know if you have further questions so we may assist. Thank you.

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

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

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