Excel Power Query PDQ!

Stringfest Analytics

1 hour to Power Query in Excel (PDQ = Pretty Darn Quick!)

<h3>It&#x27;s the most exciting Excel development in a generation... but you&#x27;d be forgiven for not knowing about it! </h3><h2>Recording &amp; downloads</h2><ul><li>A recording will be made available after the event. I&#x27;ll keep it up for one week. </li><li>All files used in the session will be shared at the time of the event.</li></ul><h2>Overview</h2><p>This free one-hour workshop will serve as an introduction to Power Query in Excel:</p><ul><li>How tables serve as the &quot;missing link&quot; between Excel and Power Query</li><li>How Power Query serves as an &quot;extract, transform, load&quot; tool</li><li>How to load your first data sources into Power Query... including <em>how to find the menu for this </em>(not so easy!)</li><li>How to explore and profile your data right from Power Query</li><li>How to perform repeatable data cleaning operations... <strong>no code or formulas required. </strong></li></ul><h2>Who this is for</h2><p>Anyone who wants to end poorly-designed Excel workbooks once and for all and make the most of their data! Typical job titles might include:</p><ul><li>Data analysts</li><li>Financial analysts</li><li>Marketing coordinators</li><li>Accountants</li><li>Controllers</li><li>Operations analysts</li></ul><h2>Prerequisites</h2><ul><li>Please have Excel 2016 or greater or an up-to-date version of 365 for desktop installed prior to the workshop. <a href="https://support.microsoft.com/en-us/office/about-power-query-in-excel-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">Power Query is currently available on these versions of Excel.</a></li><li>To make the most of the workshop, you will have some experience in topics such as taking sums and counts, creating calculated columns, and using relative and absolute references in Excel. </li><li>It is recommended to attend this workshop on a Windows machine</li><li>No other preparation is needed. The workshop materials will be shared with you at the time of the event.</li></ul><h2>About your instructor</h2><p>George Mount is the founder of Stringfest Analytics. He has over 10 years of experience in data analytics and holds master’s degrees in both finance and information systems from Case Western Reserve University. George is widely recognized an expert in the fields of data analysis and Microsoft Excel and is the author of <em>Advancing into Analytics: From Excel to Python and R</em> (O’Reilly Media, 2021). </p><p>George has extensive experience in reporting, analytics, and modeling and is a respected trainer in these fields. He provides training for companies throughout North America and beyond.</p><h2></h2><p>I look forward to seeing you at the event!</p><p>If your team is looking for a one-day overview of Power Query in Excel, <a href="https://stringfestanalytics.com/click-and-clean-pq-workshop/" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">please get in touch for corporate training.</a></p><p></p>

Modern Excel Magic in a Week

AI for Excel Demo Day

Modern Excel Demo Day: America 250 Edition

Modern Excel Demo Day

Python for Excel in a Week

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Excel Power Query PDQ!

More events from Stringfest Analytics

Discover more events from Stringfest Analytics, from Science & Tech to other experiences you might love.

Modern Excel Magic in a Week

AI for Excel Demo Day

Modern Excel Demo Day: America 250 Edition

Modern Excel Demo Day

Python for Excel in a Week

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.

Excel Power Query PDQ!

More events from Stringfest Analytics

Discover more events from Stringfest Analytics, from Science & Tech to other experiences you might love.

Modern Excel Magic in a Week

AI for Excel Demo Day

Modern Excel Demo Day: America 250 Edition

Modern Excel Demo Day

Python for Excel in a Week

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.