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
Download Course Details