Training Programmes

IT

Masterclass in Excel – Introduction

Date:  24th  and 25th January 2023

Tutor: System and Software

Venue: Online

Time: 9.30-12.30

Investment: €45 per person

Book Here: https://bit.ly/3ALWGkP

 

This is two half day workshops on 24th and 25th January 2023 from 9.30am -12.30pm

This course is for people who have a limited working knowledge of Excel.

Objectives

The purpose of this one day is course is the teach delegates the essential features of Excel . Accessing worksheets, entering data, core functions Referencing cells, formatting worksheets, headers & footers and printing are all covered. Extensive hands-on classroom training is provided throughout.

Versions ; This course is available for Excel 2003, 2007 & 2010

 

Contents

• Enter and edit information in a Worksheet

• Navigate Worksheets and Workbooks

• Create basic Formulas – Addition, Subtraction, Division, Multiplication

• Use Basic Functions – SUM, AVERAGE, MAX, MIN

• Use the AutoFill feature (Fill Handle)

• Insert/Delete columns and rows

• Understand Relative References

• Understand Absolute References

• Format figures to Text

• Merge and Centre Cells

• Set Currency Style

• Add Borders and Fill Colour

• Insert New Worksheets

• Change Page Orientation from Portrait to Landscape

• Set Page Margins

• Create a Header and Footer

• Insert & Remove Page Breaks

• Set a Print Title

• Print Worksheets

• Freeze Rows and Columns

 

Latest News