Connecting Reports in Excel | Alejandra Horvath

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

Space is limited so reserve your seat.

Contact with Alejandra:

YouTube (English): https://www.youtube.com/channel/UCFYQr-oZbz_90EWcvc-49XA/featured

YouTube (Spanish): https://www.youtube.com/channel/UCJi6z32wB3KIW9XLEmYVEmA/featured

Instagram: https://www.instagram.com/iamalejandrahorvath/

TikTok: https://www.tiktok.com/@alejandrahorvath

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.