LPC - Advanced Excel Training
Course Info
Length:
Type:
City:
Course Details
Introduction
Objective
Who should attend
Course Location
Learn everything you need to master MS office – Excel, the world's most popular spreadsheet program. This course provides you with a comprehensive overview of Excel, including manipulating workbook and cell data, using functions, printing worksheets, and collaborating with others. In the last half of the course, the course covers more complex techniques, such as summarising data with charts, working with external data, adding images and shapes, and automating routine tasks.
Learn everything you need to master MS office – Excel, the world's most popular spreadsheet program. This course provides you with a comprehensive overview of Excel, including manipulating workbook and cell data, using functions, printing worksheets, and collaborating with others. In the last half of the course,
The course covers more complex techniques, such as summarising data with charts, working with external data, adding images and shapes, and automating routine tasks.
Course Outline
Creating and modifying workbook templates
- Working with worksheets, cells and cell data
- Sorting, filtering, and managing worksheets
- Summarising data using formulas and functions
- Working with advanced formulas and functions
- Using validation rules to restrict the data entered in cells
- Creating named ranges
