Microsoft Excel Power Query course is the perfect course for the professionals. Learn key concepts, strategies of Microsoft Excel Power Query and boost your career with a marketable skill. Learn from the experts and become an expert.
What you will learn
- Become more PRODUCTIVE at using Excel Power Query which will SAVE YOU HOURS per day & ELIMINATE STRESS at work!
- Increase your Excel & Power Query SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
- Learn the various Data Analytical tools within Excel to easily find & clean your data such as: Text to Columns, Remove Duplicates, Find & Replace, Go to Special, Text to Columns, Sort & Filter plus much more
- Discover the power of Excel Tables to give color and analytical power to your boring lists
- Understand in what situations you need to use Excel Formulas v Excel Analytical Tools
- We teach you how to use Excel Power Quey with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!
- Use Text, Lookup & Logical Formulas & Functions to pull data out & reorganize it to your desired outcome
- Use Conditional Formatting to find hidden and hard to find data
- Learn the various techniques within Power Query/Get & Transform to shape your data & consolidate reports without the need to use Formulas or Macros
Who is this course for?This course is ideal for those who work in or aspire to work in the following professions:
- People who are in: Accounting, Finance, Management, Auditing, Admin & Support, Sales, IT, Consulting, Banking, Marketing, Business Owners, Engineering, Project Management, Students, Teachers plus MORE!
- People who want to change career and apply for a new job
- If you want to leverage Excel to stand out from the crowd, save hours each day, eliminate stress & get a promotion or pay-rise, then you are invited to join this course!
Why Choose Microsoft Excel Power Query course?
- Accredited by CPD
- Conducted by industry experts
- Get Instant E-certificate
- Fully online, interactive course with Professional voice-over
- Developed by qualified professionals
- Self paced learning and laptop, tablet, smartphone friendly
- Tutor Support
CertificationBy the successful completion of your course, you will get an instant accredited e-certificate. Our courses are fully accredited with updated industry knowledge and skills that aim at making you an expert in the field. The hard copy of the certificate is also available and can be sent to your address. The delivery charge is applicable with a shipping cost of £4.99. All the certificates have no expiry dates but to stay updated and valued certificates are recommended to be renewed every year.
Career PathThis training course will lead you to many different career opportunities, here are few prospects:
- Office Administrator - £22,000 per annum
- Data Analyst - £26,000 per annum
- Microsoft Office Specialist - £42,500 per annum
- Introduction to Power Query 00:03:00
- Installing Power Query in Excel 2010 00:05:00
- Installing Power Query in Excel 2013 00:05:00
- Power Query and Query Editor Ribbon 00:09:00
- Split Text Fields 00:10:00
- Trim 00:05:00
- Format Dates and Values 00:02:00
- Parsing URLs 00:05:00
- Group By 00:03:00
- Import From Folder 00:07:00
- Filtering Rows 00:05:00
- Sorting Columns 00:02:00
- Merge 00:08:00
- Doing Auto Cleanup 00:07:00
- Viewing M Code 00:02:00
- Simple M Expressions 00:08:00
- Simple M Expressions – Nested Expressions 00:03:00
- M Variables 00:08:00
- M Functions 00:06:00
- M Functions – Reusable Functions 00:02:00
- M Functions – Invoking 00:00:35
- Passing M Functions 00:08:00
- Passing M Functions – Using the “each” keyword 00:03:00
- Extract Data from Forms 00:14:00
- Pivoting Columns 00:03:00
- Unpivoting Columns 00:06:00
- Split Columns Into Other Columns 00:05:00
- Transform and Add Columns 00:07:00
- Modulo 00:06:00