How To 10x Your LiveFlow Experience

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

Google Sheets Tips

Conditional Formatting in Google Sheets: Explained

Learn how to use Conditional Formatting function in Google Sheets

Google Sheets Tips

How to Highlight Duplicates in Google Sheets

Learn how to highlight duplicates with Conditional Formatting in Google Sheets

Google Sheets Tips

How to Use Wildcard Characters in Google Sheets

Learn what wildcard characters are and how to use them in Google Sheets

Google Sheets Tips

How to Insert Multiple Rows in Google Sheets

Learn how to insert multiple rows in Google Sheets quickly

Google Sheets Tips

How to Insert Multiple Columns in Google Sheets

Learn how to insert multiple columns in Google Sheets quickly

Google Sheets Formulas

How to Use MAP Function in Google Sheets

Learn what is the MAP formula and how to use it quickly

Google Sheets Formulas

How to Use MAKEARRAY Formula in Google Sheets

Learn what the MAKEARRAY function and how to use it quickly

Google Sheets Formulas

How to Use SCAN Function in Google Sheets

Learn what the SCAN formula is and how to use it quickly

Google Sheets Formulas

How to Use REDUCE Function in Google Sheets

Learn what the REDUCE formula and how to use it quickly

Google Sheets Formulas

How to Use BYCOL Function in Google Sheets

Learn what the BYCOL formula is and how to use it in Google Sheets

Google Sheets Formulas

How to Use BYROW Function in Google Sheets

Learn what the BYROW formula is and how to use it in Google Sheets

Google Sheets Formulas

How to Use POWER Function in Google Sheets

Learn how to use the POWER formula in Google Sheets

Google Sheets Tips

Conditional Formatting Based on Another Cell Value in Google Sheets: Explained

Learn how to use Conditional Formatting based on a value in another cell

Google Sheets Formulas

How to Trim Whitespaces in Google Sheets

Learn how to remove extra spaces in Google Sheets

Google Sheets Formulas

How to Use RANK Function in Google Sheets

Learn how to use the RANK formula in Google Sheets

Google Sheets Formulas

How to Use INDEX Function in Google Sheets

Learn how to use the INDEX function quickly

Google Sheets Formulas

How to Use MATCH Function in Google Sheets

Learn how to use the MATCH formula in Google Sheets

Google Sheets Formulas

EOMONTH Function in Google Sheets: Explained

Learn how to use the EOMONTH formula in Google Sheets

Google Sheets Formulas

How to Use TRANSPOSE Function in Google Sheets

Learn how to use the TRANSPOSE formula in Google Sheets

Google Sheets Tips

How to Make a Waterfall Chart in Google Sheets

Learn how to create a waterfall chart in Google Sheets

Google Sheets Tips

How to Add a Comment to a Cell in Google Sheets

Learn how to insert a comment in Google Sheets

Google Sheets Tips

How to Insert a Note in Google Sheets

Learn how to add a note to a cell in Google Sheets

Google Sheets Tips

How to Indent Texts in Google Sheets: Explained

Learn how to add indentation to texts in Google Sheets

Google Sheets Tips

How to Alternate Row Colors in Google Sheets

Learn how to color rows alternately in Google Sheets

Google Sheets Tips

How to Merge Cells in Google Sheets

Learn how to merge cells in Google Sheets quickly

Google Sheets Tips

How to Tag Someone in Google Sheets

Learn how to tag and assign someone in Google Sheets

Google Sheets Tips

How to Calculate Compound Annual Growth Rate (“CAGR”) in Google Sheets

Learn about Compound Annual Growth Rate and how to compute it in Google Sheets

Google Sheets Formulas

AVERAGEIF Function in Google Sheets: Explained

Learn how to use the AVERAGEIF formula in Google Sheets

Google Sheets Formulas

How to Use the CONCATENATE function in Google Sheets

Learn how to use the CONCATENATE formula in Google Sheets

Google Sheets Formulas

How to Insert Current Time with NOW Function in Google Sheets

Learn how to use the NOW formula in Google Sheets

Google Sheets Tips

Comment History in Google Sheets: Explained

Learn how to view the Comment History in Google Sheets

Google Sheets Formulas

AVERAGEIFS Function in Google Sheets: Explained

Learn how to use the AVERAGEIFS formula in Google Sheets

Google Sheets Formulas

How to Use EDATE Function in Google Sheets

