Course description
VBA & Power Query
What is VBA?
Macros can automate just about any task – like generating customised charts and reports or tidying up data and improving data input using Forms.
Aimed at experienced users of Microsoft Office, this course will look to transform your skills to an advanced level and learn how to confidential create and edit Macros using VBA coding. We can offer a 2 day course on this.
====
If you only need Macros to tidy up data, then we will be showing a lower level of this course and offering a 1 day course on VBA and how to record and edit Macros and Forms and 1 day on Power Query.
What is Power Query?
Excel users can spend up to 80 percent of their time on data preparation. Each week or daily people download data and then tidy it up. By using Power Query you will learn how to seamlessly access data stored in various sources, connect them and reshape the data in it to transform ready for analysis. Power Query will remember the steps you have used and allow you to reuse these without the need for VBA coding.
Learn how to setup connections to various data sources
Pre-process data by cleaning up data using, adding columns, calculations, filtering, sorting and changing order
Present the data in Excel or Export the data Power BI
Course Dates (Cohorts) for this are as follows:
Cohort 10 - 27 & 28 September (Online)
Cohort 12 - 19 & 20 October (Online)
Cohort 14 - 23 & 24 November (Online)
Cohort 16 - 13 & 14 December (Online)
Suitability - Who should attend?
This is truly an exceptional opportunity to access high quality, high demand training which has been created due to the demand and needs of our area, eligibility for this training is as follows:
Eligibility for the ‘Be More’ Funding is:
✔ Age 16 and onwards
✔ Located in the Liverpool City Region
✔ Haven’t attended another ‘Be More’ Course prior to the start of our programme
Why choose SquareOne Training
25 years' experience of delivering quality IT Training Services
All trainers Certified Microsoft Office Trainer (MOS) or higher
Public and in-house training throughout the UK
Request info
SquareOne Training
With 30 years of experience in IT training, personal skills, and consultancy, SquareOne specialise in crafting and delivering exceptional industry leading training courses. Our extensive range of courses are tailored to cater to a diverse range of learning preferences and...
Case Studies
SquareOne Deliver IT Rollout Projects to a World Leading Gas and Oil Company
Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.
Excel Templates For Mexichem
At SquareOne Training we take pride in designing Spreadsheets for our customers, so we were delighted to be asked to design a solution to track staff courses and KPI alerts. This spreadsheet was implemented in 2018, but completely changed the way the company worked and made the data not only accurate but trackable.