Time-Tracking Spreadsheet in Excel – Do It Yourself or Use Our Template
Learn how to build a time tracking spreadsheet in Excel or connect Excel to a time-tracking app. Ready-to-use templates are included.
Author: Zakhar Yung
IMPORTRANGE Excel – How to Implement the IMPORTRANGE Functionality in Excel
Learn the options for how to implement the IMPORTRANGE equivalent for Excel in a native way or with a third-party solution.
Export Data Out of BigQuery – Options And Tools
Learn how to export BigQuery data and options available for getting tables and query results out of BigQuery with a how-to explanation.
Mailchimp to Google Sheets: How to Connect Mailchimp API Without Coding
Learn how you can sync Mailchimp and Google Sheets to retrieve records of reports, campaigns, and other data on a schedule without any coding.
Google Sheets Power BI – A Step-by-Step Connection Guide
Two actionable methods to connect Google Sheets to Power BI for further data visualization.
Power BI BigQuery – A Step-by-Step Connection Guide
A step-by-step tutorial on how to connect Power BI to BigQuery for loading data using the native connector or an ODBC driver.
Excel XLOOKUP Function Explained – Syntax and Examples
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.
Excel Vlookup Multiple Columns: Explanation + Examples
VLOOKUP formula example and explanation of how to vlookup multiple columns in Excel.
How to VLOOKUP Another Sheet in Excel
VLOOKUP formula example and explanation of how to vlookup another sheet in Excel.
Compare Two Columns in Excel Using VLOOKUP
VLOOKUP formula example and explanation of how to compare two columns in Excel using the VLOOKUP function.