Skip to content
Data Analyst Programme (Data Analysis): Excel Advanced Formulas, Power Query & Power BI cover image

Data Analyst Programme (Data Analysis): Excel Advanced Formulas, Power Query & Power BI
Skill Up

Flash Sale | Level 3,5 CPD & QLS Endorsed | 30 Courses Programme | Free CPD Accredited Certificates | Lifetime Access

Summary

Price
£209 inc VAT
Or £69.67/mo. for 3 months...
Study method
Online
Duration
145 hours · Self-paced
Access to content
Lifetime access
Qualification
No formal qualification
CPD
300 CPD hours / points
Achievement
Certificates
  • 30 CPD Accredited Digital Certificates - Free
  • CPD Accredited Hardcopy Certificate - Free
  • Transcript - Free
  • QLS Endorsed Hardcopy Certificate - £109
Assessment details
  • Multiple Choice Question (MCQ)/Assignment (included in price)
Additional info
  • Tutor is available to students

1 student purchased this course

Add to basket or enquire

Buy with Apple Pay
Buy with Google Pay

Overview

***Exclusive Savings Deal !! 30-in-1 "Level 3,5 Data Analyst (Data Analysis): Excel Advanced Formulas, Power Query & Power BI" - CPD & QLS Endorsed Programme***

Get a wide range of Gifts to excel in your journey

  • 30 Free Digital Certificates (CPD)
  • 1 Free Hardcopy Certificate (CPD)

Excel Advanced Formulas, Power Query & Power BI constitute a powerhouse toolkit for professionals. Their mastery enables streamlined workflows, accurate financial analysis, and data-driven decision-making. Advanced Excel skills, coupled with Power Query and Power BI, transform raw data into actionable insights. In today’s data-centric landscape, proficiency in these tools is paramount for success across various domains

Let's start on a transformative journey with our course, "Data Analyst Programme (Data Analysis): Excel Advanced Formulas, Power Query & Power BI", where the boundaries of your Excel proficiency will be pushed beyond limits. Delve into the intricacies of Excel's advanced formulas, unlock the power of Power Query, and unravel the mysteries of Power BI. As you enter this learning adventure, envision yourself not just as a user but as a master manipulator of data, equipped with the skills to turn raw information into actionable insights.

Throughout this Data Analyst Programme (Data Analysis): Excel Advanced Formulas, Power Query & Power BI, you will harness the prowess of Excel like never before. Learn to command complex formulas with finesse, wield the transformative capabilities of Power Query to streamline data workflows, and master the art of data visualisation through Power BI. Each module is crafted to empower you with exclusive content, examples and projects.

So, if you are also contemplating an outstanding career, then make sure to take your time. Then, join this fantastic Data Analyst Programme (Data Analysis): Excel Advanced Formulas, Power Query & Power BI bundle without any further ado!

This Data Analyst Programme (Data Analysis): Excel Advanced Formulas, Power Query & Power BI Mega Bundle includes the following courses:

Part 01: Data for Business

  • Course 01: Diploma in Data Analysis Fundamentals [QLS Level 5]
  • Course 02: Business Data Analysis
  • Course 03: Sales Analysis in Excel
  • Course 04: Microsoft Excel Training: Depreciation Accounting

Part 02: Powerful Power BI Formulas

  • Course 05: Data Analysis: Power BI Formulas [QLS Level 3]
  • Course 06: MS Access Tables and Queries for Beginners
  • Course 07: MS Excel - Advanced Formulas and Functions
  • Course 08: Advanced Excel: Pivot Table, Pivot Charts, Slicers and Timelines
  • Course 09: Online Microsoft Excel Master Certification Course
  • Course 10: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!
  • Course 11: Link Access Tables to Excel Spreadsheets

Part 03: Data Analysis and MS Excel

  • Course 12: Data Analysis: Getting Results with Power BI
  • Course 13: Data Analytics with Tableau
  • Course 14: Microsoft Excel: PowerQuery and PowerPivot
  • Course 15: Microsoft Excel Complete Training

Part 04: Office Excellence

  • Course 16: Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes!
  • Course 17: Next Level MS Outlook Skills
  • Course 18: Microsoft Word Advanced
  • Course 19: Advanced PowerPoint Training
  • Course 20: Microsoft Access

Part 05: Enhance Your Knowledge

  • Course 21: Cybersecurity: Data Protection and Privacy
  • Course 22: Secretarial, PA & Office Administration Diploma
  • Course 23: Touch Typing Masterclass
  • Course 24: Document Control and Management
  • Course 25: Creative Writing: Content Writing and Copy Writing for SEO and Sales

Additionally, you will be given access to the following career-focused courses:

  • Course 26: Career Development Training
  • Course 27: CV Writing and Interview Tricks
  • Course 28: Ace the Interview – Interview Prep That Makes a Difference
  • Course 29: Ultimate Video Job Interview Training
  • Course 30: Perfect LinkedIn Profile Creation Training

Achievement

Certificates

30 CPD Accredited Digital Certificates

Digital certificate - Included

This Data Analysis (Data Analyst): Excel Advanced Formulas, Power Query & Power BI Mega Bundle comes with FREE CPD Accredited PDF certificates, making this bundle an excellent value for money.

CPD Accredited Hardcopy Certificate

Hard copy certificate - Included

