With the data quickly pulled out and formatted, Katie now wants to visualize the data, but isn’t sure what the best formatting, graph, or table is for this type of data. Instead of selecting the data and creating new charts or tables she can use Excel’s Quick Analysis feature to get live previews of what different data visualizations will look like. In this case, maybe data bars are the best, or this column chart. Or maybe a pivot table is the best way to roll up the data. Katie gets a preview of what a pivot table view of this data would look like, all without even needing to know what a pivot table is! So you see, the Quick Analysis feature lets Katie focus more on the best way to present data about her customer and get the necessary insights from it, instead of spending valuable time focusing on how to set it up. New Chart Types for Excel 2016 Excel 2016 offers some new charting options that can save Katie a lot of time when analyzing data. One of these is the Pareto Chart, which is useful when you want to analyze what each category contributes to a total. In this case, Katie is looking into categories of spending on marketing for Northwind. Which are the top spending categories, and how much do they contribute to the total? Quick Analysis icon that appears at the lower right of the selected cells. to open Quick Analysis. Formatting, hover over Data Bars. over the Icon Set. Charts. over first Clustered Column chart. Tables. over the Table icon. over the second PivotTable. the preview. the second PivotTable icon. the Pivot Table, now in a new sheet. Pareto Chart the workbook, switch back to the SNAPSHOT tab. C3:C23. the and paste to the right of Category. You will create a new column Amount2. cells E4:F23 (the cells containing data). the Insert tab. the Ribbon, in the Charts group, tap the down-arrow next to the statistical chart button .
forecasts a substantial spending increase. This is valuable information she will use for her next budget review. Power View This spreadsheet also has some Northwind data, which Katie wants to use to generate some deeper insights on their worldwide sales demographics before and even during the meeting. Power View in Excel Professional Plus provides information workers like Katie with a powerful way to create rich, interactive, beautiful dashboards on top of Excel data. Just like Flash Fill and Quick Analysis features help every day Excel users get from data to insights quicker, Power View democratizes deeper data analysis. With PowerView, people spend less time formatting data and more time getting visual insights and digging into business questions. These dashboards query data models defined by PowerPivot. If we tap the PowerPivot tab, and then tap Manage, we can actually see that data model and view the relationships between pieces of customer and sales data here. These Power View sheets really are easy to set up. Katie can easily replace the GrossMargin visualization with a a new visualization. In the Power View Fields list, she’ll just check the categories she wants to pivot the visualization on – in this case Product Categories and Sales by Gross Margin. A basic tabular view of this data gets created, but if Katie wants a different visualization, she can just tab to select a Stacked Bar chart, for example. It’s that easy! the ribbon, tap PowerPivot tab, and then in Data Model group, tap Manage. Sales tab, and then tap Products tab. the ribbon, tap Home tab, and in the View group, tap Diagram View. PowerPivot window and return to Sales Analysis sheet. View Fields, make sure ALL is selected. Products, and Category. Sales, and check GrossMargin. Category/GrossMargin % the Ribbon, on the Design tab, in Switch Visualization tap Bar Chart, and then tap Stacked Bar. bar chart to take up full white space. GrossMargin by Category, hover over Cameras & Camcorders to see values. the blue bar for Cameras & Camcorders to apply cross filter. filtering that appears in other views. the blue bar again to turn off filter. the SalesQuantity, SalesAmount, and Margin by Brand, and Category view, tap the Pop out icon (). the play button.
Katie can get creative and support her message with effective visuals. On slide 9, Katie has a diagram that supports a specific number she wants to call attention to – the 55% of parts being recycled in the fine print beside #4. She can easily emphasize the data with an infographic that shows, visually, the impact of this number. To keep things in context, Katie can create a small TV icon using Merge Shapes, which allows her to take two or more shapes, and union, subtract, combine, intersect or fragment them into new custom shapes. In this case, the benefit is that the new icon is a shape in itself, which means she can easily apply the PowerPoint Shape Styles for a polished look. To create the icon, starts by drawing the various elements and placing them in position. She then subtracts shapes to create outlines, and unions the remaining shapes to create a new one. With the TV icon prepared, she can place it next to the others. As you can see, the improved Smart Guides pop into action when the shapes are in alignment, guiding Katie to intuitively Press and hold Shift, and then tap the middle TV rectangle. Under Format, in the Insert Shapes group, tap Merge Shapes (), and then from the drop down, select Subtract. Tap out of the shapes to de-select. Tap on the slide canvas and, using the track pad, drag to select the entire set of shapes making up the monitor. the Format tab, in the Insert Shapes group, tap Merge Shapes, and then from the drop down select Union. newly single shape still selected, under Format, in the Shape Styles group, tap the more arrow to expand the style gallery. the bottom left, select the orange shape style (Intense Effect – Orange, Accent 1). the newly-orange TV shape towards empty space near other 8 TV icons. Smart Guides, align top right corner of the big TV shape with the smaller TVs using Smart Guides. the Guides. Smart Guides, resize the big TV shape to match others.
are doing and get instant feedback on running conversations, documents, and projects she’s working on. Katie can like comments, post replies, and create hash tags or “Topics” so that discussions are instantly discoverable to create rich social linking. Katie can also start an @mention in a reply, to flag a post and point to a particular person in her Yammer network. Companies can even integrate this with Active Directory. The groups on the left are a great way for Katie to have scoped social interaction, about certain topics, or with certain coworkers, in the same way she can with her entire company’s activity feed. Here’s the Sales group whose activity feed Katie saw embedded in the Team Site. “Following” is a foundational capability in Yammer, and it helps Katie narrow what’s most interesting to her. But the great thing about Yammer is how it suggests groups that are relevant for Katie to follow. This makes it very discoverable and easy for Katie to create a rich social tapestry with ease. She can follow or join a group with just a tap! Yammer also makes it easy to set up external networks, so that Katie and her coworkers can collaborate outside the company in the same way they communicate with each other. This is a great way for Katie and her team to work with the Northwind Traders account representatives. To set up the external Yammer network, Katie can tap here, check if her desired network’s name is available, decide if she wants it to be open to all, and create it. It’s that easy! And as soon as the group is created, Katie can begin inviting members and interacting with them seamlessly. In summary, Yammer is a place for Katie to manage and share documents and information, and to discover new people, to Garth’s post, and type Great!, then add the tag #marketing and type CC @AlexD. Tap Post. back to the top of the page. Groups, point out the Sales group. left navigation, tap Home. the right, note Suggested Groups. a Suggested Group, and then tap Join. the green Join notification. lower left navigation, tap settings (gear icon), and then tap Create a New Network. it a Network Name like Northwind-<tenant> Group (where <tenant> is your custom demo environment). Create Network. the green Create notification. new network feed, post: welcome to the new group!, and then tap Post.
single tap, so she can see if she can get a real-time response to Northwind’s question. If Katie wants to have a more interactive conversation with her colleague, or an actual face-to-face experience, she can easily escalate this conversation to a voice or a high-definition video call, with just one more tap of these icons here. Adding video also will let her colleague interact with the customer directly, so she’ll go ahead and launch the call. *Optional: perform multiparty demo: If Katie wants to have a more collaborative session, she can easily go ahead and add others to the video call. She can simply drag and drop them into the conversation to invite them to the call, and they could accept with a single tap. For example, she could invite the entire team to the call and see who might accept. And just like that, Katie has launched a multi-party, HD video conference! Seeing all of her colleagues together, live, makes this meeting much more impactful than a traditional conference call, since Katie can really interact with everybody almost as seamlessly as if they were in the room with her. But, thanks to the Skype Meeting experience, her colleagues could be halfway around the world or just another building away. *End optional multi-party video portion And this Skype Meeting isn’t just limited to voice and video, either. Katie can easily add content to help her share and collaborate with her colleagues most effectively. The Present icon gives Katie the option to present her desktop, or start a shared whiteboard session. She can even add a personal or Type Can you answer a customer question?, and then Enter. *Demo buddy response: Let’s add video! Note phone icon. Note video icon. Tap icon, and then tap, Start My Video. *Demo buddy can initiate video, in which case demo presenter just needs to accept video invite from demo buddy). *Optional: perform multiparty video demo: Tap and drag other contacts from Lync buddy list into the video call (choose among: AlexD, GarthF, MollyD, SaraD, and SaraD). *Demo buddy could also drag the others in quickly using mouse and multi-select in Skype, while presenter just notes addition of video feeds. *End optional multi-party video portion Present icon. Present Desktop. More, and note Whiteboard icon.
shared note-taking pane, and those notes will sync to her personal OneNote page, or a team OneNote page synchronized through SharePoint, and be available after the meeting is over. Of course, Katie can also add a PowerPoint to present to the meeting attendees through Skype. Tapping Present PowerPoint Files lets her browse her computer to choose a file to add. If she already has a presentation open in PowerPoint, she can skip the browsing in Skype and add it right from within PowerPoint. She can go into the ribbon and select the Present Online option. This PowerPoint and Skype feature will identify any active or upcoming Skype Meetings, and give Katie the or click option to present her PowerPoint to the meeting attendees. This seamless experience is just another example of how Office breaks down the borders between applications, and lets Katie focus more on the workflow she wants to complete. In this example, the meeting is more impactful and enables richer collaboration between Katie and her colleagues. In addition to adding content to her Skype Meeting, Katie can also transition her experience between different views depending on what makes the most sense at any given time during the meeting. If seeing the current speaker is most important, she can select that option which will maximize the video feed for whoever is the active speaker at a given time. Or, when the conversation between attendees is most important, she can select the gallery view, which shows a standing row with 5 simultaneous HD video streams based on the 5 most active speakers, and a “seated row” with HD photos for the rest. At any Present icon again, and then tap Shared Notes. Present icon again and note My Notes. Shared Notes icon. Present. Present PowerPoint Files. cancel. taskbar, tap PowerPoint icon to go to the Northwind presentation. the ribbon, on the Slideshow tab, in the Start Slide Show group, click Present Online, and then click Skype for Business. the active Skype Meeting, and then tap OK. uploading peek. the Skype meeting, tap arrows to advance slides and see transitions a couple of times. bottom right of Skype meeting screen, tap Pick a Layout icon. Speaker View. Pick a Layout icon. Gallery View. the Pick a Layout icon. the Presentation View icon. the Windows 10 demo machine, start the Project my screen app.