INHOUSE Workshop Automated dashboards using Power Query 1
- LIVE ONLINE EXCEL workshop for your team
- 3 hours with Power Query
- learn how to import and transform data + create simple automated dashboards using Power Query
- meet smarter brother of EXCEL (not just) for automated dashboards
- solving of hands-on problems
- active engagement of participants
*it is a necessary, to order the workshop at least 4 weeks before the desired start date
What will you learn on the workshop – Automated dashboards using Power Query 1?
Workshop MS EXCEL Automated dashboards using Power Query 1 is designed for advanced EXCEL users, who already worked with pivot tables, charts and dashboards, and who want to learn how to automate repetitive creation of dashboards using Power Query. Coding skills are not necessary.
This workshop will show you:
How to understand the layout, naming and purpose of functionalities in the interface of Power Query?
How to connect to the data from different sources (EXCEL table, another EXCEL worksheet, .txt or .csv file, several files from one folder)?
How to use the connection to create simple automated dashboards, that can be updated within few seconds?
Basic orientation in the interface of Power Query (PQ)
- How to understand the difference between the Transform Tab and the Add Column Tab
- How does the query recording work and where to find recorded queries
- How to show Formula Bar in PQ to observe and make basic changes directly in the M language
- How to use EXCEL table as source of data for PQ
- How to connect to another EXCEL workbook (e.g. alarge one) and use it as a source of data for easier processing
- How to import file in text format (.txt or .csv) and use it as source of data
- How to import several files of the same type and structure – Import from Folder
Basic data transformation of data using Power Query (PQ)
- How to set up data types properly
- How to split data to columns using several conditions
- How to decide which type of import is the best for your use case – Import to the Table, PivotTable report, PivotChart, or Only create connection
Creation and refresh of the simple dashboards
- How to create simple dashboard from data imported to the PivotTable report and PivotChart
- How to refresh your report in few seconds
How do I lead the workshop?
I lead the workshop ONLINE LIVE, via Zoom (in case your company prefers different meeting app, let me know on info@love2teach.sk). The training lasts 3 hours and it’s split into two 90 minutes blocks, to maximize participants attention. I strongly prefer that your employees work together with me during the sessions on their computers. In this way they can work on the assignments on their own and ask me the questions directly.
What do you need for the workshop?
- reliable internet connection
- installed version of MS EXCEL. I lead workshops with the version MS Office 365, but the participants could use older/other versions. In case you are not sure about the EXCEL version, contact me on info@love2teach.sk
Communication with the participants during the workshop could be led via chat. In case you prefer live QnA, make sure that your employees will have microphones.
Are you interested in cooperation?
Contact me on info@love2teach.sk. Looking forward to EXCEL with you!
Recommendations from my clients
Colleagues approached me with a request to find training aimed at strengthening their Excel skills. Choosing a suitable lecturer, given the variety of activities and responsibilities, seemed at first glance like a real nut. The priority requirement was that the training was practical, effective and useful for all participants. And that’s exactly what he was. The participants highly appreciated the professional (but humane) and especially proactive approach of the lecturer. Veronika tailored the entire program and worked with real requirements, expectations and also data from colleagues. I give NPS: 10 points! Monika V.
Veronika is a very skilled and experienced lecturer with a pro-client approach. We chose her as a lecturer for a two-day Excel course in our company. She created a pleasant atmosphere at the training and even though she was training a group, she maintained an individual approach to everyone who had questions. It is important to her that the client really understands the topic she is training and that he takes away from the training not only high-quality information, but also a good feeling. We were very satisfied and recommend it to anyone who wants to improve in Excel. Ivana D.
I had the opportunity to get to know Veronika as part of the Excel training that she led in our company. The training was perfectly adapted to groups, it was interactive and we learned a lot. Veronika is an empathetic, kind lecturer and we will definitely arrange further training sessions. Nikola B.
Veronika and I met only recently, when we compiled and organized several Excel trainings for our Martinu students. All the time, I communicate very well with Veronika, she exudes not only humanity, but also enormous professionalism. Although I did not personally experience the training, I heard a lot of praise from colleagues for her teaching skills and overall approach. However, the biggest compliment for me is the fact that she fired up colleagues about Excel, its ins and outs, regardless of level. It can be seen that they sincerely enjoy using it. Andrea K.
To see more recommendations, check my LinkedIn profile.
Who will teach you?
Mgr. Veronika Baláž
„I graduated as a teacher of mathematics and physics at the University of mathematics, physics and informatics in Bratislava. Although I love teaching, after my studies I started to work in the multinational corporations. I was gaining hands-on experience in various positions, for eight years. This period brought me a lot of practical knowledge in Excel, VBA and SQL programming and Power Query.
After a half-year sabbatical, I started to teach again, this time as a freelancer. Two years later I founded my own company – Love2teach s.r.o., where I help employees to grow in MS EXCEL and Power Query.“
Contact me on: