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.

PowerPoint 2013: See What’s Coming with Presenter View

new feature for microsoft office 2013One of the most common questions in PowerPoint training is “how can I see something different on my screen to the audience?” The answer is complicated and involves multiple graphics card outputs. The Presenter View was added in 2010 but has really come into it’s own in PowerPoint 2013.

In Presenter View you can see the current slide as well as the next slide and your notes on your monitor whilst the audience only sees the current slide. This is one of my favourite additions to PowerPoint as you are certain what is coming next, avoiding that embarrassing flicking between slides as you work out where that topic is.

presenter view in powerpoint 2013

There’s a whole bunch of other tools underneath the main thumbnail, such as being able to zoom into slides to add emphasis, display a laser pointer to draw attention, and jump around the presentation without the delegates seeing what you’re doing.

How to: The Presenter View will be used by default. If you want to enable or disable it go to SLIDE SHOW > Use Presenter View.