Overview

<p>To become an effective user of Excel and to get the best out of your data and calculating totals this course is for you.</p> <p>The magic of Excel lays in the use of formulas and how to fix or leave them moveable.</p> <p>During this hands on session, you will gain valuable skills about how to create different types of calculations using formulae and functions.</p>

Pre-Requisites

This session is designed for new users to Excel spreadsheets or for those who would like a refresher on the basics. It is essential you have hands on practice of using a computer and mouse.

What will I learn?

  • Learn how to:
    • Use arithmetical operations to create simple calculations including percentages
    • Create simple formula using brackets
    • Use quick functions to calculate the Total, Mean, Highest and Lowest of a range of data
    • Use moveable and fixed cells in calculations
    • Automatically fill a range of cells with a series of data
    • Edit and interpret existing spreadsheet data