Date and Time:

26th February 2025

9:30am to 4:30pm

Programme Aim:

This course covers all the basics of Microsoft Excel. Participants will learn how to enter and edit information in a worksheet, manage and navigate worksheets, perform calculations and manipulate worksheet data, format the worksheet contents, and prepare, set up, and print information.

Programme Objectives:

At the end of this course, participants will be able to enter and edit information in a worksheet, manage workbooks and navigate worksheets and workbooks. Perform basic calculations on worksheet data, manipulate the data, format the contents of a worksheet and prepare, set up and print information.

Programme Structure:

This course is virtually delivered via Zoom Virtual Classroom. Demo excel files will be provided in advance to facilitate 'hands-on' participation.

Prerequisites:

Participants should be familiar with PC's/Laptops and have used a mouse and keyboard; be able to launch and close programmes; navigate to information stored on the computer; and manage files and folders.

Programme Outline:

§ Start Excel

§ Get Help

§ Enter information

§ Edit information in Cells

§ Using Undo/Redo

§ Save, close, and re-start Workbooks

§ Exit Excel

§ Use Basic Formulas

§ Use Functions

o SUM

o AVERAGE

o MAX

o MIN

o COUNT

§ Apply Currency format

§ Apply Percent style

§ Apply Decimals

§ Merge and Centre

§ Navigate a Worksheet using the Keyboard

§ Insert/Delete Columns and Rows

§ Resize Columns and Rows

§ Hide/Unhide Columns and Rows

§ Hide/Unhide Worksheets

§ Using AutoFill

§ Copy and Paste/Transpose

§ Apply Borders and Shading

§ Deleting formatting

§ Understand the Order of Operations Understand and create Relative References

§ Understand and create Absolute References

§ Understand and create Mixed References

§ Link calculations across sheets

§ Wrap Text and Line Breaks

§ Naming Sheets

§ Moving Sheets

§ Copying Sheets

§ Freeze Panes

§ Repeat Titles on each Page

§ Page Orientation

§ Split Screen

§ Scale to Fit

§ Check Spelling in a Worksheet

§ Preview a Worksheet,

§ Set the Page Options and Margins

§ Add Headers and Footers

§ Insert and remove Page Breaks

§ Print a Worksheet

§ Set a Print Area