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.