KNIME for Microsoft Excel Users

KNIME for Microsoft Excel Users, available at $79.99, has an average rating of 4.8, with 59 lectures, based on 70 reviews, and has 430 subscribers.

You will learn about You can transition tasks from Excel to KNIME You know KNIME equivalent Nodes for common excel tasks You can use Excel specific KNIME nodes for cleaning, updating, formatting and visualizing data You increase your KNIME skills You increase your productivity New job opportunities might open up for you This course is ideal for individuals who are You want to transition from Excel to KNIME or You want to learn how to apply Excel formulas and logic in KNIME or You want to reduce the Excel stress and learn an alternative way to clean, transform and visualize your data It is particularly useful for You want to transition from Excel to KNIME or You want to learn how to apply Excel formulas and logic in KNIME or You want to reduce the Excel stress and learn an alternative way to clean, transform and visualize your data.

Enroll now: KNIME for Microsoft Excel Users

Summary

Title: KNIME for Microsoft Excel Users

Price: $79.99

Average Rating: 4.8

Number of Lectures: 59

Number of Published Lectures: 59

Number of Curriculum Items: 59

Number of Published Curriculum Objects: 59

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

You can transition tasks from Excel to KNIME
You know KNIME equivalent Nodes for common excel tasks
You can use Excel specific KNIME nodes for cleaning, updating, formatting and visualizing data
You increase your KNIME skills
You increase your productivity
New job opportunities might open up for you

Who Should Attend

You want to transition from Excel to KNIME
You want to learn how to apply Excel formulas and logic in KNIME
You want to reduce the Excel stress and learn an alternative way to clean, transform and visualize your data

Target Audiences

You want to transition from Excel to KNIME
You want to learn how to apply Excel formulas and logic in KNIME
You want to reduce the Excel stress and learn an alternative way to clean, transform and visualize your data

You are an extensive Excel user? You want to learn new and better ways of doing things with your data?

Then you are right here!

Let’s face it. Data cleaning is always a big hassle, especially if we are short on time and want to deliver crucial data analysis insights to our audience.

But how can we be more efficient in the ETL/ Data Prep process? How can this process be more FUN?

Meet KNIME!

A great tool which comes to our rescue. KNIME allows us to do data preparation / data cleaning in a very appealing drag and drop interface. (No coding experience is required yet it still allows us if we want to use languages like R, Python or Java. So, we can code if we want but don’t have to!). The flexibility of KNIME makes that happen.

In this course we lay the foundation for your successfull transition from Excel to KNIME

More specifically we learn

Reading and writing Excel data (file, files, sheet, sheets, locations, …)
Updating Excel sheets (append data, overwrite cells, …)
Covering KNIME‘s equivalent Excel Formulas (Vlookup, (Advanced) Filtering, …)
Formatting Excel Worksheets (Font, background color, borders

Further we will have an introduction to visualizations in KNIME

In particular

available visualization options
Required data shaping

Ready? Set! GO!

Course Curriculum

Chapter 1: Before we start

Lecture 1: 1 KNIME for Excel users Course Introduction

Lecture 2: Important update information regarding the course please read before you start!

Chapter 2: KNIME for Excel Users – How to transition from Excel to KNIME New Interface

Lecture 1: 0 Switch between old and new interface in KNIME

Lecture 2: Download Resources to follow along here

Lecture 3: 3 Reading Data from Excel Worksheet into KNIME

Lecture 4: 4 Reading multiple Excel files into KNIME

Lecture 5: 6 Reading multiple Excel Workbooks with multiple excel worksheets into KNIME

Lecture 6: 8 How to update individual cells in an excel file

Lecture 7: 9 Vlookup or Index Match in KNIME

Lecture 8: 10 Vlookup with multiple criteria and drop duplicates in KNIME

Lecture 9: 11 Filtering Columns in KNIME multiple options available

Lecture 10: 12 More Filtering Options in KNIME we can use

Lecture 11: 13 Pivoting and Unpivoting data in KNIME

Lecture 12: 14 Importance of data type conversions and how to do it

Lecture 13: 15 All about sorting renaming and all in one in KNIME

Lecture 14: 16 Math Formulas in KNIME

Lecture 15: 17 Handling different Excel Table structures in KNIME

Lecture 16: 18 How to handle file dependencies in KNIME

Lecture 17: 21 Introduction to Charts in KNIME

Chapter 3: KNIME for Excel Users – How to transition from Excel to KNIME Classic Interface

Lecture 1: Download all resources to follow along

Lecture 2: 3 Reading Data from Excel Worksheet into KNIME

Lecture 3: 4 Reading multiple Excel sheets from one Workbook into KNIME

Lecture 4: 5 Reading multiple Excel Files into KNIME

Lecture 5: 6 Reading multiple Excel Workbooks with multiple sheets into KNIME

Lecture 6: 7 How to connect to Online sources like sharepoint and s3

Lecture 7: 8 How to update individual Cells in Excel files

Lecture 8: 9 Vlookup Index Match in KNIME in 2 ways

Lecture 9: 10 Vlookup with multiple criteria

Lecture 10: 11 The various options to filter rows in KNIME

Lecture 11: 12 The various options to filter rows in KNIME part 2

Lecture 12: 13 Pivot and Unpivot Data like Powerquery or Pivot Tables in KNIME

Lecture 13: 14 Data Type Conversions in KNIME

Lecture 14: 15 All about Sorting Renaming and All in One KNIME vs Excel

Lecture 15: 16 Math Formulas in KNIME vs Excel

Lecture 16: 17 Combining Excel Tables with different structures in KNIME

Lecture 17: 18 How to handle file dependencies in KNIME

Lecture 18: 19 How to apply Excel Formatting in KNIME

Lecture 19: 20 How to apply Excel Formatting in KNIME

Lecture 20: 21 Introduction to Charts with KNIME

Lecture 21: 22 Which Charts are available in KNIME

Lecture 22: 23 Example for required Datapreparation for visualizing charts in KNIME

Lecture 23: 24 How to create geographical map visualizations with KNIME vs Excel

Lecture 24: 25 Congratulations and final words

Chapter 4: Bonus Videos

Lecture 1: Bonus Combine KNIME with Excel Templates

Lecture 2: KNIME Bonus Challenge CreateMonthColumns

Chapter 5: Additional KNIME Tips and Tricks (Classic Interface!)

Lecture 1: A note before you start this section

Lecture 2: Here you can download the course resources to follow along

Lecture 3: 3 The customer Challenge in KNIME

Lecture 4: 4 The Lookup Comparison Challenge in KNIME

Lecture 5: 5 The validation period creation challenge

Lecture 6: 6 The dynamic selection challenge in KNIME

Lecture 7: 7 The Filter Challenge Lets use some Leverage

Lecture 8: 8 Choosing the best supplier challenge

Lecture 9: 9 The what is missing challenge in KNIME

Lecture 10: 10 The restarting group challenge in KNIME

Lecture 11: 11 The only one challenge in KNIME

Lecture 12: 12 The universal challenge across all industries and departments

Lecture 13: 13 The Approximate Group creation challenge

Chapter 6: More KNIME

Lecture 1: Let's continue KNIMING together 😉

Instructors

Dan We
Coach

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 0 votes
4 stars: 20 votes
5 stars: 49 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu