Tutorialspoint

Leap Year Sale! Use code FEB10 to get an extra 10% off

Advanced Excel (Power Query) Online Training

person icon Pavan Lalwani

4.2

Advanced Excel (Power Query) Online Training

Learn Advanced Excel and crucial concepts with comprehensive training

updated on icon Updated on Feb, 2024

language icon Language - English

person icon Pavan Lalwani

category icon Office Productivity,Microsoft,Excel

Lectures -58

Resources -14

Duration -5.5 hours

4.2

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 8,500+ top Tutorials Point courses anytime, anywhere.

Course Description

Microsoft created and distributed Microsoft Excel, a professional spreadsheet program, for both Microsoft Windows and Mac OS X. Microsoft Excel version 2016 was used while these training modules were being created. Microsoft Excel is a spreadsheet program with the ability to compute, analyze data, and combine data from various sources.

Advanced Excel (Power Query) Online Training Overview

You will study the BI (Business Intelligence) process of importing data, adding and merging tables, conditional logic, data transformation, and organization in this online Advanced Excel (Power Query) Training course. The course builds its way up from the fundamentals of Power Query. This implies that, even if you're just getting started with the instrument, you'll be an expert in no time.

If you often spend a lot of time manually preparing your data for analysis, this Advanced Excel Power Query course will show you how to cut hours from your day. By the end of the course, you will be an expert at cleaning, manipulating, and reorganizing your data in order to make it ready for analysis.

For computer users who want to learn Microsoft Excel in clear, simple steps, this course has been created. That will be very helpful for students who have never used Microsoft applications before.

Goals

What will you learn in this course:

  • A clear understanding of basic Excel functions

  • Deep-dive into power query and its applications

  • Understanding Advanced Excel with real-time case studies

  • Learn Advanced Excel Functions in detail

  • Get a better understanding of concepts like Append, Excel rows & columns, sort & filter, and more.

Prerequisites

What are the prerequisites for this course?

Knowledge of pivot tables is advantageous but not required.

Advanced Excel (Power Query) Online Training

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
3 Lectures
  • play icon Introduction 04:38 04:38
  • play icon Installation of excel 02:37 02:37
  • play icon Course Resources
Basic Functions
7 Lectures
Tutorialspoint
Append
5 Lectures
Tutorialspoint
Excel Columns
15 Lectures
Tutorialspoint
Sort and Filter
1 Lectures
Tutorialspoint
Excel Rows
3 Lectures
Tutorialspoint
Replace errors and values
1 Lectures
Tutorialspoint
Transpose and headers
1 Lectures
Tutorialspoint
Group by
1 Lectures
Tutorialspoint
Functions
6 Lectures
Tutorialspoint
Case Study
6 Lectures
Tutorialspoint
Power Query
8 Lectures
Tutorialspoint

Instructor Details

Tutorialspoint

Tutorialspoint

Simply Easy Learning

Tutorials Point originated from the idea that there exists a class of readers who respond better to online content and prefer to learn new skills at their own pace from the comforts of their drawing rooms.

The journey commenced with a single tutorial on HTML in 2006 and elated by the response it generated, we worked our way to adding fresh tutorials to our repository which now proudly flaunts a wealth of tutorials and allied articles on topics ranging from programming languages to web designing to academics and much more.

40 million readers read 100 million pages every month

Our Text Library Content and resources are freely available and we prefer to keep it that way to encourage our readers acquire as many skills as they would like to. We don't force our readers to sign up with us or submit their details either to use our Free Text Tutorials Library. No preconditions and no impediments, Just Simply Easy Learning!

We have established a Digital Content Marketplace to sell Video Courses and eBooks at a very nominal cost. You will have to register with us to avail these premium services.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Feedbacks

C

Cheong Soo Kim

Pivan Lalwani is a great tutor. Even slow learner like me manage to learn Power Query without any difficulties with his clear explanation.

D

Dhanya

Cleared concepts very neatly and in a simple way. Thank you

Manikandan

Manikandan

Excellent teaching

J

jaya shree

his teaching is perfect

A

Ajay Anthony

Awesome. Well explained. Thanks

V

vishant

Awesome lectures

F

Fauziah Ahmad

Very good instructor!!

V

Velmoorthi.R

excellent for beginers

S

Sudip Das

Excellent Teaching Techniques. I learn many things about Excel, which help me in work.

S

Srinivas Vuppulapu

Very Useful

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515