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