Microsoft Office Excel - Introduction
1 Day Duration
Overview
This intermediate course is aimed at users who have a comfortable working knowledge of Microsoft Office Excel 2016 and wish to gain skills in some of the features within Excel that can enhance spreadsheets. The course is hands on and delegates will update and create intelligent formulae and efficient spreadsheets.
Working with lists in Excel
Rules for working with lists
Creating dynamic lists
Formula autofill
Sorting within lists
Filters in lists
Subtotalling lists
Intermediate Functions
Naming cells and ranges within functions
IF function and nesting IF’s
SUMIF
COUNTIF
DATE
TODAY
Formula Creation
BODMAS theory
Creating formulas using the keyboard and mouse
Copying formulas across ranges
Introducing simple functions
SUM
AVERAGE
MIN
MAX
COUNT
Analysing Data
Pivot tables and pivot chart reports
Filtering within Pivot Tables
Formatting Pivot Tables
SUM, AVERAGE and COUNT features
Drilling down within Pivot Tables
Creating Pivot Charts
Further Excel Features
Conditional formatting
Data validation
Comments within spreadsheets
VLOOKP & XLOOKUP