Learn how to use the EDATE formula in Google Sheets quickly

Google Sheets Formulas

FILTER Function in Google Sheets: Explained

Learn how to use the FILTER function in Google Sheets

Google Sheets Formulas

How to Use CHOOSE Function in Google Sheets

Learn how to use the CHOOSE formula in Google Sheets quickly

Google Sheets Formulas

Named Range in Google Sheets: Explained

Learn Named Range and how to use it in Google Sheets

Google Sheets Tips

How to Resize Column Width in Google Sheets

Learn how to change columns' widths in Google Sheets quickly

Google Sheets Tips

How to Change Default Font in Google Sheets

Learn how to change the default font setting in Google Sheets

Google Sheets Tips

Relative Reference and Absolute Reference in Google Sheets: Explained

Learn the difference between relative reference and absolute reference in Google Sheets

Google Sheets Tips

How to Resize Row Height in Google Sheets

Learn how to change row height in Google Sheets quickly

Google Sheets Tips

How to Wrap Text in Cell in Google Sheets

Learn three text formatting, wrap, overflow, and clip, and make your table more beautiful

Google Sheets Formulas

How to Use SWITCH Function in Google Sheets

Learn how to use the SWITCH formula in Google Sheets quickly

Google Sheets Tips

Switch Rows and Columns in Google Sheets: Explained

Learn how to switch rows and columns by Spacial Paste in Google Sheets

Google Sheets Tips

How to Switch Two Columns and Rows in Google Sheets

Learn how to swap two columns in Google Sheets quickly

Google Sheets Formulas

How to Use REPLACE Function in Google Sheets

Learn how to use the REPLACE formula in Google Sheets

Google Sheets Formulas

How to Use IMPORTRANGE Function in Google Sheets

Learn how to use the IMPORTRANGE formula in Google Sheets

Google Sheets Tips

How to Set Print Area in Google Sheets

Learn how to print out Google Sheets properly

Google Sheets Tips

How to Find and Replace Words in Google Sheets

Learn how to utilize Find and Replace in Google Sheets

Google Sheets Tips

Autofill Function in Google Sheets: Explained

Learn how to utilize Autofill function in Google Sheets

Google Sheets Formulas

UNIQUE Function in Google Sheets: Explained

Learn how to use UNIQUE function to remove duplicates in Google Sheets

Google Sheets Tips

How to Split Texts into Columns in Google Sheets

Learn how to split texts horizontally in Google Sheets

Google Sheets Formulas

TEXT Function in Google Sheets: Explained

Learn how to change text formatting with the TEXT function in Google Sheets

Google Sheets Formulas

How to Use SPLIT Function in Google Sheets

Learn how to split texts with the SPLIT function in Google Sheets

Google Sheets Tips

How to Remove Duplicates in Google Sheets

Learn how to eliminate duplicates in a data set in Google Sheets

Google Sheets Tips

Filter in Google Sheets: Explained

Learn how to use a filter in Google Sheets

Google Sheets Tips

Filter Views in Google Sheets: Explained

Learn Filter Views and how to use in Google Sheets quickly

Google Sheets Formulas

COUNTUNIQUE Function in Google Sheets: Explained

Learn the COUNTUNIQUE formula and how to use it in Google Sheets

Google Sheets Formulas

COUNTBLANK Function in Google Sheets: Explained

Learn the COUNTBLANK function and how to use it in Google Sheets

Google Sheets Formulas

COUNT Function in Google Sheets: Explained

Learn how to use the COUNT function in Google Sheets quickly

Google Sheets Formulas

COUNTA Function in Google Sheets: Explained

Learn how to use the COUNTA function in Google Sheets

Google Sheets Formulas

ARRAYFORMULA Function in Google Sheets: Explained

Learn the ARRAYFORMULA and how to use it in Google Sheets

Google Sheets Formulas

AND Function in Google Sheets: Explained

Learn the AND function and how to use it in Google Sheets

Google Sheets Formulas

INDIRECT Function in Google Sheets: Explained

Learn the INDIRECT function and how to use it in Google Sheets

Google Sheets Tips

How to Add a Check Box in Google Sheets

Learn how to add a checkbox and make your Google Sheets more effective

Google Sheets Tips

Dependent Drop-down List in Google Sheets: Explained

Learn how to create a dependent drop-down menu in Google Sheets

Google Sheets Formulas

OR Function in Google Sheets: Explained

