MS Office 2013/2016 – Upgrading from 2007 or 2010 – Full Day

Exploring New Excel Features
Insert a New Worksheet, Freeze Panes, Explore Excel Options, Customize the Status Bar, Use Page Layout View, Use the Zoom Slider

Using Sparklines
Inserting, Creating, Customizing, Removing Sparklines

Using New Conditional Formatting Features
Use Highlight Cell Rules, Manage Rules, Clear Rules, Data Bars

Using New Pivot table Features
Create PivotTable Report, Report Fields, Expand & Collapse Buttons, Add, Insert, Use, Format, Remove Slicers

Using New Table Features
Create a Table, Remove Duplicates from a Table

Using New Formula Features
Use Formula AutoComplete, View New Functions

Using New Sort And Filtering Features
Sort Records by Multiple Fields, Filter Data to find Above Average

Using New File Format Features
Use the Document Inspector, Mark a Workbook as Final, Save to a PDF Format, The Compatibility Checker, Convert a File to Excel 2010 Format, Save in a Binary Format

Using SmartArt
Insert, Format, Resize/Reposition a SmartArt Object, Insert Text into a SmartArt Object, Format Text Within a SmartArt Object, Add Shapes to a SmartArt Object, Group SmartArt Objects

Inserting A Photo Album
Insert Pictures from a File, Add Captions, Apply a Theme to your Album, Customize the Album Layout

Enhancing Slide Layouts
Create a Custom Layout, Apply a Theme, a Background Style, Change Slide Orientation

Enhancing Graphic Images
Apply a Picture Style, Apply a Shape, Add Effects, Add a Border

Enhancing Typography
Select & Customize a Shape Style, Apply Effects to a Text Placeholder, Select a WordArt Style, Edit Text Outline Colour, Apply Text Effects

Enhancing Tables
Apply a Table Style, Edit the Table Colour, Add Table Effects, Format Table Text Use Quick Styles, Add Table Borders

Sections
Organise Slides in Sections, Inserting Media Clips, Insert & Embed Videos

Sharing Your Presentation
Inspect the Document, Create a Custom Show, Encrypt the Presentation, Add a Digital Signature, Grant Permissions, Compress Pictures