THIS COURSE IS IDEAL FOR This course has been developed for people
wanting to utilise Excel to perform calculations using a variety of
common worksheet functions, filter, sort and summarise database lists,
format and modify charts, and conditionally format cells.
WHAT YOU WILL LEARN
*
Understand and use a range of common worksheet functions.
*
Understand and utilise Absolute Referencing.
*
Organise a database list by advanced filtering and subtotalling.
*
Utilise Conditional Formatting to change cell appearance.
*
Create, modify and format a range of charts.
TOPICS COVERED IN THIS TRAINING COURSE
FUNCTIONS AND FORMULAS
*
Absolute cell referencing
*
Function syntax
*
Common statistical functions
*
The COUNTIF function
*
The SUMIF function
*
The IF function
WORKING WITH DATE AND TIME
*
Date functions – TODAY and NOW
*
The EDATE function
*
The NETWORKDAYS function
*
Working with time values
*
AutoFill date sequences
CONDITIONAL FORMATTING
*
Conditional formatting from cell value
*
Conditional formatting from a formula
*
Editing conditional formatting rules
*
Adding sparklines
ADVANCED SORTING AND FILTERING
*
Sorting custom lists
*
Sorting by colour
*
Complex filtering criteria
*
Searching for criteria
*
SUBTOTAL function
*
Subtotalling a list
*
Creating a simple PivotTable
TABLES
*
Creating a table
*
Adding a table formula
*
Adding records to a table
*
Adding totals row
*
Grouping and hiding an outline
ADVANCED CHARTS
*
Creating a chart sheet
*
Switch columns/rows
*
Creating a secondary axis
*
Changing a series chart type
*
Moving a chart
*
3D charts
*
3D chart rotation
sports
courses
192
Views
22/07/2020 Last update