LPC - Advanced Excel Training
INTRODUCTION
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.
OBJECTIVES
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
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.
COURSE OUTLINE
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
www.lpcentre.com
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
www.lpcentre.com