Learn the OR function and how to use it in Google Sheets

Google Sheets Formulas

DATEVALUE Function in Google Sheets: Explained

Learn how to use the DATEVALUE formula in Google Sheets

Google Sheets Tips

Pivot Table in Google Sheets: Explained

Learn Pivot Table and how to use it in Google Sheets

Google Sheets Tips

How to Align Text in Google Sheets

Learn how to align text vertically and horizontally in Google Sheets

Google Sheets Tips

How to Make a Line Chart in Google Sheets

Learn how to create a line chart in Google Sheets quickly

Reports

Import large amounts of QuickBooks transactions to G-Sheets with Live Functions

This guide covers how you can import tens of thousands of transactions from QuickBooks into G-Sheets

Google Sheets Formulas

COLUMN Function in Google Sheets: Explained

Learn how to use the COLUMN function in Google Sheets quickly

Google Sheets Formulas

ROW Function in Google Sheets: Explained

Learn how to use the ROW function in Google Sheets

Google Sheets Formulas

MOD Function in Google Sheets: Explained

Learn how to use the MOD function in Google Sheets

Google Sheets Tips

Alternate Column Colors in Google Sheets: Explained

Learn how to alternate column colors by Conditional Formatting in Google Sheets

Google Sheets Tips

How to Make a Bubble Chart in Google Sheets

Learn how to create a bubble chart in Google Sheets

Google Sheets Tips

How to Make a Stacked Column Chart in Google Sheets

Learn how to create a stacked column chart in google sheets

Google Sheets Formulas

OFFSET Function in Google Sheets: Explained

Learn what the OFFSET function is and how to use it in Google Sheets

Google Sheets Tips

What is Google Data Studio?

Learn what Google Data Studio is and how you can make it live with LiveFlow

Integrations

Is It Possible to Integrate a Form to an Existing Google Sheets?

You need to open the form in Google Forms, click Responses, then click the spreadsheet icon.

Support

How to Translate Google Sheets to Desired Language

Open the Google Sheet you want to translate, and then go to the Tools menu.

Support

How to Search in Google Sheets

Here’s what you need to know about how to search in Google Sheets.‍

Reports

How to copy a Google Sheet into an existing Google Sheet

The good news it's super easy and will take you a couple of seconds!

Settings

How To Open Your Workspace

Google Sheets Formulas

SEARCH Function in Google Sheets: Explained

Learn how to use the SEARCH formula in Google Sheets quickly

Google Sheets Formulas

FIND Function in Google Sheets: Explained

Learn how to use the FIND formula in Google Sheets quickly

Google Sheets Formulas

GOOGLEFINANCE Function in Google Sheets: Explained

Learn how to quote stock information and currency date with the GOOGLEFINANCE funtion

Google Sheets Formulas

YEAR Function in Google Sheets: Explained

Learn how to extract the year from a date quickly by using the YEAR function in Google Sheets

Google Sheets Formulas

MONTH Function in Google Sheets: Explained

Learn how to pull out the month from a date quickly by using the MONTH function in Google Sheets

Google Sheets Formulas

DAY Function in Google Sheets: Explained

Learn how to extract the day from a date quickly by using the DAY function in Google Sheets

Google Sheets Formulas

WORKDAY Function in Google Sheets: Explained

Learn how to get an ending date based on a starting date and the number of days you have.

Google Sheets Formulas

NETWORKDAYS Function in Google Sheets: Explained

Learn how to compute the number of working days excluding holidays.

Google Sheets Formulas

DAYS Function in Google Sheets: Explained

Learn how to use the DAY formula in Google Sheets quickly

Google Sheets Formulas

LEN Function in Google Sheets: Explained

Learn how to use the LEN function in Google Sheets quickly

Google Sheets Formulas

CHAR Function in Google Sheets: Explained

Learn how to use the CHAR formula in Google Sheets quickly

Google Sheets Formulas

REPT Function in Google Sheets: Explained

Learn how to use the REPT formula in Google Sheets quickly

Reports

My report is too large to import

Solution: Try a shorter date range, add filters or try our Live Functions.

Google Sheets Tips

Google Sheets Sign-in: Explained

Learn how to sign in to Google Sheets quickly

Google Sheets Tips

How to Reference Another Sheet in Google Sheets

Learn how to reference data on another sheet in formulas quickly

Google Sheets Tips

How to Make a Table in Google Sheets

