Type | Name | |
---|---|---|
Calculate Totals (Multiple Files) | ||
Charts and Spreadsheets | ||
CountIf and SumIf | ||
Create and Send Report | ||
Join Strings (Multiple Sheets) | ||
Joining Spreadsheets | ||
Merge Files | ||
Non-standard format Spreadsheets | ||
Pivot Table | ||
Prediction within Spreadsheets | ||
Read Data from Different Sources | ||
Spreadsheets and Loops | ||
Time-over-Time Analysis | ||
VLOOKUP function (Different Files) | ||
VLOOKUP function (Same Sheet) |
Find examples of the most common data manipulation tasks. They are recommended for beginners, particularly spreadsheet users, who are new to visual workflows.