Updated on Oct, 2024
Language - English
pawan lawani sir is the best
Advanced Excel (Power Query) Training Course
Learn Advanced Excel and crucial concepts with comprehensive training
Office Productivity,Microsoft,Excel
Lectures -58
Resources -14
Duration -5.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ 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
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
Knowledge of pivot tables is advantageous but not required.
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
3 Lectures
-
Introduction
04:38
04:38
-
Installation of excel
02:37
02:37
-
Course Resources
Basic Functions
7 Lectures
Append
5 Lectures
Excel Columns
15 Lectures
Sort and Filter
1 Lectures
Excel Rows
3 Lectures
Replace errors and values
1 Lectures
Transpose and headers
1 Lectures
Group by
1 Lectures
Functions
6 Lectures
Case Study
6 Lectures
Power Query
8 Lectures
Instructor Details
Tutorialspoint
Simple and 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
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Feedbacks
Great !
very good experience
Lecturer demonstrate control on the course.
Satisfied
One of the best course
It was a very innovative and nice session, I have seen in the job description of Tax analyst in EY , Power query was also one of the requirement. Thank you for the opportunity and Thank you very much to Pawan Lalvani Sir
Pivan Lalwani is a great tutor. Even slow learner like me manage to learn Power Query without any difficulties with his clear explanation.
Cleared concepts very neatly and in a simple way. Thank you
Manikandan
Excellent teaching
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now