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)
Have Feedback? We'd Love to Hear Your Thoughts (Short Survey)
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock