Vaishvi Desai

Learn how to filter a pivot table in Excel using a custom list with simple helper column methods, formulas, and slicers.

Learn how to disable the Research pane in Excel, stop Smart Lookup popups, and prevent Alt+Click from opening it in Excel 365, 2019, and 2016.

Learn how to use conditional formatting with multiple conditions in Excel to highlight data, apply rules, and improve reports using simple steps and formulas.

Learn how to calculate the number of weeks between two dates in Excel using simple formulas, full weeks, working weeks, and rounding methods.

Learn the best Excel formulas to extract numbers from text. Simple to advanced methods for cleaning data quickly. Fix messy spreadsheets.

Learn 6 easy ways to insert the degree symbol (°) in Excel using shortcuts, formulas, and formatting for temperatures and angles.

Learn how to format phone numbers in Excel using custom formats, formulas, and Flash Fill. Fix leading zeros and clean messy data.

Learn how to use XLOOKUP to find the closest match in Excel. Step-by-step examples for next smaller and next larger values.

Learn the simple Excel formula to reduce a number by a percentage. Step-by-step guide with examples for discounts, sale prices, and bulk calculations.

Learn how to add live formulas in text boxes in Excel using cell linking, VBA, and Camera tool. Create dynamic dashboards that update automatically!