X Youtube
  • Home
  • Google Sheets
  • Forms
  • Docs
  • Excel
  • Sheets Vs. Excel
Search
InfoInspired InfoInspired InfoInspired
  • Home
  • Google Sheets
    • Pivot Table Formatting, Output & Special Behavior in Google Sheets

      Pivot table calculations and advanced metrics in Google Sheets from source data to pivot output

      Pivot Table Calculations & Advanced Metrics in Google Sheets

      Google Sheets pivot table tutorial showing pivot editor and date grouping options

      Google Sheets Pivot Table Tutorial: Basics, Setup, and Date Grouping

      Dynamic column selection workflow in Google Sheets QUERY

      Dynamic Column Selection Techniques in Google Sheets QUERY

      Top N vs row limiting in Google Sheets QUERY showing LIMIT and SORTN results

      Top N and Row Limiting Techniques in Google Sheets QUERY

  • Forms
    • Automatically Pre-fill Google Forms from Google Sheets: A Step-by-Step Guide

      Automatically Pre-fill Google Forms from Google Sheets: A Step-by-Step Guide

      How to Set Up Google Docs Forms: A Comprehensive Guide

  • Docs
    • Google Docs page border applied across multiple pages with existing content

      The Ultimate Google Docs Page Border Hack (Repeats on Every Page!)

      Example of an image watermark applied to a Google Docs document page

      How to Insert and Remove Watermarks in Google Docs

      Example showing how to make just one page landscape in Google Docs with surrounding pages in portrait mode

      How to Make Just One Page Landscape in Google Docs

      How to Insert Drop-Downs in Google Docs Documents

      How to Create a Table and Pin and Unpin Header Rows…

  • Excel
    • Excel calendar heatmap with a true yearly layout and a simplified full-page view for single-screen display

      Design Logic Behind the Perpetual Calendar Heatmap in Excel

      Monthly relative Excel calendar heatmap showing daily values compared within each month

      Perpetual Calendar Heatmap in Excel (Fully Dynamic, True Calendar)

      Reverse running total calculation in Excel using SCAN function

      Why Most Reverse Running Total Formulas in Excel Break with Negative…

      Excel Rupees-to-Words formula results displayed in Column B

      Rupees to Words Excel Formula (Lakhs, Crores, No VBA)

      Example of Excel formula converting numbers to words in US/Global format

      Convert Numbers to Words in Excel (No VBA, US/Global)

  • Sheets Vs. Excel
    • How to Remove Items with Zero Total (Net Zero) in Excel…

      Running total resets by category using SCAN

      Reset SCAN by Another Column in Google Sheets and Excel

      Spreadsheet example of maximum drawdown calculation

      How to Calculate Maximum Drawdown in Excel and Google Sheets

      Lookup previous values dynamically in Excel or Google Sheets

      Lookup Previous Values Dynamically in Excel and Google Sheets

      Formula example for sorting data while keeping blank rows intact (Excel and Google Sheets)

      Sort Data but Keep Blank Rows in Excel and Google Sheets

Home Google Docs Spreadsheet Page 7

Spreadsheet

Best Google Spreadsheet (Sheets) formula examples: Query, Match, Lookup, Lambda, Database Functions, etc.

Highlighting items that appear in all columns in the range

Find Common Items Across Multiple Columns in Google Sheets

Prashanth KV 0
Sort Column by Length in Google Sheets with the QUERY Function

Sort Column by Length of Text in Google Sheets

Prashanth KV 0
Example of Breaking RANK Ties Alphabetically in Google Sheets

How to Break RANK Ties Alphabetically in Google Sheets

Prashanth KV 0
Multiple columns highlighted in Google Sheets where errors are present

Google Sheets: Highlight an Entire Column If Any Cell Has an...

Prashanth KV 0
Example of extracting top N per group from query-aggregated data in Google Sheets

Google Sheets: Extract Top N per Group from Query Aggregation

Prashanth KV 0
Extract top N from query aggregation results in Google Sheets

How to Extract Top N from Aggregated Query Results in Google...

Prashanth KV 0
RANK IF in Google Sheets – Highest value ranked as 1

How to Use RANK IF in Google Sheets (Conditional Ranking)

Prashanth KV 0

How to Filter Multiple Columns in Google Sheets

Prashanth KV 0
FLIP Function Preview: Syntax and Description in Google Sheets

FLIP in Google Sheets – Custom Named Function to Reverse Data

Prashanth KV 0
Flip a Row in Google Sheets Using a Formula

How to Flip a Row in Google Sheets

Prashanth KV 0
Filtering the bottom 10 items in a Pivot Table with multi-column grouping

Filter the Bottom 10 Items in a Pivot Table in Google...

Prashanth KV 0

Cycle Highlights in Google Sheets – Rotate Highlights Daily

Prashanth KV 0
1...678...119Page 7 of 119