Google Sheets Intermediate Tutorials
How to Import Excel into Google Sheets (3 Suitable Ways)
Learn how to import Excel files into Google Sheets using the built-in import feature, direct file opening, or simple copy-paste methods.
Read article
Blog
1285 articles
Excel Pro Tips
How to Use Data Validation with Custom Multiple Criteria in Excel
Learn how to use data validation with custom multiple criteria in Excel using AND/OR logic, COUNTIF, date rules, named ranges and lists.
Read article
Excel Pro Tips
How to Apply Data Validation Based on Another Cell in Excel
Learn how to apply data validation in Excel based on another cell using dependent drop-downs, IF formulas, custom rules, and VBA automation.
Read article
Excel Pro Tips
How to Circle Invalid Data in Excel (5 Effective Ways)
Learn how to circle invalid data in Excel using Data Validation, input messages, error alerts, conditional formatting, and helper columns.
Read article
Excel Pro Tips
How to Add Item to Drop‑Down List in Excel (5 Simple Ways)
Learn how to add items to a drop-down list in Excel by editing sources, using tables, extending named ranges, OFFSET, and UNIQUE formulas.
Read article
Excel Pro Tips
How to Create a Dynamic Dependent Drop Down List in Excel
Learn how to create a dynamic dependent drop-down list in Excel using named ranges, INDIRECT, XLOOKUP, and auto-updating, sorted lists.
Read article
Excel Pro Tips
How to Create a Drop-Down List from a Table in Excel
Learn how to create a drop-down list from a table in Excel using dynamic ranges, named ranges, and UNIQUE for auto-updating lists.
Read article
Excel Pro Tips
Excel Conditional Formatting Based on Another Cell Range
Learn how to apply Excel conditional formatting based on another cell range using operators, text rules, AND/OR logic, and VBA.
Read article
Excel Pro Tips
How to Flip a Table in Excel (8 Suitable Ways)
Learn how to flip a table in Excel vertically or horizontally using SORTBY, INDEX, TRANSPOSE, Power Query, or VBA for table inversion.
Read article
Excel Pro Tips
How to Sort a Drop Down in Excel (5 Useful Techniques)
Learn how to sort a drop-down list in Excel using SORT, COUNTA with OFFSET, Power Query, or VBA for dynamic and alphabetically ordered lists.
Read article
Excel Pro Tips
How to Delete Blank Cells in Excel and Shift Data Up
Learn how to delete blank cells in Excel and shift data up using Go To Special, FILTER, Sort, Power Query, and VBA for organized sheets.
Read article
Google Sheets Intermediate Tutorials
Create a Drop-Down List from Another Sheet in Google Sheets
Learn how to create a drop-down list in Google Sheets from another sheet using direct range references, named ranges, and dependent lists.
Read article