We’ve added some new training materials in the Advanced Excel course relating to getting and transforming data and using the Power Query. It’s very relevant in our current data driven environment where we have many sources of data that we need to make sense of. Employers are looking for good staff with Microsoft Excel Advanced Certificate skills.
Power Query enables you to query large datasets from multiple sources and derive meaningful information and insights. Turn Excel into a Business Intelligence system or data analysis tool for research data! This NEW Excel Advanced Training Course material is available for FREE if you are a current student and for a very low cost if you’ve enrolled into Excel with us in the past.
There’s new content in our Advanced Microsoft Excel Course about Excel Macros that automate the reformatting of database information, exported from Xero Accounting so it can easily be imported into MailChimp for email marketing.
If any of these words don’t make sense to you, you need to upskill to get up to speed because this terminology is becoming common in most workplaces.