Excel PowerQuery and PowerPivot

CPD QC logo highlighting quality assurance in accredited Continuing Professional Development courses
CPD Member logo showcasing commitment to Continuing Professional Development standards
RoSPA Member logo demonstrating commitment to health and safety excellence.
UKRLP registered learning provider logo indicating accreditation and authenticity for educational courses.

Course Overview:

Course Plus presents the Excel PowerQuery and PowerPivot course, designed for both beginners and experienced users who want to deepen their knowledge of data management within Excel. This course covers essential concepts, including normal pivot table formulas, calculated fields, conditional formatting, and more. You will also learn advanced data processing techniques like importing data from external sources, merging and appending queries, and using PowerPivot for managing complex data models. By exploring PowerQuery’s advanced features and PowerPivot’s capabilities, you’ll be able to analyze large datasets and create sophisticated reports with ease. Enhance your data skills and unlock the full potential of Excel to elevate your career or business. Whether you’re an analyst, business professional, or aspiring data expert, this course will give you the tools to succeed.

Why Enroll in this Course?

Enrolling in this Excel PowerQuery and PowerPivot course will enhance your data analysis and reporting skills, making you more valuable in the workplace. With practical, hands-on learning, you’ll master how to manipulate large datasets and automate complex processes within Excel. The course dives deep into PowerQuery, teaching you to import, merge, and process data from various sources with ease. You’ll also learn PowerPivot techniques that allow you to build data models and create insightful reports. By the end of the course, you will be proficient in using Pivot Tables, Calculated Fields, and Conditional Formatting, empowering you to make data-driven decisions. With real-world applications and tools, this course is the key to advancing your career in data analysis or business intelligence.

Investment Value:

  • Increased Job Marketability: Acquire expertise in Excel’s advanced tools and PowerPivot, making you more competitive in data-driven job roles.
  • Enhanced Data Analysis: Learn how to streamline complex data workflows, improve decision-making, and optimize business processes.
  • Versatile Skills: Mastering PowerQuery and PowerPivot can benefit various industries, including finance, marketing, sales, and operations.
  • Long-Term Learning: Excel skills are vital for a wide range of careers, ensuring the value of this course extends throughout your professional journey.
  • Boosted Productivity: Automate data transformation processes, saving time and increasing efficiency in your daily tasks.

Technical Specifications:

  • Software Required: Microsoft Excel 2016 or later, PowerQuery and PowerPivot Add-ins
  • Format: Online e-learning modules
  • Prerequisites: Basic understanding of Excel, no prior knowledge of PowerQuery or PowerPivot required
  • Level: Beginner to Intermediate

Learning Outcome ​

  • Understand the fundamental concepts of Pivot Tables, including formulas and calculations.
  • Apply sorting and filtering techniques to manipulate Pivot Tables.
  • Use Calculated Items and Fields for custom Pivot Table calculations.
  • Implement Conditional Formatting within Pivot Tables to enhance visual appeal.
  • Consolidate data from multiple sources using Pivot Tables.
  • Import and process various types of data into PowerQuery from different sources.
  • Perform data transformations, including splitting, merging, and conditional calculations.
  • Refresh and update data in PowerQuery to maintain accuracy.
  • Utilize PowerPivot to activate, manage, and use advanced Pivot Table features.
  • Develop custom KPIs, measures, and sets in PowerPivot to create insightful dashboards.

Conclusion

In this Excel PowerQuery and PowerPivot course, learners will gain the technical skills needed to transform and analyze data efficiently using two of Excel’s most powerful features. The course is perfect for professionals aiming to enhance their data analysis capabilities and build advanced Excel reports. By mastering PowerQuery and PowerPivot, you’ll be equipped with the tools to process large amounts of data, perform complex calculations, and make data-driven decisions in any business environment. Whether you’re looking to advance your career or streamline your work processes, this course provides invaluable skills for success.

Next Steps:

  • Register on Course Plus platform
  • Access course materials
  • Join community discussions
  • Earn certification

Course Curriculum

Excel PowerQuery and PowerPivot

  • Normal Pivot Table Formulas
    10:00
  • Sorting and Filtering the Pivot Table
    01:00
  • Calculated Items
    03:00
  • Calculated Fields
    03:00
  • Conditional Formatting in the Pivot Table
    02:00
  • Consolidated Pivot Tables
    04:00
  • Importing data from Excel into PowerQuery – normal data
    09:00
  • Splitting and Merging Columns in the PowerQuery
    05:00
  • Calculate age in the PowerQuery
    03:00
  • Adding Custom Calculations in PowerQuery
    05:00
  • Importing data from a website into the PowerQuery
    04:00
  • Refreshing the data in PowerQuery
    02:00
  • Importing data from Excel into PowerQuery – formatted tables
    04:00
  • Importing Access, SQL Server, and text files into PowerQuery
    06:00
  • Append Queries
    02:00
  • GroupBy Queries
    04:00
  • Merge Queries
    04:00
  • More Calculations including a conditional column in PowerQuery
    09:00
  • Activating PowerPivot
    03:00
  • Exploring the PowerPivot menus
    04:00
  • Starting the Pivot Table from PowerPivot
    05:00
  • Managing Table Relationships
    09:00
  • Slicers and Timelines in PowerPivot
    05:00
  • Using Sets in PowerPivot
    04:00
  • Importing Data directly into the PowerPivot
    04:00
  • Measures and KPI’s in PowerPivot
    10:00

Student Ratings & Reviews

No Review Yet
No Review Yet
£13.99 £65.99
£13.99 £65.99
Team Training
£69.95

A course by

Material Includes

  • 24/7 Support
  • Online e-learning platform
  • Interactive modules
  • Video-based instruction
  • Practical exercises
  • Certification (on demand)
  • Assessment on demand

Requirements

  • Minimum age: 18 years
  • Access to a computer with internet
  • Willingness to learn and engage

Target Audience

  • Professionals in Data Analysis: Looking to enhance Excel data processing skills.
  • Business Intelligence Professionals: Seeking to master PowerQuery and PowerPivot for more efficient reporting.
  • Aspiring Data Analysts: Who want to break into data-driven careers.
  • Excel Enthusiasts: Aimed at anyone wishing to improve their Excel abilities.
  • Financial Analysts: Wanting to streamline and enhance their reporting.
  • Managers: Interested in improving decision-making through better data handling.
Course Plus certificate showcasing CPD QC accreditation, representing achievement in professional development and skill enhancement
Course Plus transcript showcasing course completion details and CPD accreditation
£13.99 £65.99
0
    0
    Your Cart
    Your cart is emptyReturn to Shop
    Scroll to Top
    × Customer Image
    Franklin

    purchased

    Payroll Management Course