Online
- Duration / Course length: Upto 4 Hours Start now
- Accredited by: CPD Group
- Certificates:
- Course delivery: This course is delivered in video format
Course details
Do you wish to start a career in Microsoft Excel Power Query or do you want to get more comprehensive knowledge in Microsoft Excel Power Query?This online training course was designed by specialists with the requirements of job seekers and established organisations in mind. This online training will boost your career.
The Microsoft Excel Power Query course contains all the most current topics to bring you up to date with job market advancements and make you a better fit for your chosen career related to Microsoft Excel Power Query.
After successfully completing the course, you will gather all knowledge about this course, and you will get a digital certificate (PDF format) which is free of cost (price included in the course price). The certificate will enable you to add more value to your CV in order to stand out in the employment market or job market.
This course is ideal for:
- Anyone interested in learning more about Microsoft Excel Power Query Skills.
- Students wanting to improve Microsoft Excel Power Query skills
- Anyone from beginner to intermediate
Special Offer
- Learners will get Free Digital Certificate
- No Extra fees
- Lifetime Course Access
- Free Assessment
Why Choose this Microsoft Excel Power Query Course?
- Developed by Qualified Professionals with Updated Materials
- 24/7 Learning Support and Assistance
- Course completion free PDF certificate
- High-quality E-learning Study Materials
- No Hidden Fees or Exam Charges
- Access the Course Anywhere in the World
- Self-Paced Learning and Laptop, Tablet, Smartphone Friendly
Microsoft Excel Power Query course curriculum breakdown
- Lecture 1: Modulo
- Lecture 2: Convert Reports into Pivot Tables
- Lecture 3: Right Anti Join
- Lecture 4: Full Outer Join
- Lecture 5: Intro to Joins
- Lecture 6: Sorting Columns
- Lecture 7: Filtering Rows
- Lecture 8: Split Columns into Other Columns
- Lecture 9: Pivoting Columns
- Lecture 10: Power Query Intro and Excel version
- Lecture 11: Extract Multiple Worksheets
- Lecture 12: Extract - Multiple Criteria
- Lecture 13: Extract Data from Forms
- Lecture 14: Doing Auto Cleanup
- Lecture 15: Import From Folder
- Lecture 16: Group By
- Lecture 17: Split Text Fields
- Lecture 18: Parsing URLs
- Lecture 19: Format Dates and Values
- Lecture 20: Trim
- Lecture 21: Power Query and Query Editor Ribbon
Certification
You will get a FREE digital certificate upon successful completion of the Microsoft Excel Power Query course. The price of a printed copy is £
Updated on 06 February, 2023
Eligibility / Requirements
No formal entry requirements for Microsoft Excel Power Query. You need to have:
- Passion for learning
- A basic understanding of the English language
- This course is available to all learners, of all academic backgrounds.
- Learners should be aged 14 or over.
Job roles this course is suitable for:
Office Administrator , Office Administration Supervisor , Microsoft Modern Workplace Specialist , Microsoft Office Specialist , Data Analyst , Market Researcher , Researcher , (Jr.) Data Engineer , Accountant , Financial AnalystAbout Course Line
With Course Line, you have access to the best courses - all with one consistent interface.
Course Line is affordable and flexible. We offer an extensive library of courses with over 300 hours of video lectures, online exams, test areas, as well as traditional handouts. It's never too late to learn something new with Course Line
Our courses are designed with busy professionals in mind - they are self-paced, start at any time of the year, and can be completed in as little as 3 months.
Courses that fit in your life with Course Line. We offer a variety of learning materials including video and audio lectures, online exams, test areas, as well as traditional handouts - you can choose what works best for you.
599 students have enrolled with Course Line through Laimoon
See all Course Line courses
