Microsoft Excel 2016 Advanced

If you use Excel 2016 every day, then having advanced skills in the program will make you more valuable and give you the confidence required to take on more advanced tasks and projects.  

The PD Training Microsoft Excel 2016 Advanced Training Course provides you with comprehensive training in the advanced features of Excel 2016, including creating and running Macros, Flash Fill, formulas and functions, data management, customizations, auditing, grouping and transporting data and solving errors.  

This hands-on training workshop is available now throughout U.S., including Atlanta, Austin, Baltimore, Birmingham, Boston, Charlotte, Chicago, Dallas, Houston, Jackson, Los Angeles, Manhattan, Miami, New York, Orlando, Philadelphia, San Antonio and Seattle.  

Click the “Group Training Quote” button for a free quote for your internal team training or click the “Register Now” button to view the current public schedule.

Your Learning Outcomes

This extensive advanced training course in Excel 2016 helps develop basic skills and understanding of the application. After this course, participants will have gained expertise in using Excel 2016

After completing this course, participants will have learned to:

• Insert SmartArt

• Insert equations, shapes, pictures, text boxes

• Create sparklines

• Insert PivotTables and PivotCharts

• Use slicers

• Create timelines

• Share your workbook on SkyDrive

• Change Ribbon display options

• Customize the Quick Access toolbar

• Create Custom Ribbon tabs

• Reset interface changes

• Use cell styles

• Format data as a table

• Add a background

• Print and email a workbook