Course description
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.
Upcoming start dates
Upcoming start dates
Suitability - Who should attend?
LPC - Advanced Excel Training is ideal for :
- Anyone who deals with data would benefit from this course including, researchers, engineers, data analysts, finance team and senior management team.
Outcome / Qualification etc.
At the end of the LPC - Advanced Excel Training you will be able to:
- Formatting worksheets, cells, and cell data
- Sorting and filtering data
- Working with formulas
- Detecting formula errors
- Creating charts
- Importing data
- Inserting objects and graphics
- Using PivotTables
- Recording macros
- Sharing workbooks
Training Course Content
Day 1
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
Day 2
Analysing data and formulas
- Formatting worksheet elements
- Introduction to arithmetic operators
- Using relative and absolute cell references
- Finding data using Vlookup and Hlookup
- Auditing formulas by identifying precedents and dependants
- Managing Excel formula error indicator
Day 3
Creating rule-based conditional formats
- Defining data bar, colour scale and icon set conditional format
- Working with charts
- Creating bar, column, pie, line and XY charts
- Creating stock charts
- Adding trendline to a chart
- Creating sparkline charts
Day 4
Working with external data
- Importing data from CSV and txt files
- Using hyperlinks
- Linking an excel chart to another MS Office programme
- Working with objects
- Creating and formatting shapes
- Managing objects using the Selection pane
Day 5
Introduction to Pivot tables
- Pivoting a pivot table report
- Managing subtotals and grand totals
- Setting AutoCorrect and automatic replace options
- Protecting a workbook
- Automating workbooks using Macros
- Recording a macro
Request info
London Premier Centre
London Premier Centre is a UK leading training provider based in London and specialises in international short courses. Our inspiring, comprehensive portfolio of more than 400 professional development courses and seminars covers a wide range of professions from Administration, Leadership,...