Tag: tutorial

Posted on

Excel Training 2013: Sparklines through Quick Analysis

new feature for microsoft office 2013Introduced in Excel 2010, Sparklines create charts within a cell. It can help to show one figure in context with others and illustrate trends. In this example a blank column is created for the sparklines before selecting the adjacent data.

In Excel 2013 the Quick Analysis feature has now brought Sparklines to the fore. Perfect for tracking performance over time, this new way of accessing them will give a quick insight into your data.

Sparklines in Excel 2013

How to: Highlight some Excel data in a table and look for the Quick Analysis tag to float over the bottom-right corner of your selection. Put your mouse over this icon to explore the options.

For more tips and features on Excel 2013 and other versions, browse Microsoft Excel training courses from STL, available London and UK wide. With our instructor-led training, you’ll be able to manipulate your data in ways you never thought possible, helping you save time and money. Choose your preferred course ranging from beginner to advanced level.

Posted on

Using Folder Pane/Peek feature for quick Outlook previews

new for microsoft office 2013The Folder Pane and the Peek feature provide quick and convenient ways to open your email, calendar, contacts, and tasks. One of the new features in Outlook 2013 is the ability to peek at the details of the other Outlook objects such as Calendar, Tasks and Email.

This is great for those times when you just need a quick overview of what’s going on and not the whole kitchen sink.

Folder Pane Excel 2013

How to: Hover cursor over Calendar on the Navigation Pane > Preview of the Calendar will appear with any appointments scheduled for the current day. The preview will stay until you move your mouse away from the peek window.

You can also dock the Peek window so it stays permanently visible on the right hand side of the screen like it would appear on the To Do Bar.

How to: At the top right hand side of the Peek window, click on the window icon as highlighted.

Peek at calendar in Excel 2013

For more tips and features on Outlook 2013 and other versions, browse Outlook training courses from STL, available London and UK wide.