Excel Charts
How to Create a Scatter Plot with 3 Variables in Excel
Learn how to create a scatter plot with 3 variables in Excel by preparing data, inserting a bubble chart, adding labels & customizing axes.
Read article
Blog
1285 articles
Excel Pro Tips
How to Reference Cell in Another Excel Sheet Dynamically
Learn how to reference a cell in another Excel sheet dynamically using INDIRECT, drop-downs, named ranges, VBA, CHOOSE, or INDEX functions.
Read article
Excel Pro Tips
How to Find Multiple Values in Excel (6 Effective Methods)
Learn how to find multiple values in Excel using FILTER, TEXTJOIN, INDEX-SMALL-IF, Advanced Filter, VBA macros, or Power Query methods.
Read article
Excel for Statistics
How to Create a Questionnaire in Excel (Online & Offline Methods)
This article explores what questionnaire is and how to create a questionnaire in Excel with Microsoft Forms and the built in Form feature.
Read article
Google Sheets Formulas
Currency Conversion Formula in Google Sheets (2 Examples)
Learn how to use a currency conversion formula in Google Sheets with GOOGLEFINANCE or automate conversions using Google Apps Script.
Read article
Excel Pro Tips
How to Change Case in Excel Without Formula (3 Different Ways)
Learn how to change case in Excel without formulas using VBA macros, Power Query, or Word’s Change Case tool for quick text formatting.
Read article
Excel Pro Tips
How to Convert Minutes to Hours and Minutes in Excel
Learn how to convert minutes to hours and minutes in Excel using time formatting, TEXT, INT & MOD functions, or VBA for quick conversion.
Read article
Excel Pro Tips
How to Combine Duplicate Rows and Sum the Values in Excel
Learn how to combine duplicate rows and sum values in Excel using Pivot Tables, SUMIFS, Power Query, or VBA for quick data management.
Read article
Google Sheets Formulas
How to Remove Comma in Google Sheets (3 Effective Ways)
Learn how to remove commas in Google Sheets using Find and Replace, the SUBSTITUTE function, or Apps Script for advanced automation.
Read article
Google Sheets Basics
How to Hide Rows Based on Cell Value in Google Sheets
Learn how to hide rows in Google Sheets based on cell values using filters, filter views, or Google Apps Script with an unhide option.
Read article
Excel VBA
How to Save Worksheet as New File with Excel VBA
Learn how to save a worksheet as a new file in Excel VBA, whether saving one sheet, all sheets separately, or only those with specific text.
Read article
Excel VBA
How to Close Workbook Without Saving in Excel VBA
Learn how to close a workbook without saving in Excel VBA by marking as saved, disabling prompts, or using the SaveChanges argument.
Read article