Receive A Free CPD Accredited Hard Copy Certificate! (According to the Learner's Choice)

For additional courses, it costs £19.99 per copy. The delivery fee for the Hard Copy certificate, however, is free for UK residents, whereas it costs £10 for international students as delivery charge.

Transcript

Digital certificate - Included

QLS Endorsed Hardcopy Certificate

Hard copy certificate - £109

For any QLS Endorsed courses included in the bundle, the Level-wise Certificate prices are - (Should be Purchased Separately)

  • Level 1 - £39
  • Level 2 - £69
  • Level 3 - £79
  • Level 4 - £89
  • Level 5 - £109
  • Level 6 - £119
  • Level 7 - £129

However, Certificate delivery is Free for UK residents, whereas it costs £10 for international students as a delivery charge.

Note: Skill-up is a Janets-approved resale partner for Quality Licence Scheme Endorsed courses.

Assessment details

Multiple Choice Question (MCQ)/Assignment

Included in course price

CPD

300 CPD hours / points
Accredited by CPD Quality Standards

Course media

Description

Learning Benefits of Data Analyst Programme (Data Analysis): Excel Advanced Formulas, Power Query & Power BI

  • Embrace your skills and aptitudes
  • Decipher all the jargon of this multifaceted discipline
  • Gain excellent communication and interpersonal skills
  • Broaden your horizon of the technological advancement in this area
  • Manipulate relevant software to accelerate your performance
  • Gain time and risk management skills around your job
  • Adhere to the regulations of your workplace
  • Reinforce your career with specific knowledge of this field
  • Keep yourself up to date with the current situation of this sector
  • Maintain your legal and ethical responsibility as a professional

Mastering Data Analysis (Data Analyst): Excel Advanced Formulas, Power Query & Power BI, a profound proficiency in office skills, enabling unparalleled efficiency and precision in data manipulation. These advanced Excel tools empower professionals to seamlessly analyse and interpret complex datasets, offering a competitive edge in data-driven decision-making. In the realm of data analysis, the synergy of Excel Advanced Formulas, Power Query & Power BI not only streamlines processes but also unlocks the full potential of data exploration, ensuring a strategic advantage in today's dynamic business landscape.

_____________________________________________________________________________________________

Our Learner's Top Reviews:

  • Nagina Firdose - “Studying and learning with Skill Up has sincerely been an amazing and valuable experience for me.”
  • Ma Katrina Q Diomampo- “Affordable Course with freebies subject that is very useful. Course are straight forward and relevant and modules are easy to navigate.”
  • Michael - “It's a top notch company with a well thought out course that delivers with top of the line customer care representative.”

Over 100+ glowing reviews.

_____________________________________________________________________________________________

Assessment

After completing all the modules of the Data Analyst Programme (Data Analysis): Excel Advanced Formulas, Power Query & Power BI courses, your learning will be assessed by an assignment or multiple-choice-based exam. In addition, you may choose to participate in a Mock Exam before attending all the courses and completing the Final Exam at no extra cost.

Certificate of Achievement: Quality Licence Scheme Endorsed Certificate

Upon completing the final assessment of the course, you can apply for the Quality Licence Scheme Endorsed Certificate of Achievement. Endorsed certificates can be ordered and delivered to your home.

  1. Diploma in Data Analysis Fundamentals at QLS Level 5 Certificate = £79
  2. Data Analysis: Power BI Formulas at QLS Level 3 Certificate = £109

However, the certificate delivery fee is free for UK residents, whereas it costs £10 for international students as a delivery charge.

Who is this course for?

If you want to keep yourself afloat in a related field or further assess your learning, this Data Analyst Programme (Data Analysis): Excel Advanced Formulas, Power Query & Power BI bundle is for you. Enthusiasts who want to explore this discipline are also eligible for this bundle.

Certainly, this Data Analyst Programme (Data Analysis): Excel Advanced Formulas, Power Query & Power BI course does not lead you to any professional certification or qualification, but can help you enhance your knowledge.

Some professional certification courses promoted by Microsoft

  • Microsoft Certified: Data Analyst Associate: This certification validates your skills in data analysis using tools like Power Query, Power BI, and Excel. It covers data visualisation, reporting, and transforming raw data into meaningful insights.
  • Microsoft Power BI Data Analyst: This course focuses on accurate data analysis using Power BI. It’s ideal for data professionals and business intelligence experts. Upon completion, you’ll be well-prepared for the certification exam.
  • Microsoft 365 Fundamentals: This course covers the basics of Microsoft 365, including Excel, Word, and other Office applications. It’s a great starting point for anyone looking to enhance their Office skills.
  • Microsoft Azure Data Engineering Associate (DP-203): If you’re interested in cloud-based data engineering, this certification course is worth exploring. It covers data storage, processing, and analytics using Azure services.
  • Microsoft Azure Fundamentals AZ-900 Exam Prep: While not specific to Office, this course provides foundational knowledge about Azure cloud services, which can be valuable for data professionals.

Requirements

Since no prior knowledge or experience is required.

Take your time to finish this Data Analyst Programme (Data Analysis): Excel Advanced Formulas, Power Query & Power BI, and there is no deadline.

Career path

Data Analyst Programme (Data Analysis): Excel Advanced Formulas, Power Query & Power BI

  • Financial Analyst: £40,000 to £60,000 per year
  • Data Analyst: £30,000 to £50,000 annually
  • Business Intelligence (BI) Developer: £40,000 to £70,000 per year
  • Supply Chain Analyst: £30,000 to £45,000 per year
  • Project Manager: £45,000 to £65,000 annually

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

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

FAQs

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 2025. All rights reserved.