Pivan Lalwani is a great tutor. Even slow learner like me manage to learn Power Query without any difficulties with his clear explanation.
Advanced Excel (Power Query) Online Training
Learn Advanced Excel and crucial concepts with comprehensive training
Updated on Feb, 2024
Language - English
Duration -5.5 hours
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.
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.
What are the prerequisites for this course?
Knowledge of pivot tables is advantageous but not required.
Check out the detailed breakdown of what’s inside the course
- Introduction 04:38 04:38
- Installation of excel 02:37 02:37
- Course Resources
Sort and Filter
Replace errors and values
Transpose and headers
TutorialspointSimply 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.
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Cleared concepts very neatly and in a simple way. Thank you
his teaching is perfect
Awesome. Well explained. Thanks
Very good instructor!!
excellent for beginers
Excellent Teaching Techniques. I learn many things about Excel, which help me in work.
Related Video CoursesView More
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video CoursesSubscribe now
Master prominent technologies at full length and become a valued certified professional.Explore Now