Setup Menus in Admin Panel

5

5

An introductory course on Power Query will guide you to brush up your skills on an invaluable data transformation tool. Any analyst working in Excel can apply the application, saving users hours, reducing manual errors and allowing users to source data from a central source of truth.

With Power Query (known as Get & Transform in Excel), you can import or connect to external data and then shape that data, for example, remove a column, change a data type, or merge tables to meet your needs. Then, you can load your query into Excel to create charts and reports.

£29.99 inc. VAT
Course Access

Unlimited Duration

Last Updated

July 7, 2023

Students Enrolled

70

Course Duration

3 hours, 20 minutes

Course Instructor
Certification
Queries skills will help you to accomplish a few different tasks. Primarily, queries are used to find specific data by filtering explicit criteria. It also helps automate data management tasks, summarises data and engages in calculations.

Power Query allows a user to import data into Excel through external sources, such as Text files, CSV files, Web, or Excel workbooks, to list a few. The data can then be cleaned and prepared for your requirements.

Power Query enables connectivity to a wide range of data sources, including data of all sizes and shapes. Consistency of experience and parity of query capabilities over all data sources. Highly interactive and intuitive experience for rapidly and iteratively building queries over any data source of any size.

You will be able to do the following after completing this course:

  • Become more productive at using Excel Power Query, which will SAVE YOU HOURS daily & 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 colour 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 Query 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

Is this course for you?

A query lets you: View data only from the fields you are interested in viewing. When you open a table, you see all the fields. A query is a handy way to save a selection of areas.

Power Query is one of the most transformative tools available to any analyst working with data in Excel. It will save analysts hours and result in reduced manual errors and a better ability to source data from a single source of truth.

Why Choose Microsoft Excel Power Query course?

  • 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

Certification

Upon successful completion of this course, an instant e-certificate will be generated free of charge. The digital version of the course transcript is available for £2.99. We can post the printed copy of the certificate and the transcript to your address. A delivery charge of £4.99 (UK) & £12.99 (Outside the UK) is applied to this service.

Career Path

The industries that mainly use Power BI as data visualisations are software or IT companies, the hospitality industry, the financial industry, management consulting services, retail sectors, the staffing & recruitment industry, and not limited to this.

The salary expectation can grow from £30,000 per annum to £45,000 per annum.

Industry Expert Instructor

Profile Photo
3.24 3.235294117647059
1011
Students
Microsoft Office | Finance | SQL

Rated Excellent on Trustpilot

Course Content

    • Power Query Intro and Excel version FREE 00:03:00
    • Installing Power Query in Excel 2010 00:05:00
    • Installing Power Query in Excel 2013 00:01:00
    • Power Query and Query Editor Ribbon 00:09:00
    • Trim 00:05:00
    • Format Dates and Values 00:02:00
    • Parsing URLs 00:05:00
    • Split Text Fields 00:10:00
    • Group By 00:03:00
    • Import From Folder 00:07:00
    • Doing Auto Cleanup 00:07:00
    • Extract Data from Forms 00:14:00
    • Extract – Multiple Criteria 00:05:00
    • Extract Multiple Worksheets 00:04:00
    • Unpivoting Columns 00:05:00
    • Pivoting Columns 00:02:00
    • Split Columns Into Other Columns 00:04:00
    • Filtering Rows 00:05:00
    • Sorting Columns 00:02:00
    • Transform and Add Columns 00:07:00
    • Intro to Joins 00:04:00
    • Merging 00:08:00
    • Full Outer Join 00:06:00
    • Right Anti-Join 00:09:00
    • Convert Reports into Pivot Tables 00:05:00
    • Modulo 00:06:00
    • M Introduction 00:03:00
    • Enabling M in Power Query 00:02:00
    • Simple Expressions 00:08:00
    • Simple M Expressions – Nested Expressions 00:03:00
    • Variables 00:08:00
    • Functions 00:06:00
    • Functions – Reusable Functions 00:02:00
    • Functions – Invoking 00:01:00
    • Passing Functions 00:08:00
    • Passing Functions – keyword each 00:03:00
    • Finding the list of M functions 00:02:00
    • Using M Functions 00:10:00
    • Microsoft Excel Power Query – Resources 00:01:00
    • What’s Next? 00:00:00
    • 101 Best Microsoft Excel Tips & Tricks E-Book 00:00:00
    • Get Your Certificate & Transcript 00:00:00

Course Reviews

© 2024 Course Central | website design & Maintenance by: menulane

Setup Menus in Admin Panel