Excel Pro Tips
How to Extract Year from Date in Excel (4 Suitable Ways)
Learn how to extract the year from a date in Excel using YEAR, TEXT functions, cell formatting, and the Text to Columns feature.
Read article
Author & Spreadsheet Consultant
Shihab Shahriar
88 Articles PublishedPublishing since
Md. Shihab Uddin holds a Graduation in Crop Science and Technology and is pursuing a Postgraduate degree in Soil Science from the University of Rajshahi. With 4+ years of Excel and Google Sheets experience, he specializes in formulas, data cleaning, lookups, automation, VBA, formatting, and file management. He has authored 100+ in-depth Excel articles and is skilled in Power Automate, RPA, and Python. He enjoys creating efficient workflows and solving real-world data problems.
Editorial Review
Articles Published by Shihab Shahriar
Articles by Shihab Shahriar are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
Excel Pro Tips
Excel Formula If Date Is Greater Than Another Date
Learn how to use Excel formulas, IF function, TODAY, conditional formatting, and VBA to check if one date is greater than another.
Read article
Excel Pro Tips
How to Use COUNTIF for Partial Match in Excel (5 Examples)
Master Excel COUNTIF for partial matches. Learn to count substrings, patterns, wildcard text, and apply COUNTIFS for advanced cases.
Read article
Excel Pro Tips
How to Convert Binary Values to Decimal in Excel (4 Easy Ways)
Learn how to convert binary to decimal in Excel using BIN2DEC, DECIMAL, SUMPRODUCT formulas, and custom VBA functions step by step.
Read article
Excel Pro Tips
How to Remove Circular Reference in Excel (with Quick Steps)
Learn how to remove circular reference in Excel by finding affected cells, tracing precedents, correcting formulas, and applying fixes.
Read article
Excel Pro Tips
How to Clear Print Area in Excel (5 Quick Tricks)
Learn how to clear print area in Excel using the Page Layout tab, Name Manager, shortcuts, Page Setup dialog box or VBA macros.
Read article
Excel Pro Tips
How to Recover Previous Version of Excel File (4 Possible Ways)
Learn how to recover previous version of Excel file using Version History, Manage Workbook, Recover Unsaved Workbooks or File History options.
Read article
Excel Pro Tips
How to Fix Unsaved Excel File Not in Recovery Issue (5 Solutions)
Fix unsaved Excel file not in recovery by checking Excel Options, TEMP files, Recycle Bin, OneDrive Recycle Bin, or using Document Recovery.
Read article
![[Fixed] This Workbook Was Opened in Read Only Mode](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-this-workbook-was-opened-in-read-only-mode-1-db78c0aa.webp)
Excel Pro Tips
[Fixed] This Workbook Was Opened in Read Only Mode
Fix 'This workbook was opened in read-only mode' in Excel by removing read-only settings, editing file properties & disabling Protected View.
Read article
Excel Pro Tips
How to Highlight Active Row in Excel (3 Useful Methods)
Learn how to highlight the active row in Excel using conditional formatting, VBA macros, or combining defined names with VBA for automation.
Read article
Excel Pro Tips
How to Unlock Excel Sheet for Editing (2 Effective Ways)
Learn how to unlock an Excel sheet for editing using a password or by applying the XML editing method when the password is unavailable.
Read article
Excel Pro Tips
How to Insert Digital Signature in Excel (6 Easy Ways)
Learn how to insert a digital signature in Excel using signature lines, invisible signatures, handwritten or typed styles, or PDF attachments.
Read article