Tools
You are here: Home » Microsoft » Excel » Microsoft Excel 2013 » Microsoft Excel v2013 Intermediate
Tuesday, 23 Jan 2018

Microsoft Excel v2013 Intermediate

Course Objectives

This course will cover some more advanced commands of this powerful application. The topics include an overview of the spreadsheet commands, the more involved graphics and database capabilities, the advanced functions and a look at Excel's macro commands.

Who Should Attend?

Those who have used Excel 2013 but have not yet tapped its full potential.

Previous experience of using Excel at an introductory level will be assumed. Delegates with no previous experience of Excel should first attend our "Microsoft Excel 2013 Introductory" Course.

Course Contents

A review of Excel basics

  • Spreadsheet
  • Charts
  • Database

Customising the Ribbon

Spreadsheet commands

  • Absolute and Relative cell addresses
  • Use of named areas

Excel's functions

  • IF function
  • The LOOKUP function
  • Discussions on other functions available

Workbooks and file linking

More involved charting techniques

Data Menu commands

  • Validation
  • Sorting
  • Filtering
  • Sub-totals
  • Pivot Tables

Macros

Microsoft Excel 2013 Course DetailsDownload Course Details

 

Event Properties

Event date: 09-01-2018 09:30 AM
Event end date: 09-01-2018 05:00 PM
Individual Price £150.00
Location AJP IT Services
Please phone us on 0117 929 1509 to book this course