Use Excel as your calculator - Microsoft Support
WEBUse Excel as your calculator. Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. Or use the AutoSum feature to quickly total a series of values without entering them manually in a formula. After you create a formula, you can copy it ...
Overview of diagnostic log files for Office - Microsoft Support
WEBWhen a user runs an Office app, such as Word or Excel, diagnostic information is collected and saved to log files on the user’s device. These log files contain information about the processes and components running in the application, and can help detect, diagnose, and fix issues and help make improvements to Office.
Analyze Data in Excel - Microsoft Support
WEBAnalyze Data in Excel empowers you to understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas. In addition, Analyze Data provides high …
Calculate multiple results by using a data table
WEBCalculate multiple results by using a data table. A data table is a range of cells in which you can change values in some of the cells and come up with different answers to a problem. A good example of a data table employs the PMT function with different loan amounts and interest rates to calculate the affordable amount on a home mortgage loan.
Create a PivotTable to analyze worksheet data - Microsoft Support
WEBHow to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.
Automatically number rows - Microsoft Support
WEBUse the ROW function to number rows. In the first cell of the range that you want to number, type =ROW (A1). The ROW function returns the number of the row that you reference. For example, =ROW (A1) returns the number 1. Drag the …
Write an equation or formula - Microsoft Support
WEBWrite an equation or formula. Insert built-in equation Write new equation Edit equations Ink equations. Select Insert > Equation or press Alt + =. Select the equation you need. See the ribbon for more Structures and Convert options. Use your finger, stylus, or mouse to write your equation.
Switch between relative, absolute, and mixed references
WEBPress F4 to switch between the reference types. The table below summarizes how a reference type updates if a formula containing the reference is copied two cells down and two cells to the right. Use absolute or relative cell references in formulas, or a mix of both.
Count numbers greater than or less than a number
WEBUse COUNTIF to count the number of cells that meet a specific criteria. For example, you are preparing a report and want to count how many sales invoices were greater or lesser than a particular value. Use the COUNTIF function to …
COUNTIF function - Microsoft Support
WEBUse COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest form, COUNTIF says: =COUNTIF (Where do you want to look?, What do you want to look for?) For example: =COUNTIF (A2:A5,"London") =COUNTIF (A2:A5,A4)
Using IF with AND, OR, and NOT functions in Excel
WEBIn Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)