Microsoft Excel – SPAT

Microsoft Excel

This Course.

This two-day course will cover using lists in Excel, Pivot Tables, common sizing, scenarios, built-in functions, formulas, linking sheets.

£220.00

Course Content

Creating spreadsheets/worksheets
Managing spreadsheets
Analysing data
Formatting and presenting data
Charts and graphs
Quality control.
Formatting text
Simple and complex formulas
Handling rows and columns
Autocomplete, using styles, headers, and footers,
Average, max and min functions and using charts.
Use of IF Formula
Summing Techniques
Cell References
Formula Linking
Sumifs
Tables and Bordering
Look up References (Vlookup, Hlookup, etc)
Data Validation
Conditional Formatting
Date & Time Formulas
Protection & Security
Creating a Pivot Table
Pivot Table Analysis

Virtual Training

Entry Requirement

Course Details

Start Learning

Get practical financial skills to help you become more employable.

Trusted by

Built by Xthetic Studio