No products in the cart.
Description
Curriculum
Instructor
Go from basic to advance in mastering in the art of data transformation
This course will provide you with all the practical knowledge on to ace your Excel skills and expertise in using all advanced excel functions. This course will enable you to eliminate all your manual efforts in transferring data from source file to the master file and will help you automate data transformation.
This course has 16 videos in total and will take you through all of these in just 1 hour. You can watch the videos at your own pace and accordingly can raise doubts or questions if you get stuck. There are only 2 basic requirement to enroll in this course, that is:
- Computer operating knowledge
- Microsoft Excel
Concepts covered in this course:
- Discover state-of-the art data transformation skills,
- Explore the AI (Artificial Intelligence) that Power Query brings to us.
- Discover Power Query’s basic steps in data processing
- Identify 3 advanced functions in Power Query that will enable easy modeling in Pivot Tables
Some exceptional benefits associated with this course enrollment are:
- Quality course material on MS Excel
- Lifetime access to the course
- Instant & free course updates
- Access to all Questions & Answers initiated by other students as well
- Personalized support from the instructor’s end on any issue related to the course
- Few free lectures for a quick overview
Be it a working professional or a student, this course will be helpful to all. Don’t miss on this unique opportunity and enroll today itself!!
Lenny Wu
0 Students1 Course
A Lecturer at Tsinghua University in Beijing, China. Also, acts as an Examiner for the International English Language Testing System (or IELTS) in the 1990s. On top of these, he is an exam trainer for various high profile exams, such as GRE (or Graduate Record Examination), GMAT (or Graduate Management Admission Test), TOEFL (or Test of English as a Foreign Language), and math contests such as Euler, Gauss and Pascal. He has published books on test taking strategies.
Lenny received his MBA, Finance from The George Washington University in Washington, DC, USA, and currently is a Senior Financial Analyst with an international engineering company in Vancouver, BC, Canada.
Lenny's motto at work is "Don’t work hard, work smart". Lenny has passion in teaching how to build your own "robot" into everyday office work. He has over over 22 years working with Microsoft Excel, and he is a modeling expert in Power Query, Power Pivot, and Power BI.
Lenny is a big proponent of OCR (One-click Reporting), and SSR (Self-service Reporting).
Courses you might be interested in
The ability to study each potential buyer and respond immediately and appropriately to their verbal and physical cues. In this course, you” go through the history of psychology in...
-
15 Lessons
₹449.00
Discover The Hidden Secrets Of Beating Anxiety! On Completion of this course, you’ll be able to: Discover How To Banish Worry & Live An Anxiety Free Life! Learn How...
-
10 Lessons
₹599.00
Secrets They NEVER Taught You In School Or Life! On Completion of this course, you’ll be: Talking In A Way That Your Children Will Listen & Change! Knowing The...
-
13 Lessons
₹599.00
Using the Power of Social Media to Attract a Crowd of Loyal Customers. On Completion of this course, you’ll be: In no longer need to “run an ad” and...
-
39 Lessons
₹449.00