Skip to content

Details

Speakers: Oz du Soleil and Cristian Angyal
Start Date: Fri, Apr 28th · 07:00 PM EEST ( 16:00 UTC)
Language: English
Location: Online (link visible for attendees)

===================================================

Description:

Join April 2023 User Group session to explore the versatility of Excel through two distinct solutions to a common problem, using Dynamic Arrays and Power Query.

Learn the advantages and limitations of each approach, and understand how having diverse Excel skills can improve your problem-solving capabilities.

Additionally, we'll briefly discuss the integration of Power Query in Power BI and how, depending on requirements, data can be viewed directly in Excel, Power BI, or within Excel using Power BI's "Analyze in Excel" feature.

Don't miss this chance to expand your toolkit and create adaptable, efficient solutions in Excel and beyond.

===================================================
Speakers:
Oz du Soleil,
Microsoft MVP

Oz du Soleil is an Excel developer, trainer, videographer, author, raconteur, LinkedIn instructor, and Microsoft Excel MVP.
He’s known for his brash, dramatic YouTube videos at Excel On Fire where Oz goes beyond Excel tips-&-tricks and brings you the real world why, how, and when so that users get the most from their data and Excel. Oz is a US Navy veteran and lives in Portland Oregon.
Fun fact: Oz is in a documentary about sriracha hot sauce.

LinkedIn : https://www.linkedin.com/in/ozdata/
YouTube: https://www.youtube.com/c/OzduSoleilDATA
Website: https://ozdusoleil.com/
Twitter: https://twitter.com/OzExcel
LinkedIn Instructor: https://www.linkedin.com/learning/instructors/oz-du-soleil

Cristian Angyal,
Microsoft MVP

Cristian describes himself as a “Project Management Professional turned into a Data Guy”, working as a link between two worlds: Business and IT. Having worked for the last 15+ years with data in different roles in several industries, he was fascinated when he discovered Power Query and Power Pivot back in 2014 and then, Power BI in 2015. Ever since he learned about the Power Tools, he realized that these tools, with the ability to “learn them once and used them in both places, Excel and PBI”, could make a huge difference in the way Data is managed inside organizations.

Find more about Cristian's work and connect with him:

Related topics

Business Analytics
Data Visualization
Power BI
Data Management
Microsoft Excel

Sponsors

ENTERPRISE DNA

ENTERPRISE DNA

Learn Faster with proven, personalized training pathways

ETA2U

ETA2U

Cel mai complex portofoliu de cursuri IT din Romania

You may also like