Skip to content
- Data Analysis in Excel: Methods, Steps, and ExamplesYes—Excel can analyze data by cleaning and organizing it, calculating summaries with formulas, and revealing patterns with PivotTables and charts. A practical…How-to basics
- Excel Data Analysis Not Working? Troubleshooting and FixesIf Excel’s Data Analysis command is missing or will not run, enable the Analysis ToolPak: in Windows Excel, choose File > Options…Errors & fixes
- Excel Solver: Find a Target Sum with Changing CellsTo make a set of numbers add up to a target in Excel, create a total formula, use Solver to set that…How-to basics
- How to Set Up Solver in ExcelTo set up Solver in Excel for Microsoft 365 on Windows, enable the Solver Add-in from File > Options > Add-ins, then…How-to basics
- Solver in Excel: How to Enable and Set It UpTo put Solver in Excel for Microsoft 365 on Windows, enable the Solver Add-in under File > Options > Add-ins, then select…How-to basics
- How to Open Solver in Excel and Enable the Solver Add-inIn Excel for Microsoft 365 on Windows, open Solver by going to File > Options > Add-ins, choosing Excel Add-ins beside Manage,…How-to basics
- Install Solver in Excel: A Step-by-Step Setup GuideTo install Solver in Excel for Microsoft 365 on Windows, open File > Options > Add-ins, choose Excel Add-ins beside Manage, select…How-to basics
- How to Find a Z-Score Using Excel Solver Step by StepTo find a z-score from a cumulative probability, put a starting z value in one cell, calculate its standard normal cumulative probability…How-to basics
- Find Solver Parameters in Excel and Understand Each OneTo find Solver parameters in Excel for Microsoft 365 on Windows, open the worksheet you want to optimize, select Data > Solver,…How-to basics
- How to Enable Solver in Excel on Windows and MacTo enable Solver in Excel for Microsoft 365 on Windows, choose File > Options > Add-ins, select Excel Add-ins beside Manage, click…How-to basics
- Excel Goal Seek Shortcut: Open It, Set a Target, SolveIn Excel for Microsoft 365 on Windows, open Goal Seek by pressing Alt, then A, W, and G in sequence. You can…How-to basics
- Flash Fill in Excel: Keyboard Shortcut and How to Use ItTo use Flash Fill in Excel for Microsoft 365 on Windows, type one example of the result you want in the column…How-to basics
- Excel Autofill Keyboard Shortcuts for Fill Down and RightTo autofill a selected range in Excel, include the source cell and the cells you want to fill, then press Ctrl+D to…Formulas & functions
- Autofill in Excel From Another Cell: A Practical GuideTo autofill from another cell in Excel, select the cell you want to copy, then drag its fill handle over the destination…How-to basics
- Excel Autofill Based on Cell Input: Formulas That WorkTo autofill related information when someone enters a value in Excel, put a lookup formula in the result cell and fill it…Formulas & functions
- How to Autofill in Excel From the Cell Directly AboveTo fill cells from the one above in Excel, select the source cell and the cells below it, then press Ctrl+D on…How-to basics
- Excel Data Validation Source: How to Find ItTo find a dropdown list’s source in Excel for Microsoft 365 on Windows, select a cell with the dropdown, open Data >…How-to basics
- Excel Data Validation With Color: Step-by-Step GuideTo add color to Excel data validation, create a drop-down list with Data > Data Validation, then use Home > Conditional Formatting…How-to basics
- Excel Data Validation Drop-Down: Create and Edit ListsTo create a drop-down list in Excel for Microsoft 365 on Windows, select the cell or cells, choose Data > Data Validation…How-to basics
- Add to a Data Validation List in Excel: Step-by-StepTo add an option to an Excel drop-down list, select a cell that uses the list, open Data > Data Validation, and…How-to basics
- Excel Data Validation: Copy Rules Quickly and SafelyTo copy only data validation in Excel for Microsoft 365 on Windows, copy a cell that has the rule, select the destination…How-to basics
- Find and Replace in Excel: Select Data FirstTo find and replace text in only part of an Excel worksheet, select the cells or range first, press Ctrl+H, enter the…How-to basics
- Extract Text in an Excel Cell: Formulas and Steps That WorkTo extract part of a cell’s text, use a formula such as TEXTBEFORE for text before a separator, TEXTAFTER for text after…Formulas & functions
- Remove Spaces in Excel: The Shortcut and Right MethodTo remove every ordinary space from selected cells in Excel for Microsoft 365 on Windows, select the cells, press Ctrl+H, enter one…Formulas & functions
- Remove Spaces in One Excel Cell: Formula and StepsTo remove every ordinary space from one Excel cell, enter =SUBSTITUTE(A1," ","") in a nearby blank cell, replacing A1 with the cell…Formulas & functions
- Compare Two Columns of Names in Excel: Find MatchesTo check whether names in one list appear anywhere in another, put the first list in A2:A6 and the second in B2:B6,…How-to basics
- Compare Two Columns in Excel for DifferencesTo compare two Excel columns row by row, put a comparison formula in a third column and fill it down. With the…How-to basics
- Can You Import Excel and CSV Files Into QuickBooks?Yes. QuickBooks can import Excel and CSV files for certain kinds of data, but the accepted format depends on whether you use…How-to basics
- Excel Power Query: Import Multiple CSV FilesTo import and combine multiple CSV files in Excel for Microsoft 365 on Windows, put the files in one folder, then select…How-to basics
- Excel CSV Import Problems? Fix Dates, Delimiters & MoreFor most Excel CSV import problems, avoid opening the file by double-clicking it. In Excel for Microsoft 365 on Windows, choose Data…Errors & fixes