Airport West | search
Click here to view Airport West news from 60+ newspapers.
Bookmark or Share- Explode or expand a pie chart - Microsoft SupportExplode or expand a pie chart. Applies To. To make parts of a pie chart stand out without changing the underlying data, you can pull out an individual slice, pull the whole pie apart, or enlarge or stack whole sections by using a pie or bar of pie chart.
- Change the source data for a PivotTable - Microsoft SupportHowever, if the source data has been changed substantially—such as having more or fewer columns, consider creating a new PivotTable. You can change the data source of a PivotTable to a different Excel table or a cell range, or change to a different external data source.
- Use AND and OR to test a combination of conditionsThis formula nests the AND function inside the OR function to search for units sold between April 1, 2011 and January 1, 2012, or any units sold by Nancy. You can see it returns True for units sold by Nancy, and also for units sold by Tim and Ed during the dates specified in the formula.
- Analyze Data in Excel - Microsoft SupportAnalyze 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 patterns.
- Get geographic location data - Microsoft SupportGet geographic location data. Applies To. To insert geographic data into Excel, you first convert text into the Geography data type. Then you can use another column to extract certain details relative to that data type, like Total population, or Time zone.
More
