Track your health and fitness goals in Excel - Microsoft Support
网页Just enter your age, height, weight, gender, activity level, and goal weight to calculate a daily calorie intake that's realistic and easy to achieve. > Calorie amortization schedule. Exercise planner. Plan your fitness training program and log …
Outline (group) data in a worksheet - Microsoft Support
网页If you have a list of data you want to group and summarize, you can create an outline of up to eight levels. Each inner level, represented by a higher number in the outline symbols, displays detail data for the preceding outer level, represented by a lower number in the outline symbols.
Create a forecast in Excel for Windows - Microsoft Support
网页When you create a forecast, Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. A forecast can help you predict things like future sales, inventory requirements, or consumer trends.
Export an Excel table to SharePoint - Microsoft Support
网页You can export data from an Excel table to a SharePoint list. When you export the list, Excel will create a new SharePoint list on the site. You can then work with the data on the site, just like you would for any other SharePoint list.
Define and use names in formulas - Microsoft Support
网页Define and use names in formulas. By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names. Windows macOS Web.
Automatically run a macro when opening a workbook
网页You might want a macro you recorded to run automatically when you open a specific workbook. The following procedure uses an example to show you how that works. You may also want to run macros automatically when Excel …
Change the color or style of a chart in Office - Microsoft Support
网页Click the chart you want to change. In the upper right corner, next to the chart, click Chart Styles . Click Color and pick the color scheme you want. Tip: Chart styles (combinations of formatting options and chart layouts) use the theme colors. To change color schemes, switch to a different theme.
COVARIANCE.S function - Microsoft Support
网页This article describes the formula syntax and usage of the COVARIANCE.S function in Microsoft Excel. Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets.
Manage your household budget in Excel - Microsoft Support
网页This Excel template can help you track your monthly budget by income and expenses. Input your costs and income, and any difference is calculated automatically so you can avoid shortfalls or make plans for any projected surpluses. Compare projected costs with actual costs to hone your budgeting skills over time.
Key Performance Indicators (KPIs) in Power Pivot - Microsoft …
网页Key performance indicators (KPIs) are visual measures of performance. Supported by a specific calculated field, a KPI is designed to help users quickly evaluate the current value and status of a metric against a defined target.
Excel specifications and limits - Microsoft Support
网页In Excel 2010, the maximum worksheet size is 1,048,576 rows by 16,384 columns. In this article, find all workbook, worksheet, and feature specifications and limits.