Step 1 - MS Excel – Getting Started Level 1 - IT0056

Who is this course for?

This course is for any level of MS Excel users who would like to know how to manipulate and work with data tables more efficiently. This is a Level 1 course. If you follow the Steps in order this will give you a grounding in the use of MS Excel across the Application.

Aim(s)

This course provides the skills and knowledge to be able to identify how a worksheet is created, to be able to review the settings for maximum control, to insert/delete aspects of the workbook, to format and work with data tables, to help with management of data and to understand the fundamentals of MS Excel on how the Application, processes data inputs.

Objectives

• Navigate around the spreadsheet & Review Table layouts – table setup do's and don'ts 
• Name Box fundamentals  
• Manipulate the workbook, inserting columns, rows, additional worksheets and tab formatting 
• Use of the replicator for a variety of actions  
• Format data types in the spreadsheet eg changing cell formats - percentage, date, currency and general
• Use Word Wrap in cells, Merge cells Vs centre cells  
• Operate the functionality of FlashFill 
• Apply sorts to data

Trainer

Business Systems Trainer

Delivery Method

Virtual Training and Face to Face

Course Cost

£75.00

Apply

This course is available either as a Virtual or Face to Face course – which is better for you?

Face-to-Face – this is perfect if you'd rather take your time and ask more questions of the Trainer.

Virtual Training – this is ideal if you're comfortable working with computers, able to navigate between a variety of files and working with multiple windows. The course tends to be faster paced and with a little less interaction than the face-to-face option. For this type of training, it is a must that you have use of two monitors and use of a mouse (not the trackpad on a laptop).

If there are no dates available, please Register your interest.

How to Register your interest - to register your interest in this course please email psteamstrainingandsupport@lancashire.gov.uk - stating whether you'd prefer virtual or face-to-face training, and your name will be added to our waiting list. When we have a few names on the waiting list, we will schedule a course and contact you to advise of the next steps.