Services4People

  Create professional slide layouts with Designer Designer improves slides for   Microsoft 365   subscribers by automatically generating design ideas to choose from. While you're putting content on a slide, Designer works in the background to match that content to professionally designed layouts. Designer is only available to subscribers of  Microsoft 365 . If you don't see the Designer    button, or you don't see certain features described on this page, see  Requirements  for more details. Get design ideas In PowerPoint, you can get design ideas any time. Select  Design  > Designer    on the ribbon. The first time you try Designer, a prompt might appear requesting your permission to provide design ideas for you. To use Designer, select  Turn on . If you're not sure the feature is turned on, go to  File  >  Account , and under  Account Privacy  select  Manage Settings . Check the box to  Turn on optional connected experiences . Note:  Microsoft is committed to hel

  Analyze Data in Excel IMPORTANT: Ideas in Excel is now Analyze Data To better represent how Ideas makes data analysis simpler, faster and more intuitive, the feature has been renamed to  Analyze Data . The experience and functionality is the same and still aligns to the same privacy and licensing regulations. If you're on Semi-Annual Enterprise Channel, you may still see "Ideas" until Excel has been updated. 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 patterns. Have a question? We can answer it! Simply select a cell in a data range > select the  Analyze Data  button on the  Home  tab. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane. If you're interested in more specific information, you can ente

FILTER function Excel for Microsoft 365   Excel for Microsoft 365 for Mac   Excel for the web   Excel 2021   More... The  FILTER  function allows you to filter a range of data based on criteria you define. In the following example we used the formula  =FILTER(A5:D20,C5:C20=H2,"")  to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string (""). Syntax Examples FILTER used to return multiple criteria In this case, we're using the multiplication operator (*) to return all values in our array range (A5:D20) that have Apples  AND  are in the East region:  =FILTER(A5:D20,(C5:C20=H1)*(A5:A20=H2),"") . FILTER used to return multiple criteria and sort In this case, we're using the previous FILTER function with the SORT function to return all values in our array range (A5:D20) that have Apples  AND  are in the East region, and then sort Units in descending order:  =SORT(FILTER(A5:D20,(C5:C20=H1)*(A5:A20=H2),&