Excel Pro Tips
How to Remove Year from Date in Excel (7 Effective Ways)
Learn 7 ways to remove the year from dates in Excel, including custom formatting, formulas, Flash Fill, and VBA macros.
Read article
Blog
1285 articles
Excel Pro Tips
How to Remove Numbers from a Cell in Excel (10 Simple Ways)
Learn how to remove numbers from a cell in Excel using Flash Fill, Find & Replace, SUBSTITUTE, formulas, Power Query, or VBA methods.
Read article
Google Sheets Intermediate Tutorials
How to Filter Duplicates in Google Sheets (4 Easy Methods)
Learn how to filter duplicates in Google Sheets using FILTER with COUNTIF, UNIQUE, conditional formatting, or Google Apps Script.
Read article
Google Sheets Basics
How to Remove Hyperlinks in Google Sheets (5 Easy Ways)
Learn how to remove hyperlinks in Google Sheets using the context menu, link preview, formulas, paste special, or Apps Script.
Read article
Google Sheets Basics
How to Change Negative Numbers to Positive in Google Sheets
Learn how to change negative numbers to positive in Google Sheets using ABS, IF, -1 multiplication, ARRAYFORMULA, Find and Replace.
Read article
Excel Pro Tips
How to Convert Notepad to Excel with Columns
Learn how to convert Notepad to Excel with columns using copy-paste, Text Import Wizard, delimiters, fixed width, or Power Query features.
Read article
Excel Pro Tips
How to Protect Excel Workbook from Editing (6 Useful Tricks)
Learn how to protect an Excel workbook from editing using passwords, worksheet protection, read-only mode, and view-only sharing options.
Read article
Excel Pro Tips
How to Reference Cell by Row and Column Number in Excel
Learn how to reference cells by row and column number in Excel using ROW, COLUMN, ADDRESS, INDIRECT, INDEX, and R1C1-style formulas.
Read article
Excel Pro Tips
How to Trace Dependents in Excel (4 Suitable Methods)
Learn how to trace dependents in Excel using the built-in feature, keyboard shortcuts, multiple trace clicks, and VBA macros.
Read article
Excel Pro Tips
How to Insert Multiple Bullet Points in an Excel Cell
Learn how to insert multiple bullet points in an Excel cell using Alt+7, symbols with line breaks, CHAR(149), or by copying from Word.
Read article
Excel Pro Tips
How to Insert Multiple Page Breaks in Excel (4 Easy Tricks)
Learn how to insert multiple page breaks in Excel manually, using context menus, VBA macros, or the Subtotal feature for grouped data.
Read article
Excel Pro Tips
How to Compress Excel File for Email (6 Effective Ways)
Learn how to compress Excel files for email using ZIP, .xlsb format, online tools, picture compression, and by removing unused content.
Read article