Excel video training - Microsoft Support
网页A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Overview of Excel tables - Microsoft Support
网页Excel has some features that enable you to work efficiently with your table data: Using structured references Instead of using cell references, such as A1 and R1C1, you can use structured references that reference table names in a formula. For more information, see Using structured references with Excel tables.
Using IF with AND, OR, and NOT functions in Excel
网页Here are overviews of how to structure AND, OR and NOT functions individually. When you combine each one of them with an IF statement, they read like this: AND – =IF(AND(Something is True, Something else is True), Value if True, Value if False)
Calculate 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 conditional formulas - Microsoft Support
网页You can use the AND, OR, NOT, and IF functions to create conditional formulas. For example, the IF function uses the following arguments. Formula that uses the IF function. logical_test: The condition that you want to check. value_if_true: The value to return if the condition is True.
Get creative with 3D models - Microsoft Support
网页Change how your 3D models look in Office. When you insert a 3D model into your Office file you'll get a contextual tab on the ribbon under 3D Model Tools called Format. On the format tab there are some handy controls to help you customize how …
Use nested functions in a formula - Microsoft Support
网页Using a function as one of the arguments in a formula that uses a function is called nesting, and we’ll refer to that function as a nested function. For example, by nesting the AVERAGE and SUM function in the arguments of the IF function, the following formula sums a set of numbers (G2:G5) only if the average of another set of numbers (F2:F5 ...
Get started with Python in Excel - Microsoft Support
网页Start using Python. To begin using Python in Excel, select a cell and on the Formulas tab, select Insert Python. This tells Excel that you want to write a Python formula in the selected cell. Or use the function =PY in a cell to enable Python.
Basic tasks in Excel - Microsoft Support
网页Get started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..
Analyze Data in Excel - Microsoft Support
网页Analyze 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-level visual summaries, trends, and …
Overview of formulas in Excel - Microsoft Support
网页If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour. With real-world examples and helpful visuals, you’ll be able to Sum, Count, Average, and Vlookup like a pro.