Microsoft Excel 2013 Advanced

This one-day instructor led training course will extend user knowledge in using the more advanced features and capabilities of Excel 2013. Delegates will learn how to use advanced functions, manipulate data, apply advanced analysis techniques and manage data in worksheets.

Description

At the end of the course, delegates will be able to:

  • Know and use the advanced logical and create pivot charts mathematical functions   
  • Manipulate data using advanced analytical
  • Apply lookups to data tools
  • Create and manipulate data tables     
  • Import and export data in compatible formats
  • Create, modify and manage pivot tables to record, run and manage macros 
  • Customise the Ribbon

Prerequisites

Delegates are recommended to have a good working knowledge of Excel 2013 Or Attended the Excel 2013 intermediate training course 

Similar events

This course builds on learners’ existing knowledge and covers a variety of topics, from how to create slide decks quickly and more efficiently, work with graphics and multimedia elements to create striking presentations, special effects, and some of the more advanced presentation delivery tools PowerPoint has to offer.

More Information

This training course builds upon basic Excel knowledge and increases user confidence in using Excel. It provides more of an understanding of working with formulas and functions and demonstrates how Excel can be applied in various business applications.

More Information

Delegates will be introduced to spreadsheet concepts and gain an appreciation of the main features of Excel and what it has to offer. 

More Information

This course has been designed for users who are new to Microsoft Project, and covers navigating around the application, starting a new project, setting up a project schedule, calendars, task lists, task dependencies, Gantt charts and more.

More Information

Quickly and easily create professional, engaging presentations using PowerPoint. Learn tips and tricks from experts to make your presentations shine.

More Information

Dramatically improve your productivity when using Microsoft Word. Discover techniques for working faster and more efficiently.

More Information