Name: Connecting Reports in Excel | Alejandra Horvath
Start: 2022-09-30T21:00:00+04:00
End: 2022-09-30T22:30:00+04:00

**Connecting Reports in Excel** -
The importance of building a reliable source of data with Power Query

In this session, Alejandra will present an example on how useful and efficient is to connect more than one report to a single source of data, yes… with power query.
• What is Power Query? – Brief explanation
• Benefits of connecting several reports to a single/specific source of data
• What a function in power query is, and why we will build one in our example
• Demo
– Building the query that will transform non-identical files
– Creating a couple of reports in Excel using a single source of data
– Adding new information to the source
– Updating all our reports with the new information

**Agenda:**

* Introductions (5 mins)
* Presentation (55 mins)
* Q&A session (15 mins)

**About Alejandra Horvath:**

Alejandra Horvath is a Chartered Professional Accountant in Canada, certified Microsoft Excel expert, and working with excel for over 20 years.
Extensive experience empowering organizations and individuals to excel in minimizing the time entering data, automating reports, finding efficiencies, and providing training to optimize existing resources, such as excel and google sheets.

This event is online. You may need to install Zoom: [https://zoom.us/download](https://zoom.us/download)

Space is limited so reserve your seat.

**Contact with Alejandra:**

YouTube (English): [https://www.youtube.com/channel/UCFYQr-oZbz_90EWcvc-49XA/featured](https://www.linkedin.com/safety/go?url=https%3A%2F%2Fwww.youtube.com%2Fchannel%2FUCFYQr-oZbz_90EWcvc-49XA%2Ffeatured&trk=flagship-messaging-web&messageThreadUrn=urn%3Ali%3AmessagingThread%3A2-MGZjZTBiYzQtYzRhZi00NjJiLTljY2YtNzU3MDA0ZWE2MzU5XzAxMw%3D%3D&lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base%3BWrjvSmutSuKvfO6Z7fH85g%3D%3D)

YouTube (Spanish): [https://www.youtube.com/channel/UCJi6z32wB3KIW9XLEmYVEmA/featured](https://www.linkedin.com/safety/go?url=https%3A%2F%2Fwww.youtube.com%2Fchannel%2FUCJi6z32wB3KIW9XLEmYVEmA%2Ffeatured&trk=flagship-messaging-web&messageThreadUrn=urn%3Ali%3AmessagingThread%3A2-MGZjZTBiYzQtYzRhZi00NjJiLTljY2YtNzU3MDA0ZWE2MzU5XzAxMw%3D%3D&lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base%3BWrjvSmutSuKvfO6Z7fH85g%3D%3D)

Instagram: [https://www.instagram.com/iamalejandrahorvath/](https://www.linkedin.com/safety/go?url=https%3A%2F%2Fwww.instagram.com%2Fiamalejandrahorvath%2F&trk=flagship-messaging-web&messageThreadUrn=urn%3Ali%3AmessagingThread%3A2-MGZjZTBiYzQtYzRhZi00NjJiLTljY2YtNzU3MDA0ZWE2MzU5XzAxMw%3D%3D&lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base%3BWrjvSmutSuKvfO6Z7fH85g%3D%3D)
TikTok: [https://www.tiktok.com/@alejandrahorvath](https://www.linkedin.com/safety/go?url=https%3A%2F%2Fwww.tiktok.com%2F%40alejandrahorvath&trk=flagship-messaging-web&messageThreadUrn=urn%3Ali%3AmessagingThread%3A2-MGZjZTBiYzQtYzRhZi00NjJiLTljY2YtNzU3MDA0ZWE2MzU5XzAxMw%3D%3D&lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base%3BWrjvSmutSuKvfO6Z7fH85g%3D%3D)

LinkedIn: https://www.linkedin.com/in/alejandrahorvath/

Members participating in Meetup Live events must be respectful in interactions with people and in content posted on the platform.

Ilgar Zarbaliyev

Azerbaijan Power BI & Microsoft Fabric Community

Microsoft Fabric User Group Network

Technology

Power BI

Data Analytics

Data Science

Big Data

Data Management

Data Mining

Microsoft Excel

Microsoft Power Platform

Microsoft Azure

Dashboards

Data Integration

Power Query

Data Visualization

Business Intelligence

Connecting Reports in Excel | Alejandra Horvath

DAX Power BI

Power Pivot

Online event

Share

Azerbaijan Power BI & Microsoft Fabric Community

Connecting Reports in Excel | Alejandra Horvath

Azerbaijan Power BI & Microsoft Fabric Community

Details

Members are also interested in