Vaishvi Desai

Learn how to COUNTIF in Excel with multiple criteria using COUNTIFS, operators, SUM with COUNTIF for OR logic, and SUMPRODUCT, with worked examples.

Learn how to write scientific notation in Excel by typing E, using the Scientific format, a custom engineering format, or the TEXT function.

Move columns in Excel without overwriting data using Shift + drag, Insert Cut Cells, a left-to-right sort, or the CHOOSECOLS function.

Unprotect an Excel sheet or workbook with the password, or remove protection without it using the ZIP and XML trick or Google Sheets.

Move an Excel chart to its own chart sheet, to another worksheet, or to a new worksheet using the Move Chart dialog or cut and paste.

Split text in one Excel cell into separate rows with TEXTSPLIT, Power Query, or Text to Columns plus Transpose. Step-by-step examples with screenshots.

Learn how to find the range in Excel with MAX and MIN, then get the range of filtered rows with SUBTOTAL or by group with MAXIFS and MINIFS.

Learn how to sum a column based on another column value in Excel using SUMIF, SUMIFS, and simple formulas with clear, practical examples.

Learn how to use XLOOKUP in Excel with two workbooks to find and return matching data across separate Excel files quickly and accurately.