Author: Zakhar Yung

Learn all the options to connect LinkedIn Ads to BigQuery and export data from it either manually or on a schedule.

All the functions to merge cells and columns in Google Sheets. Check out formula examples with CONCAT, CONCATENATE, JOIN, TEXTJOIN, SUBSTITUTE and &.

Learn the no-code ways to export data from Google Analytics to BigQuery and how you can automate this on a schedule.

Excel XLOOKUP is a function that makes a look up to the left or to the right, top to bottom or bottom to top, and allows for wildcards.

Learn how you can connect API to Excel and even automate exports on a schedule without a single line of code.

Google Sheets provides plenty of shortcuts to optimize your workflow with spreadsheets. Check out the hotkeys by category and see how they work in action.

How will you choose to sort data in Google Sheets: the built-in functionality, or Google Sheets functions, such as SORT and QUERY. Read more in this tutorial.

VLOOKUP formula example and explanation of how to vlookup for multiple criteria in Excel.

Explore the options of how to split cells in Excel using the native functionality or Excel functions, depending on your needs.

Learn the options to export check register from QuickBooks and explore how you can do the same with QuickBooks Online.