This course is for any Excel/Power BI users who have the knowledge of different file types/structures, data types, IF statements, AutoSum, Sort, filters, Append data, Text to Columns, and Pivot Table.
In this course, you will develop a good understanding of the Alteryx’s essential tools: Basic and advanced. Some of them are as follows:
Dynamic Input tool to:
Append multiple files with similar file structure, for example, CSV, XLSX, and more.
Dynamic Rename tool for:
Pulling column headers from another file.
Data Cleansing tool for:
Removing trailing and leading spaces, upper case, replacing nulls with blank, and much more.
Multi Row Formula tool to:
Row wise application of logic, for example, adding two rows.
Fuzzy Match tool to:
Compare company names which are similar vs names need to be clubbed.
Formula tool to:
Apply functions similar to excel, for example, A new column with functions such as, if then else and string functions.
Select tool to:
Rename, assigning data types, column re-arrangement, and more.
Join Multiple tool to:
Combine two or more inputs based on a commonality.
Learn the Alteryx’s essential tools through real-life exercises, tips & tricks, and pull out deeper insights for your business decision-making immediately and confidently.
I would like to tell you that I am very impressed with your courses so far – I particularly like the short videos that allow me to get to a topic quickly and then move on (your competitors mostly offer 20-30 min videos which is a bit much to keep one’s attention span). The other gem in your training are the shortcuts, I found no other course with the same insights.
Because I use spreadsheets daily, I’m often using the Shift+down arrow to highlight and then manipulate data. Of course, this takes FOREVER! As I am advancing in my role at work, it is very important for me to learn more advanced Excel skills. I chose this video b/c it was short and condensed. I could literally watch it on my breaks at work and then use it right away. I really like that. Well done!
I’ve been using Pivot Tables for a couple of years, so was expecting most of this to be familiar. But this course proved me wrong. From simple tips and keyboard shortcuts, to whole features I never knew existed, I constantly found myself muttering things like “oh wow, I had no clue about that”. Things that I can actually put into practice in my job. It’s a great feeling. Kudos to the team on a great course
The Course instructors at Yoda Learning are at Par. My only Weakness till date was Excel which is long gone now. Not only I’ve learned about Excel but I can confidently do VBA Coding and automate my Regular Excel Tasks. A colleague of mine made me watch a Couple of your Videos where you have taught Excel Tricks. And since it had a Lifetime Support it really motivated me to take your Course. Thank you so much for delivering your Best knowledge.
I have all the courses from Yoda Learning. I consider it as one of the best platforms in making Learning easier for its Learners. The Courses here are comprehensive and one of the easiest Courses on the Online Platform in recent times. Professionally explained. I love the takeaways from the Course. It’s amazing especially the Money back Guarantee which gives you the Confidence to take the course.
For Enquiry About Courses? Contact Us:
Feel free to call us for any query related to courses. Our support team will resolve your issue.