Are your employees not working efficiently? Get them this workshop and make them efficient. That’s much more effective and cheaper than just complaining, or making them work more hours. Save lots of money by working smarter, not harder. Are you working with lots and lots of data? Do people never fill in the correct data, and now you are left with a whole bunch of sheets that need cleanup? In this workshop we teach you how to analyse data with Excel and the built-in Power Query. The first step is always cleaning up the data: getting rid of errors. If you have intermediate Excel experience, and work with data a lot, this workshop will be perfect for you.
Register now at https://bit.ly/bk-power-query
Workshop of 3 hours full of interesting material includes:
- What you should know
- Getting Data with Power Query
- Getting data from another file
- Getting data from an open workbook
- Quiz
- Cleaning and Transforming Data with Power Query
- Common cleaning tasks
- Filtering and sorting data
- Splitting columns
- Conditional columns
- Quiz
If you have any questions feel free to contact us