Tutorials, templates, videos, functions, formulas, and expert guides to help you work smarter with Google Docs.
Pivot Tables are Excel’s fastest way to summarize large lists into totals, counts, averages, and breakdowns by category. Instead of building multiple formulas or manually filtering and adding, you can drag fields into rows, columns, and values to create an instant...
XLOOKUP is Microsoft’s modern replacement for legacy lookup functions like VLOOKUP and HLOOKUP. It was introduced to address long-standing limitations that made older lookup formulas fragile, hard to maintain, and error-prone in real-world spreadsheets. VLOOKUP still...
Outlook sharing looks straightforward—until your users switch devices. In 2026, the experience differs across Classic Outlook for Windows, New Outlook for Windows, and Outlook for macOS. On top of that, the way admins configure access also matters: giving permissions...
Dropdown lists are one of the most effective ways to control data entry in Excel. Instead of allowing users to type anything into a cell, you can limit entries to a predefined set of values such as statuses, departments, categories, or approval states. This improves...
If you work with Excel regularly, you’ve probably used AVERAGE to calculate a simple mean. But in real-world spreadsheets, you often need conditional averages—for example, average work hours for employees who logged overtime, or average hours for a specific...