Learn how to insert a table in Google Sheets quickly

Sorry! We couldn't find any results for that yet.

Know a vendor we should add to our partner directory? Email us at founders@liveflow.io

How can we help you today?

Get personal help

Getting started

Category

Sorry! We couldn't find any results for that yet.

Xero Profit and Loss Dashboard

Dynamic Three-Statement Rolling Monthly Cash Flow Forecasting

Standard Profit And Loss Dashboard

Non-Profit Statement of Activities

Monthly and YTD Comparative P&L and BS

Advanced Rolling 13-Week Cash Flow Forecast

Restaurant Weekly Dashboard

Ultimate SaaS Financial Dashboard Template for Excel

Construction KPI Dashboard for Excel

Monthly Client Reporting Dashboard

Consolidation Benchmarking Template

Profit and Loss Visual Dashboard

Consolidated Period Over Period Profit and Loss Template

Budget vs. Actuals with Variance

Period Over Period Comparison Template

Monthly Client Reporting Template for Google Sheets & Excel

Construction Client Reporting Template for Google Sheets

Three-Way Legal Trust Reconciliation Template for Google Sheets

Automated Financial Overview Template for Google Sheets

Intercompany Reconciliation Template for Google Sheets

Consolidated Financials Review Dashboard for Controllers for Google Sheets

Controller’s Financial Review Template for Google Sheets

Consolidated P&L by Month & Class Template for Google Sheets

Tax IRS 1040 Schedule C Template

Tax IRS 1040 Schedule F Template

Tax IRS 1040 Schedule E Template

Tax IRS 1120-S Filing Template

Tax IRS 1120 Filing Template

Vendor Management Dashboard Template for Google Sheets & Excel

Law Firm Financial Summary Template for Google Sheets

Weekly Cash Flow from P&L and BS Template for Google Sheets

Financial Summary Dashboard for Google Sheets

Nonprofit Financial Statement Template for Google Sheets & Excel

E-Commerce Sales Analysis Template for Google Sheets

Mapped Balance Sheet Consolidation Template for Google Sheets

P&L and Board Summary Template for Google Sheets & Excel

Executive Summary Report Template for Google Sheets

Restaurant 4-4-5 P&L Dashboard Template for Google Sheets & Excel

Restaurant 4-4-5 P&L Template for Google Sheets & Excel

Schedule of Values Template for Google Sheets

Consolidated Trial Balance Dashboard for Google Sheets

Multi-Year Balance Sheet Comparison Template for Google Sheets & Excel

Vendor Account Management Template for Google Sheets & Excel

A/R Consolidation Dashboard for Google Sheets

Net Worth Tracking Dashboard for Google Sheets

SaaS Financial Dashboard Template for Google Sheets & Excel

Consolidated Project Profitability Dashboard for Google Sheets

Invoice Tracking Template for Google Sheets

Construction KPI & WIP Dashboard for Google Sheets & Excel

Real Estate Profit First Dashboard for Google Sheets & Excel

Profit First Management Template for Google Sheets

Project Profitability Analysis Template for Google Sheets

Real Estate P&L Dashboard for Google Sheets & Excel

Marketing Spend Analysis Template for Google Sheets

Board Reporting Overview Template for Google Sheets

Prepaid Expense Tracker Template for Google Sheets

Client Financial Reporting Template for Google Sheets

Forecasting P&L Analysis Template for Google Sheets

Multi-Currency P&L Dashboard for Google Sheets

Business KPI Dashboard Template for Google Sheets

A/R Customer Overview Template for Google Sheets

Department Budget & P&L Template for Google Sheets

Top 10 Vendor Analysis Dashboard for Google Sheets & Excel

Monthly & YTD P&L Comparison Template for Google Sheets & Excel

YTD Financial Overview Template for Google Sheets

Break-Even Analysis Template for Google Sheets

Uncategorized Transactions Organizer for Google Sheets

Monthly Balance Sheet Growth Tracker for Google Sheets & Excel

P&L for Multiple Entities Template for Google Sheets

Vendor Spend Analysis with MoM Dashboard for Google Sheets & Excel

A/P Consolidation Dashboard for Google Sheets

Flash Financial Overview Template for Google Sheets

P&L Monthly & Class Report Template for Google Sheets

Live A/R Management Dashboard for Google Sheets & Excel

Budget vs. Actual Analysis Template for Google Sheets & Excel