Create and share a Dashboard with Excel and Microsoft Groups
A dashboard is a visual representation of key metrics that allow you to quickly view and analyze your data in one place. Dashboards not only provide consolidated data views, but a self-service business intelligence opportunity, where users are able to filter the data to display just what’s important to them.
OR function - Microsoft Support
Technical Details. The function returns TRUE if any of its arguments evaluate to TRUE, and returns FALSE if all of its arguments evaluate to FALSE. One common use for the function is to expand the usefulness of other functions that perform logical tests.
Overview of Excel tables - Microsoft Support
To quickly create a table in Excel, do the following: Select the cell or the range in the data. Select Home > Format as Table. Pick a table style. In the Format as Table dialog box, select the checkbox next to My table as headers if you want the first row of the range to be the header row, and then click OK.
Microsoft 365 Quick Starts - Microsoft Support
Training: Get started quickly on all of your favorite Microsoft 365 apps with our popular Quick Start guides.
Active content types in your files - Microsoft Support
This article lists types of active content that can be blocked by the settings in Trust Center and which, when present, will cause the display of a message bar upon opening the document. When active content is blocked, a Security Warning appears.
Manage workbook links - Microsoft Support
Description of workbook link management and storage in Excel. Linking to other workbooks is a very common task in Excel, but sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist.
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. Formulas in-depth.
Present your data in a bubble chart - Microsoft Support
In addition to the x values and y values that are plotted in a scatter chart, a bubble chart plots x values, y values, and z (size) values. You can use a bubble chart instead of a scatter chart if your data has three data series that each contain a set of values.
What happens when you sign out of Office - Microsoft Support
If you still want to sign out of your Office app, here's what happens: Your account's Office license is removed, and you can no longer create or edit files. Your recent files list is no longer shown. Your custom settings, such as your Office background and theme, are removed.
File formats that are supported in Excel - Microsoft Support
You can save an Excel file in another file format by clicking the File > Save As. The file formats that are available in the Save As dialog box vary, depending on what type of sheet is active (a worksheet, chart sheet, or other type of sheet).
Available chart types in Office - Microsoft Support
Create a chart with recommended charts. This article describes the different types of charts in Excel and other Office programs. Read a description of the available chart types in Office.