Excel Pro Tips
How To Find Text in Range and Return Cell Reference in Excel
Learn how to find specific text in a range and return its cell reference in Excel using CELL, INDEX, MATCH, and ADDRESS functions.
Read article
Excel Pro Tips
555 articles
Excel Pro Tips
How to Convert Number to Date YYYYMMDD in Excel
Learn how to convert numbers to date format YYYYMMDD in Excel using formulas, Text to Columns, and custom number formatting techniques.
Read article
Excel Pro Tips
How To Merge Two Excel Sheets Based on One Column
Learn how to merge two Excel sheets based on one column using VLOOKUP, XLOOKUP, INDEX MATCH, and Power Query for seamless data integration.
Read article
Excel Pro Tips
How to Separate First, Middle & Last Names Using Excel Formula
Learn how to separate first, middle, and last names in Excel using formulas, Text to Columns, Flash Fill, and Find and Replace techniques.
Read article
Excel Pro Tips
How to Sort by Last Name in Excel (4 Quick Approaches)
Learn how to sort data by last name in Excel using Find and Replace, Text to Columns, formulas, and Flash Fill for various name types.
Read article
Excel Pro Tips
Calculate Years of Service In Excel (Including Days & Months)
Learn how to calculate years of service in Excel using DATEDIF, YEARFRAC, NETWORKDAYS, and other date functions for accurate results.
Read article
Excel Pro Tips
How to Calculate Percentage Increase or Decrease in Excel
Learn to calculate percentage increase or decrease in Excel, handle negative values, division by zero, and find absolute % changes easily.
Read article
Excel Pro Tips
How to Insert Page Break in Excel Between Rows (5 Easy Ways)
Learn how to insert page breaks in Excel between rows manually, with VBA, using subtotals, and how to remove them for better print layout.
Read article
Excel Pro Tips
How to Enable Share Workbook in Excel (with Custom Sharing)
Learn how to enable sharing workbooks in Excel, manage user access, compare changes, and use OneDrive for modern co-authoring seamlessly.
Read article
Excel Pro Tips
How to See Who Made Changes in Excel (5 Suitable Ways)
Learn how to see who made changes in Excel using version history, co-authoring, legacy track changes, and VBA for audit trails.
Read article
Excel Pro Tips
How to Compare Two Excel Sheets and Highlight Differences
Easily compare two Excel sheets and highlight differences using built-in features, formulas, or VBA for accurate data analysis.
Read article
Excel Pro Tips
How to Add Data Bars in Excel (with Customizations)
Learn how to add data bars in Excel using conditional formatting, customize them, and apply them to pivot tables and formulas.
Read article