Learn how to automatically retrieve data from your SQL database and import it into Google Sheets with a script that you can copy and paste right into Google App
Learn, through an example, how to make a simple automated dashboard on Google Sheets for your metrics using SPARKLINE, VLOOKUP, Data Validation and Pivot Table.
Manipulate your data with a single Google Sheets QUERY function to easily analyze, transform and aggregate data.
Learn how to use the Google Sheets array formula. You’ll be able to apply a formula to an entire column and add it automatically to future rows.
If you want to delete your pivot table and keep a backup of the resulting data, learn with this 1-minute video that explains it all for Google Sheets and Excel.
The VLOOKUP formula is super useful in Google sheets. This 1-minute video is just the perfect way to get how it works.
Learn how to sort your data in a pivot table, ordering it in ascending or descending order in Google Sheets, or sort from smallest to largest in Excel.
Learn how to export SQL data to Excel and update the export automatically (MySQL, Microsoft SQL Server, PostgreSQL).