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.

Guides

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.

Windows 11

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.

Formulae

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.

Windows 11

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.

Windows 11

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.

Guides

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.

Guides

How to Fix Excel Freezing When Printing: Easy Guide

Fix Excel freezing when printing with these easy steps. Update drivers, disable add-ins, repair Office, and more. Get your spreadsheets printing again fast.