Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
WEBIt's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE)
Round a number to the decimal places I want - Microsoft Support
WEBIf you don’t want unnecessary decimal places in cells because they cause ###### symbols to appear, or you don’t need accuracy down to the microscopic level, change the cell format to get the number of decimal places you want. Round a number to nearest major unit.
Excel video training - Microsoft Support
WEBA list of Excel training, from entry level to advanced skills, plus templates and other resources.
Open files from the File menu - Microsoft Support
WEBThe Open tab on the File menu shows a list of files you’ve recently opened, and it includes links to places where you commonly store files. Windows macOS. The Recent list shows the files that you opened recently from any of your devices. If this list gets unwieldy, you can remove files from it.
NORM.S.DIST function - Microsoft Support
WEBThe equation for the standard normal density function is: Example. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
Create a table in Excel - Microsoft Support
WEBCreate or delete an Excel table. Training: In Microsoft Excel, you can create a table to easily group and analyze data. Then you can quickly format the table and apply a design style. Watch this video to learn how.
Total the data in an Excel table - Microsoft Support
WEBYou can quickly total data in an Excel table by enabling the Total Row option, and then use one of several functions that are provided in a drop-down list for each table column. The Total Row default selections use the SUBTOTAL function, which allow you to include or ignore hidden table rows, however you can also use other functions.
Keyboard shortcuts in Excel - Microsoft Support
WEBThis article describes the keyboard shortcuts, function keys, and some other common shortcut keys in Excel for Windows. Notes: To quickly find a shortcut in this article, you can use the Search. Press Ctrl+F, and then type your search words. If an action that you use often does not have a shortcut key, you can record a macro to create one.
Convert an Excel table to a range of data - Microsoft Support
WEBTo convert a table into a range, right-click anywhere in a table, point to Table, and then click Convert to Range.
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.
Look up values in a list of data - Microsoft Support
WEBLook up data in Excel to find data in a list and verify that it's correct. Then, perform calculations or display results with the values returned. Use the VLOOKUP, HLOOKUP, INDEX, MATCH, and OFFSET functions to find related data in rows and columns in Excel.