Excel How-To Guides
Step-by-step spreadsheet guides for formulas, cleanup, charts, pivot tables, dashboards, templates, and reporting.
Choose a page below for the full explanation, examples, steps, and related tips.
How to use Excel formulas: Step-by-Step GuideHow to write your first formula in Excel: Step-by-Step GuideHow to copy and paste formulas in Excel: Step-by-Step GuideHow to copy a formula down a column: Step-by-Step GuideHow to lock a cell reference in Excel: Step-by-Step GuideHow to use dollar signs in Excel formulas: Step-by-Step GuideHow to show formulas in Excel: Step-by-Step GuideHow to remove formulas but keep values: Step-by-Step GuideHow to convert formulas to values: Step-by-Step GuideHow to audit formulas in Excel: Step-by-Step GuideHow to trace precedents in Excel: Step-by-Step GuideHow to trace dependents in Excel: Step-by-Step GuideHow to use named ranges in Excel: Step-by-Step GuideHow to create a dynamic named range: Step-by-Step GuideHow to create a dropdown list in Excel: Step-by-Step GuideHow to create dependent dropdown lists in Excel: Step-by-Step GuideHow to remove duplicates in Excel: Step-by-Step GuideHow to find duplicates in Excel: Step-by-Step GuideHow to highlight duplicates in Excel: Step-by-Step GuideHow to split text into columns in Excel: Step-by-Step GuideHow to combine first and last name in Excel: Step-by-Step GuideHow to clean messy data in Excel: Step-by-Step GuideHow to remove extra spaces in Excel: Step-by-Step GuideHow to remove blank rows in Excel: Step-by-Step GuideHow to fill blank cells in Excel: Step-by-Step GuideHow to sort data in Excel: Step-by-Step GuideHow to filter data in Excel: Step-by-Step GuideHow to create a table in Excel: Step-by-Step GuideHow to use structured references in Excel: Step-by-Step GuideHow to freeze a row in Excel: Step-by-Step GuideHow to freeze multiple columns in Excel: Step-by-Step GuideHow to merge cells in Excel: Step-by-Step GuideHow to unmerge cells in Excel: Step-by-Step GuideHow to wrap text in Excel: Step-by-Step GuideHow to autofit columns in Excel: Step-by-Step GuideHow to create a chart in Excel: Step-by-Step GuideHow to create a line chart in Excel: Step-by-Step GuideHow to create a bar chart in Excel: Step-by-Step GuideHow to create a combo chart in Excel: Step-by-Step GuideHow to add a secondary axis in Excel: Step-by-Step GuideHow to create a pivot table in Excel: Step-by-Step GuideHow to refresh a pivot table in Excel: Step-by-Step GuideHow to group dates in a pivot table: Step-by-Step GuideHow to add calculated fields in a pivot table: Step-by-Step GuideHow to create a slicer in Excel: Step-by-Step GuideHow to create a dashboard in Excel: Step-by-Step GuideHow to build a KPI dashboard in Excel: Step-by-Step GuideHow to calculate percentages in Excel: Step-by-Step GuideHow to calculate percentage increase in Excel: Step-by-Step GuideHow to calculate age in Excel: Step-by-Step GuideHow to calculate days between dates in Excel: Step-by-Step GuideHow to calculate working days in Excel: Step-by-Step GuideHow to calculate compound interest in Excel: Step-by-Step GuideHow to calculate loan payments in Excel: Step-by-Step GuideHow to calculate weighted average in Excel: Step-by-Step GuideHow to calculate CAGR in Excel: Step-by-Step GuideHow to create a budget spreadsheet: Step-by-Step GuideHow to create an invoice in Excel: Step-by-Step GuideHow to create a timesheet in Excel: Step-by-Step GuideHow to create an inventory tracker in Excel: Step-by-Step GuideHow to create a project tracker in Excel: Step-by-Step GuideHow to create a Gantt chart in Excel: Step-by-Step GuideHow to protect a worksheet in Excel: Step-by-Step GuideHow to password protect an Excel file: Step-by-Step GuideHow to print an Excel sheet on one page: Step-by-Step GuideHow to save Excel as PDF: Step-by-Step GuideHow to import CSV into Excel: Step-by-Step GuideHow to use Flash Fill in Excel: Step-by-Step GuideHow to use conditional formatting in Excel: Step-by-Step GuideHow to use formulas in conditional formatting: Step-by-Step GuideHow to compare two columns in Excel: Step-by-Step GuideHow to find missing values in Excel: Step-by-Step GuideHow to remove leading zeros in Excel: Step-by-Step GuideHow to keep leading zeros in Excel: Step-by-Step GuideHow to change date format in Excel: Step-by-Step GuideHow to create monthly reports in Excel: Step-by-Step GuideHow to use Power Query basics in Excel: Step-by-Step GuideHow to connect Excel to Power BI: Step-by-Step GuideHow to prepare Excel data for Power BI: Step-by-Step GuideHow to export Power BI data to Excel: Step-by-Step Guide