Skip Main Navigation
Eventbrite
Browse Events
Organize
Help
Log InSign Up
Menu
Page Content
This event has ended.
Excel Power Query and PowerPivot

Actions Panel

Dec 08

Excel Power Query and PowerPivot

Excel Power Query and PowerPivot

By Audiopence

When and where

Date and time

Thu, December 8, 2022, 1:00 PM – 2:00 PM EST

Location

Online

Refund Policy

Contact the organizer to request a refund.

About this event

Description

These days, there are tons of data coming in from many sources. You are expected to import all of that data, and then get meaningful results from that data.

What you'll learn?

  • Importing data from Excel into PowerQuery – normal data
  • Splitting & Merging Columns in the PowerQuery
  • Calculate age in the PowerQuery
  • Adding Custom Calculations in PowerQuery
  • Importing data from a website into the PowerQuery
  • Refreshing the data in PowerQuery
  • Importing data from Excel into PowerQuery – formatted tables
  • Importing Access, SQL Server, and text files into PowerQuery
  • Append Queries
  • GroupBy Queries
  • More Calculations including a conditional column in PowerQuery
  • Activating PowerPivot
  • Exploring the PowerPivot menus
  • Starting the Pivot Table from PowerPivot
  • Managing Table Relationships
  • Slicers & Timelines in PowerPivot
  • Using Sets in PowerPivot
  • Importing Data directly into the PowerPivot
  • Measures & KPIs in PowerPivot

Who should attend?

  • Business owners
  • CEO’s / CFO’s / CTO’s
  • Managers of all levels
  • Anybody who uses SQL on a regular basis, and want to be more efficient and productive
  • Administrators
  • Salespeople
  • Trainers
  • Bankers

Why should you attend?

These days, there are tons of data coming in from many sources. You are expected to import all of that data, and then get meaningful results from that data.

This course will help you do that.

Tags

  • Online Events
  • Online Classes
  • Online Other Classes
  • #excel
  • #powerpivot
  • #excel_course
  • #excel_training
  • #excel_online_course
  • #excel_vba_training
Event ended

Excel Power Query and PowerPivot


Follow this organizer to stay informed on future events

Audiopence

Event creator

Events you might like

  • Excel PowerPivot and Power Query

    Excel PowerPivot and Power Query
    Excel PowerPivot and Power Query

    Tue, Feb 14, 2023 1:00 PM EST (-05:00)
    $189
  • Level Up Series: Power Query for Power BI  - February

    Level Up Series: Power Query for Power BI - February
    Level Up Series: Power Query for Power BI - February

    Thu, Feb 16, 2023 8:00 AM CST (-06:00)
    $599
  • Power BI  Query Editor and Dax Calculations, 2-Day Course, Live Online.

    Power BI Query Editor and Dax Calculations, 2-Day Course, Live Online.
    Power BI Query Editor and Dax Calculations, 2-Day Course, Live Online.

    Tue, Feb 21, 2023 10:00 AM GMT (+00:00)
    £580
  • Formation en ligne | Power BI : Power Query

    Formation en ligne | Power BI : Power Query
    Formation en ligne | Power BI : Power Query

    Tue, Feb 7, 2023 9:00 AM EST (-05:00)
    CA$413.93
  • Mastering Excel Pivot Tables

    Mastering Excel Pivot Tables
    Mastering Excel Pivot Tables

    Wed, Feb 15, 2023 1:00 PM EST (-05:00)
    $189
  • Power BI Center of Excellence Meetup

    Power BI Center of Excellence Meetup
    Power BI Center of Excellence Meetup

    Mon, Feb 6, 2023 7:30 PM CST (-06:00)
    Free
  • Mastering Excel Pivot Tables & Pivot Charts: Number Crunching Made Easy

    Mastering Excel Pivot Tables & Pivot Charts: Number Crunching Made Easy
    Mastering Excel Pivot Tables & Pivot Charts: Number Crunching Made Easy

    Tue, Feb 7, 2023 1:00 PM EST (-05:00)
    $189
  • Microsoft: Excel Advanced (Online Training)

    Microsoft: Excel Advanced (Online Training)
    Microsoft: Excel Advanced (Online Training)

    Wed, Feb 15, 2023 9:30 AM GMT (+00:00)
    £281.75
  • Microsoft PowerPoint: Essentials (Online Training)

    Microsoft PowerPoint: Essentials (Online Training)
    Microsoft PowerPoint: Essentials (Online Training)

    Tue, Feb 7, 2023 9:30 AM GMT (+00:00)
    £268.97
  • Microsoft PowerPoint: Advanced (Online Training)

    Microsoft PowerPoint: Advanced (Online Training)
    Microsoft PowerPoint: Advanced (Online Training)

    Fri, Feb 17, 2023 9:30 AM GMT (+00:00)
    £281.75

Site Navigation

Use Eventbrite

  • Create Events
  • Pricing
  • Eventbrite Boost
  • Eventbrite Mobile Ticket App
  • Eventbrite Check-In App
  • Eventbrite App Marketplace
  • Event Registration Software
  • Content Standards
  • FAQs
  • Sitemap

Plan events

  • Sell Tickets Online
  • Event Planning
  • Sell Concert Tickets Online
  • Event Payment System
  • Solutions for Professional Services
  • Event Management Software
  • Community Engagement
  • Virtual Events Platform
  • QR Codes for Event Check-In
  • Post your event online

Find events

  • Browse Online Events
  • Get the Eventbrite App

Connect with us

  • Report This Event
  • Help Center
  • Terms
  • Privacy
  • CA Privacy Notice
  • Accessibility
  • Community Guidelines
Eventbrite + Ticketfly

© 2023 Eventbrite