Spreadsheets Tutorials

Learn how to refresh your PivotTables manually, with keyboard shortcuts, or automatically in both Excel and Google Sheets.

Learn how to seamlessly integrate Tableau with Excel to transform static spreadsheets into powerful, interactive dashboards. Boost insights, streamline analysis, and improve your data-driven decisions.

Discover XMATCH, a powerful Excel function to find the relative position of an item that matches a specified value.

Discover how to perform a sensitivity analysis in Excel, a popular “what-if” method used to identify the most relevant inputs in a model outcome.

Learn about the various lookup functions in Excel and how they are applied through examples.

Learn to use Excel to calculate compound interest along with practical techniques and real-world applications to enhance your financial analysis skills.

Learn how to automate repetitive Excel tasks with Excel macros. Create, use, and manage macros to boost productivity and transform your data workflows.

Discover how Excel's INDIRECT() function transforms text into live references. Learn how to use it for dynamic worksheets, stable cell references, named ranges, and more.

Discover how Excel tables go beyond formatting with powerful features like structured references, automatic expansion, filtering, and integration with PivotTables and charts.

Learn how to activate Excel’s built-in dark mode and create a fully dark spreadsheet experience. Discover tips and workarounds for reducing eye strain and creating a workbook that looks nice.

Learn two reliable methods for applying PivotTable conditional formatting and avoid common pitfalls.

Learn how to unprotect an Excel sheet with and without a password.