Google Sheets Basics
How to Sort by Date in Google Sheets (4 Easy Methods)
Learn how to sort by date in Google Sheets using Sort Range, SORT, Filter, QUERY functions, and fix common date sorting issues.
Read article
Blog
1285 articles
Google Sheets Formulas
How to Make the First Letter Uppercase in Google Sheets
Learn how to make the first letter uppercase in Google Sheets using the PROPER function, UPPER function, or ARRAYFORMULA for bulk changes.
Read article
Excel Charts
How to Find the Equation of a Trendline in Excel
Learn how to find the equation of a trendline in Excel using built-in features or manual calculations for different trendlines.
Read article
Google Sheets Formulas
How to Split Text by Multiple Delimiters in Google Sheets
Learn how to split text by multiple delimiters in Google Sheets using SUBSTITUTE, SPLIT, REGEX, ARRAYFORMULA, or Apps Script for automation.
Read article
Google Sheets Basics
How to Share Only One Tab in Google Sheets (4 Easy Ways)
Learn how to share only one tab in Google Sheets by hiding other tabs, using Protect Sheet, creating a new file, or publishing to the web.
Read article
Google Sheets Intermediate Tutorials
Conditional Formatting Based on Another Cell in Google Sheets
Learn how to apply conditional formatting in Google Sheets based on another cell’s value using single or multiple formatting rules.
Read article
Google Sheets Formulas
How to Remove Formula and Keep Value in Google Sheets
Learn how to remove formulas but keep values in Google Sheets using the Paste Values feature or the values-only option from the toolbar.
Read article
Google Sheets Basics
How to Autofill in Google Sheets Without Dragging (4 Quick Tricks)
Learn how to autofill in Google Sheets without dragging using keyboard shortcuts, the suggested autofill box, or the Fill Down feature.
Read article
Google Sheets Formulas
How to Capitalize All Letters in Google Sheets (3 Simple Methods)
Learn how to capitalize all letters in Google Sheets using the UPPER function, ArrayFormula for bulk edits or third-party add-ons.
Read article
Excel Pro Tips
How to Calculate Years and Months Between Two Dates in Excel
Learn how to calculate years and months between two dates in Excel using a helper column and the DATEDIF function.
Read article
Excel Pro Tips
How to Fix All Numbers Stored as Text in Excel (3 Quick Solutions)
Learn how to fix numbers stored as text in Excel by changing number format, using a multiplication trick, and applying a helper column.
Read article
Excel for Statistics
Budget vs Actual Variance: Analysis with Excel Formula
This article explains and explores the budget vs actual variance formula in Excel, budget vs actual % variance, and plotting variance chart.
Read article