Skip to content

Advanced Microsoft Data Analysis Toolkit

CPD Accredited - The Leading Global Excel Training Platform

Excel with Business

Summary

Price
£299 inc VAT
Or £49.83/mo. for 6 months...
Study method
Online
Duration
65 hours · Self-paced
Qualification
No formal qualification
CPD
65 CPD hours / points
CPD What's this?
Certificates
  • Certificate of completion - Free

Overview

Are you ready to advance your Microsoft Analysis Skills?

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.

This four-course bundle is a combination of our Advanced Excel, Advanced Microsoft Access, Advanced Microsoft VBA and Microsoft Power Bi courses – designed to make you a Microsoft Data pro.

CPD

65 CPD hours / points
Accredited by The CPD Certification Service

Course media

Description

What you get with this Advanced Microsoft Data Analysis Bundle:

  • 4 advanced, skills-based courses to make you a data analysis pro.
  • 259 modules of training, covering the most business-relevant areas of Microsoft Excel.
  • 166+ videos and over 100 downloadable exercises.
  • 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:

Advanced Microsoft Excel:

  • Use advanced graphs in minutes instead of wasting hours trying to figure them out
  • Increase interactivity by automating your spreadsheets with macros and VBA
  • Solve complex problems with superpower functions
  • Turn raw data into ‘must make’ decisions using PivotTables and PowerPivots.
  • And more!

Advanced Microsoft Access:

  • How to effectively link to other data sources.
  • How to split a database by splitting the frontend and backend.
  • To create and maintain macros.
  • The use of Visual Basic for Applications (VBA).
  • Advanced options for the use of forms.
  • Packaging your application for distribution.

Advanced Microsoft VBA:

  • Advanced methods for automating tedious Excel jobs.
  • How to write and implement Excel events.
  • How to modify a variety of standard behaviours, such as double-clicking, opening files and saving files.
  • How to design and implement specialised classes of objects.
  • How to customise the right-click menu within cell ranges.
  • External libraries, and how you can extend VBA’s capabilities beyond standard Excel options.
  • How to modify the Excel user interface, including the “Ribbon” and context menus to interact with your VBA code

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 also CPD Accredited.

Requirements

Advanced Microsoft Excel covers 2013 PC, 2016 PC and 2019/Microsoft 365.
Advanced Microsoft Access covers 2013 PC, 2016 PC and 2019/Microsoft 365.

Questions and answers

No questions or answers found containing ''.

Cheta asked:

Is this course suitable for a beginner Data Analyst and what career opportunities would be available after completion of this course? Thanks

Answer:

Hi Cheta, This is an Advanced bundle so you will need an understanding of MS Access and Excel before starting it. I recommend you try the Microsoft Data Analysis bundle if you are new to Data Analysis. These courses are a great grounding for someone looking to become a Data Analyst or start a career in Data Science.

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

What software is provided/required in this course please?

Answer:

Good afternoon. Thank you for contacting us, Please note we do not provide you with software as this will need to be already installed on your device. You will definitely need to have Excel installed in your device. If you have any additional questions please let us know. Thank you.

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

How long do i get to complete the course and have access to the course material and supporting learning information, is it just 63 days?

Answer:

Good morning. Thank you for contacting us, You will have 12 months to complete the course, The course is 100% online and although we recommend completing on a computer, it is available on any device. Happy learning!

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

Hi , is this course is accredited by CPD or Microsoft ?Do we get certificate with CPD accreditation?

Answer:

Good morning. Thank you for contacting us, At the end of this course, you will receive a certificate of attainment which will be the certificate of completion. This will be CPD accredited. Let me know if you have further questions. Thank you.

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

Do you have to do any test and how do you get certified? Is the certificate inclusive in the price? Thank you.

Answer:

Hi Deb, Certificates are available with each course and yes they are included in the price, no hidden extras! Thanks Adam

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.
Max asked:

Hi, I noticed this is an Advanced course. Do you have a beginner and advanced bundle version of this course that is CPD accredited?

Answer:

Good morning. Thank you for contacting us, Unfortunately, we only have the Advanced Option, You can have a look for further bundles as we have many more available through reed. Let me know if you have further questions. Thank you.

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

I purchased this course 2 days ago but have not received any information email or instructions. Please advise

Answer:

Good afternoon. Thank you for contacting us, I apologise for any issues you have come across, please check your spam as this might arrive to you. If not, please contact support as we will locate your log in details for you. Kind regards,

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

Does the price include a certificate at the end or will there be a further fee for that?

Answer:

Good afternoon. Thank you for contacting us, That is correct, the certificate will be included in the price. There will be no further fees for the course. Please let me know if you have any additional questions so we may assist. Kind regards.

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

Certificates

Certificate of completion

Digital certificate - Included

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