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.
Learn how to automatically retrieve data from my SQL database to Google Sheets with a script - with the actual code to make it work.
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.
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).
Manipulate your data with Google Sheets QUERY function to easily analyze, transform and aggregate data.