This course covers all the fundamental skills required to create and format spreadsheets, automate spreadsheets with formulas and prepare spreadsheets for printing.

Open participant course: £195 per person - maximum 10 people

Closed company course: £1,000 per course - maximum 10 people

Those who need to be able to create, edit and format Microsoft Excel spreadsheets.

After attending this course, delegates will be able to create, format and edit Microsoft Excel spreadsheets. They will be able to create basic calculations and formulas.

Spreadsheet Basics:

• Spreadsheet concepts.
• Exploring the Excel window.
• Working with the ribbon and commands.

Navigating, Selecting and Entering Data:

• Creating, saving, opening and closing spreadsheets.
• Moving around a spreadsheet.
• Entering, editing and deleting data.
• Using Auto Fill and Flash Fill.
• Creating custom lists.

Editing Data, Columns and Rows:

• Inserting and navigating worksheets.
• Inserting and deleting rows and columns.
• Adjusting column widths and row heights.
• Showing and hiding columns and rows.
• Cut, copy and paste techniques.

Formatting:

• Formatting text and sizes.
• Aligning text horizontally and vertically in cells.
• Applying number and date formats.
• Formatting cells with background colours and borders.

Basic Formulae and Functions:

• Using formulas to add, subtract, divide and multiply numbers.
• Using the AutoSum function.
• Working with relative and absolute cell references.

Data Lists Essentials:

• Introducing data lists.
• Freezing worksheet titles.
• Sorting a list of data.
• Filtering data using Auto Filter. 

Page Setup and Printing:

• Using print preview.
• Changing page layouts.
• Changing and applying print options.

This course can be delivered remotely or in a classroom environment, to suit your requirements.

Attendees must be proficient with a mouse and keyboard and be able to confidently work within a Windows environment - minimise, maximise, open, close. 

Attendees must have the following equipment to attend this training remotely:

• PC or laptop with a microphone and speakers (webcam is preferred but not essential).
• Access to the internet and web browser application (e.g. Google Chrome).
• Microsoft Excel installed on the PC or laptop.
• An email account for file sharing.
• A second screen is ideal but not essential.