Date
October 3, 2022
COURSE DELIVERY
Online
START TIME
9.00am

Course Description

A good working knowledge of Excel is vital for most professionals today, particularly those based in an office environment, and stronger Excel skills can open the door to promotion and leadership opportunities. Excel is a powerful tool but cannot function alone. It requires someone to take advantage of everything Excel has to offer to provide the best results for their company.

This one-day introductory class covers all the basics of Microsoft Excel, showing attendees how to enter and edit information in a worksheet, manage and navigate worksheets, perform calculations, manipulate worksheet data, format the worksheet contents, and prepare, set up, and print information.

On leaving this course, attendees should be able to enter and edit information in a worksheet, manage workbooks and navigate worksheets and workbooks. The user will be able to perform basic calculations on worksheet data, manipulate the data, format the contents of a worksheet, and prepare, set up and print information. All delegates will also receive  full course notes to refer to at any time.

Prerequisites: Delegates should be familiar with PC’s/Laptops and have used a mouse and keyboard; be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.

Course Content

Working with Worksheets and Workbooks

• Start Excel

• Get help

• Enter information

• Edit information in cells

• Using Undo/Redo

• Save, close, and re-start workbooks

• Exit Excel

Performing Calculations

• Use Basic Formulas

• Use Functions

          o SUM

          o AVERAGE

          o MAX

          o MIN

          o COUNT

• Using AutoFill

• Understand the Order of Operations

• Understand and create Relative, Absolute, and Mixed References

• Linking calculations across sheets

Managing Worksheets

• Navigate a Worksheet using the Keyboard

• Insert/Delete Columns and Rows

• Resize Columns and Rows

• Hide/Unhide Columns and Rows

• Hide/Unhide Worksheets

Managing Worksheets Contd…

• Naming Sheets

• Moving Sheets

• Copying Sheets

• Freeze Panes

• Repeat Titles on each Page

• Page Orientation

• Split Screen

• Scale to fit

Formatting Worksheet Information

• Apply currency format

• Apply percent style

• Apply decimals

• Merge and Centre

• Copy and Paste/Transpose

• Apply Borders and Shading

• Deleting formatting

• Wrap Text and Line Breaks

Checking and Printing Information

• 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

Who should attend?

This course would be ideal for those who require a basic grounding in Microsoft Excel, this course will provide you with the knowledge 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.

Certification

On completion of this one-day training course, you will receive your Certificate of Attendance. Please note certificates are issued at the close of the training course to participants on completion of the course. Please check directly with your association or awarding body to see how many points they will award.

Cost

This course costs €465 (normal rate is €565).PLEASE NOTE THE EARLY BIRD RATE CLOSES 3 WEEKS PRIOR TO COURSE DATE. The course cost includes all course documentation and Certificate of Attendance.

Tutor

Kelly Meegan
KM Consultancy Services

Recommended for you

People who booked this course also attended: