Spreadsheets Tutorials

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.

Explore conditional formatting in Excel with simple to advanced examples and their best practices.

Learn the statistical concept of correlation, and follow along in calculating and interpreting correlations for a sample dataset, in a step-by-step tutorial.

Calculating the coefficient of variation in Excel is a straightforward process: we divide STDEV.P by AVERAGE.

A beginner-friendly, comprehensive tutorial on performing Monte Carlo Simulation in Microsoft Excel, along with examples, best practices, and advanced techniques.

A beginner-friendly, comprehensive tutorial on understanding Confidence Interval calculations in Microsoft Excel.