Skip to main content

Microsoft Excel

Microsoft Excel Articles

Excel is a spreadsheet program that organizes data into rows and columns, making it useful for tracking information, doing calculations, and creating reports. Whether you're managing a household budget, organizing a work project, or analyzing sales numbers, Excel handles tasks that would be tedious to do by hand. Most people use Excel at some point—either at work, school, or home—but many get stuck on specific features or workflows.

The articles here cover the practical questions that come up when you're actually using Excel: how to build a basic spreadsheet, format cells so data looks right, use formulas to do math automatically, sort and filter information to find what you need, and fix common problems that stop you from finishing your work.

Microsoft Excel

100 articles

Microsoft ExcelHow to Insert and Use Checkboxes in ExcelRead more →Microsoft ExcelHow to Calculate Age in Excel Using Formulas and FunctionsRead more →Microsoft ExcelHow to Calculate the Average of Numbers in ExcelRead more →Microsoft ExcelHow to Calculate Percentage Change in ExcelRead more →Microsoft ExcelHow to Calculate Standard Deviation in ExcelRead more →Microsoft ExcelHow to Calculate Variance in Excel Using Built-In FormulasRead more →Microsoft ExcelHow to Calculate a Weighted Average in ExcelRead more →Microsoft ExcelHow to Create a Bell Curve in Excel Using Your Own DataRead more →Microsoft ExcelHow to Turn Your Data Into an Excel Table in 5 StepsRead more →Microsoft ExcelHow to Set Up a Database in Excel Using Tables and FormulasRead more →Microsoft ExcelHow to Create a Drop-Down List in ExcelRead more →Microsoft ExcelHow to Set Up and Use Filters in ExcelRead more →Microsoft ExcelHow to Create a Histogram in Excel in Five StepsRead more →Microsoft ExcelHow to Merge and Center Cells in ExcelRead more →Microsoft ExcelHow to Calculate a Weighted Average in ExcelRead more →Microsoft ExcelHow to Calculate Correlation Coefficient in ExcelRead more →Microsoft ExcelHow to Calculate Percent Change in ExcelRead more →Microsoft ExcelHow to Calculate Percentage Change in ExcelRead more →Microsoft ExcelHow to Lock an Excel File So Others Can't Edit ItRead more →Microsoft ExcelHow to Sort a Pivot Table in ExcelRead more →Microsoft ExcelHow to Add a Trend Line or Reference Line to an Excel ChartRead more →Microsoft ExcelHow to Add a Link to ExcelRead more →Microsoft ExcelHow to Record and Run a Macro in ExcelRead more →Microsoft ExcelAdd a Month to Any Date in Excel With a Single FormulaRead more →Microsoft ExcelThe Fastest Way to Add Rows in ExcelRead more →Microsoft ExcelHow to Insert a New Row in ExcelRead more →Microsoft ExcelHow to Insert a New Row in ExcelRead more →Microsoft ExcelHow to Add a Second Axis to an Excel ChartRead more →Microsoft ExcelAdding a Second Vertical Axis to Your Excel ChartRead more →Microsoft ExcelHow to Add a New Sheet Tab in ExcelRead more →Microsoft ExcelHow to Add and Format Text Boxes in ExcelRead more →Microsoft ExcelHow to Insert a Checkmark or Tick Symbol in ExcelRead more →Microsoft ExcelHow to Add a Title to Your Excel SpreadsheetRead more →Microsoft ExcelHow to Add a Dollar Sign to a Number in ExcelRead more →Microsoft ExcelHow to Add a Total Row in ExcelRead more →Microsoft ExcelHow to Add a Watermark in ExcelRead more →Microsoft ExcelHow to Add an Equation to Your Excel GraphRead more →Microsoft ExcelHow to Add Error Bars to Your Excel ChartsRead more →Microsoft ExcelHow to Write Exponents in Excel Formulas and CellsRead more →Microsoft ExcelHow to Filter Data in Excel So You See Only What You NeedRead more →Microsoft ExcelHow to Add Page Numbers to Your Excel SpreadsheetRead more →Microsoft ExcelHow to Password-Protect Your Excel FileRead more →Microsoft ExcelHow to Password-Protect Your Excel Files and SheetsRead more →Microsoft ExcelHow to Password-Protect an Excel FileRead more →Microsoft ExcelHow to Password-Protect Your Excel FileRead more →Microsoft ExcelHow to Insert a PDF Into an Excel SpreadsheetRead more →Microsoft ExcelHow to Add Multiple Cells Together in ExcelRead more →Microsoft ExcelHow to Plot Multiple Data Series on One Excel ChartRead more →Microsoft ExcelHow to Add Your Signature to Excel FilesRead more →Microsoft ExcelHow to Add Your Signature to an Excel FileRead more →Microsoft ExcelHow to Add a Checkmark or Tick Mark in ExcelRead more →Microsoft ExcelAdding and Calculating Time in ExcelRead more →Microsoft ExcelHow to Add a Title to Your Excel SpreadsheetRead more →Microsoft ExcelHow to Add Up Columns in Excel Using SUM and Other MethodsRead more →Microsoft ExcelHow to Use Calculation Styles in Excel to Control When Formulas UpdateRead more →Microsoft ExcelHow to Calculate Percent Increase in ExcelRead more →Microsoft ExcelHow to Calculate Standard Deviation in Excel Using STDEV and STDEV.SRead more →Microsoft ExcelHow to Calculate Someone's Age in Excel Using DD/MM/YYYY DatesRead more →Microsoft ExcelHow to Calculate Someone's Age in Excel Using Their Birth DateRead more →Microsoft ExcelCalculate Someone's Age in Excel Using Their Birth DateRead more →Microsoft ExcelHow to Calculate an Average in Excel Using AVERAGE and Other MethodsRead more →Microsoft ExcelHow to Find the Average of Numbers in ExcelRead more →Microsoft ExcelHow to Calculate Average Percentage in ExcelRead more →Microsoft ExcelHow to Find the Average of Numbers in ExcelRead more →Microsoft ExcelHow to Calculate Someone's Age or Days Until Their Birthday in ExcelRead more →Microsoft ExcelHow to Calculate Business Days Between Two Dates in ExcelRead more →Microsoft ExcelCount Characters in Excel With LEN and Other FormulasRead more →Microsoft ExcelHow to Calculate Coefficient of Variation in ExcelRead more →Microsoft ExcelHow to Find the Number of Days Between Two Dates in ExcelRead more →Microsoft ExcelCount How Often Values Repeat in Excel With the FREQUENCY FunctionRead more →Microsoft ExcelHow to Calculate Growth Percentage in ExcelRead more →Microsoft ExcelHow to Calculate Hours in ExcelRead more →Microsoft ExcelHow to Calculate IQR in Excel Using Quartile FunctionsRead more →Microsoft ExcelFinding the Middle Value in Excel with the MEDIAN FunctionRead more →Microsoft ExcelHow to Find the Number of Days Between Two Dates in ExcelRead more →Microsoft ExcelHow to Build and Use Formulas in Excel SpreadsheetsRead more →Microsoft ExcelFinding and Flagging Outliers in Your Excel DataRead more →Microsoft ExcelHow to Calculate Percent Difference in ExcelRead more →Microsoft ExcelHow to Calculate Percent Increase in ExcelRead more →Microsoft ExcelFinding What Percentage One Number Is of Another in ExcelRead more →Microsoft ExcelHow to Calculate What Percentage One Number Is of Another in ExcelRead more →Microsoft ExcelHow to Calculate R-Squared in Excel to Measure How Well Your Data FitsRead more →Microsoft ExcelHow to Find the Highest and Lowest Values in Excel Using the Range FunctionRead more →Microsoft ExcelHow to Run Regression Analysis in ExcelRead more →Microsoft ExcelHow to Find the Average of Numbers in ExcelRead more →Microsoft ExcelFinding the Middle Value in Excel With the MEDIAN FunctionRead more →Microsoft ExcelHow to Calculate Slope in Excel Using the SLOPE Function and Manual MethodsRead more →Microsoft ExcelHow to Calculate Z-Scores in Excel Using the STANDARDIZE FunctionRead more →Microsoft ExcelHow to Add Up Numbers in Excel Using SUM and Other MethodsRead more →Microsoft ExcelHow to Calculate Variance in Excel Using Built-In FormulasRead more →Microsoft ExcelHow to Calculate Variation in Excel Using Standard Deviation and VarianceRead more →Microsoft ExcelHow to Calculate a Weighted Mean in ExcelRead more →Microsoft ExcelHow to Edit or Replace a Dropdown List in ExcelRead more →Microsoft ExcelHow to Change the Date Format in ExcelRead more →Microsoft ExcelHow to Change a Legend Name in Excel ChartsRead more →Microsoft ExcelFinding and Removing Duplicate Entries in ExcelRead more →Microsoft ExcelHow to Build a Bridge Chart in Excel to Show Changes Between Two PointsRead more →Microsoft ExcelHow to Turn Your Excel Data Into a Chart in 5 StepsRead more →Microsoft ExcelHow to Turn Your Excel Data Into a Chart in Five StepsRead more →Microsoft ExcelHow to Add Checkboxes to Excel SpreadsheetsRead more →