Repair a corrupted workbook - Microsoft Support
To recover as much of the workbook data as possible, pick Repair. If Repair isn’t able to recover your data, pick Extract Data to extract values and formulas from the workbook. If neither …
What to do if a data set is too large for the Excel grid
To help prevent reaching an Excel limit, make sure you’re using the .xlsx format instead of the .xls format to take advantage of the much larger limit. If you know your data set exceeds the .xlsx …
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, …
Reduce the file size of your Excel spreadsheets - Microsoft Support
If the file size of your spreadsheet is too large, try the following tips to make it more manageable. You can reduce your file size by saving your spreadsheet as a binary workbook (.xslb) instead …
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
How to correct a #N/A error in the VLOOKUP function
Solution: You can try to fix this by adjusting your VLOOKUP to reference the correct column. If that’s not possible, then try moving your columns.
Automate tasks with the Macro Recorder - Microsoft Support
To automate a repetitive task, you can record a macro with the Macro Recorder in Microsoft Excel. Imagine you have dates in random formats and you want to apply a single format to all …
Add or remove add-ins in Excel - Microsoft Support
Add-ins provide optional commands and features for Microsoft Excel. By default, add-ins are not immediately available in Excel, so you must first install and (in some cases) activate these add …
Edit titles or data labels in a chart - Microsoft Support
In PivotChart reports, the following procedures reestablish links between data labels and source data (not worksheet cells). On a chart, click the chart or axis title that you want to link to a …
Load the Solver Add-in in Excel - Microsoft Support
The Solver Add-in is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel. To use the Solver Add-in, however, you first need to load it in Excel. …
Tips for improving Excel's performance - Microsoft Support
We've again made substantial performance improvements to Aggregation functions (SUMIFS, COUNTIFS, AVERAGEIFS, etc.), RealtimeData (RTD), and lots more for significant decreases …