All articles
Blog
Every tutorial on the site, newest first. Looking for something specific? Use the search, or start from a topic: formulas, shortcuts, Pivot Tables, VBA or guides.
How to Unprotect an Excel Sheet (3 Easy Ways)
Unprotect an Excel sheet or workbook with the password, or remove protection without it using the ZIP and XML trick or Google Sheets.
How to Move a Chart to a New Sheet in Excel (3 Easy Ways)
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.
How to Split Text into Multiple Rows in Excel (3 Easy Ways)
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.
How to Find the Range in Excel (3 Easy Formulas)
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.
How to Sum a Column Based on Another Column Value in Excel?
Learn how to sum a column based on another column value in Excel using SUMIF, SUMIFS, and simple formulas with clear, practical examples.
How to Change Administrator Account in Windows 11?
Learn how to change administrator account in Windows 11 using Settings, Control Panel, netplwiz, and Command Prompt with easy steps.
How to Use XLOOKUP in Excel With Two Workbooks: Easy Guide
Learn how to use XLOOKUP in Excel with two workbooks to find and return matching data across separate Excel files quickly and accurately.
How to Find WiFi Password on Windows 11?
Learn how to find your WiFi password on Windows 11 using Settings, Control Panel, Command Prompt, PowerShell, or your router.
How to Take a Screenshot on Windows 11: Easy Guide
Learn how to take a screenshot on Windows 11 using Snipping Tool, PrtScn, keyboard shortcuts, and automatic screenshot saving.
How to Combine Two Columns in Excel?
Learn how to combine two columns in Excel using &, CONCAT, TEXTJOIN, and Flash Fill. Follow simple step by step methods to merge data quickly and accurately.