Autoplay
Autocomplete
Previous Lecture
Complete and Continue
Alteryx Designer: Alteryx for Excel Users
Welcome to Alteryx for Excel Users!
Intro to Alteryx for Excel Users (1:37)
Input
What we will cover in this section (1:01)
Opening files (7:06)
Opening different file types (3:21)
Input multiple files from a folder (5:45)
Cleanse
What we will cover in this section (0:57)
Rename columns (3:38)
Change data types (2:07)
Removing columns (1:53)
Removing rows (2:54)
Create new columns (2:34)
Formulas/Calculations/Aggregations
What we will cover in this section (0:59)
IF statements (6:13)
Aggregations/Auto sum (3:47)
Calculate cumulative sum of rows (4:52)
Calculate percentages of a total (3:38)
Transform
What we will cover in this section (0:56)
Filter (3:47)
Sort (1:46)
Pivot data (5:23)
Reorder fields (2:21)
Join
What we will cover in this section (0:56)
Append data (4:40)
Blend data (VLOOKUP) (5:13)
Output to Excel
What we will cover in this section (0:42)
Output to Excel (3:31)
Post-Course Feedback
Have Feedback? We'd Love to Hear Your Thoughts (Short Survey)
Filter
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock